[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
betzMon Apr 1 16:09:19 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: added ini-settings from config.xml to Runtime Config Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.38 phpdoc/en/functions/uodbc.xml:1.39 --- phpdoc/en/functions/uodbc.xml:1.38 Fri Mar 29 10:25:47 2002 +++ phpdoc/en/functions/uodbc.xml Mon Apr 1 16:09:19 2002 -1,5 +1,5 ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.38 $ -- +!-- $Revision: 1.39 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev -52,9 +52,9 titleRuntime Configuration/title para The behaviour of the ODBC functions is affected by settings in the - global link linkend=configurationconfiguration/link file. + global link linkend=configuration.fileconfiguration file/link php.ini;. table - titlelink linkend=ini.sect.uodbcUnified ODBC Configuration/link Options/title + titleUnified ODBC Configuration Options/title tgroup cols=3 thead row -119,6 +119,128 /note For further details and definition of the PHP_INI_* constants see functionini_set/function. +/para +para + Here is a short explanation of the configuration directives. +variablelist + + varlistentry id=ini.uodbc.default-db + term + parameterodbc.default_db/parameter + typestring/type + /term + listitem + para +ODBC data source to use if none is specified in +functionodbc_connect/function or +functionodbc_pconnect/function. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.default-user + term + parameterodbc.default_user/parameter + typestring/type + /term + listitem + para +User name to use if none is specified in +functionodbc_connect/function or +functionodbc_pconnect/function. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.default-pw + term + parameterodbc.default_pw/parameter + typestring/type + /term + listitem + para +Password to use if none is specified in +functionodbc_connect/function or +functionodbc_pconnect/function. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.allow-persistent + term + parameterodbc.allow_persistent/parameter + typeboolean/type + /term + listitem + para +Whether to allow persistent ODBC connections. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.check-persistent + term + parameterodbc.check_persistent/parameter + typeboolean/type + /term + listitem + para +Check that a connection is still valid before reuse. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.max-persistent + term + parameterodbc.max_persistent/parameter + typeinteger/type + /term + listitem + para +The maximum number of persistent ODBC connections per process. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.max-links + term + parameterodbc.max_links/parameter + typeinteger/type + /term + listitem + para +The maximum number of ODBC connections per process, including +persistent connections. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.defaultlrl + term + parameterodbc.defaultlrl/parameter + typeinteger/type + /term + listitem + para +Handling of LONG fields. Specifies the number of bytes returned to +variables. + /para + /listitem + /varlistentry + + varlistentry id=ini.uodbc.defaultbinmode + term + parameterodbc.defaultbinmode/parameter + typeinteger/type + /term + listitem + para +Handling of binary data. + /para + /listitem + /varlistentry + +/variablelist /para /section
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
betzFri Mar 29 10:25:47 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: Runtime Config tor uodbc added Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.37 phpdoc/en/functions/uodbc.xml:1.38 --- phpdoc/en/functions/uodbc.xml:1.37 Thu Mar 28 17:32:54 2002 +++ phpdoc/en/functions/uodbc.xml Fri Mar 29 10:25:47 2002 -1,5 +1,5 ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.37 $ -- +!-- $Revision: 1.38 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev -50,7 +50,76 section id=odbc.configuration titleRuntime Configuration/title - no.config; +para + The behaviour of the ODBC functions is affected by settings in the + global link linkend=configurationconfiguration/link file. + table + titlelink linkend=ini.sect.uodbcUnified ODBC Configuration/link +Options/title + tgroup cols=3 + thead +row + entryName/entry + entryDefault/entry + entryChangeable/entry +/row + /thead + tbody +row + entryodbc.default_db */entry + entryNULL/entry + entryPHP_INI_ALL/entry +/row +row + entryodbc.default_user */entry + entryNULL/entry + entryPHP_INI_ALL/entry +/row +row + entryodbc.default_pw */entry + entryNULL/entry + entryPHP_INI_ALL/entry +/row +row + entryodbc.allow_persistent/entry + entry1/entry + entryPHP_INI_SYSTEM/entry +/row +row + entryodbc.check_persistent/entry + entry1/entry + entryPHP_INI_SYSTEM/entry +/row +row + entryodbc.max_persistent/entry + entry-1/entry + entryPHP_INI_SYSTEM/entry +/row +row + entryodbc.max_links/entry + entry-1/entry + entryPHP_INI_SYSTEM/entry +/row +row + entryodbc.defaultlrl/entry + entry4096/entry + entryPHP_INI_ALL/entry +/row +row + entryodbc.defaultbinmode/entry + entry1/entry + entryPHP_INI_ALL/entry +/row + /tbody + /tgroup + /table + note + simpara + Entries marked with * are not implemented yet. + /simpara + /note + For further details and definition of the PHP_INI_* constants see + functionini_set/function. +/para /section section id=odbc.resources
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
cortesi Mon Mar 25 21:16:04 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: quick and dirty correction of build critical tag Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.34 phpdoc/en/functions/uodbc.xml:1.35 --- phpdoc/en/functions/uodbc.xml:1.34 Mon Mar 25 15:26:03 2002 +++ phpdoc/en/functions/uodbc.xml Mon Mar 25 21:15:56 2002 -1,5 +1,5 ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.34 $ -- +!-- $Revision: 1.35 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev -26,6 +26,7 /note section id=odbc.requirements +titleSupported Databases/title para The following databases are supported by the Unified ODBC functions: ulink url=url.adabas;Adabas D/ulink, ulink -35,8 +36,9 url=url.sybase;Sybase SQL Anywhere/ulink. /para /section - +!-- section id=odbc.installation +titleInstallation/title para Please see the link linkend=database-support-optionsInstallation on Unix -44,7 +46,7 with these databases. /para /section - +-- section id=odbc.configuration titleRuntime Configuration/title para
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
torben Mon Mar 11 20:13:36 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: Mention that the single-quotes file-reading trick in odbc_execute() also didn't respect open_basedir, and is fixed in 4.2.0. Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.32 phpdoc/en/functions/uodbc.xml:1.33 --- phpdoc/en/functions/uodbc.xml:1.32 Tue Feb 12 16:23:06 2002 +++ phpdoc/en/functions/uodbc.xml Mon Mar 11 20:13:36 2002 -1,5 +1,5 ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.32 $ -- +!-- $Revision: 1.33 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev -474,7 +474,9 listitem simpara File reading is emphasisnot/emphasis subject to any link - linkend=features.safe-modesafe mode/link restrictions. + linkend=features.safe-modesafe mode/link or link + linkend=ini.open-basedirsafe mode/link + restrictions. This is fixed in PHP 4.2.0. /simpara /listitem listitem
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
torben Tue Feb 12 16:12:23 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: Added documentation for odbc_execute()'s file reading functionality. Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.30 phpdoc/en/functions/uodbc.xml:1.31 --- phpdoc/en/functions/uodbc.xml:1.30 Sat Feb 2 10:36:10 2002 +++ phpdoc/en/functions/uodbc.xml Tue Feb 12 16:12:22 2002 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.30 $ -- +!-- $Revision: 1.31 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev @@ -451,12 +451,53 @@ /methodsynopsis para Executes a statement prepared with - functionodbc_prepare/function. Returns - true; on successful execution, - false; otherwise. The array - parameterparameters_array/parameter only needs to - be given if you really have parameters in your statement. -/para + functionodbc_prepare/function. Returns true; on successful + execution; false; otherwise. The array + parameterparameters_array/parameter only needs to be given if + you really have parameters in your statement. +/para +para + Parameters in parameterparameter_array/parameter will be + substituted for placeholders in the prepared statement in order. +/para +para + Any parameters in parameterparameter_array/parameter which + start and end with single quotes will be taken as the name of a + file to read and send to the database server as the data for the + appropriate placeholder. +/para +note + para + As of PHP 4.1.1, this file reading functionality has the + following restrictions: + itemizedlist + listitem +simpara + File reading is emphasisnot/emphasis subject to any link + linkend=features.safe-modesafe mode/link restrictions. +/simpara + /listitem + listitem +simpara + link linkend=features.remote-filesRemote files/link + are not supported. +/simpara + /listitem + listitem +simpara + If you wish to store a string which actually begins and ends + with single quotes, and you cannot escape them with + backslashes--for instance, if your server requires single + quotes to be escaped by doubling them (literal''/literal) + instead of backslashing them (literal\'/literal)--then + you must use another mechanism to store them (such as + executing the query directly with + functionodbc_exec/function). +/simpara + /listitem + /itemizedlist + /para +/note /refsect1 /refentry
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
torben Tue Feb 12 16:23:08 2002 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: Clear this up a little. Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.31 phpdoc/en/functions/uodbc.xml:1.32 --- phpdoc/en/functions/uodbc.xml:1.31 Tue Feb 12 16:12:22 2002 +++ phpdoc/en/functions/uodbc.xml Tue Feb 12 16:23:06 2002 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.31 $ -- +!-- $Revision: 1.32 $ -- reference id=ref.odbc titleUnified ODBC functions/title titleabbrevODBC/titleabbrev @@ -486,13 +486,12 @@ listitem simpara If you wish to store a string which actually begins and ends - with single quotes, and you cannot escape them with - backslashes--for instance, if your server requires single - quotes to be escaped by doubling them (literal''/literal) - instead of backslashing them (literal\'/literal)--then - you must use another mechanism to store them (such as - executing the query directly with - functionodbc_exec/function). + with single quotes, you must escape them or add a space or + other non-single-quote character to the beginning or end of + the parameter, which will prevent the parameter's being taken + as a file name. If this is not an option, then you must use + another mechanism to store the string, such as executing the + query directly with functionodbc_exec/function). /simpara /listitem /itemizedlist
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
kalowskyThu Jun 28 11:54:29 2001 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: updated to reflect new functionality in 4.0.6, and warn users of the future change Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.18 phpdoc/en/functions/uodbc.xml:1.19 --- phpdoc/en/functions/uodbc.xml:1.18 Sat Jun 23 16:10:51 2001 +++ phpdoc/en/functions/uodbc.xml Thu Jun 28 11:54:29 2001 @@ -506,6 +506,54 @@ array. The array will contain the column values starting at array index 0. /para + para +example + titlefunctionodbc_fetch_into/function pre 4.0.6 example /title + programlisting role=php +$rc = odbc_fetch_into($res_id, $my_array); + /programlisting + or + programlisting role=php +$rc = odbc_fetch_into($res_id, $row, $my_array); + +$rc = odbc_fetch_into($res_id, 1, $my_array); + /programlisting +/example + /para + para +As of PHP 4.0.5 the parameterresult_array/parameter does not need +to be passed by reference any longer. + /para + para +As of PHP 4.0.6 the parameterrownumber/parameter cannot be passed +as a constant, but rather as a variable. + /para + para +example + titlefunctionodbc_fetch_into/function 4.0.6 example/title + programlisting role=php +$rc = odbc_fetch_into($res_id, $my_array); + /programlisting + or + programlisting role=php +$row = 1; +$rc = odbc_fetch_into($res_id, $row, $my_array); + /programlisting +/example + /para + para +Future: In PHP 4.1, this function will be moved to the following format: + funcsynopsis + funcprototype + funcdefint functionodbc_fetch_into/function/funcdef + paramdefint parameterresult_id/parameter/paramdef + paramdefarray parameterresult_array/parameter/paramdef + paramdefint parameteroptionalrownumber/optional/parameter/paramdef + /funcprototype + /funcsynopsis +Please note, that parameterrownumber/parameter will be optional, +while parameterresult_array/parameter is not. + /para /refsect1 /refentry
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
torben Mon Apr 2 20:30:42 2001 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: Corrected return types for odbc_error() and odbc_errormsg(). Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.14 phpdoc/en/functions/uodbc.xml:1.15 --- phpdoc/en/functions/uodbc.xml:1.14 Mon Mar 12 10:17:40 2001 +++ phpdoc/en/functions/uodbc.xml Mon Apr 2 20:30:42 2001 @@ -380,7 +380,7 @@ titleDescription/title funcsynopsis funcprototype - funcdefint functionodbc_error/function/funcdef + funcdefstring functionodbc_error/function/funcdef paramdefint parameteroptionalconnection_id/optional/parameter/paramdef /funcprototype /funcsynopsis @@ -406,7 +406,7 @@ titleDescription/title funcsynopsis funcprototype - funcdefint functionodbc_errormsg/function/funcdef + funcdefstring functionodbc_errormsg/function/funcdef paramdefint parameteroptionalconnection_id/optional/parameter/paramdef /funcprototype /funcsynopsis
[PHP-DOC] cvs: phpdoc /en/functions uodbc.xml
jon Mon Mar 12 10:17:40 2001 EDT Modified files: /phpdoc/en/functionsuodbc.xml Log: More detail concerning iODBC. Submitted by: "Andrew Hill" [EMAIL PROTECTED] Index: phpdoc/en/functions/uodbc.xml diff -u phpdoc/en/functions/uodbc.xml:1.13 phpdoc/en/functions/uodbc.xml:1.14 --- phpdoc/en/functions/uodbc.xml:1.13 Sun Jan 14 16:40:50 2001 +++ phpdoc/en/functions/uodbc.xml Mon Mar 12 10:17:40 2001 @@ -31,7 +31,11 @@ There is no ODBC involved when connecting to the above databases. The functions that you use to speak natively to them just happen to share the same names and syntax as the ODBC - functions. + functions. The exception to this is iODBC. Building PHP with iODBC + support enables you to use any ODBC-compliant drivers with your PHP + applications. iODBC is maintained by ulink url="url.openlink;" + OpenLink Software/ulink. More information on iODBC, as well as a + HOWTO, is available at ulink url="url.iodbc;"www.iodbc.org/ulink. /simpara /note /partintro
