Error in the PDO database

Question

Error in the PDO database

Navigation

#1 by (4 votes)

3

I am creating a page that saves values in the MySql database using PDO and is not writing the data. I'm using the following code:

<?php
  $conexao = new PDO('mysql:host=localhost;dbname=dbTeste', 'root', '');

  $query = "INSERT INTO names(nome, email) VALUES('Wade', '[email protected]')";

  $stmt = $conexao->prepare($query);
  $stmt->execute();
?>

But do not save the data in the database.

php mysql pdo

asked by anonymous 14.08.2015 / 20:57

1 answer

Adding and removing elements in an array When mapping class to viewModel, some data is lost

score 4 · Accepted Answer

The problem is the name of your table NAMES is a mysql reserved word, in this case it is mandatory to escape the name with crase '' ''

Change:

$query = "INSERT INTO names(nome, email) VALUES('Wade', '[email protected]')";

To:

$query = "INSERT INTO 'names'(nome, email) VALUES('Wade','[email protected]')";
                      ^-----^

List of reserved words