Prepared statement PDO does nothing

Question

I am trying to figure out how prepared statements work in PDO. I have the following file:

<?php


$user = "root";
$pass = "<removed for this post>";
$db = new PDO("mysql:host=localhost;dbname=pdo-demo", $user, $pass);

$stmt = $db->prepare("INSERT INTO pdo-demo (firstname, lastname, email) value (:firstname, :lastname, :email)");

$stmt->bindParam(':firstname', $firstname);
$stmt->bindParam(':lastname', $lastname);
$stmt->bindParam(':email', $email);

$firstname = "John";
$lastname = "Doe";
$email = "johndoe@nowhere123.com";
$stmt->execute();

$db = null;?>

When I enter the page nothing happens, what am I missing? Shouldn't it insert the data?

You are missing error reporting. Refer to the linked answer for the proper setup to get the error message from PHP.PDO which will give you a clue. — Your Common Sense, Feb 26 '17 at 14:41
This question was closed with the wrong duplicate in not addressing the real problem. Simply getting errors doesn't inform what the person should have used. Get that through your head YCS. — Funk Forty Niner, Feb 26 '17 at 14:42
Possible duplicate of [When to use single quotes, double quotes, and backticks in MySQL](http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — Funk Forty Niner, Feb 26 '17 at 14:44
to which I reopened with this ^ new duplicate. So, wrap it in ticks `\`` or use an underscore. — Funk Forty Niner, Feb 26 '17 at 14:44
@crystyxn well one person obviously used my comment in their answer *lol* — Funk Forty Niner, Feb 26 '17 at 14:57

score 0 · Answer 1 · answered Feb 26 '17 at 14:48

0

pdo-demo that translates to pdo minus demo And your using that name for database AND table.

answered Feb 26 '17 at 14:48

Annemieke Buijs

80
7

both my db and table are called pdo-demo – crystyxn Feb 26 '17 at 14:49
1

[*"pdo-demo that translates to pdo minus demo"*](http://stackoverflow.com/questions/42469803/prepared-statement-pdo-does-nothing?noredirect=1#comment72080427_42469803) - If you're going to post an answer based on a comment, you really should be quoting the person who wrote that comment up there, mainly *"moi"*. – Funk Forty Niner Feb 26 '17 at 14:58
My bad, won't happen again – Annemieke Buijs Feb 26 '17 at 15:38

score 0 · Accepted Answer · answered Feb 26 '17 at 14:54

0

Turns out I needed backticks (`) for the variable names like so:

$stmt = $db->prepare("INSERT INTO `pdo-demo` (`firstname`, `lastname`, `email`) value (:firstname, :lastname, :email)");

Now it worked

answered Feb 26 '17 at 14:54

crystyxn

1,411
4
27
59

Prepared statement PDO does nothing

2 Answers2