cvs: phpdoc /en/reference/mysqli/functions mysqli-affected-rows.xml mysqli-autocommit.xml mysqli-bind-param.xml mysqli-bind-result.xml
mysqli-change-user.xml
| From: | Georg Richter | Date: | Thu, 19 Feb 2004 16:27:40 +0000 |
| Subject: | cvs: phpdoc /en/reference/mysqli/functions mysqli-affected-rows.xml mysqli-autocommit.xml mysqli-bind-param.xml mysqli-bind-result.xml mysqli-change-user.xml |
||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969359074@lists.php.net to get a copy of this message | ||
georg Thu Feb 19 11:27:40 2004 EDT
Modified files:
/phpdoc/en/reference/mysqli/functions mysqli-affected-rows.xml
mysqli-autocommit.xml
mysqli-bind-param.xml
mysqli-bind-result.xml
mysqli-change-user.xml
Log:
added and fixed samples
http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml?r1=1.12&r2=1.13&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.12 phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.13 --- phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.12 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="function.mysqli-affected-rows"> <refnamediv> <refname>mysqli_affected_rows</refname> @@ -51,84 +51,83 @@ </note> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_num_rows</function>, + <function>mysqli_info</function>. + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Example for affected rows</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ - <?php - /* - +-----------------------------------------------------------+ - | file: mysqli_affected_rows.php | - +-----------------------------------------------------------+ - | modifies some datasets and returns number of affected | - | rows | - +-----------------------------------------------------------+ - */ - - /* ---- Procedural style ---- */ - $link = mysqli_connect("localhost", "my_user", "my_password", "test") - or die("Can't connect to MySQL server on localhost"); - - /* create table and insert some data */ - mysqli_query($link, "DROP TABLE IF EXISTS affected_rows"); - mysqli_query($link, "CREATE TABLE affected_rows (a int)"); - mysqli_query($link, "INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); - - /* update values and retrieve number of affected rows */ - mysqli_query($link, "UPDATE affected_rows SET a=5 WHERE a=1"); - printf("Affected rows (update): %d\n", mysqli_affected_rows($link)); - - /* delete rows and retrieve number of affected_rows */ - mysqli_query($link, "DELETE FROM affected_rows WHERE a < 4"); - printf("Affected rows (delete): %d\n", mysqli_affected_rows($link)); - - /* select all rows and retrieve number of affected_rows */ - mysqli_query($link, "SELECT a FROM affected_rows"); - printf("Affected rows (select): %d\n", mysqli_affected_rows($link)); - - mysqli_close($link); - - /* ---- Object oriented style ----*/ - $mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - - if (mysqli_connect_errno()) { - printf("Connect failed: %s\n", mysqli_connect_error()); - exit(); - } - - /* create table and insert some data */ - $mysqli->query("DROP TABLE IF EXISTS affected_rows"); - $mysqli->query("CREATE TABLE affected_rows (a int)"); - $mysqli->query("INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); - - /* update values and retrieve number of affected rows */ - $mysqli->query("UPDATE affected_rows SET a=5 WHERE a=1"); - printf("Affected rows (update): %d\n", $mysqli->affected_rows); - - /* delete rows and retrieve number of affected_rows */ - $mysqli->query("DELETE FROM affected_rows WHERE a < 4"); - printf("Affected rows (delete): %d\n", $mysqli->affected_rows); - - /* select all rows and retrieve number of affected_rows */ - $mysqli->query("SELECT a FROM affected_rows"); - printf("Affected rows (select): %d\n", $mysqli->affected_rows); +<?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - $mysqli->close(); - ?> +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); + exit(); +} + +/* create table and insert some data */ +$mysqli->query("DROP TABLE IF EXISTS affected_rows"); +$mysqli->query("CREATE TABLE affected_rows (a int)"); +$mysqli->query("INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); + +/* update values and retrieve number of affected rows */ +$mysqli->query("UPDATE affected_rows SET a=5 WHERE a=1"); +printf("Affected rows (update): %d\n", $mysqli->affected_rows); + +/* delete rows and retrieve number of affected_rows */ +$mysqli->query("DELETE FROM affected_rows WHERE a < 4"); +printf("Affected rows (delete): %d\n", $mysqli->affected_rows); + +/* select all rows and retrieve number of affected_rows */ +$mysqli->query("SELECT a FROM affected_rows"); +printf("Affected rows (select): %d\n", $mysqli->affected_rows); + +/* close connection */ +$mysqli->close(); +?> + ]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); + +/* create table and insert some data */ +mysqli_query($link, "DROP TABLE IF EXISTS affected_rows"); +mysqli_query($link, "CREATE TABLE affected_rows (a int)"); +mysqli_query($link, "INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); + +/* update values and retrieve number of affected rows */ +mysqli_query($link, "UPDATE affected_rows SET a=5 WHERE a=1"); +printf("Affected rows (update): %d\n", mysqli_affected_rows($link)); + +/* delete rows and retrieve number of affected_rows */ +mysqli_query($link, "DELETE FROM affected_rows WHERE a < 4"); +printf("Affected rows (delete): %d\n", mysqli_affected_rows($link)); + +/* select all rows and retrieve number of affected_rows */ +mysqli_query($link, "SELECT a FROM affected_rows"); +printf("Affected rows (select): %d\n", mysqli_affected_rows($link)); + +/* close connection */ +mysqli_close($link); +?> ]]> </programlisting> </example> </para> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_num_rows</function>, - <function>mysqli_info</function>. - </para> - </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml?r1=1.11&r2=1.12&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.11 phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.12 --- phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.11 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="function.mysqli-autocommit"> <refnamediv> <refname>mysqli_autocommit</refname> @@ -46,70 +46,67 @@ </para> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_commit</function>, + <function>mysqli_rollback</function>. + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Using the mysqli_autocommit function</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php -/* - +-----------------------------------------------------------+ - | file: mysqli_autocommit.php | - +-----------------------------------------------------------+ - | connects to MySQL server on localhost, turns autocommit | - | on and retrieves autocommit variable | - +-----------------------------------------------------------+ -*/ - - /* ---- Procedural style ---- */ - $link = mysqli_connect("localhost", "my_user", "my_password", "test") - or die("Can't connect to MySQL server on localhost"); - - /* turn autocommit on */ - mysqli_autocommit($link, TRUE); - - if ($result = mysqli_query($link, "SELECT @@autocommit")) { - $row = mysqli_fetch_row($result); - printf("Autocommit is %s\n", $row[0]); - mysqli_free_result($result); - } - - mysqli_close($link); - - /* ---- Object oriented style ----*/ - $mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - - if (mysqli_connect_errno()) { - printf("Connect failed: %s\n", mysqli_connect_error()); - exit(); - } - - /* turn autocommit on */ - $mysqli->autocommit(TRUE); - - if ($result = $mysqli->query("SELECT @@autocommit")) { - $row = $result->fetch_row(); - printf("Autocommit is %s\n", $row[0]); - $result->free(); - } +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); +exit(); +} + +/* turn autocommit on */ +$mysqli->autocommit(TRUE); + +if ($result = $mysqli->query("SELECT @@autocommit")) { + $row = $result->fetch_row(); + printf("Autocommit is %s\n", $row[0]); + $result->free(); +} - $mysqli->close(); +/* close connection */ +$mysqli->close(); ?> +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); +/* turn autocommit on */ +mysqli_autocommit($link, TRUE); + +if ($result = mysqli_query($link, "SELECT @@autocommit")) { + $row = mysqli_fetch_row($result); + printf("Autocommit is %s\n", $row[0]); + mysqli_free_result($result); +} + +/* close connection */ +mysqli_close($link); ?> ]]> </programlisting> </example> </para> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_commit</function>, - <function>mysqli_rollback</function>. - </para> - </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml?r1=1.5&r2=1.6&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.5 phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.6 --- phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.5 Wed Feb 11 03:10:47 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> +<!-- $Revision: 1.6 $ --> <refentry id="function.mysqli-bind-param"> <refnamediv> <refname>mysqli_bind_param</refname> @@ -83,74 +83,80 @@ </para> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_bind_result</function>, + <function>mysqli_execute</function>, + <function>mysqli_fetch</function>, +<!-- <function>mysqli_fetch_column</function> --> + <function>mysqli_prepare</function>, + <function>mysqli_send_long_data</function>, + <function>mysqli_stmt_errno</function>, + <function>mysqli_stmt_error</function> + </para> + </refsect1> + <refsect1> <title>Example</title> <example> - <title>Prepared statements</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - /* --- procedural style --- */ - $link = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or - die("Could not connect: " . mysqli_connect_error()); - - /* create mytable */ - mysqli_query($link, "CREATE TABLE mytable (a int, b int, c varchar(30))"); +/* create mytable */ +$mysqli->query("DROP TABLE IF EXISTS mytable"); +$mysqli->query("CREATE TABLE mytable (a int, b int, c varchar(30))"); - /* prepare statement and bind variables for insert statements */ - $stmt = mysqli_prepare($link, "INSERT INTO mytable VALUES (?, ?, ?)"); - mysqli_bind_param("iis", $a, $b, $c); - - $a = 1; - $b = 2; - $c = "I prefer OpenSource software"; - - /* execute prepared statement */ - mysqli_execute($stmt); - - /* close statement and connection */ - mysqli_close_stmt(stmt); - mysqli_close(link); - - /* --- object oriented style --- */ - $mysql = new mysqli("localhost", "mysql_user", "mysql_password", "mydb"); +/* prepare statement and bind parameters */ +$stmt = $mysqli->prepare("INSERT INTO mytable VALUES (?, ?, ?)"); +$stmt->bind_param("iis", $a, $b, $c); + +$a = 1; +$b = 2; +$c = "I like PHP"; + +/* execute prepared statement */ +$stmt->execute(); + +/* close statement and connection */ +$stmt->close(); +$mysqli->close(); +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") or +die("Could not connect: " . mysqli_connect_error()); - /* create mytable */ - $mysql->query("CREATE TABLE mytable (a int, b int, c varchar(30))"); +/* create mytable */ +mysqli_query($link, "DROP TABLE IF EXISTS mytable"); +mysqli_query($link, "CREATE TABLE mytable (a int, b int, c varchar(30))"); - /* prepare statement and bind parameters */ - $stmt = $mysql->prepare("INSERT INTO mytable VALUES (?, ?, ?)"); - $stmt->bind_param("iis", $a, $b, $c); - - $a = 1; - $b = 2; - $c = "I prefer opensource software"; - - /* execute prepared statement */ - $stmt->execute(); - - /* close statement and connection */ - $stmt->close(); - $mysql->close(); +/* prepare statement and bind variables for insert statements */ +$stmt = mysqli_prepare($link, "INSERT INTO mytable VALUES (?, ?, ?)"); +mysqli_bind_param($stmt, "iis", $a, $b, $c); + +$a = 1; +$b = 2; +$c = "I like PHP"; + +/* execute prepared statement */ +mysqli_execute($stmt); + +/* close statement and connection */ +mysqli_stmt_close($stmt); +mysqli_close($link); ?> ]]> </programlisting> </example> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_bind_result</function>, - <function>mysqli_execute</function>, - <function>mysqli_fetch</function>, -<!-- <function>mysqli_fetch_column</function> --> - <function>mysqli_prepare</function>, - <function>mysqli_send_long_data</function>, - <function>mysqli_stmt_errno</function>, - <function>mysqli_stmt_error</function> - </para> - </refsect1> - </refentry> + </refentry> <!-- Keep this comment at the end of the file Local variables: http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml?r1=1.2&r2=1.3&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.2 phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.3 --- phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.2 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <refentry id="function.mysqli-bind-result"> <refnamediv> <refname>mysqli_bind_result</refname> @@ -60,7 +60,88 @@ <function>mysqli_stmt_error</function> </para> </refsect1> - </refentry> + <refsect1> + <title>Example</title> + <para> + <example> + <title>Object oriented style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); + exit(); +} + +/* create table and insert some data */ +$mysqli->query("DROP TABLE IF EXISTS bind_result"); +$mysqli->query("CREATE TABLE bind_result (id int, extension varchar(20))"); +$mysqli->query("INSERT INTO bind_result VALUES (1, 'ldap')"); +$mysqli->query("INSERT INTO bind_result VALUES (2, 'mysql')"); +$mysqli->query("INSERT INTO bind_result VALUES (3, 'pcre')"); + +/* prepare statement */ +if ($stmt = $mysqli->prepare("SELECT id, extension FROM bind_result")) { + $stmt->execute(); + + /* bind variables to prepared statement */ + $stmt->bind_result($col1, $col2); + + /* fetch values */ + while ($stmt->fetch()) { + printf("Id: %d Extension: %s\n", $col1, $col2); + } + /* close statement */ + $stmt->close(); +} +/* close connection */ +$mysqli->close(); + +?> + ]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); + +/* create table and insert some data */ +mysqli_query($link, "DROP TABLE IF EXISTS bind_result"); +mysqli_query($link, "CREATE TABLE bind_result (id int, extension varchar(20))"); +mysqli_query($link, "INSERT INTO bind_result VALUES (1, 'ldap')"); +mysqli_query($link, "INSERT INTO bind_result VALUES (2, 'mysql')"); +mysqli_query($link, "INSERT INTO bind_result VALUES (3, 'pcre')"); + +/* prepare statement */ +if ($stmt = mysqli_prepare($link, "SELECT id, extension FROM bind_result")) { + mysqli_execute($stmt); + + /* bind variables to prepared statement */ + mysqli_bind_result($stmt, $col1, $col2); + + /* fetch values */ + while (mysqli_fetch($stmt)) { + printf("Id: %d Extension: %s\n", $col1, $col2); + } + /* close statement */ + mysqli_stmt_close($stmt); +} + +/* close connection */ +mysqli_close($link); +?> + ]]> + </programlisting> + </example> + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml?r1=1.7&r2=1.8&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.7 phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.8 --- phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.7 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.7 $ --> +<!-- $Revision: 1.8 $ --> <refentry id="function.mysqli-change-user"> <refnamediv> <refname>mysqli_change_user</refname> @@ -59,21 +59,68 @@ </para> </refsect1> <refsect1> + <title>See also:</title> + <para> + <function>mysqli_connect</function> + <function>mysqli_select_db</function> + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Using the mysqli_change_user function</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php - - /* Open a connection as foo@localhost and select foo_db */ - $link = mysqli_connect("localhost", "foo", "pass"); - mysqli_select_db("foo_db"); + +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +$mysqli->query("CREATE TEMPORARY TABLE mytemp (a int)"); - /* Change user to bar@localhost and default database to bar_db */ - mysqli_change_user($link, "bar", "otherpass", "bar_db"); +/* reset all */ +$mysqli->change_user("my_user", "my_password", NULL); + +if ($result = $mysqli->query("SELECT DATABASE()")) { + $row = $result->fetch_row(); + printf("Default database: %s\n", $row[0]); + $result->close(); +} + +if (!($result = $mysqli->query("SHOW TABLES LIKE mytemp"))) { + printf ("temporary table mytemp doesn't exist\n"); +} + +/* close connection */ +$mysqli->close(); +?> +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test"); + +mysqli_query($link, "CREATE TEMPORARY TABLE mytemp (a int)"); + +/* reset all */ +mysqli_change_user($link, "my_user", "my_password", NULL); + +if ($result = mysqli_query($link, "SELECT DATABASE()")) { + $row = mysqli_fetch_row($result); + printf("Default database: %s\n", $row[0]); + mysqli_free_result($result); +} + +if (!($result = mysqli_query($link, "SHOW TABLES LIKE mytemp"))) { + printf ("temporary table mytemp doesn't exist\n"); +} +/* close connection */ +mysqli_close($link); ?> ]]> </programlisting>
http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml?r1=1.12&r2=1.13&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.12 phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.13 --- phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.12 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="function.mysqli-affected-rows"> <refnamediv> <refname>mysqli_affected_rows</refname> @@ -51,84 +51,83 @@ </note> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_num_rows</function>, + <function>mysqli_info</function>. + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Example for affected rows</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ - <?php - /* - +-----------------------------------------------------------+ - | file: mysqli_affected_rows.php | - +-----------------------------------------------------------+ - | modifies some datasets and returns number of affected | - | rows | - +-----------------------------------------------------------+ - */ - - /* ---- Procedural style ---- */ - $link = mysqli_connect("localhost", "my_user", "my_password", "test") - or die("Can't connect to MySQL server on localhost"); - - /* create table and insert some data */ - mysqli_query($link, "DROP TABLE IF EXISTS affected_rows"); - mysqli_query($link, "CREATE TABLE affected_rows (a int)"); - mysqli_query($link, "INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); - - /* update values and retrieve number of affected rows */ - mysqli_query($link, "UPDATE affected_rows SET a=5 WHERE a=1"); - printf("Affected rows (update): %d\n", mysqli_affected_rows($link)); - - /* delete rows and retrieve number of affected_rows */ - mysqli_query($link, "DELETE FROM affected_rows WHERE a < 4"); - printf("Affected rows (delete): %d\n", mysqli_affected_rows($link)); - - /* select all rows and retrieve number of affected_rows */ - mysqli_query($link, "SELECT a FROM affected_rows"); - printf("Affected rows (select): %d\n", mysqli_affected_rows($link)); - - mysqli_close($link); - - /* ---- Object oriented style ----*/ - $mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - - if (mysqli_connect_errno()) { - printf("Connect failed: %s\n", mysqli_connect_error()); - exit(); - } - - /* create table and insert some data */ - $mysqli->query("DROP TABLE IF EXISTS affected_rows"); - $mysqli->query("CREATE TABLE affected_rows (a int)"); - $mysqli->query("INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); - - /* update values and retrieve number of affected rows */ - $mysqli->query("UPDATE affected_rows SET a=5 WHERE a=1"); - printf("Affected rows (update): %d\n", $mysqli->affected_rows); - - /* delete rows and retrieve number of affected_rows */ - $mysqli->query("DELETE FROM affected_rows WHERE a < 4"); - printf("Affected rows (delete): %d\n", $mysqli->affected_rows); - - /* select all rows and retrieve number of affected_rows */ - $mysqli->query("SELECT a FROM affected_rows"); - printf("Affected rows (select): %d\n", $mysqli->affected_rows); +<?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - $mysqli->close(); - ?> +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); + exit(); +} + +/* create table and insert some data */ +$mysqli->query("DROP TABLE IF EXISTS affected_rows"); +$mysqli->query("CREATE TABLE affected_rows (a int)"); +$mysqli->query("INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); + +/* update values and retrieve number of affected rows */ +$mysqli->query("UPDATE affected_rows SET a=5 WHERE a=1"); +printf("Affected rows (update): %d\n", $mysqli->affected_rows); + +/* delete rows and retrieve number of affected_rows */ +$mysqli->query("DELETE FROM affected_rows WHERE a < 4"); +printf("Affected rows (delete): %d\n", $mysqli->affected_rows); + +/* select all rows and retrieve number of affected_rows */ +$mysqli->query("SELECT a FROM affected_rows"); +printf("Affected rows (select): %d\n", $mysqli->affected_rows); + +/* close connection */ +$mysqli->close(); +?> + ]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); + +/* create table and insert some data */ +mysqli_query($link, "DROP TABLE IF EXISTS affected_rows"); +mysqli_query($link, "CREATE TABLE affected_rows (a int)"); +mysqli_query($link, "INSERT INTO affected_rows VALUES (1),(2),(3),(4)"); + +/* update values and retrieve number of affected rows */ +mysqli_query($link, "UPDATE affected_rows SET a=5 WHERE a=1"); +printf("Affected rows (update): %d\n", mysqli_affected_rows($link)); + +/* delete rows and retrieve number of affected_rows */ +mysqli_query($link, "DELETE FROM affected_rows WHERE a < 4"); +printf("Affected rows (delete): %d\n", mysqli_affected_rows($link)); + +/* select all rows and retrieve number of affected_rows */ +mysqli_query($link, "SELECT a FROM affected_rows"); +printf("Affected rows (select): %d\n", mysqli_affected_rows($link)); + +/* close connection */ +mysqli_close($link); +?> ]]> </programlisting> </example> </para> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_num_rows</function>, - <function>mysqli_info</function>. - </para> - </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml?r1=1.11&r2=1.12&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.11 phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.12 --- phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml:1.11 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-autocommit.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="function.mysqli-autocommit"> <refnamediv> <refname>mysqli_autocommit</refname> @@ -46,70 +46,67 @@ </para> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_commit</function>, + <function>mysqli_rollback</function>. + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Using the mysqli_autocommit function</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php -/* - +-----------------------------------------------------------+ - | file: mysqli_autocommit.php | - +-----------------------------------------------------------+ - | connects to MySQL server on localhost, turns autocommit | - | on and retrieves autocommit variable | - +-----------------------------------------------------------+ -*/ - - /* ---- Procedural style ---- */ - $link = mysqli_connect("localhost", "my_user", "my_password", "test") - or die("Can't connect to MySQL server on localhost"); - - /* turn autocommit on */ - mysqli_autocommit($link, TRUE); - - if ($result = mysqli_query($link, "SELECT @@autocommit")) { - $row = mysqli_fetch_row($result); - printf("Autocommit is %s\n", $row[0]); - mysqli_free_result($result); - } - - mysqli_close($link); - - /* ---- Object oriented style ----*/ - $mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - - if (mysqli_connect_errno()) { - printf("Connect failed: %s\n", mysqli_connect_error()); - exit(); - } - - /* turn autocommit on */ - $mysqli->autocommit(TRUE); - - if ($result = $mysqli->query("SELECT @@autocommit")) { - $row = $result->fetch_row(); - printf("Autocommit is %s\n", $row[0]); - $result->free(); - } +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); +exit(); +} + +/* turn autocommit on */ +$mysqli->autocommit(TRUE); + +if ($result = $mysqli->query("SELECT @@autocommit")) { + $row = $result->fetch_row(); + printf("Autocommit is %s\n", $row[0]); + $result->free(); +} - $mysqli->close(); +/* close connection */ +$mysqli->close(); ?> +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); +/* turn autocommit on */ +mysqli_autocommit($link, TRUE); + +if ($result = mysqli_query($link, "SELECT @@autocommit")) { + $row = mysqli_fetch_row($result); + printf("Autocommit is %s\n", $row[0]); + mysqli_free_result($result); +} + +/* close connection */ +mysqli_close($link); ?> ]]> </programlisting> </example> </para> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_commit</function>, - <function>mysqli_rollback</function>. - </para> - </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml?r1=1.5&r2=1.6&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.5 phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.6 --- phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml:1.5 Wed Feb 11 03:10:47 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-bind-param.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> +<!-- $Revision: 1.6 $ --> <refentry id="function.mysqli-bind-param"> <refnamediv> <refname>mysqli_bind_param</refname> @@ -83,74 +83,80 @@ </para> </refsect1> <refsect1> + <title>See also</title> + <para> + <function>mysqli_bind_result</function>, + <function>mysqli_execute</function>, + <function>mysqli_fetch</function>, +<!-- <function>mysqli_fetch_column</function> --> + <function>mysqli_prepare</function>, + <function>mysqli_send_long_data</function>, + <function>mysqli_stmt_errno</function>, + <function>mysqli_stmt_error</function> + </para> + </refsect1> + <refsect1> <title>Example</title> <example> - <title>Prepared statements</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); - /* --- procedural style --- */ - $link = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or - die("Could not connect: " . mysqli_connect_error()); - - /* create mytable */ - mysqli_query($link, "CREATE TABLE mytable (a int, b int, c varchar(30))"); +/* create mytable */ +$mysqli->query("DROP TABLE IF EXISTS mytable"); +$mysqli->query("CREATE TABLE mytable (a int, b int, c varchar(30))"); - /* prepare statement and bind variables for insert statements */ - $stmt = mysqli_prepare($link, "INSERT INTO mytable VALUES (?, ?, ?)"); - mysqli_bind_param("iis", $a, $b, $c); - - $a = 1; - $b = 2; - $c = "I prefer OpenSource software"; - - /* execute prepared statement */ - mysqli_execute($stmt); - - /* close statement and connection */ - mysqli_close_stmt(stmt); - mysqli_close(link); - - /* --- object oriented style --- */ - $mysql = new mysqli("localhost", "mysql_user", "mysql_password", "mydb"); +/* prepare statement and bind parameters */ +$stmt = $mysqli->prepare("INSERT INTO mytable VALUES (?, ?, ?)"); +$stmt->bind_param("iis", $a, $b, $c); + +$a = 1; +$b = 2; +$c = "I like PHP"; + +/* execute prepared statement */ +$stmt->execute(); + +/* close statement and connection */ +$stmt->close(); +$mysqli->close(); +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") or +die("Could not connect: " . mysqli_connect_error()); - /* create mytable */ - $mysql->query("CREATE TABLE mytable (a int, b int, c varchar(30))"); +/* create mytable */ +mysqli_query($link, "DROP TABLE IF EXISTS mytable"); +mysqli_query($link, "CREATE TABLE mytable (a int, b int, c varchar(30))"); - /* prepare statement and bind parameters */ - $stmt = $mysql->prepare("INSERT INTO mytable VALUES (?, ?, ?)"); - $stmt->bind_param("iis", $a, $b, $c); - - $a = 1; - $b = 2; - $c = "I prefer opensource software"; - - /* execute prepared statement */ - $stmt->execute(); - - /* close statement and connection */ - $stmt->close(); - $mysql->close(); +/* prepare statement and bind variables for insert statements */ +$stmt = mysqli_prepare($link, "INSERT INTO mytable VALUES (?, ?, ?)"); +mysqli_bind_param($stmt, "iis", $a, $b, $c); + +$a = 1; +$b = 2; +$c = "I like PHP"; + +/* execute prepared statement */ +mysqli_execute($stmt); + +/* close statement and connection */ +mysqli_stmt_close($stmt); +mysqli_close($link); ?> ]]> </programlisting> </example> </refsect1> - <refsect1> - <title>See also</title> - <para> - <function>mysqli_bind_result</function>, - <function>mysqli_execute</function>, - <function>mysqli_fetch</function>, -<!-- <function>mysqli_fetch_column</function> --> - <function>mysqli_prepare</function>, - <function>mysqli_send_long_data</function>, - <function>mysqli_stmt_errno</function>, - <function>mysqli_stmt_error</function> - </para> - </refsect1> - </refentry> + </refentry> <!-- Keep this comment at the end of the file Local variables: http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml?r1=1.2&r2=1.3&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.2 phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.3 --- phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml:1.2 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-bind-result.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <refentry id="function.mysqli-bind-result"> <refnamediv> <refname>mysqli_bind_result</refname> @@ -60,7 +60,88 @@ <function>mysqli_stmt_error</function> </para> </refsect1> - </refentry> + <refsect1> + <title>Example</title> + <para> + <example> + <title>Object oriented style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +if (mysqli_connect_errno()) { + printf("Connect failed: %s\n", mysqli_connect_error()); + exit(); +} + +/* create table and insert some data */ +$mysqli->query("DROP TABLE IF EXISTS bind_result"); +$mysqli->query("CREATE TABLE bind_result (id int, extension varchar(20))"); +$mysqli->query("INSERT INTO bind_result VALUES (1, 'ldap')"); +$mysqli->query("INSERT INTO bind_result VALUES (2, 'mysql')"); +$mysqli->query("INSERT INTO bind_result VALUES (3, 'pcre')"); + +/* prepare statement */ +if ($stmt = $mysqli->prepare("SELECT id, extension FROM bind_result")) { + $stmt->execute(); + + /* bind variables to prepared statement */ + $stmt->bind_result($col1, $col2); + + /* fetch values */ + while ($stmt->fetch()) { + printf("Id: %d Extension: %s\n", $col1, $col2); + } + /* close statement */ + $stmt->close(); +} +/* close connection */ +$mysqli->close(); + +?> + ]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> + <![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test") + or die("Can't connect to MySQL server on localhost"); + +/* create table and insert some data */ +mysqli_query($link, "DROP TABLE IF EXISTS bind_result"); +mysqli_query($link, "CREATE TABLE bind_result (id int, extension varchar(20))"); +mysqli_query($link, "INSERT INTO bind_result VALUES (1, 'ldap')"); +mysqli_query($link, "INSERT INTO bind_result VALUES (2, 'mysql')"); +mysqli_query($link, "INSERT INTO bind_result VALUES (3, 'pcre')"); + +/* prepare statement */ +if ($stmt = mysqli_prepare($link, "SELECT id, extension FROM bind_result")) { + mysqli_execute($stmt); + + /* bind variables to prepared statement */ + mysqli_bind_result($stmt, $col1, $col2); + + /* fetch values */ + while (mysqli_fetch($stmt)) { + printf("Id: %d Extension: %s\n", $col1, $col2); + } + /* close statement */ + mysqli_stmt_close($stmt); +} + +/* close connection */ +mysqli_close($link); +?> + ]]> + </programlisting> + </example> + </para> + </refsect1> +</refentry> <!-- Keep this comment at the end of the file Local variables: http://cvs.php.net/diff.php/phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml?r1=1.7&r2=1.8&ty=u Index: phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.7 phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.8 --- phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml:1.7 Wed Jan 28 18:18:42 2004 +++ phpdoc/en/reference/mysqli/functions/mysqli-change-user.xml Thu Feb 19 11:27:40 2004 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.7 $ --> +<!-- $Revision: 1.8 $ --> <refentry id="function.mysqli-change-user"> <refnamediv> <refname>mysqli_change_user</refname> @@ -59,21 +59,68 @@ </para> </refsect1> <refsect1> + <title>See also:</title> + <para> + <function>mysqli_connect</function> + <function>mysqli_select_db</function> + </para> + </refsect1> + <refsect1> <title>Example</title> <para> <example> - <title>Using the mysqli_change_user function</title> + <title>Object oriented style</title> <programlisting role="php"> <![CDATA[ <?php - - /* Open a connection as foo@localhost and select foo_db */ - $link = mysqli_connect("localhost", "foo", "pass"); - mysqli_select_db("foo_db"); + +$mysqli = new mysqli("localhost", "my_user", "my_password", "test"); + +$mysqli->query("CREATE TEMPORARY TABLE mytemp (a int)"); - /* Change user to bar@localhost and default database to bar_db */ - mysqli_change_user($link, "bar", "otherpass", "bar_db"); +/* reset all */ +$mysqli->change_user("my_user", "my_password", NULL); + +if ($result = $mysqli->query("SELECT DATABASE()")) { + $row = $result->fetch_row(); + printf("Default database: %s\n", $row[0]); + $result->close(); +} + +if (!($result = $mysqli->query("SHOW TABLES LIKE mytemp"))) { + printf ("temporary table mytemp doesn't exist\n"); +} + +/* close connection */ +$mysqli->close(); +?> +]]> + </programlisting> + </example> + <example> + <title>Procedural style</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysqli_connect("localhost", "my_user", "my_password", "test"); + +mysqli_query($link, "CREATE TEMPORARY TABLE mytemp (a int)"); + +/* reset all */ +mysqli_change_user($link, "my_user", "my_password", NULL); + +if ($result = mysqli_query($link, "SELECT DATABASE()")) { + $row = mysqli_fetch_row($result); + printf("Default database: %s\n", $row[0]); + mysqli_free_result($result); +} + +if (!($result = mysqli_query($link, "SHOW TABLES LIKE mytemp"))) { + printf ("temporary table mytemp doesn't exist\n"); +} +/* close connection */ +mysqli_close($link); ?> ]]> </programlisting>