Questions tagged as 'mysql'

Tagged questions
1
answer

User has exceeded the 'max_user_connections' resource (current value: 4)

I have a problem with the open connections in the database, where an error is occurring if the application tries to create more connections than the limit. Assuming that the application creates and closes the connections for each interaction in...
asked by 26.05.2016 / 20:14
1
answer

How do I define custom sort on a DB return?

Today I have a simple product catalog that shows all products together or by category. However, when I show all together I can only sort by ASC or DESC, but I need to sort it differently. When I show everyone I want to see a product X first o...
asked by 28.05.2016 / 19:32
1
answer

SELECT Multiple Date Range in MySQL

Staff have a problem with extracting dates in a training range. What I need is the following if a training started on 01/01/2017 and its completion on 03/03/2017 elevate should return in the select below for the months 01.02 and 03. Today this s...
asked by 08.01.2017 / 23:07
1
answer

UPDATE without changing the date of a record

How do I change a record in my table and keep the date the record was created. In% with% I'm using the INSERT method. When I use a now() to change only one column the date is being changed, and I need to keep the date the record...
asked by 03.04.2017 / 08:48
1
answer

Error converting mysql_list_tables to mysqli_

I have a page to download a backup of the MySQL information, but it is giving the following error since I started migrating from mysql_ to mysqli_ :    Fatal error: Can not use object of type mysqli as array in /home/.../public_h...
asked by 19.03.2016 / 20:14
1
answer

I can not find the reason for FormatExcpetion

Good evening guys, with a little problem in a basic test program that I'm doing, could anyone help me?    Error: The input string was not in an incorrect format. (FormatException)       in System.Number.StringToNumber (String str, NumberStyl...
asked by 23.03.2016 / 03:43
1
answer

Doubt with checkbox and PHP

I have 2 fields, as below, which are checkboxes : <tr> <td>Dizeres Legais:</td> <td><input type="checkbox" name="export_dizeres[]" value="PORTUGUES"> Português...
asked by 08.01.2016 / 19:33
1
answer

Using last_insert_id (), is it credible if multiple users are entering the database at the same time?

I have a question regarding the last_insert_id() method of mysql. And the following: I am creating a procedure to insert into 3 tables, example:    person (idPerson, first name, last name)       employee (idEmpregado, idPessoa, cargo)...
asked by 26.01.2016 / 14:48
1
answer

mySQL result coming with the bars

I'm using link , and when I send something to the database, for example, if I add this HTML tag <img = src="http://link">intheeditor,andsendittothedatabase,itsaves<img==\"\" src=\"http://link\"> and that way when I select it...
asked by 20.01.2016 / 23:03
1
answer

Create a download link for path that is in mysql

I have the following structure in the database: reuniaoId escolaId usuarioId dataReuniao tituloReuniao pathReuniao 7 14 1 2016-01-13 AEQEQ uploads/reuniao/ata_2016_2418530_2HK73386F.pdf I need to create a download page for...
asked by 26.01.2016 / 18:15