php-mysql-pdo: execute not working after prepare when inserting

Question

I have following lines:

    $sql = "INSERT INTO news (title, content) VALUES :title, :content";
    $pre = $this->prepare($sql);
    $pre->bindValue(":title", "xxx");
    $pre->bindValue(":content", "yyy");
    $pre->execute();

I get no error, but the query is also not executed (i checked the query log).

I tried following changes desperately:

 $t="xxx" and $pre->bindValue(":title", $t); (the same also for y)
 $sql = "INSERT INTO `news` (`title`, `content`) VALUES :title, :content";
 $sql = "INSERT INTO `news` (`title`, `content`) VALUES ':title', ':content'";

Nothing changes. Funny thing is i get no response, no warning, no error just nothing. But the query is not executed.

I found similar posts but non of them solved my problem.

(about $this ... The code is in a class extended from PDO class.)

Don't forget about the method errorInfo(). Does that give you any errors? — user1846065
– user1846065, Commented Dec 14, 2013 at 18:50
If you were using a development framework or at least an ORM like Propel or Doctrine you wouldn't need to fuss around with stuff like this. — tadman
– tadman, Commented Dec 14, 2013 at 19:54

Krish R · Accepted Answer · 2013-12-14 18:53:11Z

4

try this, your values should be wrapped inside the values()

"INSERT INTO news (title, content) VALUES (:title, :content)";

instead of

"INSERT INTO news (title, content) VALUES :title, :content";

edited Dec 14, 2013 at 18:53

answered Dec 14, 2013 at 18:47

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MillaresRoo · Accepted Answer · 2013-12-14 18:54:49Z

3

Try: "INSERT INTO news (title, content) VALUES (:title, :content)";

You must surround the insert values with parentheses.

edited Dec 14, 2013 at 18:54

answered Dec 14, 2013 at 18:49

MillaresRoo

3,8581 gold badge35 silver badges39 bronze badges

1 Comment

user1846065 Over a year ago

It would make your answer a little better if you explained the subtle difference between this and the asker's code.

Collectives™ on Stack Overflow

php-mysql-pdo: execute not working after prepare when inserting

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related