cvs: peardoc /en/package/database/db intro-dsn.xml
| From: | Daniel Convissor | Date: | Thu, 08 Jul 2004 21:26:49 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-dsn.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-4577@lists.php.net to get a copy of this message | ||
danielc Thu Jul 8 17:26:49 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-dsn.xml
Log:
* Note database and options can be url encoded.
* Add CDATA to some sections and convert their contents
from entities to characters.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-dsn.xml?r1=1.29&r2=1.30&ty=u
Index: peardoc/en/package/database/db/intro-dsn.xml
diff -u peardoc/en/package/database/db/intro-dsn.xml:1.29
peardoc/en/package/database/db/intro-dsn.xml:1.30
--- peardoc/en/package/database/db/intro-dsn.xml:1.29 Wed May 12 15:56:03 2004
+++ peardoc/en/package/database/db/intro-dsn.xml Thu Jul 8 17:26:48 2004
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1" ?>
-<!-- $Revision: 1.29 $ -->
+<!-- $Revision: 1.30 $ -->
<refentry id="package.database.db.intro-dsn">
<refnamediv>
@@ -64,12 +64,15 @@
<para>
The format of the supplied DSN is in its fullest form:
<programlisting role="url">
+ <![CDATA[
phptype(dbsyntax)://username:password@protocol+hostspec/database?option=value
+ ]]>
</programlisting>
</para>
<para>
Most variations are allowed:
<programlisting role="url">
+ <![CDATA[
phptype://username:password@protocol+hostspec:110//usr/db_file.db
phptype://username:password@hostspec/database
phptype://username:password@hostspec
@@ -77,38 +80,44 @@
phptype://hostspec/database
phptype://hostspec
phptype:///database
-phptype:///database?option=value&anotheroption=anothervalue
+phptype:///database?option=value&anotheroption=anothervalue
phptype(dbsyntax)
phptype
+ ]]>
</programlisting>
</para>
<para>
The currently supported database backends are:
<programlisting role="configure">
-dbase -> dBase
-fbsql -> FrontBase
-ibase -> InterBase
-ifx -> Informix
-msql -> Mini SQL
-mssql -> Microsoft SQL Server
-mysql -> MySQL (for MySQL <= 4.0)
-mysqli -> MySQL (for MySQL >= 4.1) (since DB 1.6.3)
-oci8 -> Oracle 7/8/9
-odbc -> ODBC (Open Database Connectivity)
-pgsql -> PostgreSQL
-sqlite -> SQLite
-sybase -> Sybase
+ <![CDATA[
+dbase -> dBase
+fbsql -> FrontBase
+ibase -> InterBase
+ifx -> Informix
+msql -> Mini SQL
+mssql -> Microsoft SQL Server
+mysql -> MySQL (for MySQL <= 4.0)
+mysqli -> MySQL (for MySQL >= 4.1) (since DB 1.6.3)
+oci8 -> Oracle 7/8/9
+odbc -> ODBC (Open Database Connectivity)
+pgsql -> PostgreSQL
+sqlite -> SQLite
+sybase -> Sybase
+ ]]>
</programlisting>
</para>
<para>
With an up-to-date version of &class.db;, you can use a
second DSN format
<programlisting role="url">
+ <![CDATA[
phptype(syntax)://user:pass@protocol(proto_opts)/database
+ ]]>
</programlisting>
</para>
<para>
- If your <varname>username</varname> or <varname>password</varname>
+ If your <varname>database</varname>, <varname>option</varname> values,
+ <varname>username</varname> or <varname>password</varname>
contain characters used to delineate DSN parts, you
can escape them via URI hex encodings:
<programlisting role="url">
@@ -136,37 +145,49 @@
<example>
<title>Connect to database through a socket</title>
<programlisting role="url">
+ <![CDATA[
mysql://user@unix(/path/to/socket)/pear
+ ]]>
</programlisting>
</example>
<example>
<title>Connect to database on a non standard port</title>
<programlisting role="url">
+ <![CDATA[
pgsql://user:pass@tcp(localhost:5555)/pear
+ ]]>
</programlisting>
</example>
<example>
<title>Connect to SQLite on a Unix machine using options</title>
<programlisting role="url">
+ <![CDATA[
sqlite:////full/unix/path/to/file.db?mode=0666
+ ]]>
</programlisting>
</example>
<example>
<title>Connect to SQLite on a Windows machine using options</title>
<programlisting role="url">
+ <![CDATA[
sqlite:///c:/full/windows/path/to/file.db?mode=0666
+ ]]>
</programlisting>
</example>
<example>
<title>Connect to MySQLi using SSL</title>
<programlisting role="url">
-mysqli://user:pass@localhost/pear?key=client-key.pem&cert=client-cert.pem
+ <![CDATA[
+mysqli://user:pass@localhost/pear?key=client-key.pem&cert=client-cert.pem
+ ]]>
</programlisting>
</example>
<example>
<title>Connecting to MS Access sometimes requires <literal>admin</literal> as
the user name</title>
<programlisting role="url">
+ <![CDATA[
odbc(access)://admin@/datasourcename
+ ]]>
</programlisting>
</example>
</refsect1>