cvs: phpdoc /en/reference/pdo/functions PDOStatement-execute.xml

dbs Wed May 3 15:22:00 2006 UTC Modified files: /phpdoc/en/reference/pdo/functions PDOStatement-execute.xml Log: Add an example for placeholders. http://cvs.php.net/viewcvs.cgi/phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml?r1=1.8&r2=1.9&diff_format=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml:1.8 phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml:1.9 --- phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml:1.8 Sun Jan 8 14:02:42 2006 +++ phpdoc/en/reference/pdo/functions/PDOStatement-execute.xml Wed May 3 15:22:00 2006 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.8 $ --> +<!-- $Revision: 1.9 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-execute"> <refnamediv> @@ -75,7 +75,7 @@ </programlisting> </example> - <example><title>Execute a prepared statement with an array of insert values</title> + <example><title>Execute a prepared statement with an array of insert values (named parameters)</title> <programlisting role='php'> <![CDATA[ <?php @@ -91,6 +91,23 @@ </programlisting> </example> + <example><title>Execute a prepared statement with an array of insert values (placeholders)</title> + <programlisting role='php'> +<![CDATA[ +<?php +/* Execute a prepared statement by passing an array of insert values */ +$calories = 150; +$colour = 'red'; +$sth = $dbh->prepare('SELECT name, colour, calories + FROM fruit + WHERE calories < ? AND colour = ?'); +$sth->execute(array($calories, $colour)); +?> +]]> + </programlisting> + </example> + + <example><title>Execute a prepared statement with question mark placeholders</title> <programlisting role='php'> <![CDATA[