CVS update: php3/doc/functions

Date: Monday December 14, 1998 @ 15:32 Author: eschmid Update of /repository/php3/doc/functions In directory asf:/u/temp/cvs-serv16902 Modified Files: mysql.sgml Log Message: There may be a problem with mysql_dbname, mysql_db_name and mysql_tablename. All are mapped to php3_mysql_result. If I haven't overseen something, it may now be in sync with the foldings in mysql.c. If not, correct me. Index: php3/doc/functions/mysql.sgml diff -c php3/doc/functions/mysql.sgml:1.19 php3/doc/functions/mysql.sgml:1.20 *** php3/doc/functions/mysql.sgml:1.19 Wed Dec 9 21:07:39 1998 --- php3/doc/functions/mysql.sgml Mon Dec 14 15:32:43 1998 *************** *** 12,19 **** <refentry id="function.mysql-affected-rows"> <refnamediv> ! <refname>mysql_affected_rows</refname> ! <refpurpose>get number of affected rows in last query</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 12,20 ---- <refentry id="function.mysql-affected-rows"> <refnamediv> ! <refname>mysql_affected_rows</refname> ! <refpurpose>Get number of affected rows in previous MySQL ! operation</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 73,86 **** <refentry id="function.mysql-connect"> <refnamediv> <refname>mysql_connect</refname> ! <refpurpose>open MySQL server connection</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_connect</function></funcdef> <paramdef>string <parameter><optional>hostname</optional> ! </parameter></paramdef> <paramdef>string <parameter><optional>username</optional> </parameter></paramdef> <paramdef>string <parameter><optional>password</optional> --- 74,88 ---- <refentry id="function.mysql-connect"> <refnamediv> <refname>mysql_connect</refname> ! <refpurpose>Open a connection to a MySQL Server</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_connect</function></funcdef> <paramdef>string <parameter><optional>hostname</optional> ! <optional>:port</optional></parameter> ! </paramdef> <paramdef>string <parameter><optional>username</optional> </parameter></paramdef> <paramdef>string <parameter><optional>password</optional> *************** *** 93,100 **** <function>mysql_connect</function> establishes a connection to a MySQL server. All of the arguments are optional, and if they're missing, defaults are assumed ('localhost', user name of the user ! that owns the server process, empty password). The hostname string ! can also include a port number. eg. &quot;hostname:port&quot; <para> In case a second call is made to <function>mysql_connect</function> with the same arguments, no --- 95,103 ---- <function>mysql_connect</function> establishes a connection to a MySQL server. All of the arguments are optional, and if they're missing, defaults are assumed ('localhost', user name of the user ! that owns the server process, empty password). The hostname ! string can also include a port number. ! eg. &quot;hostname:port&quot; <para> In case a second call is made to <function>mysql_connect</function> with the same arguments, no *************** *** 113,119 **** <refentry id="function.mysql-create-db"> <refnamediv> <refname>mysql_create_db</refname> ! <refpurpose>create MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 116,122 ---- <refentry id="function.mysql-create-db"> <refnamediv> <refname>mysql_create_db</refname> ! <refpurpose>Create a MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 134,161 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-createdb"> - <refnamediv> - <refname>mysql_createdb</refname> - <refpurpose>create MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_createdb</function></funcdef> - <void> - </funcsynopsis> - <para> - Identical to <function>mysql_create_db</function>. - </refsect1> - </refentry> - --> - <refentry id="function.mysql-data-seek"> <refnamediv> <refname>mysql_data_seek</refname> ! <refpurpose>move internal row pointer</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 137,146 ---- </refsect1> </refentry> <refentry id="function.mysql-data-seek"> <refnamediv> <refname>mysql_data_seek</refname> ! <refpurpose>Move internal result pointer</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 171,181 **** pointer of the MySQL result associated with the specified result identifier to point to the specified row number. The next call to <function>mysql_fetch_row</function> would return that row. - <para> - See also: <function>mysql_data_seek</function>. </refsect1> </refentry> <refentry id="function.mysql-dbname"> <refnamediv> <refname>mysql_dbname</refname> --- 156,165 ---- pointer of the MySQL result associated with the specified result identifier to point to the specified row number. The next call to <function>mysql_fetch_row</function> would return that row. </refsect1> </refentry> + <!-- <refentry id="function.mysql-dbname"> <refnamediv> <refname>mysql_dbname</refname> *************** *** 196,206 **** used to determine how many database names are available. </refsect1> </refentry> <refentry id="function.mysql-db-query"> <refnamediv> <refname>mysql_db_query</refname> ! <refpurpose>send MySQL query</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 180,191 ---- used to determine how many database names are available. </refsect1> </refentry> + --> <refentry id="function.mysql-db-query"> <refnamediv> <refname>mysql_db_query</refname> ! <refpurpose>Send an MySQL query to MySQL</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 208,214 **** <funcdef>int <function>mysql_db_query</function></funcdef> <paramdef>string <parameter>database</parameter></paramdef> <paramdef>string <parameter>query</parameter></paramdef> ! <paramdef>int <parameter>link_identifier</parameter></paramdef> </funcsynopsis> <para> Returns: A positive MySQL result identifier to the query result, --- 193,200 ---- <funcdef>int <function>mysql_db_query</function></funcdef> <paramdef>string <parameter>database</parameter></paramdef> <paramdef>string <parameter>query</parameter></paramdef> ! <paramdef>int <parameter><optional>link_identifier</optional> ! </parameter></paramdef> </funcsynopsis> <para> Returns: A positive MySQL result identifier to the query result, *************** *** 226,264 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql"> - <refnamediv> - <refname>mysql</refname> - <refpurpose>send MySQL query</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql</function></funcdef> - <paramdef>string <parameter>database</parameter></paramdef> - <paramdef>string <parameter>query</parameter></paramdef> - <paramdef>int <parameter>link_identifier</parameter></paramdef> - </funcsynopsis> - <para> - Returns: A positive MySQL result identifier to the query result, - or false on error. - <para> - <function>mysql</function> selects a database and executes a - query on it. If the optional link identifier isn't specified, - the function will try to find an open link to the MySQL server - and if no such link is found it'll try to create one as if - <function>mysql_connect</function> was called with no arguments - <para> - See also <function>mysql_connect</function>. - </refsect1> - </refentry> - --> <refentry id="function.mysql-drop-db"> <refnamediv> <refname>mysql_drop_db</refname> ! <refpurpose>drop (delete) MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 212,222 ---- </refsect1> </refentry> <refentry id="function.mysql-drop-db"> <refnamediv> <refname>mysql_drop_db</refname> ! <refpurpose>Drop (delete) a MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 280,315 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-dropdb"> - <refnamediv> - <refname>mysql_dropdb</refname> - <refpurpose>drop (delete) MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_drop_db</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>int <parameter><optional>link_identifier</optional> - </parameter></paramdef> - </funcsynopsis> - <para> - Returns: true on success, false on failure. - <para> - <function>mysql_drop_db</function> attempts to drop (remove) an - entire database from the server associated with the specified - link identifier. - <para> - See also: <function>mysql_create_db</function> - </refsect1> - </refentry> - --> <refentry id="function.mysql-errno"> <refnamediv> ! <refname>mysql_errno</refname> ! <refpurpose>returns error number of last mysql call</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 238,249 ---- </refsect1> </refentry> <refentry id="function.mysql-errno"> <refnamediv> ! <refname>mysql_errno</refname> ! <refpurpose>Returns the number of the error message from previous ! MySQL operation</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 344,350 **** <refentry id="function.mysql-error"> <refnamediv> <refname>mysql_error</refname> ! <refpurpose>returns error message of last mysql call</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 278,285 ---- <refentry id="function.mysql-error"> <refnamediv> <refname>mysql_error</refname> ! <refpurpose>Returns the text of the error message from previous ! MySQL operation</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 379,385 **** <refentry id="function.mysql-fetch-array"> <refnamediv> <refname>mysql_fetch_array</refname> ! <refpurpose>fetch row as array</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 314,320 ---- <refentry id="function.mysql-fetch-array"> <refnamediv> <refname>mysql_fetch_array</refname> ! <refpurpose>Fetch a result row as an associative array</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 433,439 **** <refentry id="function.mysql-fetch-field"> <refnamediv> <refname>mysql_fetch_field</refname> ! <refpurpose>get field information</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 368,375 ---- <refentry id="function.mysql-fetch-field"> <refnamediv> <refname>mysql_fetch_field</refname> ! <refpurpose>Get column information from a result and return as an ! object</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 501,512 **** <refentry id="function.mysql-fetch-lengths"> <refnamediv> <refname>mysql_fetch_lengths</refname> ! <refpurpose>get max data size of output columns</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>mysql_fetch_lengths</function></funcdef> <paramdef>int <parameter>result</parameter></paramdef> </funcsynopsis> <para> --- 437,449 ---- <refentry id="function.mysql-fetch-lengths"> <refnamediv> <refname>mysql_fetch_lengths</refname> ! <refpurpose>Get max data size of each output in a ! result</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>array <function>mysql_fetch_lengths</function></funcdef> <paramdef>int <parameter>result</parameter></paramdef> </funcsynopsis> <para> *************** *** 526,537 **** <refentry id="function.mysql-fetch-object"> <refnamediv> <refname>mysql_fetch_object</refname> ! <refpurpose>fetch row as object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>mysql_fetch_object</function></funcdef> <paramdef>int <parameter>result</parameter></paramdef> </funcsynopsis> <para> --- 463,474 ---- <refentry id="function.mysql-fetch-object"> <refnamediv> <refname>mysql_fetch_object</refname> ! <refpurpose>Fetch a result row as an object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>object <function>mysql_fetch_object</function></funcdef> <paramdef>int <parameter>result</parameter></paramdef> </funcsynopsis> <para> *************** *** 571,577 **** <refentry id="function.mysql-fetch-row"> <refnamediv> <refname>mysql_fetch_row</refname> ! <refpurpose>get row as enumerated array</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 508,514 ---- <refentry id="function.mysql-fetch-row"> <refnamediv> <refname>mysql_fetch_row</refname> ! <refpurpose>Get a result row as an enumerated array</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 603,616 **** <refentry id="function.mysql-field-name"> <refnamediv> <refname>mysql_field_name</refname> ! <refpurpose>get field name</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_name</function></funcdef> ! <paramdef>string <parameter>result</parameter></paramdef> ! <paramdef>int <parameter>i</parameter></paramdef> </funcsynopsis> <para> <function>mysql_field_name</function> returns the name of the --- 540,554 ---- <refentry id="function.mysql-field-name"> <refnamediv> <refname>mysql_field_name</refname> ! <refpurpose>Get the name of the specified field in a ! result</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_name</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> ! <paramdef>int <parameter>field_index</parameter></paramdef> </funcsynopsis> <para> <function>mysql_field_name</function> returns the name of the *************** *** 626,659 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-fieldname"> - <refnamediv> - <refname>mysql_fieldname</refname> - <refpurpose>get field name</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>string <function>mysql_fieldname</function></funcdef> - <paramdef>string <parameter>result</parameter></paramdef> - <paramdef>int <parameter>i</parameter></paramdef> - </funcsynopsis> - <para> - mysql_fieldname() returns the name of the specified - field. Arguments to the function is the result identifier and the - field index, ie. <literal>mysql_fieldname($result,2);</literal> - <para> - Will return the name of the second field in the result associated - with the result identifier. - </refsect1> - </refentry> - --> <refentry id="function.mysql-field-seek"> <refnamediv> <refname>mysql_field_seek</refname> ! <refpurpose>set field offset</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 564,574 ---- </refsect1> </refentry> <refentry id="function.mysql-field-seek"> <refnamediv> <refname>mysql_field_seek</refname> ! <refpurpose>Set result pointer to a specified field offset</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 674,680 **** <refentry id="function.mysql-field-table"> <refnamediv> <refname>mysql_field_table</refname> ! <refpurpose>get table name for field</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 589,596 ---- <refentry id="function.mysql-field-table"> <refnamediv> <refname>mysql_field_table</refname> ! <refpurpose>Get name of the table the specified field is ! in</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 689,723 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-fieldtable"> - <refnamediv> - <refname>mysql_fieldtable</refname> - <refpurpose>get table name for field</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>string <function>mysql_fieldtable</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcsynopsis> - <para> - Get the table name for field. - </refsect1> - </refentry> - --> <refentry id="function.mysql-field-type"> <refnamediv> <refname>mysql_field_type</refname> ! <refpurpose>get field type</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_type</function></funcdef> ! <paramdef>string <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> --- 605,622 ---- </refsect1> </refentry> <refentry id="function.mysql-field-type"> <refnamediv> <refname>mysql_field_type</refname> ! <refpurpose>Get the type of the specified field in a ! result</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_type</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> *************** *** 760,824 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-fieldtype"> - <refnamediv> - <refname>mysql_fieldtype</refname> - <refpurpose>get field type</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>string <function>mysql_field_type</function></funcdef> - <paramdef>string <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_fieldtype</function> is similar to the - <function>mysql_fieldname</function> function. The arguments are - identical, but the field type is returned. This will be one of - "int", "real", "string", or "blob". - <example> - <title>mysql field types</title> - <programlisting role=php> - &lt;?php - mysql_connect("localhost:3306"); - mysql_select_db("wisconsin"); - $result = mysql("SELECT * FROM onek"); - $fields = mysql_numfields($result); - $rows = mysql_numrows($result); - $i = 0; - $table = mysql_fieldtable($result, $i); - echo "Your '".$table."' table has ".$fields." fields and ".$rows." records &lt;BR>"; - echo "The table has the following fields &lt;BR>"; - while ($i &lt; $fields) { - $type = mysql_fieldtype ($result, $i); - $name = mysql_fieldname ($result, $i); - $len = mysql_fieldlen ($result, $i); - $flags = mysql_fieldflags ($result, $i); - echo $type." ".$name." ".$len." ".$flags."&lt;BR>"; - $i++; - } - mysql_close(); - ?> - </programlisting> - </example> - - </refsect1> - </refentry> - --> - <refentry id="function.mysql-field-flags"> <refnamediv> <refname>mysql_field_flags</refname> ! <refpurpose>get field flags</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_flags</function></funcdef> ! <paramdef>string <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> --- 659,676 ---- </refsect1> </refentry> <refentry id="function.mysql-field-flags"> <refnamediv> <refname>mysql_field_flags</refname> ! <refpurpose>Get the flags associated with the specified field in a ! result</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>string <function>mysql_field_flags</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> *************** *** 836,873 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-fieldflags"> - <refnamediv> - <refname>mysql_fieldflags</refname> - <refpurpose>get field flags</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>string <function>mysql_fieldflags</function></funcdef> - <paramdef>string <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_fieldflags</function> returns the field flags of - the specified field. Currently this is either, "not null", - "primary key", a combination of the two or "" (an empty string). - </para> - </refsect1> - </refentry> - --> <refentry id="function.mysql-field-len"> <refnamediv> <refname>mysql_field_len</refname> ! <refpurpose>get field length</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_field_len</function></funcdef> ! <paramdef>string <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> --- 688,704 ---- </refsect1> </refentry> <refentry id="function.mysql-field-len"> <refnamediv> <refname>mysql_field_len</refname> ! <refpurpose>Returns the length of the specified field</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_field_len</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> <paramdef>int <parameter>field_offset</parameter></paramdef> </funcsynopsis> <para> *************** *** 878,908 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-fieldlen"> - <refnamediv> - <refname>mysql_fieldlen</refname> - <refpurpose>get field length</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_fieldlen</function></funcdef> - <paramdef>string <parameter>result</parameter></paramdef> - <paramdef>int <parameter>field_offset</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_fieldlen</function> returns the length of the - specified field. - </para> - </refsect1> - </refentry> - --> <refentry id="function.mysql-free-result"> <refnamediv> <refname>mysql_free_result</refname> ! <refpurpose>free result memory</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 709,719 ---- </refsect1> </refentry> <refentry id="function.mysql-free-result"> <refnamediv> <refname>mysql_free_result</refname> ! <refpurpose>Free result memory</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 921,959 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-freeresult"> - <refnamediv> - <refname>mysql_freeresult</refname> - <refpurpose>free result memory</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_freeresult</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_freeresult</function> only needs to be called if - you are worried about using too much memory while your script is - running. All result memory will automatically be freed when the - script, you may call mysql_freeresult() with the result - identifier as an argument and the associated result memory will - be freed. - </refsect1> - </refentry> - --> <refentry id="function.mysql-insert-id"> <refnamediv> <refname>mysql_insert_id</refname> ! <refpurpose>get generated id from last INSERT</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_insert_id</function></funcdef> ! <paramdef>int <parameter><optional>link_identifier</optional></parameter></paramdef> </funcsynopsis> <para> <function>mysql_insert_id</function> returns the ID generated for --- 732,750 ---- </refsect1> </refentry> <refentry id="function.mysql-insert-id"> <refnamediv> <refname>mysql_insert_id</refname> ! <refpurpose>Get the id generated from the previous INSERT ! operation</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_insert_id</function></funcdef> ! <paramdef>int <parameter><optional>link_identifier</optional> ! </parameter></paramdef> </funcsynopsis> <para> <function>mysql_insert_id</function> returns the ID generated for *************** *** 966,979 **** <refentry id="function.mysql-list-fields"> <refnamediv> <refname>mysql_list_fields</refname> ! <refpurpose>list result fields</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_list_fields</function></funcdef> ! <paramdef>string <parameter>database</parameter></paramdef> ! <paramdef>string <parameter>tablename</parameter></paramdef> </funcsynopsis> <para> <function>mysql_list_fields</function> retrieves information --- 757,772 ---- <refentry id="function.mysql-list-fields"> <refnamediv> <refname>mysql_list_fields</refname> ! <refpurpose>List MySQL result fields</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_list_fields</function></funcdef> ! <paramdef>string <parameter>database_name</parameter></paramdef> ! <paramdef>string <parameter>table_name</parameter></paramdef> ! <paramdef>int <parameter><optional>link_identifier</optional> ! </parameter></paramdef> </funcsynopsis> <para> <function>mysql_list_fields</function> retrieves information *************** *** 996,1048 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-listfields"> - <refnamediv> - <refname>mysql_listfields</refname> - <refpurpose>list result fields</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_listfields</function></funcdef> - <paramdef>string <parameter>database</parameter></paramdef> - <paramdef>string <parameter>tablename</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_list_fields</function> retrieves information - about the given tablename. Arguments are the database name and - the table name. A result pointer is returned which can be used - with - <function>mysql_fieldflags</function>, - <function>mysql_fieldlen</function>, - <function>mysql_fieldname</function>, and - <function>mysql_fieldtype</function>. - <para> - A result identifier is a positive integer. The function returns - -1 if a error occurs. A string describing the error will be - placed in <literal>$phperrmsg</literal>, and unless the function - was called as <literal>@mysql()</literal> then this error string - will also be printed out. - </refsect1> - </refentry> - --> <refentry id="function.mysql-list-dbs"> <refnamediv> <refname>mysql_list_dbs</refname> ! <refpurpose>list MySQL databases on server</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>mysql_listdbs</function></funcdef> ! <void> </funcsynopsis> <para> ! <function>mysql_listdbs</function> will return a result pointer containing the databases available from the current mysql ! daemon. Use the <function>mysql_dbname</function> function to traverse this result pointer. <para> For downward compatibility <function>mysql_listdbs</function> can --- 789,811 ---- </refsect1> </refentry> <refentry id="function.mysql-list-dbs"> <refnamediv> <refname>mysql_list_dbs</refname> ! <refpurpose>List databases available on on MySQL server</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>mysql_list_dbs</function></funcdef> ! <paramdef>int <parameter><optional>link_identifier</optional> ! </parameter></paramdef> </funcsynopsis> <para> ! <function>mysql_list_dbs</function> will return a result pointer containing the databases available from the current mysql ! daemon. Use the <function>mysql_tablename</function> function to traverse this result pointer. <para> For downward compatibility <function>mysql_listdbs</function> can *************** *** 1050,1086 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-listdbs"> - <refnamediv> - <refname>mysql_listdbs</refname> - <refpurpose>list MySQL databases on server</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_listdbs</function></funcdef> - <void> - </funcsynopsis> - <para> - <function>mysql_listdbs</function> will return a result pointer - containing the databases available from the current mysql - daemon. Use the <function>mysql_dbname</function> function to - traverse this result pointer. - </refsect1> - </refentry> - --> <refentry id="function.mysql-list-tables"> <refnamediv> <refname>mysql_list_tables</refname> ! <refpurpose>list tables in a MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_list_tables</function></funcdef> <paramdef>string <parameter>database</parameter></paramdef> </funcsynopsis> <para> <function>mysql_list_tables</function> takes a database name and --- 813,831 ---- </refsect1> </refentry> <refentry id="function.mysql-list-tables"> <refnamediv> <refname>mysql_list_tables</refname> ! <refpurpose>List tables in a MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_list_tables</function></funcdef> <paramdef>string <parameter>database</parameter></paramdef> + <paramdef>int <parameter><optional>link_identifier</optional> + </parameter></paramdef> </funcsynopsis> <para> <function>mysql_list_tables</function> takes a database name and *************** *** 1094,1125 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-listtables"> - <refnamediv> - <refname>mysql_listtables</refname> - <refpurpose>list tables in a MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_listtables</function></funcdef> - <paramdef>string <parameter>database</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_listtables</function> takes a database name and - result pointer much like the <function>mysql_db_query</function> - function. The <function>mysql_tablename</function> function - should be used to extract the actual table names from the result - pointer. - </refsect1> - </refentry> - --> <refentry id="function.mysql-num-fields"> <refnamediv> <refname>mysql_num_fields</refname> ! <refpurpose>get number of fields in result</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 839,849 ---- </refsect1> </refentry> <refentry id="function.mysql-num-fields"> <refnamediv> <refname>mysql_num_fields</refname> ! <refpurpose>Get number of fields in result</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 1142,1176 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-numfields"> - <refnamediv> - <refname>mysql_numfields</refname> - <refpurpose>get number of fields in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_numfields</function></funcdef> - <paramdef>int <parameter>result</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_numfields</function> returns the number of fields - in a result set. - <para> - See also: - <function>mysql_db_query</function>, - <function>mysql_query</function>, - <function>mysql_fetchfield</function>, - <function>mysql_numrows</function>. - </refsect1> - </refentry> - --> <refentry id="function.mysql-num-rows"> <refnamediv> <refname>mysql_num_rows</refname> ! <refpurpose>get number of rows in result</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 866,876 ---- </refsect1> </refentry> <refentry id="function.mysql-num-rows"> <refnamediv> <refname>mysql_num_rows</refname> ! <refpurpose>Get number of rows in result</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 1192,1233 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-numrows"> - <refnamediv> - <refname>mysql_numrows</refname> - <refpurpose>get number of rows in result</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_numrows</function></funcdef> - <paramdef>string <parameter>result</parameter></paramdef> - </funcsynopsis> - <para> - <function>mysql_numrows</function> returns the number of rows in - a result set. - <para> - See also: - <function>mysql_db_query</function>, - <function>mysql_query</function> and, - <function>mysql_fetch_row</function>. - </para> - </refsect1> - </refentry> - --> - <refentry id="function.mysql-pconnect"> <refnamediv> ! <refname>mysql_pconnect</refname> ! <refpurpose>open persistent MySQL connection</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_pconnect</function></funcdef> <paramdef>string <parameter><optional>hostname</optional> </parameter></paramdef> <paramdef>string <parameter><optional>username</optional> </parameter></paramdef> --- 892,910 ---- </refsect1> </refentry> <refentry id="function.mysql-pconnect"> <refnamediv> ! <refname>mysql_pconnect</refname> ! <refpurpose>Open a persistent connection to a MySQL ! Server</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> <funcdef>int <function>mysql_pconnect</function></funcdef> <paramdef>string <parameter><optional>hostname</optional> + <optional>:port</optional> </parameter></paramdef> <paramdef>string <parameter><optional>username</optional> </parameter></paramdef> *************** *** 1258,1264 **** <refentry id="function.mysql-query"> <refnamediv> <refname>mysql_query</refname> ! <refpurpose>send MySQL query</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 935,941 ---- <refentry id="function.mysql-query"> <refnamediv> <refname>mysql_query</refname> ! <refpurpose>Send an SQL query to MySQL</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 1271,1280 **** <para> <function>mysql_query</function> sends a query to the currently active database on the server that's associated with the ! specified link identifier. If <parameter>link_identifier</parameter> isn't ! specified, the last opened link is assumed. If no link is open, ! the function tries to establish a link as if ! <function>mysql_connect</function> was called, and use it. <para> This function returns TRUE or FALSE to indicate the success of UPDATE, INSERT, and DELETE queries. For SELECT queries it returns --- 948,958 ---- <para> <function>mysql_query</function> sends a query to the currently active database on the server that's associated with the ! specified link identifier. If ! <parameter>link_identifier</parameter> isn't specified, the last ! opened link is assumed. If no link is open, the function tries ! to establish a link as if <function>mysql_connect</function> was ! called, and use it. <para> This function returns TRUE or FALSE to indicate the success of UPDATE, INSERT, and DELETE queries. For SELECT queries it returns *************** *** 1291,1297 **** <refentry id="function.mysql-result"> <refnamediv> <refname>mysql_result</refname> ! <refpurpose>get result data</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 969,975 ---- <refentry id="function.mysql-result"> <refnamediv> <refname>mysql_result</refname> ! <refpurpose>Get result data</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 1330,1336 **** <refentry id="function.mysql-select-db"> <refnamediv> <refname>mysql_select_db</refname> ! <refpurpose>select MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> --- 1008,1014 ---- <refentry id="function.mysql-select-db"> <refnamediv> <refname>mysql_select_db</refname> ! <refpurpose>Select a MySQL database</refpurpose> </refnamediv> <refsect1> <title>Description</title> *************** *** 1362,1399 **** </refsect1> </refentry> - <!-- - <refentry id="function.mysql-selectdb"> - <refnamediv> - <refname>mysql_selectdb</refname> - <refpurpose>select MySQL database</refpurpose> - </refnamediv> - <refsect1> - <title>Description</title> - <funcsynopsis> - <funcdef>int <function>mysql_selectdb</function></funcdef> - <paramdef>string <parameter>database_name</parameter></paramdef> - <paramdef>int <parameter>link_identifier</parameter></paramdef> - </funcsynopsis> - <para> - Returns: true on success, false on error - <para> - <function>mysql_selectdb</function> sets the current active - database on the server that's associated with the specified link - identifier. If no link identifier is specified, the last opened - link is assumed. If no link is open, the function will try to - establish a link as if <function>mysql_connect</function> was - called, and use it. - <para> - Every subsequent call to <function>mysql_query</function> will be - made on the active database. - <para> See also: - <function>mysql_connect</function>, - <function>mysql_pconnect</function>, and - <function>mysql_query</function> - </refsect1> - </refentry> - --> <refentry id="function.mysql-tablename"> <refnamediv> --- 1040,1045 ---- -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net