Sql calculates date instead of insert

Question

Sql calculates date instead of insert

Navigation

#1 by (0 votes)

-1

I'm trying to insert date into my DB but sql calculates the result always is 1997 in the fields I tested as "date" and did not insert "varchar and text" resulted me a calculation of subtraction of the current date

$conn = new PDO('mysql:host=localhost;dbname=data', 'root');

   $query = 'INSERT INTO codes (code,dt) VALUES ('.$generator.','.$data_atual.')';

?>

php mysql

asked by anonymous 13.07.2017 / 02:40

1 answer

Python / Pandas - How to create in the data frame, a column "str" from another numeric, including zero to the left when the value is less than 9 Change content according to select option

score 0 · Accepted Answer

Missing parentheses in sql. You do not need to use periods in the variables: if you use single quotes in variables, then use double quotation marks in the SQL row. PDO has to prepare before running.

$query = $conn -> prepare ("INSERT INTO codes (code,dt) VALUES ('$generator','$data_atual')");
$query -> execute();