Error: the right syntax to use near 'add

Question

I don’t know what’s going on but my code doesn’t work it is simply not entering data into the table

<?php
include "../../lib/inc_con.php";
session_start();
$mesa = $_POST['mesa'];
$tamanho = $_POST['tamanho'];
$quantidade = $_POST['qtd'];
$add = $_POST['add'];
$hiddentotal = $_POST['hiddentotal'];
$data = date('Y-m-d H:i:s');
$produto_id1 = $_POST['produto_id1'];
$atendente_id = $_SESSION['id'];

$sql = mysql_query("INSERT INTO pedidos (mesa, tamanho, qtd, add, hiddentotal, data, produto_id1, atendente_id) values ('$mesa', '$tamanho', '$quantidade', '$add', '$hiddentotal', '$data', '$produto_id1', '$atendente_id')") or die (mysql_error());

?>

if necessary here is my table

And here’s the error that’s showing on the screen

You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near 'add, hiddentotal, date, producto_id1, atendente_id) values ('6', '14.25', '2', '1' at line 1

Answer 1

The problem is add is a mysql reserved word then it is necessary to escape column names or tables with backsticks.

The add is usually seen this way:

ALTER TABLE <nome> ADD COLUMN <nome> ... 

Corrected query:

INSERT INTO pedidos (mesa, tamanho, qtd, `add`, hiddentotal, data, produto_id1, atendente_id)
 values ('$mesa', '$tamanho', '$quantidade', '$add', '$hiddentotal', '$data', '$produto_id1', '$atendente_id')"

Answer 2

The error is in the entry of your column date in Mysql. Your column date is of the defined type date, so this type accepts input values in the format yyyy-mm-dd and its variable $data is trying to pass the value of yyyy-mm-dd H:i:s.

2 options for correction:

1. Change the value of your variable to date('Y-m-d')

or

2. Change the type of your column date in Mysql of date for datetime, so you can receive the value in the format you are trying to pass.

Mysql Reference Manual > Data Types > Date and Time Types

Answer 3

Yes, it is really due to the use of the reserved word 'add', as to the date, it is appropriate to change the field in the database to datetime, otherwise no error appears but the data that will appear in the database will be - '0000-00-00'.