cvs: peardoc /en/package/database/db intro-dsn.xml

From: 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&amp;anotheroption=anothervalue +phptype:///database?option=value&anotheroption=anothervalue phptype(dbsyntax) phptype + ]]> </programlisting> </para> <para> The currently supported database backends are: <programlisting role="configure"> -dbase -&gt; dBase -fbsql -&gt; FrontBase -ibase -&gt; InterBase -ifx -&gt; Informix -msql -&gt; Mini SQL -mssql -&gt; Microsoft SQL Server -mysql -&gt; MySQL (for MySQL &lt;= 4.0) -mysqli -&gt; MySQL (for MySQL &gt;= 4.1) (since DB 1.6.3) -oci8 -&gt; Oracle 7/8/9 -odbc -&gt; ODBC (Open Database Connectivity) -pgsql -&gt; PostgreSQL -sqlite -&gt; SQLite -sybase -&gt; 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&amp;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>

« previous php.pear.doc (#4577) next »