cvs: phpdoc /en/reference/mysql/functions mysql-create-db.xml mysql-db-query.xml mysql-drop-db.xml mysql-list-tables.xml

philip Mon Mar 7 13:23:08 2005 EDT Modified files: /phpdoc/en/reference/mysql/functions mysql-create-db.xml mysql-db-query.xml mysql-drop-db.xml mysql-list-tables.xml Log: Added an example that replaces use of this deprecated function. http://cvs.php.net/diff.php/phpdoc/en/reference/mysql/functions/mysql-create-db.xml?r1=1.10&r2=1.11&ty=u Index: phpdoc/en/reference/mysql/functions/mysql-create-db.xml diff -u phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.10 phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.11 --- phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.10 Fri Feb 20 12:36:42 2004 +++ phpdoc/en/reference/mysql/functions/mysql-create-db.xml Mon Mar 7 13:23:07 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.10 $ --> +<!-- $Revision: 1.11 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-create-db"> <refnamediv> @@ -25,7 +25,7 @@ </para> <para> <example> - <title>MySQL create database example</title> + <title><function>mysql_create_db</function> alternative example</title> <programlisting role="php"> <![CDATA[ <?php @@ -34,8 +34,9 @@ die('Could not connect: ' . mysql_error()); } -if (mysql_create_db('my_db')) { - echo "Database created successfully\n"; +$sql = 'CREATE DATABASE my_db'; +if (mysql_query($sql, $link)) { + echo "Database my_db created successfully\n"; } else { echo 'Error creating database: ' . mysql_error() . "\n"; } http://cvs.php.net/diff.php/phpdoc/en/reference/mysql/functions/mysql-db-query.xml?r1=1.4&r2=1.5&ty=u Index: phpdoc/en/reference/mysql/functions/mysql-db-query.xml diff -u phpdoc/en/reference/mysql/functions/mysql-db-query.xml:1.4 phpdoc/en/reference/mysql/functions/mysql-db-query.xml:1.5 --- phpdoc/en/reference/mysql/functions/mysql-db-query.xml:1.4 Fri Sep 6 09:02:32 2002 +++ phpdoc/en/reference/mysql/functions/mysql-db-query.xml Mon Mar 7 13:23:07 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-db-query"> <refnamediv> @@ -40,6 +40,43 @@ this function. </para> <para> + <example> + <title><function>mysql_db_query</function> alternative example</title> + <programlisting role="php"> +<![CDATA[ +<?php +$dbname = 'mysql_dbname'; + +if (!$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) { + echo 'Could not connect to mysql'; + exit; +} + +if (!mysql_select_db($dbname, $link)) { + echo 'Could not select database'; + exit; +} + +$sql = 'SELECT foo FROM bar WHERE id = 42'; +$result = mysql_query($sql, $link); + +if (!$result) { + echo "DB Error, could not list tables\n"; + echo 'MySQL Error: ' . mysql_error(); + exit; +} + +while ($row = mysql_fetch_assoc($result)) { + echo $row['foo']; +} + +mysql_free_result($result); +?> +]]> + </programlisting> + </example> + </para> + <para> See also <function>mysql_connect</function> and <function>mysql_query</function>. </para> http://cvs.php.net/diff.php/phpdoc/en/reference/mysql/functions/mysql-drop-db.xml?r1=1.10&r2=1.11&ty=u Index: phpdoc/en/reference/mysql/functions/mysql-drop-db.xml diff -u phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.10 phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.11 --- phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.10 Tue Sep 28 11:33:55 2004 +++ phpdoc/en/reference/mysql/functions/mysql-drop-db.xml Mon Mar 7 13:23:07 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.10 $ --> +<!-- $Revision: 1.11 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-drop-db"> <refnamediv> @@ -34,6 +34,28 @@ <literal>SQL DROP DATABASE</literal> statement instead. </para> </note> + <para> + <example> + <title><function>mysql_drop_db</function> alternative example</title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); +if (!$link) { + die('Could not connect: ' . mysql_error()); +} + +$sql = 'DROP DATABASE my_db'; +if (mysql_query($sql, $link)) { + echo "Database my_db was successfully dropped\n"; +} else { + echo 'Error creating database: ' . mysql_error() . "\n"; +} +?> +]]> + </programlisting> + </example> + </para> <warning> <para> This function will not be available http://cvs.php.net/diff.php/phpdoc/en/reference/mysql/functions/mysql-list-tables.xml?r1=1.12&r2=1.13&ty=u Index: phpdoc/en/reference/mysql/functions/mysql-list-tables.xml diff -u phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.12 phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.13 --- phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.12 Tue Nov 23 04:31:58 2004 +++ phpdoc/en/reference/mysql/functions/mysql-list-tables.xml Mon Mar 7 13:23:07 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-list-tables"> <refnamediv> @@ -42,7 +42,7 @@ </note> <para> <example> - <title><function>mysql_list_tables</function> example</title> + <title><function>mysql_list_tables</function> alternative example</title> <programlisting role="php"> <![CDATA[ <?php @@ -53,7 +53,8 @@ exit; } -$result = mysql_list_tables($dbname); +$sql = "SELECT TABLES FROM $dbname"; +$result = mysql_query($sql); if (!$result) { echo "DB Error, could not list tables\n"; @@ -62,7 +63,7 @@ } while ($row = mysql_fetch_row($result)) { - echo "Table: $row[0]\n"; + echo "Table: {$row[0]}\n"; } mysql_free_result($result);