Questions tagged as 'mysql'

Tagged questions
1
answer

Filter dates that user entered our system

Hello, how are you guys? I'm trying to filter the dates that users connect to my system. It has a but, first need to filter so it does not have duplicate users. I'm already doing this with the DISTINCT command. With the result that D...
asked by 09.12.2016 / 13:45
1
answer

Load ComboBox from a MySQL table - Manipulate key and other field

I have a table with the following structure: +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | idLo...
asked by 04.12.2016 / 17:50
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

How to set the timeout for dump in database.php?

I need to increase the timeout of MySQL to execute a dump processing of the bank. 'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_P...
asked by 15.11.2016 / 04:06
0
answers

How to Make an Update on the Mysql Database with Cache

I have a wordpress plugin for related posts, I have a table where I update the number of clicks and the number of views of each post! The problem is, on large websites I'm dropping servers with so many updates in the database, since I do this wi...
asked by 15.11.2016 / 16:16
1
answer

Translate Connection String H2 (JDBC) to MySQL (JDBC)

Personal speech, I'm trying to run the OW2 Orchestra software, and it comes with a default connection string belonging to H2 in the following format: jdbc\:h2\:file\:/tmp/orchestra-db/orchestra_core.db I need to translate it to a MySQL s...
asked by 14.11.2016 / 20:30
1
answer

User to log in has 2 types of menus and before that the system must understand if it is logged in or not to display another menu [closed]

Personal in my code above, I'm trying to display 2 types of menu for the user, when logged in, not logged in, in case when logged in he still assembles another menu comparing which type of user is logged in, if it is a user simple or advanced us...
asked by 16.11.2016 / 19:50
0
answers

How to send values from two different forms to an insert?

I need to save the ID of the event I want to register the presence of a certain student in the Bank, but I also need to save some other data, so I created a <?php if(!isset($_POST['evento'])):?> But I need to send the value of both...
asked by 17.11.2016 / 17:32
1
answer

SQL syntax error when starting the OW2 Orchestra

Recently, I downloaded the OW2 orchestra software. In the user manual, after going through all the configuration steps (I am using MySQL as my BD. The other settings are the standards, including the use of hibernate), I came to the instructions...
asked by 14.11.2016 / 02:41
0
answers

Database - Merge tables with different structures

My main question is: what is the best way to do it and not what commands to use. What I need, basically, is this: I have two tables with different structures, in different databases. For example: Database 1 - Customer table structure: id -...
asked by 14.11.2016 / 11:33