How to correctly make a PDO statement with PHP variables as parameters?

Question

I currently have the following code:

$dbh = new PDO('mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

$dbh->prepare("INSERT INTO mdr_contacts SET fkRelatieId = 0, reseller = 0, code = :code, naam = :naam");
$dbh->execute(array(":code" => $contact["contact_id"],":naam" => $name));

However this seems to fail: Fatal error: Call to undefined method PDO::execute() in file.php on line 67

What i've done so far to make this work:

Checked if $name and $contact exists and has the right value.
Executed a SELECT query before the prepare statement to make sure that PDO works.
Runned the code without ATTR_EMULATE_PREPARES set to false.

But none of this works, can anyone set me in the right direction?

Ray · Accepted Answer · 2012-11-05 14:41:09Z

2

You execute a statement, not a connection. prepare() on a connection, returns a statement.

Also, I prefer to explicitly call bind on values, but this is just my OCD prefs.

 $statement = $dbh->prepare("INSERT INTO mdr_contacts SET fkRelatieId = 0, reseller = 0, code = :code, naam = :naam");
 $statement->bindValue(":code", $contact["contact_id"]);
 $statement->bindValue(":naam", $name);
 $statement->execute();

answered Nov 5, 2012 at 14:41

Ray

41.6k22 gold badges110 silver badges144 bronze badges

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

2 Comments

RTB Over a year ago

my god i feel like such an idiot. This completly works. Thanks.

Ray Over a year ago

@RTB no problem... also check your spelling of 'name' ;)

Collectives™ on Stack Overflow

How to correctly make a PDO statement with PHP variables as parameters?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related