simenec Wed Oct 26 11:27:30 2005 EDT
Modified files:
/phpdoc/en/reference/maxdb/functions maxdb-stmt-bind-param.xml
Log:
update documentation
http://cvs.php.net/diff.php/phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml?r1=1.4&r2=1.5&ty=u
Index: phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml
diff -u phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml:1.4
phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml:1.5
--- phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml:1.4 Wed May
4 05:39:11 2005
+++ phpdoc/en/reference/maxdb/functions/maxdb-stmt-bind-param.xml Wed Oct
26 11:27:30 2005
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.4 $ -->
+<!-- $Revision: 1.5 $ -->
<refentry id="function.maxdb-stmt-bind-param">
<refnamediv>
<refname>maxdb_stmt_bind_param</refname>
@@ -22,11 +22,28 @@
<methodsynopsis>
<type>bool</type>
<methodname>bind_param</methodname>
- <methodparam><type>array</type><parameter>types</parameter></methodparam>
+
<methodparam><type>string</type><parameter>types</parameter></methodparam>
<methodparam><type>mixed</type><parameter
role="reference">var1</parameter></methodparam>
<methodparam choice="opt"><type>mixed</type><parameter
role="reference">...</parameter></methodparam>
</methodsynopsis>
</classsynopsis>
+ <para>Procedural style (extended syntax):</para>
+ <methodsynopsis>
+ <type>bool</type><methodname>maxdb_stmt_bind_param</methodname>
+
<methodparam><type>resource</type><parameter>stmt</parameter></methodparam>
+ <methodparam><type>string</type><parameter>types</parameter></methodparam>
+ <methodparam><type>array</type><parameter
role="reference">var</parameter></methodparam>
+ </methodsynopsis>
+ <para>Object oriented style (method) (extended syntax):</para>
+ <classsynopsis>
+ <ooclass><classname>stmt</classname></ooclass>
+ <methodsynopsis>
+ <type>bool</type>
+ <methodname>bind_param</methodname>
+
<methodparam><type>string</type><parameter>types</parameter></methodparam>
+ <methodparam><type>array</type><parameter
role="reference">var</parameter></methodparam>
+ </methodsynopsis>
+ </classsynopsis>
<para>
<function>maxdb_stmt_bind_param</function> is used to bind variables for
the
parameter markers in the SQL statement that was passed to
@@ -35,6 +52,12 @@
the types for the corresponding bind variables.
</para>
<para>
+ The extended syntax of <function>maxdb_stmt_bind_param</function> allows
to give the parameters
+ as an array instead of a variable list of PHP variables to the function.
If the array variable has not been
+ used before calling <function>maxdb_stmt_bind_param</function>, it has to
be initialized as an emtpy
+ array. See the examples how to use
<function>maxdb_stmt_bind_param</function> with extended syntax.
+ </para>
+ <para>
Variables for SELECT INTO SQL statements can also be bound using
<function>maxdb_stmt_bind_param</function>.
Parameters for database procedures can be bound using
<function>maxdb_stmt_bind_param</function>. See the
examples how to use <function>maxdb_stmt_bind_param</function> in this
cases.
@@ -277,6 +300,79 @@
a
]]>
</screen>
+ <example>
+ <title>Object oriented style (extended syntax)</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+$maxdb = new maxdb('localhost', 'MONA', 'RED', 'DEMODB');
+
+/* check connection */
+if (maxdb_connect_errno()) {
+ printf("Connect failed: %s\n", maxdb_connect_error());
+ exit();
+}
+
+$maxdb->query ("CREATE TABLE temp.mycity LIKE hotel.city");
+$maxdb->query ("INSERT INTO temp.mycity SELECT * FROM hotel.city");
+
+$stmt = $maxdb->prepare("INSERT INTO temp.mycity VALUES (?, ?, ?)");
+
+$arr = array();
+
+$stmt->bind_param('iss', $arr);
+
+$arr[0] = 11111;
+$arr[1] = 'Georgetown';
+$arr[2] = 'NY';
+
+/* execute prepared statement */
+$stmt->execute();
+
+printf("%d Row inserted.\n", maxdb_stmt_affected_rows($stmt));
+
+$arr[0] = 22222;
+$arr[1] = 'New Orleans';
+$arr[2] = 'LA';
+
+/* execute prepared statement */
+$stmt->execute();
+
+printf("%d Row inserted.\n", $stmt->affected_rows);
+
+/* close statement and connection */
+$stmt->close();
+
+$result = $maxdb->query("SELECT * from temp.mycity WHERE zip = '11111' OR zip
= '22222'");
+if ($result) {
+ while ($row = $result->fetch_row()) {
+ printf ("%s %s %s\n", $row[0], $row[1], $row[2]);
+ }
+}
+
+/* Clean up table CountryLanguage */
+$maxdb->query("DELETE FROM temp.mycity WHERE name='Georgetown'");
+$maxdb->query("DELETE FROM temp.mycity WHERE name='New Orleans'");
+printf("%d Rows deleted.\n", $maxdb->affected_rows);
+
+/* close connection */
+$maxdb->close();
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ The above examples would produce the following output:
+ </para>
+ <screen>
+<![CDATA[
+1 Row inserted.
+1 Row inserted.
+11111 Georgetown NY
+22222 New Orleans LA
+2 Rows deleted.
+]]>
+ </screen>
</refsect1>
</refentry>
