PDO

pecl::PDO

[ AdvancedSearch | AreaMap ]

exec

execute() in ADOdb and query() in PEAR::DB can be used instead of prepare() and execute(), if you set a second parameter (data array) and your query uses placeholders.

In PDO exec() can only do the following:

<?php
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
?>

what about something like:

<?php
$data = array(
 'extension' => $extension,
 'name' => $name
);
$count = $dbh->exec("INSERT INTO CREDITS (extension, name) VALUES (:extension, :name)", $data);
?>

of course the second parameter is optional. The syntax should fit to bindParam.

This site powered by YaWiki 0.22 beta.