Questions tagged as 'mysql'

Tagged questions
1
answer

Incorrect datetime value

I am trying to insert some data by php into my database, when making the INSERT I get the following error: Error de MySQL : 1411 : Incorrect datetime value: '21/09/2018' for function str_to_date. I leave the insertion code: $SQL = "INSER...
asked by 21.09.2018 / 14:22
1
answer

Connection failed in Xampp, does not connect to phpmyadmin

For some reason, I can not connect to phpmyadmin using this code. In connect_db.php. It says there is a connection problem and it does not give the error number. <form method="POST" action =""/> <!-- El formulario en si --> <la...
asked by 21.09.2018 / 15:10
3
answers

Create procedure with input parameters, and then insert in BD after a validation

My problem is this, I am trying to create a procedure that receives input parameters and check if the data exists or not, to be able to insert in one table or another. I have tried in different ways and I can not find the error that appears in t...
asked by 24.09.2018 / 11:02
1
answer

Bring Select values where both MYSQL match

I have the following SELECT * FROM metadatas WHERE value IN ('Monumento', 'Arquitectura') After making that query, it brings me several results, but I need to bring where both coincide. The result would be the following: id - name - valu...
asked by 21.09.2018 / 15:40
1
answer

Function of PHP to buy data against a table created with a FOR

I have a table in html of turns that is dynamically created with a FOR having as limiting the schedules that the doctors work and I need to create a SELECT in a modal with the available schedules but I can not find the way to compare the schedul...
asked by 20.09.2018 / 19:30
1
answer

Delete rows from several tables at the same time with MySQL

I am trying to delete several rows of several tables at the same time using this statement in mysql DELETE fhi, ave, car, pen FROM fhi INNER JOIN ave INNER JOIN car INNER JOIN pen WHERE fhi.id = 1 AND fhi.id2 =...
asked by 19.09.2018 / 23:42
6
answers

How to save selected and unselected checkboxes

I put them a bit in context, I'm doing an academic attendance record system, and I plan to keep the id of the students in a table along with a value that tells me whether or not they attended classes so that after this a percentage of the absenc...
asked by 19.09.2018 / 23:54
0
answers

Problems with equivalence of Measurement Units Products

I am developing a warehouse system and I have a problem that I do not know how to solve it. I have a customer who buys their supplier for Triangle chocolate boxes, each box has 24 display, and each display contains 22 units. My client can sell b...
asked by 19.09.2018 / 02:49
1
answer

How to validate php record that does not repeat? [duplicate]

Good morning: I am creating a file in php that connects to a localhost, what I need is to make it validate in the localhost that there are no duplicate records, the validation I have to do with the rfc (Mexican) since it is a unique value. I r...
asked by 19.09.2018 / 04:01
3
answers

When sending form by Ajax I recharged the page

my problem is that I have a page with several form to which I intend to make ajax requests so that it does not recharge the page, but I recharged it and I do not know what the reason is, I have investigated and tried in several ways, but...
asked by 25.09.2018 / 01:48