[DOC-CVS] [doc-en] master: mysql : fix XML by converting para to simpara tags via script
[email protected] (Gina Peter Banyard)
| Newsgroups | php.doc.cvs |
|---|---|
| Message-ID | <[email protected]> |
Author: Gina Peter Banyard (Girgias)
Date: 2026-01-19T03:22:00Z
Commit: https://github.com/php/doc-en/commit/15d88bef8b9082fb92a3753a9e7551f9cf1836d3
Raw diff: https://github.com/php/doc-en/commit/15d88bef8b9082fb92a3753a9e7551f9cf1836d3.diff
mysql : fix XML by converting para to simpara tags via script
Changed paths:
M reference/mysql/book.xml
M reference/mysql/changelog.xml
M reference/mysql/configure.xml
M reference/mysql/functions/mysql-affected-rows.xml
M reference/mysql/functions/mysql-client-encoding.xml
M reference/mysql/functions/mysql-close.xml
M reference/mysql/functions/mysql-connect.xml
M reference/mysql/functions/mysql-create-db.xml
M reference/mysql/functions/mysql-data-seek.xml
M reference/mysql/functions/mysql-db-name.xml
M reference/mysql/functions/mysql-db-query.xml
M reference/mysql/functions/mysql-drop-db.xml
M reference/mysql/functions/mysql-errno.xml
M reference/mysql/functions/mysql-error.xml
M reference/mysql/functions/mysql-escape-string.xml
M reference/mysql/functions/mysql-fetch-array.xml
M reference/mysql/functions/mysql-fetch-assoc.xml
M reference/mysql/functions/mysql-fetch-field.xml
M reference/mysql/functions/mysql-fetch-lengths.xml
M reference/mysql/functions/mysql-fetch-object.xml
M reference/mysql/functions/mysql-fetch-row.xml
M reference/mysql/functions/mysql-field-flags.xml
M reference/mysql/functions/mysql-field-len.xml
M reference/mysql/functions/mysql-field-name.xml
M reference/mysql/functions/mysql-field-seek.xml
M reference/mysql/functions/mysql-field-table.xml
M reference/mysql/functions/mysql-field-type.xml
M reference/mysql/functions/mysql-free-result.xml
M reference/mysql/functions/mysql-get-client-info.xml
M reference/mysql/functions/mysql-get-host-info.xml
M reference/mysql/functions/mysql-get-proto-info.xml
M reference/mysql/functions/mysql-get-server-info.xml
M reference/mysql/functions/mysql-info.xml
M reference/mysql/functions/mysql-insert-id.xml
M reference/mysql/functions/mysql-list-dbs.xml
M reference/mysql/functions/mysql-list-fields.xml
M reference/mysql/functions/mysql-list-processes.xml
M reference/mysql/functions/mysql-list-tables.xml
M reference/mysql/functions/mysql-num-fields.xml
M reference/mysql/functions/mysql-num-rows.xml
M reference/mysql/functions/mysql-pconnect.xml
M reference/mysql/functions/mysql-ping.xml
M reference/mysql/functions/mysql-query.xml
M reference/mysql/functions/mysql-real-escape-string.xml
M reference/mysql/functions/mysql-result.xml
M reference/mysql/functions/mysql-select-db.xml
M reference/mysql/functions/mysql-set-charset.xml
M reference/mysql/functions/mysql-stat.xml
M reference/mysql/functions/mysql-tablename.xml
M reference/mysql/functions/mysql-thread-id.xml
M reference/mysql/functions/mysql-unbuffered-query.xml
M reference/mysql/ini.xml
M reference/mysql/reference.xml
M reference/mysql/setup.xml
Diff:
diff --git a/reference/mysql/book.xml b/reference/mysql/book.xml
index a5a3b9c9d496..6cece2f2bd61 100644
--- a/reference/mysql/book.xml
+++ b/reference/mysql/book.xml
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!-- State: deprecated -->
-<book xml:id="book.mysql" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
+<book xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xml:id="book.mysql">
<?phpdoc extension-membership="pecl"?>
<title>Original MySQL API</title>
<titleabbrev>MySQL (Original)</titleabbrev>
@@ -8,23 +8,21 @@
<!-- {{{ preface -->
<preface xml:id="intro.mysql">
&reftitle.intro;
- <para>
- This extension is deprecated as of PHP 5.5.0, and
+ <simpara>
+ This extension is deprecated as of PHP 5.5.0, and
has been removed as of PHP 7.0.0. Instead, either the
<link linkend="book.mysqli">mysqli</link> or
<link linkend="ref.pdo-mysql">PDO_MySQL</link> extension should be
used. See also the <link linkend="mysqlinfo.api.choosing">MySQL API
Overview</link> for further help while choosing a MySQL API.
- </para>
- <para>
+ </simpara>
+ <simpara>
These functions allow you to access MySQL database servers.
- More information about MySQL can be found at <link
- xlink:href="&url.mysql;">&url.mysql;</link>.
- </para>
- <para>
- Documentation for MySQL can be found at <link
- xlink:href="&url.mysql.docs;">&url.mysql.docs;</link>.
- </para>
+ More information about MySQL can be found at <link xlink:href="&url.mysql;">&url.mysql;</link>.
+ </simpara>
+ <simpara>
+ Documentation for MySQL can be found at <link xlink:href="&url.mysql.docs;">&url.mysql.docs;</link>.
+ </simpara>
</preface>
<!-- }}} -->
@@ -55,4 +53,3 @@ vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
-
diff --git a/reference/mysql/changelog.xml b/reference/mysql/changelog.xml
index 9993f6398ff9..8e273d15f075 100644
--- a/reference/mysql/changelog.xml
+++ b/reference/mysql/changelog.xml
@@ -2,20 +2,20 @@
<!-- $Revision$ -->
<appendix xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xml:id="changelog.mysql">
<title>&ChangelogListingTitle;</title>
- <para>&ChangelogListingDescription;</para>
+ <simpara>&ChangelogListingDescription;</simpara>
<simplesect>
<title>General Changelog for the ext/mysql extension</title>
- <para>
+ <simpara>
This changelog references the ext/mysql extension.
- </para>
+ </simpara>
</simplesect>
<simplesect xml:id="changelog.mysql.global">
<title>Global ext/mysql changes</title>
- <para>
+ <simpara>
The following is a list of changes to the entire ext/mysql extension.
- </para>
+ </simpara>
<informaltable xml:id="changelog.mysql.global.table">
<tgroup cols="2">
<thead>
@@ -28,10 +28,10 @@
<row>
<entry>7.0.0</entry>
<entry>
- <para>
+ <simpara>
This extension was removed from PHP. For details, see
<xref linkend="mysqlinfo.api.choosing"/>.
- </para>
+ </simpara>
</entry>
</row>
</tbody>
@@ -41,10 +41,10 @@
<simplesect xml:id="changelog.mysql.functions">
<title>Changes to existing functions</title>
- <para>
+ <simpara>
The following list is a compilation of changelog entries from
the ext/mysql functions.
- </para>
+ </simpara>
<?phpdoc generate-changelog-for="ref.mysql book.mysql"?>
</simplesect>
diff --git a/reference/mysql/configure.xml b/reference/mysql/configure.xml
index b9e5e0af1956..10fe32acb109 100644
--- a/reference/mysql/configure.xml
+++ b/reference/mysql/configure.xml
@@ -1,35 +1,35 @@
<?xml version="1.0" encoding="utf-8"?>
<!-- $Revision$ -->
-<section xml:id="mysql.installation" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
+<section xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xml:id="mysql.installation">
&reftitle.install;
<warning>
&mysql.alternative.note;
</warning>
- <para xml:id="mysql.configure">
- For compiling, simply use the
+ <simpara xml:id="mysql.configure">
+ For compiling, simply use the
<option role="configure">--with-mysql[=DIR]</option>
- configuration option where the optional <literal>[DIR]</literal> points to
+ configuration option where the optional <literal>[DIR]</literal> points to
the MySQL installation directory.
- </para>
- <para>
- Although this MySQL extension is compatible with MySQL 4.1.0 and greater,
- it doesn't support the extra functionality that these versions provide.
+ </simpara>
+ <simpara>
+ Although this MySQL extension is compatible with MySQL 4.1.0 and greater,
+ it doesn't support the extra functionality that these versions provide.
For that, use the <link linkend="book.mysqli">MySQLi</link> extension.
- </para>
- <para>
+ </simpara>
+ <simpara>
If you would like to install the mysql extension along with the mysqli extension
you have to use the same client library to avoid any conflicts.
- </para>
+ </simpara>
<section xml:id="mysql.installation.linux">
<title>Installation on Linux Systems</title>
- <para>
- Note: <literal>[DIR]</literal> is the path to the MySQL client library
- files (<emphasis>headers and libraries</emphasis>), which can be downloaded from
+ <simpara>
+ Note: <literal>[DIR]</literal> is the path to the MySQL client library
+ files (<emphasis>headers and libraries</emphasis>), which can be downloaded from
<link xlink:href="&url.mysql;">MySQL</link>.
- </para>
+ </simpara>
<table xml:id="mysql.installation.compile.support">
<title>ext/mysql compile time support matrix</title>
<tgroup cols="5">
@@ -83,67 +83,66 @@
<title>Installation on Windows Systems</title>
<section xml:id="mysql.installation.windows.php52">
<title>PHP 5.0.x, 5.1.x, 5.2.x</title>
- <para>
- MySQL is no longer enabled by default, so the
- <filename>php_mysql.dll</filename> DLL must be enabled inside of
+ <simpara>
+ MySQL is no longer enabled by default, so the
+ <filename>php_mysql.dll</filename> DLL must be enabled inside of
&php.ini;. Also, PHP needs access to the MySQL client library. A file
- named <filename>libmysql.dll</filename> is included in the Windows PHP
- distribution and in order for PHP to talk to MySQL this file needs to be
+ named <filename>libmysql.dll</filename> is included in the Windows PHP
+ distribution and in order for PHP to talk to MySQL this file needs to be
available to the Windows systems <envar>PATH</envar>. See the FAQ
- titled "<link linkend="faq.installation.addtopath">How do I add my PHP
+ titled "<link linkend="faq.installation.addtopath">How do I add my PHP
directory to the <envar>PATH</envar> on Windows</link>" for information on how to do
this. Although copying <filename>libmysql.dll</filename> to the Windows
- system directory also works (because the system directory is by default in
+ system directory also works (because the system directory is by default in
the system's <envar>PATH</envar>), it's not recommended.
- </para>
- <para>
- As with enabling any PHP extension (such as
- <filename>php_mysql.dll</filename>), the PHP directive
- <link linkend="ini.extension-dir">extension_dir</link> should be set to
- the directory where the PHP extensions are located. See also the
+ </simpara>
+ <simpara>
+ As with enabling any PHP extension (such as
+ <filename>php_mysql.dll</filename>), the PHP directive
+ <link linkend="ini.extension-dir">extension_dir</link> should be set to
+ the directory where the PHP extensions are located. See also the
<link linkend="install.windows.manual">Manual Windows Installation
Instructions</link>. An example extension_dir value for PHP 5 is
<literal>c:\php\ext</literal>
- </para>
+ </simpara>
<note>
- <para>
+ <simpara>
If when starting the web server an error similar to the following occurs:
- <literal>"Unable to load dynamic library './php_mysql.dll'"</literal>,
- this is because <filename>php_mysql.dll</filename> and/or
+ <literal>"Unable to load dynamic library './php_mysql.dll'"</literal>,
+ this is because <filename>php_mysql.dll</filename> and/or
<filename>libmysql.dll</filename> cannot be found by the system.
- </para>
+ </simpara>
</note>
</section>
<section xml:id="mysql.installation.windows.php53">
<title>PHP 5.3.0+</title>
- <para>
+ <simpara>
The <link linkend="mysqlnd.overview">MySQL Native Driver</link> is enabled by
default. Include <filename>php_mysql.dll</filename>, but <filename>libmysql.dll</filename>
is no longer required or used.
- </para>
+ </simpara>
</section>
</section>
<section xml:id="mysql.installation.notes">
<title>MySQL Installation Notes</title>
<warning>
- <para>
+ <simpara>
Crashes and startup problems of PHP may be encountered
when loading this extension in conjunction with the recode extension.
See the <link linkend="ref.recode">recode</link> extension for more
information.
- </para>
+ </simpara>
</warning>
<note>
- <para>
+ <simpara>
If you need charsets other than <emphasis>latin</emphasis> (default), you
have to install external (not bundled) libmysqlclient with compiled charset
- support.
- </para>
+ support.
+ </simpara>
</note>
</section>
</section>
-
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
diff --git a/reference/mysql/functions/mysql-affected-rows.xml b/reference/mysql/functions/mysql-affected-rows.xml
index 05f5003c07b6..6422d41bf721 100644
--- a/reference/mysql/functions/mysql-affected-rows.xml
+++ b/reference/mysql/functions/mysql-affected-rows.xml
@@ -22,10 +22,10 @@
<type>int</type><methodname>mysql_affected_rows</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Get the number of affected rows by the last INSERT, UPDATE, REPLACE
or DELETE query associated with <parameter>link_identifier</parameter>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,32 +37,32 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the number of affected rows on success, and -1 if the last query
failed.
- </para>
- <para>
+ </simpara>
+ <simpara>
If the last query was a DELETE query with no WHERE clause, all
of the records will have been deleted from the table but this
function will return zero with MySQL versions prior to 4.1.2.
- </para>
- <para>
+ </simpara>
+ <simpara>
When using UPDATE, MySQL will not update columns where the new value is the
same as the old value. This creates the possibility that
<function>mysql_affected_rows</function> may not actually equal the number
of rows matched, only the number of rows that were literally affected by
the query.
- </para>
- <para>
+ </simpara>
+ <simpara>
The REPLACE statement first deletes the record with the same primary key
and then inserts the new record. This function returns the number of
deleted records plus the number of inserted records.
- </para>
- <para>
+ </simpara>
+ <simpara>
In the case of "INSERT ... ON DUPLICATE KEY UPDATE" queries, the
return value will be <literal>1</literal> if an insert was performed,
or <literal>2</literal> for an update of an existing row.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -127,26 +127,26 @@ Updated Records: 10
&reftitle.notes;
<note>
<title>Transactions</title>
- <para>
+ <simpara>
If you are using transactions, you need to call
<function>mysql_affected_rows</function> after your INSERT, UPDATE, or
DELETE query, not after the COMMIT.
- </para>
+ </simpara>
</note>
<note>
<title>SELECT Statements</title>
- <para>
+ <simpara>
To retrieve the number of rows returned by a SELECT, it is possible to
use <function>mysql_num_rows</function>.
- </para>
+ </simpara>
</note>
<note>
<title>Cascaded Foreign Keys</title>
- <para>
+ <simpara>
<function>mysql_affected_rows</function> does not count rows affected
implicitly through the use of ON DELETE CASCADE and/or ON UPDATE CASCADE
in foreign key constraints.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-client-encoding.xml b/reference/mysql/functions/mysql-client-encoding.xml
index 02a66d07e0dd..3712a8e5520d 100644
--- a/reference/mysql/functions/mysql-client-encoding.xml
+++ b/reference/mysql/functions/mysql-client-encoding.xml
@@ -21,9 +21,9 @@
<type>string</type><methodname>mysql_client_encoding</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the <literal>character_set</literal> variable from MySQL.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -35,9 +35,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the default character set name for the current connection.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-close.xml b/reference/mysql/functions/mysql-close.xml
index dad8a859a6d2..a2501fe0a5df 100644
--- a/reference/mysql/functions/mysql-close.xml
+++ b/reference/mysql/functions/mysql-close.xml
@@ -22,12 +22,12 @@
<type>bool</type><methodname>mysql_close</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_close</function> closes the non-persistent connection to
the MySQL server that's associated with the specified link identifier. If
<parameter>link_identifier</parameter> isn't specified, the last opened
link is used.
- </para>
+ </simpara>
&mysql.close.connections.result.sets;
</refsect1>
@@ -40,9 +40,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -73,12 +73,12 @@ Connected successfully
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
<function>mysql_close</function> will not close persistent links
created by <function>mysql_pconnect</function>.
For additional details, see the manual page on
<link linkend="features.persistent-connections">persistent connections</link>.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-connect.xml b/reference/mysql/functions/mysql-connect.xml
index 2e4bb7ef33a3..96858d728168 100644
--- a/reference/mysql/functions/mysql-connect.xml
+++ b/reference/mysql/functions/mysql-connect.xml
@@ -26,9 +26,9 @@
<methodparam choice="opt"><type>bool</type><parameter>new_link</parameter><initializer>&false;</initializer></methodparam>
<methodparam choice="opt"><type>int</type><parameter>client_flags</parameter><initializer>0</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Opens or reuses a connection to a MySQL server.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,42 +37,42 @@
<varlistentry>
<term><parameter>server</parameter></term>
<listitem>
- <para>
+ <simpara>
The MySQL server. It can also include a port number. e.g.
"hostname:port" or a path to a local socket e.g. ":/path/to/socket" for
the localhost.
- </para>
- <para>
+ </simpara>
+ <simpara>
If the PHP directive <link linkend="ini.mysql.default-host">
mysql.default_host</link> is undefined (default), then the default
value is 'localhost:3306'. In &sqlsafemode;, this parameter is ignored
and value 'localhost:3306' is always used.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>username</parameter></term>
<listitem>
- <para>
+ <simpara>
The username. Default value is defined by <link linkend="ini.mysql.default-user">mysql.default_user</link>. In
&sqlsafemode;, this parameter is ignored and the name of the user that
owns the server process is used.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>password</parameter></term>
<listitem>
- <para>
+ <simpara>
The password. Default value is defined by <link linkend="ini.mysql.default-password">mysql.default_password</link>. In
&sqlsafemode;, this parameter is ignored and empty password is used.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>new_link</parameter></term>
<listitem>
- <para>
+ <simpara>
If a second call is made to <function>mysql_connect</function>
with the same arguments, no new link will be established, but
instead, the link identifier of the already opened link will be
@@ -81,13 +81,13 @@
a new link, even if <function>mysql_connect</function> was called
before with the same parameters.
In &sqlsafemode;, this parameter is ignored.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>client_flags</parameter></term>
<listitem>
- <para>
+ <simpara>
The <parameter>client_flags</parameter> parameter can be a combination
of the following constants:
128 (enable <literal>LOAD DATA LOCAL</literal> handling),
@@ -97,7 +97,7 @@
<constant>MYSQL_CLIENT_INTERACTIVE</constant>.
Read the section about <xref linkend="mysql.client-flags"/> for further information.
In &sqlsafemode;, this parameter is ignored.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -105,9 +105,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a MySQL link identifier on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -183,7 +183,7 @@ mysql_close($link);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
Whenever you specify "localhost" or
"localhost:port" as server, the MySQL client library will
override this and try to connect to a local socket (named pipe on
@@ -192,22 +192,22 @@ mysql_close($link);
connect to the wrong local socket, the correct path should be set as
<link linkend="ini.mysql.default-host">mysql.default_host</link> in &php.ini; and the server field
left blank.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
The link to the server will be closed as soon as the execution of
the script ends, unless it's closed earlier by explicitly calling
<function>mysql_close</function>.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
Error "Can't create TCP/IP socket (10106)" usually means that the <link linkend="ini.variables-order">variables_order</link> configure directive
doesn't contain character <literal>E</literal>. On Windows, if the
environment is not copied the <literal>SYSTEMROOT</literal> environment
variable won't be available and PHP will have problems loading Winsock.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-create-db.xml b/reference/mysql/functions/mysql-create-db.xml
index aff5a255fbf7..ea11e1fa5692 100644
--- a/reference/mysql/functions/mysql-create-db.xml
+++ b/reference/mysql/functions/mysql-create-db.xml
@@ -23,11 +23,11 @@
<methodparam><type>string</type><parameter>database_name</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_create_db</function> attempts to create a new
database on the server associated with the specified link
identifier.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,9 +36,9 @@
<varlistentry>
<term><parameter>database_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database being created.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -47,20 +47,20 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
&reftitle.examples;
<example>
<title><function>mysql_create_db</function> alternative example</title>
- <para>
+ <simpara>
The function <function>mysql_create_db</function> is deprecated. It is
preferable to use <function>mysql_query</function> to issue an sql
<literal>CREATE DATABASE</literal> statement instead.
- </para>
+ </simpara>
<programlisting role="php">
<![CDATA[
<?php
@@ -90,16 +90,16 @@ Database my_db created successfully
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_createdb</function>
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
This function will not be available if the MySQL extension was built
against a MySQL 4.x client library.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-data-seek.xml b/reference/mysql/functions/mysql-data-seek.xml
index e9ec0909f6b1..53933ae009ca 100644
--- a/reference/mysql/functions/mysql-data-seek.xml
+++ b/reference/mysql/functions/mysql-data-seek.xml
@@ -23,21 +23,21 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>row_number</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_data_seek</function> moves the internal row
pointer of the MySQL result associated with the specified result
identifier to point to the specified row number. The next call
to a MySQL fetch function, such as <function>mysql_fetch_assoc</function>,
would return that row.
- </para>
- <para>
+ </simpara>
+ <simpara>
<parameter>row_number</parameter> starts at 0. The
<parameter>row_number</parameter> should be a value in the range from 0 to
<function>mysql_num_rows</function> - 1. However if the result set
is empty (<function>mysql_num_rows</function> == 0), a seek to 0 will
fail with an <constant>E_WARNING</constant> and
<function>mysql_data_seek</function> will return &false;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -47,9 +47,9 @@
<varlistentry>
<term><parameter>row_number</parameter></term>
<listitem>
- <para>
+ <simpara>
The desired row number of the new result pointer.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -57,9 +57,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -106,11 +106,11 @@ mysql_free_result($result);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
The function <function>mysql_data_seek</function> can be used in
conjunction only with <function>mysql_query</function>, not with
<function>mysql_unbuffered_query</function>.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-db-name.xml b/reference/mysql/functions/mysql-db-name.xml
index 95a64c4a5874..bf06fe0c7f90 100644
--- a/reference/mysql/functions/mysql-db-name.xml
+++ b/reference/mysql/functions/mysql-db-name.xml
@@ -23,10 +23,10 @@
<methodparam><type>int</type><parameter>row</parameter></methodparam>
<methodparam choice="opt"><type>mixed</type><parameter>field</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieve the database name from a call to
<function>mysql_list_dbs</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -35,25 +35,25 @@
<varlistentry>
<term><parameter>result</parameter></term>
<listitem>
- <para>
+ <simpara>
The result pointer from a call to <function>mysql_list_dbs</function>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>row</parameter></term>
<listitem>
- <para>
+ <simpara>
The index into the result set.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>field</parameter></term>
<listitem>
- <para>
+ <simpara>
The field name.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -61,11 +61,11 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the database name on success, and &false; on failure. If &false;
is returned, use <function>mysql_error</function> to determine the nature
of the error.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -95,10 +95,10 @@ while ($i < $cnt) {
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_dbname</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-db-query.xml b/reference/mysql/functions/mysql-db-query.xml
index 2fbaf6acc05e..da49bacfddca 100644
--- a/reference/mysql/functions/mysql-db-query.xml
+++ b/reference/mysql/functions/mysql-db-query.xml
@@ -24,10 +24,10 @@
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_db_query</function> selects a database, and executes a
query on it.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,20 +36,20 @@
<varlistentry>
<term><parameter>database</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database that will be selected.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>query</parameter></term>
<listitem>
- <para>
+ <simpara>
The MySQL query.
- </para>
- <para>
+ </simpara>
+ <simpara>
Data inside the query should be <link linkend="function.mysql-real-escape-string">properly escaped</link>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -58,12 +58,12 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a positive MySQL result resource to the query result,
or &false; on error. The function also returns &true;/&false; for
<literal>INSERT</literal>/<literal>UPDATE</literal>/<literal>DELETE</literal>
queries to indicate success/failure.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -108,7 +108,7 @@ mysql_free_result($result);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
Be aware that this function does <emphasis role="strong">NOT</emphasis>
switch back to the database you were connected before. In other words,
you can't use this function to <emphasis>temporarily</emphasis> run a
@@ -116,7 +116,7 @@ mysql_free_result($result);
Users are strongly encouraged to use the
<literal>database.table</literal> syntax in their sql queries or
<function>mysql_select_db</function> instead of this function.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-drop-db.xml b/reference/mysql/functions/mysql-drop-db.xml
index 86c9c39ebd5f..432ff55c7fc2 100644
--- a/reference/mysql/functions/mysql-drop-db.xml
+++ b/reference/mysql/functions/mysql-drop-db.xml
@@ -22,13 +22,13 @@
<methodparam><type>string</type><parameter>database_name</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_drop_db</function> attempts to drop (remove) an
entire database from the server associated with the specified
link identifier. This function is deprecated, it is preferable to use
<function>mysql_query</function> to issue an sql
<literal>DROP DATABASE</literal> statement instead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,9 +37,9 @@
<varlistentry>
<term><parameter>database_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database that will be deleted.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -48,9 +48,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -80,16 +80,16 @@ if (mysql_query($sql, $link)) {
<refsect1 role="notes">
&reftitle.notes;
<warning>
- <para>
+ <simpara>
This function will not be available if the MySQL extension was built
against a MySQL 4.x client library.
- </para>
+ </simpara>
</warning>
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_dropdb</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-errno.xml b/reference/mysql/functions/mysql-errno.xml
index 4345da1d2ad4..2f0eb7f44746 100644
--- a/reference/mysql/functions/mysql-errno.xml
+++ b/reference/mysql/functions/mysql-errno.xml
@@ -22,10 +22,10 @@
<type>int</type><methodname>mysql_errno</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns the error number from the last MySQL function.
- </para>
- <para>
+ </simpara>
+ <simpara>
Errors coming back from the MySQL database backend no longer
issue warnings. Instead, use <function>mysql_errno</function> to
retrieve the error code. Note that this function only returns the
@@ -34,7 +34,7 @@
<function>mysql_errno</function>), so if you want to use it,
make sure you check the value before calling another MySQL
function.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -46,10 +46,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the error number from the last MySQL function, or
<literal>0</literal> (zero) if no error occurred.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-error.xml b/reference/mysql/functions/mysql-error.xml
index 517e689dc5d9..20babf41731b 100644
--- a/reference/mysql/functions/mysql-error.xml
+++ b/reference/mysql/functions/mysql-error.xml
@@ -22,7 +22,7 @@
<type>string</type><methodname>mysql_error</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns the error text from the last MySQL function.
Errors coming back from the MySQL database backend no longer
issue warnings. Instead, use <function>mysql_error</function> to
@@ -31,7 +31,7 @@
including <function>mysql_error</function> and
<function>mysql_errno</function>), so if you want to use it, make
sure you check the value before calling another MySQL function.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -43,10 +43,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the error text from the last MySQL function, or
<literal>''</literal> (empty string) if no error occurred.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-escape-string.xml b/reference/mysql/functions/mysql-escape-string.xml
index c351e3718576..a28322331069 100644
--- a/reference/mysql/functions/mysql-escape-string.xml
+++ b/reference/mysql/functions/mysql-escape-string.xml
@@ -22,18 +22,18 @@
<type>string</type><methodname>mysql_escape_string</methodname>
<methodparam><type>string</type><parameter>unescaped_string</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
This function will escape the <parameter>unescaped_string</parameter>,
so that it is safe to place it in a <function>mysql_query</function>.
This function is deprecated.
- </para>
- <para>
+ </simpara>
+ <simpara>
This function is identical to <function>mysql_real_escape_string</function>
except that <function>mysql_real_escape_string</function> takes a
connection handler and escapes the string according to the current
character set. <function>mysql_escape_string</function> does not take a
connection argument and does not respect the current charset setting.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -42,9 +42,9 @@
<varlistentry>
<term><parameter>unescaped_string</parameter></term>
<listitem>
- <para>
+ <simpara>
The string that is to be escaped.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -52,9 +52,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the escaped string.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -82,10 +82,10 @@ Escaped string: Zak\'s Laptop
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
<function>mysql_escape_string</function> does not escape
<literal>%</literal> and <literal>_</literal>.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-fetch-array.xml b/reference/mysql/functions/mysql-fetch-array.xml
index a4487ee67169..83bfc1fbaa91 100644
--- a/reference/mysql/functions/mysql-fetch-array.xml
+++ b/reference/mysql/functions/mysql-fetch-array.xml
@@ -23,10 +23,10 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>result_type</parameter><initializer>MYSQL_BOTH</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns an array that corresponds to the fetched row
and moves the internal data pointer ahead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,12 +36,12 @@
<varlistentry>
<term><parameter>result_type</parameter></term>
<listitem>
- <para>
+ <simpara>
The type of array that is to be fetched. It's a constant and can
take the following values: <constant>MYSQL_ASSOC</constant>,
<constant>MYSQL_NUM</constant>, and
<constant>MYSQL_BOTH</constant>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -49,7 +49,7 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns an array of strings that corresponds to the fetched row, or &false;
if there are no more rows. The type of returned array depends on
how <parameter>result_type</parameter> is defined. By using
@@ -58,14 +58,14 @@
only get associative indices (as <function>mysql_fetch_assoc</function>
works), using <constant>MYSQL_NUM</constant>, you only get number indices
(as <function>mysql_fetch_row</function> works).
- </para>
- <para>
+ </simpara>
+ <simpara>
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other column(s)
of the same name, you must use the numeric index of the column or
make an alias for the column. For aliased columns, you cannot
access the contents with the original column name.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -144,13 +144,13 @@ mysql_free_result($result);
&reftitle.notes;
<note>
<title>Performance</title>
- <para>
+ <simpara>
An important thing to note is that using
<function>mysql_fetch_array</function> is <emphasis>not
significantly</emphasis> slower than using
<function>mysql_fetch_row</function>, while it provides
a significant added value.
- </para>
+ </simpara>
</note>
&database.field-case;
&database.fetch-null;
diff --git a/reference/mysql/functions/mysql-fetch-assoc.xml b/reference/mysql/functions/mysql-fetch-assoc.xml
index bcad3e92ec6a..12e1868900ad 100644
--- a/reference/mysql/functions/mysql-fetch-assoc.xml
+++ b/reference/mysql/functions/mysql-fetch-assoc.xml
@@ -25,13 +25,13 @@
<type>array</type><methodname>mysql_fetch_assoc</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns an associative array that corresponds to the fetched row
and moves the internal data pointer ahead.
<function>mysql_fetch_assoc</function> is equivalent to calling
<function>mysql_fetch_array</function> with MYSQL_ASSOC for the
optional second parameter. It only returns an associative array.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -43,11 +43,11 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns an associative array of strings that corresponds to the fetched row, or
&false; if there are no more rows.
- </para>
- <para>
+ </simpara>
+ <simpara>
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other
column(s) of the same name, you either need to access the
@@ -55,7 +55,7 @@
<function>mysql_fetch_row</function> or add alias names.
See the example at the <function>mysql_fetch_array</function>
description about aliases.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -116,13 +116,13 @@ mysql_free_result($result);
&reftitle.notes;
<note>
<title>Performance</title>
- <para>
+ <simpara>
An important thing to note is that using
<function>mysql_fetch_assoc</function> is <emphasis>not
significantly</emphasis> slower than using
<function>mysql_fetch_row</function>, while it
provides a significant added value.
- </para>
+ </simpara>
</note>
&database.field-case;
&database.fetch-null;
diff --git a/reference/mysql/functions/mysql-fetch-field.xml b/reference/mysql/functions/mysql-fetch-field.xml
index c7571933e683..2b00cdba2748 100644
--- a/reference/mysql/functions/mysql-fetch-field.xml
+++ b/reference/mysql/functions/mysql-fetch-field.xml
@@ -23,10 +23,10 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>field_offset</parameter><initializer>0</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns an object containing field information. This function can be used
to obtain information about fields in the provided query result.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,11 +36,11 @@
<varlistentry>
<term><parameter>field_offset</parameter></term>
<listitem>
- <para>
+ <simpara>
The numerical field offset. If the field offset is not specified, the
next field that was not yet retrieved by this function is retrieved.
The <parameter>field_offset</parameter> starts at <literal>0</literal>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -48,10 +48,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns an <type>object</type> containing field information. The properties
of the object are:
- </para>
+ </simpara>
<itemizedlist>
<listitem>
<simpara>
@@ -167,11 +167,11 @@ mysql_free_result($result);
&reftitle.notes;
&database.field-case;
<note>
- <para>
+ <simpara>
If field or tablenames are aliased in the SQL query the aliased name will
be returned. The original name can be retrieved for instance by using
<methodname>mysqli_result::fetch_field</methodname>.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-fetch-lengths.xml b/reference/mysql/functions/mysql-fetch-lengths.xml
index 0d6dfe41ce2c..d4bd2b46d406 100644
--- a/reference/mysql/functions/mysql-fetch-lengths.xml
+++ b/reference/mysql/functions/mysql-fetch-lengths.xml
@@ -22,11 +22,11 @@
<type class="union"><type>array</type><type>false</type></type><methodname>mysql_fetch_lengths</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns an array that corresponds to the lengths of each field
in the last row fetched by MySQL.
- </para>
- <para>
+ </simpara>
+ <simpara>
<function>mysql_fetch_lengths</function> stores the lengths of
each result column in the last row returned by
<function>mysql_fetch_row</function>,
@@ -34,7 +34,7 @@
<function>mysql_fetch_array</function>, and
<function>mysql_fetch_object</function> in an array, starting at
offset 0.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -46,9 +46,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
An <type>array</type> of lengths on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-fetch-object.xml b/reference/mysql/functions/mysql-fetch-object.xml
index 20ec3cb78783..d118207131a0 100644
--- a/reference/mysql/functions/mysql-fetch-object.xml
+++ b/reference/mysql/functions/mysql-fetch-object.xml
@@ -27,10 +27,10 @@
<methodparam choice="opt"><type>string</type><parameter>class_name</parameter></methodparam>
<methodparam choice="opt"><type>array</type><parameter>params</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns an object with properties that correspond to the fetched row
and moves the internal data pointer ahead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -40,19 +40,19 @@
<varlistentry>
<term><parameter>class_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the class to instantiate, set the properties of and return.
If not specified, a <classname>stdClass</classname> object is returned.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>params</parameter></term>
<listitem>
- <para>
+ <simpara>
An optional <type>array</type> of parameters to pass to the constructor
for <parameter>class_name</parameter> objects.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -60,10 +60,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns an <type>object</type> with string properties that correspond to the
fetched row, or &false; if there are no more rows.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -110,21 +110,21 @@ var_dump($obj);
&reftitle.notes;
<note>
<title>Performance</title>
- <para>
+ <simpara>
Speed-wise, the function is identical to
<function>mysql_fetch_array</function>, and almost as quick as
<function>mysql_fetch_row</function> (the difference is
insignificant).
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
<function>mysql_fetch_object</function> is similar to
<function>mysql_fetch_array</function>, with one difference - an
object is returned, instead of an array. Indirectly, that means
that you can only access the data by the field names, and not by
their offsets (numbers are illegal property names).
- </para>
+ </simpara>
</note>
&database.field-case;
&database.fetch-null;
diff --git a/reference/mysql/functions/mysql-fetch-row.xml b/reference/mysql/functions/mysql-fetch-row.xml
index 1c6c164ab4e1..3e877a7af507 100644
--- a/reference/mysql/functions/mysql-fetch-row.xml
+++ b/reference/mysql/functions/mysql-fetch-row.xml
@@ -25,10 +25,10 @@
<type>array</type><methodname>mysql_fetch_row</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns a numerical array that corresponds to the fetched row
and moves the internal data pointer ahead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -40,16 +40,16 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns an numerical array of strings that corresponds to the fetched row, or
&false; if there are no more rows.
- </para>
- <para>
+ </simpara>
+ <simpara>
<function>mysql_fetch_row</function> fetches one row of data from
the result associated with the specified result identifier. The
row is returned as an array. Each result column is stored in an
array offset, starting at offset 0.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-field-flags.xml b/reference/mysql/functions/mysql-field-flags.xml
index 7fe902b48ee0..372861f951a4 100644
--- a/reference/mysql/functions/mysql-field-flags.xml
+++ b/reference/mysql/functions/mysql-field-flags.xml
@@ -23,12 +23,12 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_field_flags</function> returns the field flags of
the specified field. The flags are reported as a single word
per flag separated by a single space, so that you can split the
returned value using <function>explode</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -41,10 +41,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a string of flags associated with the result&return.falseforfailure;.
- </para>
- <para>
+ </simpara>
+ <simpara>
The following flags are reported, if your version of MySQL
is current enough to support them: <literal>"not_null"</literal>,
<literal>"primary_key"</literal>, <literal>"unique_key"</literal>,
@@ -52,7 +52,7 @@
<literal>"unsigned"</literal>, <literal>"zerofill"</literal>,
<literal>"binary"</literal>, <literal>"enum"</literal>,
<literal>"auto_increment"</literal> and <literal>"timestamp"</literal>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -92,10 +92,10 @@ Array
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_fieldflags</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-field-len.xml b/reference/mysql/functions/mysql-field-len.xml
index 479458454c0b..679d9c9dc78f 100644
--- a/reference/mysql/functions/mysql-field-len.xml
+++ b/reference/mysql/functions/mysql-field-len.xml
@@ -23,10 +23,10 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_field_len</function> returns the length of the
specified field.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -39,9 +39,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The length of the specified field index on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -70,10 +70,10 @@ echo $length;
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_fieldlen</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-field-name.xml b/reference/mysql/functions/mysql-field-name.xml
index 5d35bd6376b6..9d23f5bca98c 100644
--- a/reference/mysql/functions/mysql-field-name.xml
+++ b/reference/mysql/functions/mysql-field-name.xml
@@ -23,10 +23,10 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_field_name</function> returns the name of the
specified field index.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -39,9 +39,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The name of the specified field index on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -86,10 +86,10 @@ password
&reftitle.notes;
&database.field-case;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_fieldname</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-field-seek.xml b/reference/mysql/functions/mysql-field-seek.xml
index d28795af2568..c1cb581b4455 100644
--- a/reference/mysql/functions/mysql-field-seek.xml
+++ b/reference/mysql/functions/mysql-field-seek.xml
@@ -27,12 +27,12 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Seeks to the specified field offset. If the next call to
<function>mysql_fetch_field</function> doesn't include a field
offset, the field offset specified in
<function>mysql_field_seek</function> will be returned.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -45,9 +45,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="seealso">
diff --git a/reference/mysql/functions/mysql-field-table.xml b/reference/mysql/functions/mysql-field-table.xml
index 17353b966784..8c256f2aeb9d 100644
--- a/reference/mysql/functions/mysql-field-table.xml
+++ b/reference/mysql/functions/mysql-field-table.xml
@@ -23,9 +23,9 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns the name of the table that the specified field is in.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -38,9 +38,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The name of the table on success.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -73,10 +73,10 @@ for ($i = 0; $i < mysql_num_fields($result); ++$i) {
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_fieldtable</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-field-type.xml b/reference/mysql/functions/mysql-field-type.xml
index 0185d28d2438..7578758f02c5 100644
--- a/reference/mysql/functions/mysql-field-type.xml
+++ b/reference/mysql/functions/mysql-field-type.xml
@@ -23,11 +23,11 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_field_type</function> is similar to the
<function>mysql_field_name</function> function. The arguments are
identical, but the field type is returned instead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -40,13 +40,13 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The returned field type
will be one of <literal>"int"</literal>, <literal>"real"</literal>,
<literal>"string"</literal>, <literal>"blob"</literal>, and others as
detailed in the <link xlink:href="&url.mysql.docs;">MySQL
documentation</link>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -93,10 +93,10 @@ string type 9 not_null enum
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_fieldtype</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-free-result.xml b/reference/mysql/functions/mysql-free-result.xml
index c62802723417..575915e688a3 100644
--- a/reference/mysql/functions/mysql-free-result.xml
+++ b/reference/mysql/functions/mysql-free-result.xml
@@ -22,16 +22,16 @@
<type>bool</type><methodname>mysql_free_result</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_free_result</function> will free all memory
associated with the result identifier <parameter>result</parameter>.
- </para>
- <para>
+ </simpara>
+ <simpara>
<function>mysql_free_result</function> only needs to be called if
you are concerned about how much memory is being used for queries
that return large result sets. All associated result memory is
automatically freed at the end of the script's execution.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -43,15 +43,15 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
- <para>
+ </simpara>
+ <simpara>
If a non-resource is used for the <parameter>result</parameter>, an
error of level E_WARNING will be emitted. It's worth noting that
<function>mysql_query</function> only returns a <type>resource</type>
for SELECT, SHOW, EXPLAIN, and DESCRIBE queries.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -83,10 +83,10 @@ echo $row['email'];
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_freeresult</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-get-client-info.xml b/reference/mysql/functions/mysql-get-client-info.xml
index d4d61fd9efa8..286d34421bb6 100644
--- a/reference/mysql/functions/mysql-get-client-info.xml
+++ b/reference/mysql/functions/mysql-get-client-info.xml
@@ -25,10 +25,10 @@
<type>string</type><methodname>mysql_get_client_info</methodname>
<void/>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_get_client_info</function> returns a string that
represents the client library version.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -38,9 +38,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The MySQL client version.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-get-host-info.xml b/reference/mysql/functions/mysql-get-host-info.xml
index 7a69f43e89fd..802c0d131f83 100644
--- a/reference/mysql/functions/mysql-get-host-info.xml
+++ b/reference/mysql/functions/mysql-get-host-info.xml
@@ -25,10 +25,10 @@
<type class="union"><type>string</type><type>false</type></type><methodname>mysql_get_host_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Describes the type of connection in use for the connection, including the
server host name.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -40,10 +40,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a string describing the type of MySQL connection in use for the
connection&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-get-proto-info.xml b/reference/mysql/functions/mysql-get-proto-info.xml
index 47864b8c9c49..44b04b3abb80 100644
--- a/reference/mysql/functions/mysql-get-proto-info.xml
+++ b/reference/mysql/functions/mysql-get-proto-info.xml
@@ -21,9 +21,9 @@
<type class="union"><type>int</type><type>false</type></type><methodname>mysql_get_proto_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the MySQL protocol.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -35,9 +35,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the MySQL protocol on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-get-server-info.xml b/reference/mysql/functions/mysql-get-server-info.xml
index f5e27c2dc298..13e34b52584e 100644
--- a/reference/mysql/functions/mysql-get-server-info.xml
+++ b/reference/mysql/functions/mysql-get-server-info.xml
@@ -25,9 +25,9 @@
<type class="union"><type>string</type><type>false</type></type><methodname>mysql_get_server_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the MySQL server version.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -39,9 +39,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the MySQL server version on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-info.xml b/reference/mysql/functions/mysql-info.xml
index dca36aac53f5..76796bd66943 100644
--- a/reference/mysql/functions/mysql-info.xml
+++ b/reference/mysql/functions/mysql-info.xml
@@ -21,9 +21,9 @@
<type>string</type><methodname>mysql_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns detailed information about the last query.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -35,22 +35,22 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns information about the statement on success, or &false; on
failure. See the example below for which statements provide information,
and what the returned value may look like. Statements that are not listed
will return &false;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
&reftitle.examples;
<example>
<title>Relevant MySQL Statements</title>
- <para>
+ <simpara>
Statements that return string values. The numbers are only for
illustrating purpose; their values will correspond to the query.
- </para>
+ </simpara>
<programlisting role="mysql">
<![CDATA[
INSERT INTO ... SELECT ...
@@ -71,11 +71,11 @@ String format: Rows matched: 65 Changed: 65 Warnings: 0
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
<function>mysql_info</function> returns a non-&false; value for the
INSERT ... VALUES statement only if multiple value lists are
specified in the statement.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-insert-id.xml b/reference/mysql/functions/mysql-insert-id.xml
index c7bbd16d26ef..cccbeeda8dc0 100644
--- a/reference/mysql/functions/mysql-insert-id.xml
+++ b/reference/mysql/functions/mysql-insert-id.xml
@@ -22,10 +22,10 @@
<type>int</type><methodname>mysql_insert_id</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the ID generated for an AUTO_INCREMENT column by the previous
query (usually INSERT).
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,12 +37,12 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The ID generated for an AUTO_INCREMENT column by the previous
query on success, <literal>0</literal> if the previous
query does not generate an AUTO_INCREMENT value, or &false; if
no MySQL connection was established.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -69,7 +69,7 @@ printf("Last inserted record has id %d\n", mysql_insert_id());
<refsect1 role="notes">
&reftitle.notes;
<caution>
- <para>
+ <simpara>
<function>mysql_insert_id</function> will convert the return type of the
native MySQL C API function <literal>mysql_insert_id()</literal> to a type
of <literal>long</literal> (named <type>int</type> in PHP). If your
@@ -78,22 +78,22 @@ printf("Last inserted record has id %d\n", mysql_insert_id());
MySQL SQL function LAST_INSERT_ID() in an SQL query. For more information
about PHP's maximum integer values, please see the
<link linkend="language.types.integer">integer</link> documentation.
- </para>
+ </simpara>
</caution>
<note>
- <para>
+ <simpara>
Because <function>mysql_insert_id</function> acts on the last performed
query, be sure to call <function>mysql_insert_id</function> immediately
after the query that generates the value.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
The value of the MySQL SQL function
<literal>LAST_INSERT_ID()</literal> always contains the most
recently generated AUTO_INCREMENT value, and is not reset
between queries.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-list-dbs.xml b/reference/mysql/functions/mysql-list-dbs.xml
index 5b3d43ad81ae..595dc27a89d9 100644
--- a/reference/mysql/functions/mysql-list-dbs.xml
+++ b/reference/mysql/functions/mysql-list-dbs.xml
@@ -21,10 +21,10 @@
<type>resource</type><methodname>mysql_list_dbs</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Returns a result pointer containing the databases available from the
current mysql daemon.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,12 +36,12 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a result pointer <type>resource</type> on success, or &false; on
failure. Use the <function>mysql_tablename</function> function to traverse
this result pointer, or any function for result tables, such as
<function>mysql_fetch_array</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -83,10 +83,10 @@ database3
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_listdbs</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-list-fields.xml b/reference/mysql/functions/mysql-list-fields.xml
index f12061b3e9b6..a9a3b736c143 100644
--- a/reference/mysql/functions/mysql-list-fields.xml
+++ b/reference/mysql/functions/mysql-list-fields.xml
@@ -23,14 +23,14 @@
<methodparam><type>string</type><parameter>table_name</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves information about the given table name.
- </para>
- <para>
+ </simpara>
+ <simpara>
This function is deprecated. It is preferable to use
<function>mysql_query</function> to issue an SQL <literal>SHOW COLUMNS FROM
table [LIKE 'name']</literal> statement instead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -39,17 +39,17 @@
<varlistentry>
<term><parameter>database_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database that's being queried.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>table_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the table that's being queried.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -58,16 +58,16 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
A result pointer <type>resource</type> on success, or &false; on
failure.
- </para>
- <para>
+ </simpara>
+ <simpara>
The returned result can be used with <function>mysql_field_flags</function>,
<function>mysql_field_len</function>,
<function>mysql_field_name</function>&listendand;
<function>mysql_field_type</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -119,10 +119,10 @@ Array
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_listfields</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-list-processes.xml b/reference/mysql/functions/mysql-list-processes.xml
index ce895fe32980..ef91dfdb2cf2 100644
--- a/reference/mysql/functions/mysql-list-processes.xml
+++ b/reference/mysql/functions/mysql-list-processes.xml
@@ -21,9 +21,9 @@
<type class="union"><type>resource</type><type>false</type></type><methodname>mysql_list_processes</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the current MySQL server threads.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -35,9 +35,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
A result pointer <type>resource</type> on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-list-tables.xml b/reference/mysql/functions/mysql-list-tables.xml
index bc39f0f03d0c..36798fd5d7ce 100644
--- a/reference/mysql/functions/mysql-list-tables.xml
+++ b/reference/mysql/functions/mysql-list-tables.xml
@@ -22,14 +22,14 @@
<methodparam><type>string</type><parameter>database</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves a list of table names from a MySQL database.
- </para>
- <para>
+ </simpara>
+ <simpara>
This function is deprecated. It is preferable to use
<function>mysql_query</function> to issue an SQL <literal>SHOW TABLES
[FROM db_name] [LIKE 'pattern']</literal> statement instead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -38,9 +38,9 @@
<varlistentry>
<term><parameter>database</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -49,14 +49,14 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
A result pointer <type>resource</type> on success&return.falseforfailure;.
- </para>
- <para>
+ </simpara>
+ <simpara>
Use the <function>mysql_tablename</function> function to
traverse this result pointer, or any function for result tables,
such as <function>mysql_fetch_array</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -96,10 +96,10 @@ mysql_free_result($result);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_listtables</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-num-fields.xml b/reference/mysql/functions/mysql-num-fields.xml
index 363d2badbdbf..c525e0d6a0e5 100644
--- a/reference/mysql/functions/mysql-num-fields.xml
+++ b/reference/mysql/functions/mysql-num-fields.xml
@@ -22,9 +22,9 @@
<type class="union"><type>int</type><type>false</type></type><methodname>mysql_num_fields</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the number of fields from a query.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,10 +36,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the number of fields in the result set <type>resource</type> on
success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -66,10 +66,10 @@ echo mysql_num_fields($result);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_numfields</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-num-rows.xml b/reference/mysql/functions/mysql-num-rows.xml
index 01142c49894f..bc43c5340487 100644
--- a/reference/mysql/functions/mysql-num-rows.xml
+++ b/reference/mysql/functions/mysql-num-rows.xml
@@ -23,12 +23,12 @@
<type class="union"><type>int</type><type>false</type></type><methodname>mysql_num_rows</methodname>
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the number of rows from a result set. This command is only valid
for statements like SELECT or SHOW that return an actual result set.
To retrieve the number of rows affected by a INSERT, UPDATE, REPLACE or
DELETE query, use <function>mysql_affected_rows</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -40,9 +40,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The number of rows in a result set on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -70,18 +70,18 @@ echo "$num_rows Rows\n";
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
If you use <function>mysql_unbuffered_query</function>,
<function>mysql_num_rows</function> will not return the
correct value until all the rows in the result set have been
retrieved.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_numrows</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-pconnect.xml b/reference/mysql/functions/mysql-pconnect.xml
index 9810883f20a3..bb4c83d4c8fa 100644
--- a/reference/mysql/functions/mysql-pconnect.xml
+++ b/reference/mysql/functions/mysql-pconnect.xml
@@ -35,29 +35,29 @@
<methodparam choice="opt"><type>int</type><parameter>client_flags</parameter></methodparam>
</methodsynopsis>
-->
- <para>
+ <simpara>
Establishes a persistent connection to a MySQL server.
- </para>
+ </simpara>
<!-- TODO: Integrate this information more nicely with features.persistent -->
- <para>
+ <simpara>
<function>mysql_pconnect</function> acts very much like
<function>mysql_connect</function> with two major differences.
- </para>
- <para>
+ </simpara>
+ <simpara>
First, when connecting, the function would first try to find a
(persistent) link that's already open with the same host,
username and password. If one is found, an identifier for it
will be returned instead of opening a new connection.
- </para>
- <para>
+ </simpara>
+ <simpara>
Second, the connection to the SQL server will not be closed when
the execution of the script ends. Instead, the link will remain
open for future use (<function>mysql_close</function> will not
close links established by <function>mysql_pconnect</function>).
- </para>
- <para>
+ </simpara>
+ <simpara>
This type of link is therefore called 'persistent'.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -66,39 +66,39 @@
<varlistentry>
<term><parameter>server</parameter></term>
<listitem>
- <para>
+ <simpara>
The MySQL server. It can also include a port number. e.g.
"hostname:port" or a path to a local socket e.g. ":/path/to/socket" for
the localhost.
- </para>
- <para>
+ </simpara>
+ <simpara>
If the PHP directive <link linkend="ini.mysql.default-host">
mysql.default_host</link> is undefined (default), then the default
value is 'localhost:3306'
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>username</parameter></term>
<listitem>
- <para>
+ <simpara>
The username. Default value is the name of the user that owns the
server process.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>password</parameter></term>
<listitem>
- <para>
+ <simpara>
The password. Default value is an empty password.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>client_flags</parameter></term>
<listitem>
- <para>
+ <simpara>
The <parameter>client_flags</parameter> parameter can be a combination
of the following constants:
128 (enable <literal>LOAD DATA LOCAL</literal> handling),
@@ -106,7 +106,7 @@
<constant>MYSQL_CLIENT_COMPRESS</constant>,
<constant>MYSQL_CLIENT_IGNORE_SPACE</constant> or
<constant>MYSQL_CLIENT_INTERACTIVE</constant>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -114,28 +114,28 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a MySQL persistent link identifier on success, or &false; on
failure.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
Note, that these kind of links only work if you are using
a module version of PHP. See the
<link linkend="features.persistent-connections">Persistent
Database Connections</link> section for more information.
- </para>
+ </simpara>
</note>
<warning>
- <para>
+ <simpara>
Using persistent connections can require a bit of tuning of your Apache
and MySQL configurations to ensure that you do not exceed the number of
connections allowed by MySQL.
- </para>
+ </simpara>
</warning>
</refsect1>
diff --git a/reference/mysql/functions/mysql-ping.xml b/reference/mysql/functions/mysql-ping.xml
index f946b3ef872e..570cffe9e634 100644
--- a/reference/mysql/functions/mysql-ping.xml
+++ b/reference/mysql/functions/mysql-ping.xml
@@ -21,17 +21,17 @@
<type>bool</type><methodname>mysql_ping</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Checks whether or not the connection to
the server is working. If it has gone down, an automatic reconnection is
attempted. This function can be used by scripts that remain idle for a
long while, to check whether or not the server has closed the connection
and reconnect if necessary.
- </para>
+ </simpara>
<note>
- <para>
+ <simpara>
Automatic reconnection is disabled by default in versions of MySQL >= 5.0.3.
- </para>
+ </simpara>
</note>
</refsect1>
@@ -44,10 +44,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns &true; if the connection to the server MySQL server is working,
otherwise &false;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-query.xml b/reference/mysql/functions/mysql-query.xml
index 5ca040db887a..39e974a5af7a 100644
--- a/reference/mysql/functions/mysql-query.xml
+++ b/reference/mysql/functions/mysql-query.xml
@@ -23,12 +23,12 @@
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_query</function> sends a unique query (multiple queries
are not supported) to the currently
active database on the server that's associated with the
specified <parameter>link_identifier</parameter>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,13 +37,13 @@
<varlistentry>
<term><parameter>query</parameter></term>
<listitem>
- <para>
+ <simpara>
An SQL query
- </para>
- <para>
+ </simpara>
+ <simpara>
The query string should not end with a semicolon.
Data inside the query should be <link linkend="function.mysql-real-escape-string">properly escaped</link>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -52,44 +52,44 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset,
<function>mysql_query</function>
returns a <type>resource</type> on success, or &false; on
error.
- </para>
- <para>
+ </simpara>
+ <simpara>
For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc,
<function>mysql_query</function> returns &true; on success
or &false; on error.
- </para>
- <para>
+ </simpara>
+ <simpara>
The returned result resource should be passed to
<function>mysql_fetch_array</function>, and other
functions for dealing with result tables, to access the returned data.
- </para>
- <para>
+ </simpara>
+ <simpara>
Use <function>mysql_num_rows</function> to find out how many rows
were returned for a SELECT statement or
<function>mysql_affected_rows</function> to find out how many
rows were affected by a DELETE, INSERT, REPLACE, or UPDATE
statement.
- </para>
- <para>
+ </simpara>
+ <simpara>
<function>mysql_query</function> will also fail and return &false;
if the user does not have permission to access the table(s) referenced by
the query.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
&reftitle.examples;
<example>
<title>Invalid Query</title>
- <para>
+ <simpara>
The following query is syntactically invalid, so
<function>mysql_query</function> fails and returns &false;.
- </para>
+ </simpara>
<programlisting role="php">
<![CDATA[
<?php
@@ -104,10 +104,10 @@ if (!$result) {
</example>
<example>
<title>Valid Query</title>
- <para>
+ <simpara>
The following query is valid, so <function>mysql_query</function>
returns a <type>resource</type>.
- </para>
+ </simpara>
<programlisting role="php">
<![CDATA[
<?php
diff --git a/reference/mysql/functions/mysql-real-escape-string.xml b/reference/mysql/functions/mysql-real-escape-string.xml
index 1d49d618ee24..9424be20a2e2 100644
--- a/reference/mysql/functions/mysql-real-escape-string.xml
+++ b/reference/mysql/functions/mysql-real-escape-string.xml
@@ -23,33 +23,33 @@
<methodparam><type>string</type><parameter>unescaped_string</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Escapes special characters in the <parameter>unescaped_string</parameter>,
taking into account the current character set of the connection so that it
is safe to place it in a <function>mysql_query</function>. If binary data
is to be inserted, this function must be used.
- </para>
- <para>
+ </simpara>
+ <simpara>
<function>mysql_real_escape_string</function> calls MySQL's library function
mysql_real_escape_string, which prepends backslashes to the following characters:
<literal>\x00</literal>, <literal>\n</literal>,
<literal>\r</literal>, <literal>\</literal>, <literal>'</literal>,
<literal>"</literal> and <literal>\x1a</literal>.
- </para>
- <para>
+ </simpara>
+ <simpara>
This function must always (with few exceptions) be used to make data
safe before sending a query to MySQL.
- </para>
+ </simpara>
<caution>
<title>Security: the default character set</title>
- <para>
+ <simpara>
The character set must be set either at the server level, or with
the API function <function>mysql_set_charset</function> for it to affect
<function>mysql_real_escape_string</function>. See the concepts section
on <link linkend="mysqlinfo.concepts.charset">character sets</link> for
more information.
- </para>
+ </simpara>
</caution>
</refsect1>
@@ -59,9 +59,9 @@
<varlistentry>
<term><parameter>unescaped_string</parameter></term>
<listitem>
- <para>
+ <simpara>
The string that is to be escaped.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -70,18 +70,18 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns the escaped string, or &false; on error.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="errors">
&reftitle.errors;
- <para>
+ <simpara>
Executing this function without a MySQL connection present will
also emit <constant>E_WARNING</constant> level PHP errors. Only
execute this function with a valid MySQL connection present.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -105,10 +105,10 @@ $query = sprintf("SELECT * FROM users WHERE user='%s' AND password='%s'",
</example>
<example>
<title><function>mysql_real_escape_string</function> requires a connection example</title>
- <para>
+ <simpara>
This example demonstrates what happens if a MySQL connection is not
present when calling this function.
- </para>
+ </simpara>
<programlisting role="php">
<![CDATA[
<?php
@@ -153,36 +153,36 @@ echo $query;
?>
]]>
</programlisting>
- <para>
+ <simpara>
The query sent to MySQL:
- </para>
+ </simpara>
<screen>
<![CDATA[
SELECT * FROM users WHERE user='aidan' AND password='' OR ''=''
]]>
</screen>
- <para>
+ <simpara>
This would allow anyone to log in without a valid password.
- </para>
+ </simpara>
</example>
</refsect1>
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
A MySQL connection is required before using
<function>mysql_real_escape_string</function> otherwise an error of
level <constant>E_WARNING</constant> is generated, and &false; is
returned. If <parameter>link_identifier</parameter> isn't defined, the
last MySQL connection is used.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
If this function is not used to escape data, the query is vulnerable to
<link linkend="security.database.sql-injection">SQL Injection Attacks</link>.
- </para>
+ </simpara>
</note>
<note>
<simpara>
diff --git a/reference/mysql/functions/mysql-result.xml b/reference/mysql/functions/mysql-result.xml
index fedb1b1316ea..097a3e289786 100644
--- a/reference/mysql/functions/mysql-result.xml
+++ b/reference/mysql/functions/mysql-result.xml
@@ -28,10 +28,10 @@
<methodparam><type>int</type><parameter>row</parameter></methodparam>
<methodparam choice="opt"><type>mixed</type><parameter>field</parameter><initializer>0</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the contents of one cell from a MySQL result set.
- </para>
- <para>
+ </simpara>
+ <simpara>
When working on large result sets, you should consider using one
of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one
@@ -39,7 +39,7 @@
<function>mysql_result</function>. Also, note that specifying a
numeric offset for the field argument is much quicker than
specifying a fieldname or tablename.fieldname argument.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -49,24 +49,24 @@
<varlistentry>
<term><parameter>row</parameter></term>
<listitem>
- <para>
+ <simpara>
The row number from the result that's being retrieved. Row numbers
start at <literal>0</literal>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>field</parameter></term>
<listitem>
- <para>
+ <simpara>
The name or offset of the field being retrieved.
- </para>
- <para>
+ </simpara>
+ <simpara>
It can be the field's offset, the field's name, or the field's table
dot field name (tablename.fieldname). If the column name has been
aliased ('select foo as bar from...'), use the alias instead of the
column name. If undefined, the first field is retrieved.
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -74,10 +74,10 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The contents of one cell from a MySQL result set on success, or
&false; on failure.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -110,10 +110,10 @@ mysql_close($link);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
Calls to <function>mysql_result</function> should not be mixed
with calls to other functions that deal with the result set.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-select-db.xml b/reference/mysql/functions/mysql-select-db.xml
index 866b08df9066..32ab346a2f59 100644
--- a/reference/mysql/functions/mysql-select-db.xml
+++ b/reference/mysql/functions/mysql-select-db.xml
@@ -23,11 +23,11 @@
<methodparam><type>string</type><parameter>database_name</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Sets the current active database on the server that's associated with the
specified link identifier. Every subsequent call to
<function>mysql_query</function> will be made on the active database.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -36,9 +36,9 @@
<varlistentry>
<term><parameter>database_name</parameter></term>
<listitem>
- <para>
+ <simpara>
The name of the database that is to be selected.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -47,9 +47,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -79,10 +79,10 @@ if (!$db_selected) {
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
&info.deprecated.alias;
<function>mysql_selectdb</function>
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-set-charset.xml b/reference/mysql/functions/mysql-set-charset.xml
index 06933ae06bb3..20997dbc1044 100644
--- a/reference/mysql/functions/mysql-set-charset.xml
+++ b/reference/mysql/functions/mysql-set-charset.xml
@@ -23,9 +23,9 @@
<methodparam><type>string</type><parameter>charset</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Sets the default character set for the current connection.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -34,9 +34,9 @@
<varlistentry>
<term><parameter>charset</parameter></term>
<listitem>
- <para>
+ <simpara>
A valid character set name.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -45,25 +45,25 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
&return.success;
- </para>
+ </simpara>
</refsect1>
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
This function requires MySQL 5.0.7 or later.
- </para>
+ </simpara>
</note>
<note>
- <para>
+ <simpara>
This is the preferred way to change the charset. Using
<function>mysql_query</function> to set it (such as <literal>SET NAMES utf8</literal>)
is not recommended. See the <link linkend="mysqlinfo.concepts.charset">MySQL character set concepts</link>
section for more information.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-stat.xml b/reference/mysql/functions/mysql-stat.xml
index 891fc6eadaad..019715df9143 100644
--- a/reference/mysql/functions/mysql-stat.xml
+++ b/reference/mysql/functions/mysql-stat.xml
@@ -25,9 +25,9 @@
<type>string</type><methodname>mysql_stat</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_stat</function> returns the current server status.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -39,12 +39,12 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
Returns a string with the status for uptime, threads, queries, open tables,
flush tables and queries per second. For a complete list of other status
variables, you have to use the <literal>SHOW STATUS</literal> SQL command.
If <parameter>link_identifier</parameter> is invalid, &null; is returned.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-tablename.xml b/reference/mysql/functions/mysql-tablename.xml
index 51a07fe7f233..af1002f9822b 100644
--- a/reference/mysql/functions/mysql-tablename.xml
+++ b/reference/mysql/functions/mysql-tablename.xml
@@ -22,14 +22,14 @@
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>i</parameter></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the table name from a <parameter>result</parameter>.
- </para>
- <para>
+ </simpara>
+ <simpara>
This function is deprecated. It is preferable to use
<function>mysql_query</function> to issue an SQL <literal>SHOW TABLES
[FROM db_name] [LIKE 'pattern']</literal> statement instead.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -38,18 +38,18 @@
<varlistentry>
<term><parameter>result</parameter></term>
<listitem>
- <para>
+ <simpara>
A result pointer <type>resource</type> that's returned from
<function>mysql_list_tables</function>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry>
<term><parameter>i</parameter></term>
<listitem>
- <para>
+ <simpara>
The integer index (row/table number)
- </para>
+ </simpara>
</listitem>
</varlistentry>
</variablelist>
@@ -57,14 +57,14 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The name of the table on success&return.falseforfailure;.
- </para>
- <para>
+ </simpara>
+ <simpara>
Use the <function>mysql_tablename</function> function to
traverse this result pointer, or any function for result tables,
such as <function>mysql_fetch_array</function>.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
@@ -91,10 +91,10 @@ mysql_free_result($result);
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
The <function>mysql_num_rows</function> function may be used to
determine the number of tables in the result pointer.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/functions/mysql-thread-id.xml b/reference/mysql/functions/mysql-thread-id.xml
index f435eecfcba4..aec4c5fd29f6 100644
--- a/reference/mysql/functions/mysql-thread-id.xml
+++ b/reference/mysql/functions/mysql-thread-id.xml
@@ -21,11 +21,11 @@
<type class="union"><type>int</type><type>false</type></type><methodname>mysql_thread_id</methodname>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
Retrieves the current thread ID. If the connection is lost, and a reconnect
with <function>mysql_ping</function> is executed, the thread ID will
change. This means only retrieve the thread ID when needed.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -37,9 +37,9 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
The thread ID on success&return.falseforfailure;.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="examples">
diff --git a/reference/mysql/functions/mysql-unbuffered-query.xml b/reference/mysql/functions/mysql-unbuffered-query.xml
index a23fe11cd6c6..251d536710a0 100644
--- a/reference/mysql/functions/mysql-unbuffered-query.xml
+++ b/reference/mysql/functions/mysql-unbuffered-query.xml
@@ -22,7 +22,7 @@
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam choice="opt"><type>resource</type><parameter>link_identifier</parameter><initializer>NULL</initializer></methodparam>
</methodsynopsis>
- <para>
+ <simpara>
<function>mysql_unbuffered_query</function> sends the SQL query
<parameter>query</parameter> to MySQL without automatically
fetching and buffering the result rows as
@@ -35,7 +35,7 @@
connections are open, you must specify the optional parameter
<parameter>link_identifier</parameter> to identify which connection
you want to use.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="parameters">
@@ -44,12 +44,12 @@
<varlistentry>
<term><parameter>query</parameter></term>
<listitem>
- <para>
+ <simpara>
The SQL query to execute.
- </para>
- <para>
+ </simpara>
+ <simpara>
Data inside the query should be <link linkend="function.mysql-real-escape-string">properly escaped</link>.
- </para>
+ </simpara>
</listitem>
</varlistentry>
&mysql.linkid.description;
@@ -58,23 +58,23 @@
<refsect1 role="returnvalues">
&reftitle.returnvalues;
- <para>
+ <simpara>
For SELECT, SHOW, DESCRIBE or EXPLAIN statements,
<function>mysql_unbuffered_query</function>
returns a <type>resource</type> on success, or &false; on
error.
- </para>
- <para>
+ </simpara>
+ <simpara>
For other type of SQL statements, UPDATE, DELETE, DROP, etc,
<function>mysql_unbuffered_query</function> returns &true; on success
or &false; on error.
- </para>
+ </simpara>
</refsect1>
<refsect1 role="notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
The benefits of <function>mysql_unbuffered_query</function> come
at a cost: you cannot use <function>mysql_num_rows</function> and
<function>mysql_data_seek</function> on a result set returned from
@@ -82,7 +82,7 @@
You also have to fetch all result rows from an unbuffered SQL query
before you can send a new SQL query to MySQL, using the same
<parameter>link_identifier</parameter>.
- </para>
+ </simpara>
</note>
</refsect1>
diff --git a/reference/mysql/ini.xml b/reference/mysql/ini.xml
index df50f447f888..89fa35fe0da6 100644
--- a/reference/mysql/ini.xml
+++ b/reference/mysql/ini.xml
@@ -98,10 +98,10 @@
<type>int</type>
</term>
<listitem>
- <para>
+ <simpara>
Allow accessing, from PHP's perspective, local files with LOAD DATA
statements
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -111,11 +111,11 @@
<type>bool</type>
</term>
<listitem>
- <para>
+ <simpara>
Whether to allow
<link linkend="features.persistent-connections">persistent connections</link>
to MySQL.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -125,10 +125,10 @@
<type>int</type>
</term>
<listitem>
- <para>
+ <simpara>
The maximum number of persistent MySQL connections per
process.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -138,10 +138,10 @@
<type>int</type>
</term>
<listitem>
- <para>
+ <simpara>
The maximum number of MySQL connections per process, including
persistent connections.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -151,11 +151,11 @@
<type>bool</type>
</term>
<listitem>
- <para>
+ <simpara>
Trace mode. When <literal>mysql.trace_mode</literal> is enabled, warnings
for table/index scans, non free result sets, and SQL-Errors will be
displayed. (Introduced in PHP 4.3.0)
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -165,7 +165,7 @@
<type>string</type>
</term>
<listitem>
- <para>
+ <simpara>
The default TCP port number to use when connecting to
the database server if no other port is specified. If
no default is specified, the port will be obtained
@@ -174,7 +174,7 @@
<filename>/etc/services</filename> or the compile-time
<constant>MYSQL_PORT</constant> constant, in that order. Win32
will only use the <constant>MYSQL_PORT</constant> constant.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -184,10 +184,10 @@
<type>string</type>
</term>
<listitem>
- <para>
+ <simpara>
The default socket name to use when connecting to a local
database server if no other socket name is specified.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry xml:id="ini.mysql.default-host">
@@ -196,11 +196,11 @@
<type>string</type>
</term>
<listitem>
- <para>
+ <simpara>
The default server host to use when connecting to the database
server if no other host is specified. Doesn't apply in
&sqlsafemode;.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -210,11 +210,11 @@
<type>string</type>
</term>
<listitem>
- <para>
+ <simpara>
The default user name to use when connecting to the database
server if no other name is specified. Doesn't apply in
&sqlsafemode;.
- </para>
+ </simpara>
</listitem>
</varlistentry>
@@ -224,11 +224,11 @@
<type>string</type>
</term>
<listitem>
- <para>
+ <simpara>
The default password to use when connecting to the database
server if no other password is specified. Doesn't apply in
&sqlsafemode;.
- </para>
+ </simpara>
</listitem>
</varlistentry>
<varlistentry xml:id="ini.mysql.connect-timeout">
@@ -237,10 +237,10 @@
<type>int</type>
</term>
<listitem>
- <para>
+ <simpara>
Connect timeout in seconds. On Linux this timeout is also used for
waiting for the first answer from the server.
- </para>
+ </simpara>
</listitem>
</varlistentry>
diff --git a/reference/mysql/reference.xml b/reference/mysql/reference.xml
index b7f4956c1196..630c7d7869b6 100644
--- a/reference/mysql/reference.xml
+++ b/reference/mysql/reference.xml
@@ -1,20 +1,19 @@
<?xml version="1.0" encoding="utf-8"?>
<!-- $Revision$ -->
-
- <reference xml:id="ref.mysql" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
+<reference xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xml:id="ref.mysql">
<title>MySQL &Functions;</title>
<partintro>
<section xml:id="mysql.notes">
&reftitle.notes;
<note>
- <para>
+ <simpara>
Most MySQL functions accept <parameter>link_identifier</parameter> as
the last optional parameter. If it is not provided, last opened
connection is used. If it doesn't exist, connection is tried to
establish with default parameters defined in &php.ini;. If it is not
successful, functions return &false;.
- </para>
+ </simpara>
</note>
</section>
</partintro>
@@ -22,7 +21,6 @@
&reference.mysql.entities.functions;
</reference>
-
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
@@ -43,4 +41,3 @@ vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
-
diff --git a/reference/mysql/setup.xml b/reference/mysql/setup.xml
index 42026b60ea02..076f1d13853c 100644
--- a/reference/mysql/setup.xml
+++ b/reference/mysql/setup.xml
@@ -1,16 +1,15 @@
<?xml version="1.0" encoding="utf-8"?>
<!-- $Revision$ -->
-
-<chapter xml:id="mysql.setup" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
+<chapter xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xml:id="mysql.setup">
&reftitle.setup;
<!-- {{{ Requirements -->
<section xml:id="mysql.requirements">
&reftitle.required;
- <para>
+ <simpara>
In order to have these functions available, you must compile PHP with
MySQL support.
- </para>
+ </simpara>
<warning>
&mysql.alternative.note;
</warning>
@@ -28,16 +27,15 @@
<!-- {{{ Resources -->
<section xml:id="mysql.resources">
&reftitle.resources;
- <para>
+ <simpara>
There are two resource types used in the MySQL module. The first one
is the link identifier for a database connection, the second a resource
which holds the result of a query.
- </para>
+ </simpara>
</section>
<!-- }}} -->
</chapter>
-
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
@@ -58,4 +56,3 @@ vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
-