betz Mon Jan 5 08:03:26 2004 EDT
Modified files:
/phpdoc/en/reference/mysql reference.xml
/phpdoc/en/reference/mysql/functions mysql-affected-rows.xml
mysql-close.xml
mysql-connect.xml
mysql-create-db.xml
mysql-data-seek.xml
mysql-db-name.xml
mysql-drop-db.xml
mysql-errno.xml
mysql-error.xml
mysql-escape-string.xml
mysql-fetch-array.xml
mysql-fetch-assoc.xml
mysql-get-client-info.xml
mysql-get-host-info.xml
mysql-get-proto-info.xml
mysql-get-server-info.xml
mysql-insert-id.xml
mysql-list-tables.xml
mysql-query.xml
mysql-result.xml
mysql-select-db.xml
mysql-tablename.xml
Log:
examples start at col 0
Index: phpdoc/en/reference/mysql/reference.xml
diff -u phpdoc/en/reference/mysql/reference.xml:1.17
phpdoc/en/reference/mysql/reference.xml:1.18
--- phpdoc/en/reference/mysql/reference.xml:1.17 Mon Dec 15 11:52:06 2003
+++ phpdoc/en/reference/mysql/reference.xml Mon Jan 5 08:03:25 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.17 $ -->
+<!-- $Revision: 1.18 $ -->
<reference id="ref.mysql">
<title>MySQL Functions</title>
<titleabbrev>MySQL</titleabbrev>
@@ -52,32 +52,32 @@
<programlisting role="php">
<![CDATA[
<?php
- /* Connecting, selecting database */
- $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
- or die("Could not connect : " . mysql_error());
- echo "Connected successfully";
- mysql_select_db("my_database") or die("Could not select database");
-
- /* Performing SQL query */
- $query = "SELECT * FROM my_table";
- $result = mysql_query($query) or die("Query failed : " . mysql_error());
-
- /* Printing results in HTML */
- echo "<table>\n";
- while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
- echo "\t<tr>\n";
- foreach ($line as $col_value) {
- echo "\t\t<td>$col_value</td>\n";
- }
- echo "\t</tr>\n";
+/* Connecting, selecting database */
+$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
+ or die("Could not connect : " . mysql_error());
+echo "Connected successfully";
+mysql_select_db("my_database") or die("Could not select database");
+
+/* Performing SQL query */
+$query = "SELECT * FROM my_table";
+$result = mysql_query($query) or die("Query failed : " . mysql_error());
+
+/* Printing results in HTML */
+echo "<table>\n";
+while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
+ echo "\t<tr>\n";
+ foreach ($line as $col_value) {
+ echo "\t\t<td>$col_value</td>\n";
}
- echo "</table>\n";
+ echo "\t</tr>\n";
+ }
+echo "</table>\n";
- /* Free resultset */
- mysql_free_result($result);
+/* Free resultset */
+mysql_free_result($result);
- /* Closing connection */
- mysql_close($link);
+/* Closing connection */
+mysql_close($link);
?>
]]>
</programlisting>
@@ -110,4 +110,3 @@
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
-
Index: phpdoc/en/reference/mysql/functions/mysql-affected-rows.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-affected-rows.xml:1.11
phpdoc/en/reference/mysql/functions/mysql-affected-rows.xml:1.12
--- phpdoc/en/reference/mysql/functions/mysql-affected-rows.xml:1.11 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-affected-rows.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.11 $ -->
+<!-- $Revision: 1.12 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-affected-rows">
<refnamediv>
@@ -56,18 +56,18 @@
<programlisting role="php">
<![CDATA[
<?php
- /* connect to database */
- mysql_pconnect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
-
- /* this should return the correct numbers of deleted records */
- mysql_query("DELETE FROM mytable WHERE id < 10");
- printf("Records deleted: %d\n", mysql_affected_rows());
+/* connect to database */
+mysql_pconnect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- /* without a where clause in a delete statement, it should return 0 */
- mysql_query("DELETE FROM mytable");
- printf("Records deleted: %d\n", mysql_affected_rows());
+/* this should return the correct numbers of deleted records */
+mysql_query("DELETE FROM mytable WHERE id < 10");
+printf("Records deleted: %d\n", mysql_affected_rows());
+
+/* without a where clause in a delete statement, it should return 0 */
+mysql_query("DELETE FROM mytable");
+printf("Records deleted: %d\n", mysql_affected_rows());
?>
]]>
</programlisting>
@@ -88,15 +88,15 @@
<programlisting role="php">
<![CDATA[
<?php
- /* connect to database */
- mysql_pconnect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
+/* connect to database */
+mysql_pconnect("localhost", "mysql_user", "mysql_password") or
+ die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- /* Update records */
- mysql_query("UPDATE mytable SET used=1 WHERE id < 10");
- printf ("Updated records: %d\n", mysql_affected_rows());
- mysql_query("COMMIT");
+/* Update records */
+mysql_query("UPDATE mytable SET used=1 WHERE id < 10");
+printf ("Updated records: %d\n", mysql_affected_rows());
+mysql_query("COMMIT");
?>
]]>
</programlisting>
@@ -111,7 +111,7 @@
</example>
</para>
<para>
- See also <function>mysql_num_rows</function>,
+ See also <function>mysql_num_rows</function>, and
<function>mysql_info</function>.
</para>
</refsect1>
Index: phpdoc/en/reference/mysql/functions/mysql-close.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-close.xml:1.5
phpdoc/en/reference/mysql/functions/mysql-close.xml:1.6
--- phpdoc/en/reference/mysql/functions/mysql-close.xml:1.5 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-close.xml Mon Jan 5 08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-close">
<refnamediv>
@@ -41,10 +41,10 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_connect("localhost", "mysql_user", "mysql_password")
- or die("Could not connect: " . mysql_error());
- echo "Connected successfully";
- mysql_close($link);
+$link = mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+echo "Connected successfully";
+mysql_close($link);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-connect.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-connect.xml:1.9
phpdoc/en/reference/mysql/functions/mysql-connect.xml:1.10
--- phpdoc/en/reference/mysql/functions/mysql-connect.xml:1.9 Thu Dec 18 09:14:30
2003
+++ phpdoc/en/reference/mysql/functions/mysql-connect.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.9 $ -->
+<!-- $Revision: 1.10 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-connect">
<refnamediv>
@@ -99,10 +99,10 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_connect("localhost", "mysql_user", "mysql_password")
- or die("Could not connect: " . mysql_error());
- echo "Connected successfully";
- mysql_close($link);
+$link = mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+echo "Connected successfully";
+mysql_close($link);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-create-db.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-create-db.xml:1.8 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-create-db.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-create-db">
<refnamediv>
@@ -29,14 +29,14 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_pconnect("localhost", "mysql_user", "mysql_password")
- or die("Could not connect: " . mysql_error());
+$link = mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
- if (mysql_create_db("my_db")) {
- echo "Database created successfully\n";
- } else {
- echo "Error creating database: " . mysql_error() . "\n";
- }
+if (mysql_create_db("my_db")) {
+ echo "Database created successfully\n";
+} else {
+ echo "Error creating database: " . mysql_error() . "\n";
+}
?>
]]>
</programlisting>
@@ -60,9 +60,7 @@
</para>
</warning>
<para>
- See also
- <function>mysql_drop_db</function> and
- <function>mysql_query</function>.
+ See also <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/en/reference/mysql/functions/mysql-data-seek.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-data-seek.xml:1.7
phpdoc/en/reference/mysql/functions/mysql-data-seek.xml:1.8
--- phpdoc/en/reference/mysql/functions/mysql-data-seek.xml:1.7 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-data-seek.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-data-seek">
<refnamediv>
@@ -40,30 +40,30 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_pconnect("localhost", "mysql_user", "mysql_password")
- or die("Could not connect: " . mysql_error());
+$link = mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
- mysql_select_db("samp_db")
- or die("Could not select database: " . mysql_error());
+mysql_select_db("samp_db")
+ or die("Could not select database: " . mysql_error());
- $query = "SELECT last_name, first_name FROM friends";
- $result = mysql_query($query)
- or die("Query failed: " . mysql_error());
-
- /* fetch rows in reverse order */
- for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
- if (!mysql_data_seek($result, $i)) {
- echo "Cannot seek to row $i: " . mysql_error() . "\n";
- continue;
- }
+$query = "SELECT last_name, first_name FROM friends";
+$result = mysql_query($query)
+ or die("Query failed: " . mysql_error());
+
+/* fetch rows in reverse order */
+for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
+ if (!mysql_data_seek($result, $i)) {
+ echo "Cannot seek to row $i: " . mysql_error() . "\n";
+ continue;
+ }
- if (!($row = mysql_fetch_object($result)))
- continue;
+ if (!($row = mysql_fetch_object($result)))
+ continue;
- echo "$row->last_name $row->first_name<br />\n";
- }
+ echo "$row->last_name $row->first_name<br />\n";
+}
- mysql_free_result($result);
+mysql_free_result($result);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-db-name.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-db-name.xml:1.3
phpdoc/en/reference/mysql/functions/mysql-db-name.xml:1.4
--- phpdoc/en/reference/mysql/functions/mysql-db-name.xml:1.3 Wed Jul 9 11:07:29
2003
+++ phpdoc/en/reference/mysql/functions/mysql-db-name.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.3 $ -->
+<!-- $Revision: 1.4 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.23 -->
<refentry id="function.mysql-db-name">
<refnamediv>
@@ -35,17 +35,17 @@
<programlisting role="php">
<![CDATA[
<?php
- error_reporting(E_ALL);
+error_reporting(E_ALL);
- mysql_connect('dbhost', 'username', 'password');
- $db_list = mysql_list_dbs();
+$link = mysql_connect('dbhost', 'username', 'password');
+$db_list = mysql_list_dbs($link);
- $i = 0;
- $cnt = mysql_num_rows($db_list);
- while ($i < $cnt) {
- echo mysql_db_name($db_list, $i) . "\n";
- $i++;
- }
+$i = 0;
+$cnt = mysql_num_rows($db_list);
+while ($i < $cnt) {
+ echo mysql_db_name($db_list, $i) . "\n";
+ $i++;
+}
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-drop-db.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-drop-db.xml:1.8 Wed Jul 9 11:07:29
2003
+++ phpdoc/en/reference/mysql/functions/mysql-drop-db.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-drop-db">
<refnamediv>
@@ -41,9 +41,7 @@
</para>
</warning>
<para>
- See also
- <function>mysql_create_db</function> and
- <function>mysql_query</function>.
+ See also <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/en/reference/mysql/functions/mysql-errno.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-errno.xml:1.7
phpdoc/en/reference/mysql/functions/mysql-errno.xml:1.8
--- phpdoc/en/reference/mysql/functions/mysql-errno.xml:1.7 Wed Jul 9 11:07:29
2003
+++ phpdoc/en/reference/mysql/functions/mysql-errno.xml Mon Jan 5 08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-errno">
<refnamediv>
@@ -35,14 +35,14 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password");
+$link = mysql_connect("localhost", "mysql_user", "mysql_password");
- mysql_select_db("nonexistentdb");
- echo mysql_errno() . ": " . mysql_error(). "\n";
+mysql_select_db("nonexistentdb", $link);
+echo mysql_errno($link) . ": " . mysql_error($link). "\n";
- mysql_select_db("kossu");
- mysql_query("SELECT * FROM nonexistenttable");
- echo mysql_errno() . ": " . mysql_error() . "\n";
+mysql_select_db("kossu", $link);
+mysql_query("SELECT * FROM nonexistenttable", $link);
+echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-error.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-error.xml:1.10
phpdoc/en/reference/mysql/functions/mysql-error.xml:1.11
--- phpdoc/en/reference/mysql/functions/mysql-error.xml:1.10 Thu Dec 18 09:14:30
2003
+++ phpdoc/en/reference/mysql/functions/mysql-error.xml Mon Jan 5 08:03:26 2004
@@ -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-error">
<refnamediv>
@@ -37,14 +37,14 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password");
+$link = mysql_connect("localhost", "mysql_user", "mysql_password");
- mysql_select_db("nonexistentdb");
- echo mysql_errno() . ": " . mysql_error(). "\n";
+mysql_select_db("nonexistentdb", $link);
+echo mysql_errno($link) . ": " . mysql_error($link). "\n";
- mysql_select_db("kossu");
- mysql_query("SELECT * FROM nonexistenttable");
- echo mysql_errno() . ": " . mysql_error() . "\n";
+mysql_select_db("kossu", $link);
+mysql_query("SELECT * FROM nonexistenttable", $link);
+echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-escape-string.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-escape-string.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-escape-string.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-escape-string.xml:1.8 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-escape-string.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-escape-string">
<refnamediv>
@@ -37,9 +37,9 @@
<programlisting role="php">
<![CDATA[
<?php
- $item = "Zak's Laptop";
- $escaped_item = mysql_escape_string($item);
- printf("Escaped string: %s\n", $escaped_item);
+$item = "Zak's Laptop";
+$escaped_item = mysql_escape_string($item);
+printf("Escaped string: %s\n", $escaped_item);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.12
phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.13
--- phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.12 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml Mon Jan 5 08:03:26
2004
@@ -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.27 -->
<refentry id="function.mysql-fetch-array">
<refnamediv>
@@ -70,17 +70,17 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
+mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- $result = mysql_query("SELECT id, name FROM mytable");
+$result = mysql_query("SELECT id, name FROM mytable");
- while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
- printf("ID: %s Name: %s", $row[0], $row[1]);
- }
+while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
+ printf("ID: %s Name: %s", $row[0], $row[1]);
+}
- mysql_free_result($result);
+mysql_free_result($result);
?>
]]>
</programlisting>
@@ -90,17 +90,17 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
+mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- $result = mysql_query("SELECT id, name FROM mytable");
+$result = mysql_query("SELECT id, name FROM mytable");
- while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
- printf("ID: %s Name: %s", $row["id"], $row["name"]);
- }
+while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
+ printf("ID: %s Name: %s", $row["id"], $row["name"]);
+}
- mysql_free_result($result);
+mysql_free_result($result);
?>
]]>
</programlisting>
@@ -110,17 +110,17 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
+mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- $result = mysql_query("SELECT id, name FROM mytable");
+$result = mysql_query("SELECT id, name FROM mytable");
- while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
- printf ("ID: %s Name: %s", $row[0], $row["name"]);
- }
+while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
+ printf ("ID: %s Name: %s", $row[0], $row["name"]);
+}
- mysql_free_result($result);
+mysql_free_result($result);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-fetch-assoc.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-fetch-assoc.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-fetch-assoc.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-fetch-assoc.xml:1.8 Wed Jul 9
11:07:29 2003
+++ phpdoc/en/reference/mysql/functions/mysql-fetch-assoc.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.45 -->
<refentry id="function.mysql-fetch-assoc">
<refnamediv>
@@ -49,45 +49,45 @@
<![CDATA[
<?php
- $conn = mysql_connect("localhost", "mysql_user", "mysql_password");
-
- if (!$conn) {
- echo "Unable to connect to DB: " . mysql_error();
- exit;
- }
-
- if (!mysql_select_db("mydbname")) {
- echo "Unable to select mydbname: " . mysql_error();
- exit;
- }
-
- $sql = "SELECT id as userid, fullname, userstatus
- FROM sometable
- WHERE userstatus = 1";
-
- $result = mysql_query($sql);
-
- if (!$result) {
- echo "Could not successfully run query ($sql) from DB: " . mysql_error();
- exit;
- }
+$conn = mysql_connect("localhost", "mysql_user", "mysql_password");
+
+if (!$conn) {
+ echo "Unable to connect to DB: " . mysql_error();
+ exit;
+}
- if (mysql_num_rows($result) == 0) {
- echo "No rows found, nothing to print so am exiting";
- exit;
- }
-
- // While a row of data exists, put that row in $row as an associative array
- // Note: If you're expecting just one row, no need to use a loop
- // Note: If you put extract($row); inside the following loop, you'll
- // then create $userid, $fullname, and $userstatus
- while ($row = mysql_fetch_assoc($result)) {
- echo $row["userid"];
- echo $row["fullname"];
- echo $row["userstatus"];
- }
-
- mysql_free_result($result);
+if (!mysql_select_db("mydbname")) {
+ echo "Unable to select mydbname: " . mysql_error();
+ exit;
+}
+
+$sql = "SELECT id as userid, fullname, userstatus
+ FROM sometable
+ WHERE userstatus = 1";
+
+$result = mysql_query($sql);
+
+if (!$result) {
+ echo "Could not successfully run query ($sql) from DB: " . mysql_error();
+ exit;
+}
+
+if (mysql_num_rows($result) == 0) {
+ echo "No rows found, nothing to print so am exiting";
+ exit;
+}
+
+// While a row of data exists, put that row in $row as an associative array
+// Note: If you're expecting just one row, no need to use a loop
+// Note: If you put extract($row); inside the following loop, you'll
+// then create $userid, $fullname, and $userstatus
+while ($row = mysql_fetch_assoc($result)) {
+ echo $row["userid"];
+ echo $row["fullname"];
+ echo $row["userstatus"];
+}
+
+mysql_free_result($result);
?>
]]>
Index: phpdoc/en/reference/mysql/functions/mysql-get-client-info.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-get-client-info.xml:1.5
phpdoc/en/reference/mysql/functions/mysql-get-client-info.xml:1.6
--- phpdoc/en/reference/mysql/functions/mysql-get-client-info.xml:1.5 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-get-client-info.xml Mon Jan 5
08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-get-client-info">
<refnamediv>
@@ -22,7 +22,7 @@
<programlisting role="php">
<![CDATA[
<?php
- printf("MySQL client info: %s\n", mysql_get_client_info());
+printf("MySQL client info: %s\n", mysql_get_client_info());
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-get-host-info.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-get-host-info.xml:1.7
phpdoc/en/reference/mysql/functions/mysql-get-host-info.xml:1.8
--- phpdoc/en/reference/mysql/functions/mysql-get-host-info.xml:1.7 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-get-host-info.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-get-host-info">
<refnamediv>
@@ -25,9 +25,9 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- printf("MySQL host info: %s\n", mysql_get_host_info());
+mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+printf("MySQL host info: %s\n", mysql_get_host_info());
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-get-proto-info.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-get-proto-info.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-get-proto-info.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-get-proto-info.xml:1.8 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-get-proto-info.xml Mon Jan 5
08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-get-proto-info">
<refnamediv>
@@ -25,9 +25,9 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- printf("MySQL protocol version: %s\n", mysql_get_proto_info());
+mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+printf("MySQL protocol version: %s\n", mysql_get_proto_info());
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-get-server-info.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-get-server-info.xml:1.7
phpdoc/en/reference/mysql/functions/mysql-get-server-info.xml:1.8
--- phpdoc/en/reference/mysql/functions/mysql-get-server-info.xml:1.7 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-get-server-info.xml Mon Jan 5
08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.96 -->
<refentry id="function.mysql-get-server-info">
<refnamediv>
@@ -25,9 +25,9 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- printf("MySQL server version: %s\n", mysql_get_server_info());
+mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+printf("MySQL server version: %s\n", mysql_get_server_info());
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-insert-id.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-insert-id.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-insert-id.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-insert-id.xml:1.8 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-insert-id.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-insert-id">
<refnamediv>
@@ -56,12 +56,12 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password") or
- die("Could not connect: " . mysql_error());
- mysql_select_db("mydb");
+mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+mysql_select_db("mydb");
- mysql_query("INSERT INTO mytable (product) values ('kossu')");
- printf("Last inserted record has id %d\n", mysql_insert_id());
+mysql_query("INSERT INTO mytable (product) values ('kossu')");
+printf("Last inserted record has id %d\n", mysql_insert_id());
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-list-tables.xml:1.8 Mon Dec 15
11:52:07 2003
+++ phpdoc/en/reference/mysql/functions/mysql-list-tables.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-list-tables">
<refnamediv>
@@ -47,26 +47,26 @@
<programlisting role="php">
<![CDATA[
<?php
- $dbname = 'mysql_dbname';
+$dbname = 'mysql_dbname';
- if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
- echo 'Could not connect to mysql';
- exit;
- }
-
- $result = mysql_list_tables($dbname);
-
- if (!$result) {
- echo "DB Error, could not list tables\n";
- echo 'MySQL Error: ' . mysql_error();
- exit;
- }
-
- while ($row = mysql_fetch_row($result)) {
- echo "Table: $row[0]\n";
- }
+if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
+ echo 'Could not connect to mysql';
+ exit;
+}
- mysql_free_result($result);
+$result = mysql_list_tables($dbname);
+
+if (!$result) {
+ echo "DB Error, could not list tables\n";
+ echo 'MySQL Error: ' . mysql_error();
+ exit;
+}
+
+while ($row = mysql_fetch_row($result)) {
+ echo "Table: $row[0]\n";
+}
+
+mysql_free_result($result);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-query.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-query.xml:1.8
phpdoc/en/reference/mysql/functions/mysql-query.xml:1.9
--- phpdoc/en/reference/mysql/functions/mysql-query.xml:1.8 Tue Sep 30 04:33:38
2003
+++ phpdoc/en/reference/mysql/functions/mysql-query.xml Mon Jan 5 08:03:26 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-query">
<refnamediv>
@@ -46,7 +46,7 @@
<title><function>mysql_query</function> example</title>
<programlisting role="php">
<![CDATA[
-<php
+<?php
$result = mysql_query("SELECT * WHERE 1=1")
or die("Invalid query: " . mysql_error());
?>
Index: phpdoc/en/reference/mysql/functions/mysql-result.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-result.xml:1.5
phpdoc/en/reference/mysql/functions/mysql-result.xml:1.6
--- phpdoc/en/reference/mysql/functions/mysql-result.xml:1.5 Thu Dec 18 12:45:43
2003
+++ phpdoc/en/reference/mysql/functions/mysql-result.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-result">
<refnamediv>
@@ -43,15 +43,15 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_connect("localhost", "mysql_user", "mysql_password")
- or die("Could not connect: " . mysql_error());
-
- $result = mysql_query("SELECT name FROM work.employee")
- or die("Could not query:" . mysql_error());
-
- echo mysql_result($result, 2); // outputs third employee's name
-
- mysql_close($link);
+$link = mysql_connect("localhost", "mysql_user", "mysql_password")
+ or die("Could not connect: " . mysql_error());
+
+$result = mysql_query("SELECT name FROM work.employee")
+ or die("Could not query:" . mysql_error());
+
+echo mysql_result($result, 2); // outputs third employee's name
+
+mysql_close($link);
?>
]]>
</programlisting>
Index: phpdoc/en/reference/mysql/functions/mysql-select-db.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-select-db.xml:1.5
phpdoc/en/reference/mysql/functions/mysql-select-db.xml:1.6
--- phpdoc/en/reference/mysql/functions/mysql-select-db.xml:1.5 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-select-db.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-select-db">
<refnamediv>
@@ -37,11 +37,11 @@
<![CDATA[
<?php
-$lnk = mysql_connect('localhost', 'mysql_user', 'mysql_password')
- or die('Not connected : ' . mysql_error());
+$link = mysql_connect('localhost', 'mysql_user', 'mysql_password')
+ or die('Not connected : ' . mysql_error());
// make foo the current db
-mysql_select_db('foo', $lnk) or die ('Can\'t use foo : ' . mysql_error());
+mysql_select_db('foo', $link) or die ('Can\'t use foo : ' . mysql_error());
?>
]]>
Index: phpdoc/en/reference/mysql/functions/mysql-tablename.xml
diff -u phpdoc/en/reference/mysql/functions/mysql-tablename.xml:1.7
phpdoc/en/reference/mysql/functions/mysql-tablename.xml:1.8
--- phpdoc/en/reference/mysql/functions/mysql-tablename.xml:1.7 Mon Dec 15 11:52:07
2003
+++ phpdoc/en/reference/mysql/functions/mysql-tablename.xml Mon Jan 5 08:03:26
2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-tablename">
<refnamediv>
@@ -27,13 +27,13 @@
<programlisting role="php">
<![CDATA[
<?php
- mysql_connect("localhost", "mysql_user", "mysql_password");
- $result = mysql_list_tables("mydb");
+mysql_connect("localhost", "mysql_user", "mysql_password");
+$result = mysql_list_tables("mydb");
- for ($i = 0; $i < mysql_num_rows($result); $i++)
- printf("Table: %s\n", mysql_tablename($result, $i));
+for ($i = 0; $i < mysql_num_rows($result); $i++)
+ printf("Table: %s\n", mysql_tablename($result, $i));
- mysql_free_result($result);
+mysql_free_result($result);
?>
]]>
</programlisting>
