aidan Sat Sep 11 05:18:26 2004 EDT
Modified files:
/phpdoc/en/reference/mysql reference.xml
Log:
pearised example
http://cvs.php.net/diff.php/phpdoc/en/reference/mysql/reference.xml?r1=1.19&r2=1.20&ty=u
Index: phpdoc/en/reference/mysql/reference.xml
diff -u phpdoc/en/reference/mysql/reference.xml:1.19
phpdoc/en/reference/mysql/reference.xml:1.20
--- phpdoc/en/reference/mysql/reference.xml:1.19 Mon Jan 5 22:16:50 2004
+++ phpdoc/en/reference/mysql/reference.xml Sat Sep 11 05:18:21 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.19 $ -->
+<!-- $Revision: 1.20 $ -->
<reference id="ref.mysql">
<title>MySQL Functions</title>
<titleabbrev>MySQL</titleabbrev>
@@ -40,7 +40,6 @@
</section>
&reference.mysql.constants;
-
<section id="mysql.examples">
&reftitle.examples;
@@ -52,17 +51,17 @@
<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());
+// 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 */
+// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
@@ -73,10 +72,10 @@
}
echo "</table>\n";
-/* Free resultset */
+// Free resultset
mysql_free_result($result);
-/* Closing connection */
+// Closing connection
mysql_close($link);
?>
]]>
