irchtml Wed Mar 3 02:33:38 2004 EDT
Modified files:
/phpdoc/en/reference/msql reference.xml
/phpdoc/en/reference/msql/functions msql-connect.xml msql-error.xml
Log:
added example; fixed proto
http://cvs.php.net/diff.php/phpdoc/en/reference/msql/reference.xml?r1=1.10&r2=1.11&ty=u
Index: phpdoc/en/reference/msql/reference.xml
diff -u phpdoc/en/reference/msql/reference.xml:1.10
phpdoc/en/reference/msql/reference.xml:1.11
--- phpdoc/en/reference/msql/reference.xml:1.10 Tue Mar 2 20:01:07 2004
+++ phpdoc/en/reference/msql/reference.xml Wed Mar 3 02:33:37 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.10 $ -->
+<!-- $Revision: 1.11 $ -->
<reference id="ref.msql">
<title>mSQL Functions</title>
<titleabbrev>mSQL</titleabbrev>
@@ -29,6 +29,50 @@
&reference.msql.constants;
+ <section id="msql.examples">
+ &reftitle.examples;
+ <para>
+ This simple example shows how to connect, execute a query, print
+ resulting rows and disconnect from a mSQL database.
+ <example>
+ <title>mSQL usage example</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+/* Connecting, selecting database */
+$link = msql_connect('localhost', 'username', 'password')
+ or die('Could not connect : ' . msql_error($link));
+
+msql_select_db('database')
+ or die('Could not select database', $link);
+
+/* Issue SQL query */
+$query = 'SELECT * FROM my_table';
+$result = msql_query($query, $link) or die('Query failed : ' . msql_error($link));
+
+/* Printing results in HTML */
+echo "<table>\n";
+while ($row = msql_fetch_array($result, MSQL_ASSOC)) {
+ echo "\t<tr>\n";
+ foreach ($row as $col_value) {
+ echo "\t\t<td>$col_value</td>\n";
+ }
+ echo "\t</tr>\n";
+}
+echo "</table>\n";
+
+/* Free result set */
+msql_free_result($result);
+
+/* Close connection */
+msql_close($link);
+?>
+]]>
+ </programlisting>
+ </example>
+ </para>
+ </section>
+
</partintro>
&reference.msql.functions;
http://cvs.php.net/diff.php/phpdoc/en/reference/msql/functions/msql-connect.xml?r1=1.6&r2=1.7&ty=u
Index: phpdoc/en/reference/msql/functions/msql-connect.xml
diff -u phpdoc/en/reference/msql/functions/msql-connect.xml:1.6
phpdoc/en/reference/msql/functions/msql-connect.xml:1.7
--- phpdoc/en/reference/msql/functions/msql-connect.xml:1.6 Tue Mar 2 05:16:06
2004
+++ phpdoc/en/reference/msql/functions/msql-connect.xml Wed Mar 3 02:33:38 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.6 $ -->
+<!-- $Revision: 1.7 $ -->
<!-- splitted from ./en/functions/msql.xml, last change in rev 1.2 -->
<refentry id="function.msql-connect">
<refnamediv>
@@ -11,13 +11,12 @@
<methodsynopsis>
<type>int</type><methodname>msql_connect</methodname>
<methodparam
choice="opt"><type>string</type><parameter>hostname</parameter></methodparam>
- <methodparam
choice="opt"><type>string</type><parameter>server</parameter></methodparam>
<methodparam
choice="opt"><type>string</type><parameter>username</parameter></methodparam>
<methodparam
choice="opt"><type>string</type><parameter>password</parameter></methodparam>
</methodsynopsis>
<para>
<function>msql_connect</function> establishes a connection to a
- mSQL server. The <parameter>server</parameter> parameter can also
+ mSQL server. The <parameter>hostname</parameter> parameter can also
include a port number. e.g. "hostname:port". It defaults
to 'localhost'.
</para>
http://cvs.php.net/diff.php/phpdoc/en/reference/msql/functions/msql-error.xml?r1=1.3&r2=1.4&ty=u
Index: phpdoc/en/reference/msql/functions/msql-error.xml
diff -u phpdoc/en/reference/msql/functions/msql-error.xml:1.3
phpdoc/en/reference/msql/functions/msql-error.xml:1.4
--- phpdoc/en/reference/msql/functions/msql-error.xml:1.3 Tue Mar 2 05:16:06
2004
+++ phpdoc/en/reference/msql/functions/msql-error.xml Wed Mar 3 02:33:38 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.3 $ -->
+<!-- $Revision: 1.4 $ -->
<!-- splitted from ./en/functions/msql.xml, last change in rev 1.2 -->
<refentry id="function.msql-error">
<refnamediv>
@@ -13,9 +13,11 @@
<methodparam
choice="opt"><type>resource</type><parameter>link_identifier</parameter></methodparam>
</methodsynopsis>
<para>
- Errors coming back from the mSQL database backend no longer
- issue warnings. Instead, use this functions to retrieve the
- error string.
+ <function>msql_error</function> returns the last issued error by the mSQL
+ server or an empty string if no error was issued. If no link is
+ explicitly passed, the last successful open link will be used to retrieve
+ the error message. Note that only the last error message is accessible
+ with <function>msql_error</function>.
</para>
</refsect1>
</refentry>
