diff options
21 files changed, 2434 insertions, 2434 deletions
diff --git a/trunk/adodb-for-php4/lang/adodb-cn.inc.php b/trunk/adodb-for-php4/lang/adodb-cn.inc.php index eb8c7de5..44d5f490 100644 --- a/trunk/adodb-for-php4/lang/adodb-cn.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-cn.inc.php @@ -1,35 +1,35 @@ -<?php
-// Chinese language file contributed by "Cuiyan (cysoft)" cysoft#php.net.
-// Encode by GB2312
-// Simplified Chinese
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'cn',
- DB_ERROR => '未知错误',
- DB_ERROR_ALREADY_EXISTS => '已经存在',
- DB_ERROR_CANNOT_CREATE => '不能创建',
- DB_ERROR_CANNOT_DELETE => '不能删除',
- DB_ERROR_CANNOT_DROP => '不能丢弃',
- DB_ERROR_CONSTRAINT => '约束限制',
- DB_ERROR_DIVZERO => '被0除',
- DB_ERROR_INVALID => '无效',
- DB_ERROR_INVALID_DATE => '无效的日期或者时间',
- DB_ERROR_INVALID_NUMBER => '无效的数字',
- DB_ERROR_MISMATCH => '不匹配',
- DB_ERROR_NODBSELECTED => '没有数据库被选择',
- DB_ERROR_NOSUCHFIELD => '没有相应的字段',
- DB_ERROR_NOSUCHTABLE => '没有相应的表',
- DB_ERROR_NOT_CAPABLE => '数据库后台不兼容',
- DB_ERROR_NOT_FOUND => '没有发现',
- DB_ERROR_NOT_LOCKED => '没有被锁定',
- DB_ERROR_SYNTAX => '语法错误',
- DB_ERROR_UNSUPPORTED => '不支持',
- DB_ERROR_VALUE_COUNT_ON_ROW => '在行上累计值',
- DB_ERROR_INVALID_DSN => '无效的数据源 (DSN)',
- DB_ERROR_CONNECT_FAILED => '连接失败',
- 0 => '没有错误', // DB_OK
- DB_ERROR_NEED_MORE_DATA => '提供的数据不能符合要求',
- DB_ERROR_EXTENSION_NOT_FOUND=> '扩展没有被发现',
- DB_ERROR_NOSUCHDB => '没有相应的数据库',
- DB_ERROR_ACCESS_VIOLATION => '没有合适的权限'
-);
+<?php +// Chinese language file contributed by "Cuiyan (cysoft)" cysoft#php.net. +// Encode by GB2312 +// Simplified Chinese +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'cn', + DB_ERROR => '未知错误', + DB_ERROR_ALREADY_EXISTS => '已经存在', + DB_ERROR_CANNOT_CREATE => '不能创建', + DB_ERROR_CANNOT_DELETE => '不能删除', + DB_ERROR_CANNOT_DROP => '不能丢弃', + DB_ERROR_CONSTRAINT => '约束限制', + DB_ERROR_DIVZERO => '被0除', + DB_ERROR_INVALID => '无效', + DB_ERROR_INVALID_DATE => '无效的日期或者时间', + DB_ERROR_INVALID_NUMBER => '无效的数字', + DB_ERROR_MISMATCH => '不匹配', + DB_ERROR_NODBSELECTED => '没有数据库被选择', + DB_ERROR_NOSUCHFIELD => '没有相应的字段', + DB_ERROR_NOSUCHTABLE => '没有相应的表', + DB_ERROR_NOT_CAPABLE => '数据库后台不兼容', + DB_ERROR_NOT_FOUND => '没有发现', + DB_ERROR_NOT_LOCKED => '没有被锁定', + DB_ERROR_SYNTAX => '语法错误', + DB_ERROR_UNSUPPORTED => '不支持', + DB_ERROR_VALUE_COUNT_ON_ROW => '在行上累计值', + DB_ERROR_INVALID_DSN => '无效的数据源 (DSN)', + DB_ERROR_CONNECT_FAILED => '连接失败', + 0 => '没有错误', // DB_OK + DB_ERROR_NEED_MORE_DATA => '提供的数据不能符合要求', + DB_ERROR_EXTENSION_NOT_FOUND=> '扩展没有被发现', + DB_ERROR_NOSUCHDB => '没有相应的数据库', + DB_ERROR_ACCESS_VIOLATION => '没有合适的权限' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-cz.inc.php b/trunk/adodb-for-php4/lang/adodb-cz.inc.php index 2424c244..1f5c08a9 100644 --- a/trunk/adodb-for-php4/lang/adodb-cz.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-cz.inc.php @@ -1,40 +1,40 @@ -<?php
-
-# Czech language, encoding by ISO 8859-2 charset (Iso Latin-2)
-# For convert to MS Windows use shell command:
-# iconv -f ISO_8859-2 -t CP1250 < adodb-cz.inc.php
-# For convert to ASCII use shell command:
-# unaccent ISO_8859-2 < adodb-cz.inc.php
-# v1.0, 19.06.2003 Kamil Jakubovic <jake@host.sk>
-
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'cz',
- DB_ERROR => 'nezn醡 chyba',
- DB_ERROR_ALREADY_EXISTS => 'ji? existuje',
- DB_ERROR_CANNOT_CREATE => 'nelze vytvo?it',
- DB_ERROR_CANNOT_DELETE => 'nelze smazat',
- DB_ERROR_CANNOT_DROP => 'nelze odstranit',
- DB_ERROR_CONSTRAINT => 'poru?en omezuj韈 podm韓ky',
- DB_ERROR_DIVZERO => 'd?len nulou',
- DB_ERROR_INVALID => 'neplatn',
- DB_ERROR_INVALID_DATE => 'neplatn datum nebo ?as',
- DB_ERROR_INVALID_NUMBER => 'neplatn ?韘lo',
- DB_ERROR_MISMATCH => 'nesouhlas',
- DB_ERROR_NODBSELECTED => '?醖n datab醶e nen vybr醤a',
- DB_ERROR_NOSUCHFIELD => 'pole nenalezeno',
- DB_ERROR_NOSUCHTABLE => 'tabulka nenalezena',
- DB_ERROR_NOT_CAPABLE => 'nepodporov醤o',
- DB_ERROR_NOT_FOUND => 'nenalezeno',
- DB_ERROR_NOT_LOCKED => 'nezam?eno',
- DB_ERROR_SYNTAX => 'syntaktick chyba',
- DB_ERROR_UNSUPPORTED => 'nepodporov醤o',
- DB_ERROR_VALUE_COUNT_ON_ROW => '',
- DB_ERROR_INVALID_DSN => 'neplatn DSN',
- DB_ERROR_CONNECT_FAILED => 'p?ipojen selhalo',
- 0 => 'bez chyb', // DB_OK
- DB_ERROR_NEED_MORE_DATA => 'm醠o zdrojov齝h dat',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'roz??en nenalezeno',
- DB_ERROR_NOSUCHDB => 'datab醶e neexistuje',
- DB_ERROR_ACCESS_VIOLATION => 'nedostate?n pr醰a'
-);
+<?php + +# Czech language, encoding by ISO 8859-2 charset (Iso Latin-2) +# For convert to MS Windows use shell command: +# iconv -f ISO_8859-2 -t CP1250 < adodb-cz.inc.php +# For convert to ASCII use shell command: +# unaccent ISO_8859-2 < adodb-cz.inc.php +# v1.0, 19.06.2003 Kamil Jakubovic <jake@host.sk> + +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'cz', + DB_ERROR => 'nezn醡 chyba', + DB_ERROR_ALREADY_EXISTS => 'ji? existuje', + DB_ERROR_CANNOT_CREATE => 'nelze vytvo?it', + DB_ERROR_CANNOT_DELETE => 'nelze smazat', + DB_ERROR_CANNOT_DROP => 'nelze odstranit', + DB_ERROR_CONSTRAINT => 'poru?en omezuj韈 podm韓ky', + DB_ERROR_DIVZERO => 'd?len nulou', + DB_ERROR_INVALID => 'neplatn', + DB_ERROR_INVALID_DATE => 'neplatn datum nebo ?as', + DB_ERROR_INVALID_NUMBER => 'neplatn ?韘lo', + DB_ERROR_MISMATCH => 'nesouhlas', + DB_ERROR_NODBSELECTED => '?醖n datab醶e nen vybr醤a', + DB_ERROR_NOSUCHFIELD => 'pole nenalezeno', + DB_ERROR_NOSUCHTABLE => 'tabulka nenalezena', + DB_ERROR_NOT_CAPABLE => 'nepodporov醤o', + DB_ERROR_NOT_FOUND => 'nenalezeno', + DB_ERROR_NOT_LOCKED => 'nezam?eno', + DB_ERROR_SYNTAX => 'syntaktick chyba', + DB_ERROR_UNSUPPORTED => 'nepodporov醤o', + DB_ERROR_VALUE_COUNT_ON_ROW => '', + DB_ERROR_INVALID_DSN => 'neplatn DSN', + DB_ERROR_CONNECT_FAILED => 'p?ipojen selhalo', + 0 => 'bez chyb', // DB_OK + DB_ERROR_NEED_MORE_DATA => 'm醠o zdrojov齝h dat', + DB_ERROR_EXTENSION_NOT_FOUND=> 'roz??en nenalezeno', + DB_ERROR_NOSUCHDB => 'datab醶e neexistuje', + DB_ERROR_ACCESS_VIOLATION => 'nedostate?n pr醰a' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-de.inc.php b/trunk/adodb-for-php4/lang/adodb-de.inc.php index 244cb2f6..44c57e9f 100644 --- a/trunk/adodb-for-php4/lang/adodb-de.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-de.inc.php @@ -1,33 +1,33 @@ -<?php
-// contributed by "Heinz Hombergs" <opn@hhombergs.de>
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'de',
- DB_ERROR => 'Unbekannter Fehler',
- DB_ERROR_ALREADY_EXISTS => 'existiert bereits',
- DB_ERROR_CANNOT_CREATE => 'kann nicht erstellen',
- DB_ERROR_CANNOT_DELETE => 'kann nicht löschen',
- DB_ERROR_CANNOT_DROP => 'Tabelle oder Index konnte nicht gelöscht werden',
- DB_ERROR_CONSTRAINT => 'Constraint Verletzung',
- DB_ERROR_DIVZERO => 'Division durch Null',
- DB_ERROR_INVALID => 'ung¨ltig',
- DB_ERROR_INVALID_DATE => 'ung¨ltiges Datum oder Zeit',
- DB_ERROR_INVALID_NUMBER => 'ung¨ltige Zahl',
- DB_ERROR_MISMATCH => 'Unverträglichkeit',
- DB_ERROR_NODBSELECTED => 'keine Dantebank ausgewählt',
- DB_ERROR_NOSUCHFIELD => 'Feld nicht vorhanden',
- DB_ERROR_NOSUCHTABLE => 'Tabelle nicht vorhanden',
- DB_ERROR_NOT_CAPABLE => 'Funktion nicht installiert',
- DB_ERROR_NOT_FOUND => 'nicht gefunden',
- DB_ERROR_NOT_LOCKED => 'nicht gesperrt',
- DB_ERROR_SYNTAX => 'Syntaxfehler',
- DB_ERROR_UNSUPPORTED => 'nicht Unterst¨tzt',
- DB_ERROR_VALUE_COUNT_ON_ROW => 'Anzahl der zur¨ckgelieferten Felder entspricht nicht der Anzahl der Felder in der Abfrage',
- DB_ERROR_INVALID_DSN => 'ung¨ltiger DSN',
- DB_ERROR_CONNECT_FAILED => 'Verbindung konnte nicht hergestellt werden',
- 0 => 'kein Fehler', // DB_OK
- DB_ERROR_NEED_MORE_DATA => 'Nicht gen¨gend Daten geliefert',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'erweiterung nicht gefunden',
- DB_ERROR_NOSUCHDB => 'keine Datenbank',
- DB_ERROR_ACCESS_VIOLATION => 'ungen¨gende Rechte'
-);
+<?php +// contributed by "Heinz Hombergs" <opn@hhombergs.de> +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'de', + DB_ERROR => 'Unbekannter Fehler', + DB_ERROR_ALREADY_EXISTS => 'existiert bereits', + DB_ERROR_CANNOT_CREATE => 'kann nicht erstellen', + DB_ERROR_CANNOT_DELETE => 'kann nicht löschen', + DB_ERROR_CANNOT_DROP => 'Tabelle oder Index konnte nicht gelöscht werden', + DB_ERROR_CONSTRAINT => 'Constraint Verletzung', + DB_ERROR_DIVZERO => 'Division durch Null', + DB_ERROR_INVALID => 'ung¨ltig', + DB_ERROR_INVALID_DATE => 'ung¨ltiges Datum oder Zeit', + DB_ERROR_INVALID_NUMBER => 'ung¨ltige Zahl', + DB_ERROR_MISMATCH => 'Unverträglichkeit', + DB_ERROR_NODBSELECTED => 'keine Dantebank ausgewählt', + DB_ERROR_NOSUCHFIELD => 'Feld nicht vorhanden', + DB_ERROR_NOSUCHTABLE => 'Tabelle nicht vorhanden', + DB_ERROR_NOT_CAPABLE => 'Funktion nicht installiert', + DB_ERROR_NOT_FOUND => 'nicht gefunden', + DB_ERROR_NOT_LOCKED => 'nicht gesperrt', + DB_ERROR_SYNTAX => 'Syntaxfehler', + DB_ERROR_UNSUPPORTED => 'nicht Unterst¨tzt', + DB_ERROR_VALUE_COUNT_ON_ROW => 'Anzahl der zur¨ckgelieferten Felder entspricht nicht der Anzahl der Felder in der Abfrage', + DB_ERROR_INVALID_DSN => 'ung¨ltiger DSN', + DB_ERROR_CONNECT_FAILED => 'Verbindung konnte nicht hergestellt werden', + 0 => 'kein Fehler', // DB_OK + DB_ERROR_NEED_MORE_DATA => 'Nicht gen¨gend Daten geliefert', + DB_ERROR_EXTENSION_NOT_FOUND=> 'erweiterung nicht gefunden', + DB_ERROR_NOSUCHDB => 'keine Datenbank', + DB_ERROR_ACCESS_VIOLATION => 'ungen¨gende Rechte' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-fa.inc.php b/trunk/adodb-for-php4/lang/adodb-fa.inc.php index 55943135..a58a21cc 100644 --- a/trunk/adodb-for-php4/lang/adodb-fa.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-fa.inc.php @@ -1,35 +1,35 @@ -<?php
-
-/* Farsi - by "Peyman Hooshmandi Raad" <phooshmand#gmail.com> */
-
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'fa',
- DB_ERROR => '禺胤丕蹖 賳丕卮賳丕禺鬲賴',
- DB_ERROR_ALREADY_EXISTS => '賵噩賵丿 丿丕乇丿',
- DB_ERROR_CANNOT_CREATE => '丕賲讴丕賳 create 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_CANNOT_DELETE => '丕賲讴丕賳 丨匕賮 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_CANNOT_DROP => '丕賲讴丕賳 drop 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_CONSTRAINT => '賳賯囟 卮乇胤',
- DB_ERROR_DIVZERO => '鬲賯爻蹖賲 亘乇 氐賮乇',
- DB_ERROR_INVALID => '賳丕賲毓鬲亘乇',
- DB_ERROR_INVALID_DATE => '夭賲丕賳 蹖丕 鬲丕乇蹖禺 賳丕賲毓鬲亘乇',
- DB_ERROR_INVALID_NUMBER => '毓丿丿 賳丕賲毓鬲亘乇',
- DB_ERROR_MISMATCH => '毓丿賲 賲胤丕亘賯鬲',
- DB_ERROR_NODBSELECTED => '亘丕賳讴 丕胤賱丕毓丕鬲蹖 丕賳鬲禺丕亘 賳卮丿賴 丕爻鬲',
- DB_ERROR_NOSUCHFIELD => '趩賳蹖賳 爻鬲賵賳蹖 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_NOSUCHTABLE => '趩賳蹖賳 噩丿賵賱蹖 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_NOT_CAPABLE => 'backend 亘丕賳讴 丕胤賱丕毓丕鬲蹖 賯丕丿乇 賳蹖爻鬲',
- DB_ERROR_NOT_FOUND => '倬蹖丿丕 賳卮丿',
- DB_ERROR_NOT_LOCKED => '賯賮賱 賳卮丿賴',
- DB_ERROR_SYNTAX => '禺胤丕蹖 丿爻鬲賵乇蹖',
- DB_ERROR_UNSUPPORTED => '倬卮鬲蹖亘丕賳蹖 賳賲蹖 卮賵丿',
- DB_ERROR_VALUE_COUNT_ON_ROW => '卮賲丕乇卮 賲賯丕丿蹖乇 乇賵蹖 乇丿蹖賮',
- DB_ERROR_INVALID_DSN => 'DSN 賳丕賲毓鬲亘乇',
- DB_ERROR_CONNECT_FAILED => '丕乇鬲亘丕胤 亘乇賯乇丕乇 賳卮丿',
- 0 => '亘丿賵賳 禺胤丕', // DB_OK
- DB_ERROR_NEED_MORE_DATA => '丿丕丿賴 賳丕讴丕賮蹖 丕爻鬲',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'extension 倬蹖丿丕 賳卮丿',
- DB_ERROR_NOSUCHDB => '趩賳蹖賳 亘丕賳讴 丕胤賱丕毓丕鬲蹖 賵噩賵丿 賳丿丕乇丿',
- DB_ERROR_ACCESS_VIOLATION => '丨賯 丿爻鬲乇爻蹖 賳丕讴丕賮蹖'
-);
+<?php + +/* Farsi - by "Peyman Hooshmandi Raad" <phooshmand#gmail.com> */ + +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'fa', + DB_ERROR => '禺胤丕蹖 賳丕卮賳丕禺鬲賴', + DB_ERROR_ALREADY_EXISTS => '賵噩賵丿 丿丕乇丿', + DB_ERROR_CANNOT_CREATE => '丕賲讴丕賳 create 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_CANNOT_DELETE => '丕賲讴丕賳 丨匕賮 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_CANNOT_DROP => '丕賲讴丕賳 drop 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_CONSTRAINT => '賳賯囟 卮乇胤', + DB_ERROR_DIVZERO => '鬲賯爻蹖賲 亘乇 氐賮乇', + DB_ERROR_INVALID => '賳丕賲毓鬲亘乇', + DB_ERROR_INVALID_DATE => '夭賲丕賳 蹖丕 鬲丕乇蹖禺 賳丕賲毓鬲亘乇', + DB_ERROR_INVALID_NUMBER => '毓丿丿 賳丕賲毓鬲亘乇', + DB_ERROR_MISMATCH => '毓丿賲 賲胤丕亘賯鬲', + DB_ERROR_NODBSELECTED => '亘丕賳讴 丕胤賱丕毓丕鬲蹖 丕賳鬲禺丕亘 賳卮丿賴 丕爻鬲', + DB_ERROR_NOSUCHFIELD => '趩賳蹖賳 爻鬲賵賳蹖 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_NOSUCHTABLE => '趩賳蹖賳 噩丿賵賱蹖 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_NOT_CAPABLE => 'backend 亘丕賳讴 丕胤賱丕毓丕鬲蹖 賯丕丿乇 賳蹖爻鬲', + DB_ERROR_NOT_FOUND => '倬蹖丿丕 賳卮丿', + DB_ERROR_NOT_LOCKED => '賯賮賱 賳卮丿賴', + DB_ERROR_SYNTAX => '禺胤丕蹖 丿爻鬲賵乇蹖', + DB_ERROR_UNSUPPORTED => '倬卮鬲蹖亘丕賳蹖 賳賲蹖 卮賵丿', + DB_ERROR_VALUE_COUNT_ON_ROW => '卮賲丕乇卮 賲賯丕丿蹖乇 乇賵蹖 乇丿蹖賮', + DB_ERROR_INVALID_DSN => 'DSN 賳丕賲毓鬲亘乇', + DB_ERROR_CONNECT_FAILED => '丕乇鬲亘丕胤 亘乇賯乇丕乇 賳卮丿', + 0 => '亘丿賵賳 禺胤丕', // DB_OK + DB_ERROR_NEED_MORE_DATA => '丿丕丿賴 賳丕讴丕賮蹖 丕爻鬲', + DB_ERROR_EXTENSION_NOT_FOUND=> 'extension 倬蹖丿丕 賳卮丿', + DB_ERROR_NOSUCHDB => '趩賳蹖賳 亘丕賳讴 丕胤賱丕毓丕鬲蹖 賵噩賵丿 賳丿丕乇丿', + DB_ERROR_ACCESS_VIOLATION => '丨賯 丿爻鬲乇爻蹖 賳丕讴丕賮蹖' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-fr.inc.php b/trunk/adodb-for-php4/lang/adodb-fr.inc.php index 066a2a5e..11127cd6 100644 --- a/trunk/adodb-for-php4/lang/adodb-fr.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-fr.inc.php @@ -1,33 +1,33 @@ -<?php
-
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'fr',
- DB_ERROR => 'erreur inconnue',
- DB_ERROR_ALREADY_EXISTS => 'existe déjà',
- DB_ERROR_CANNOT_CREATE => 'crétion impossible',
- DB_ERROR_CANNOT_DELETE => 'effacement impossible',
- DB_ERROR_CANNOT_DROP => 'suppression impossible',
- DB_ERROR_CONSTRAINT => 'violation de contrainte',
- DB_ERROR_DIVZERO => 'division par zéro',
- DB_ERROR_INVALID => 'invalide',
- DB_ERROR_INVALID_DATE => 'date ou heure invalide',
- DB_ERROR_INVALID_NUMBER => 'nombre invalide',
- DB_ERROR_MISMATCH => 'erreur de concordance',
- DB_ERROR_NODBSELECTED => 'pas de base de donnéessélectionnée',
- DB_ERROR_NOSUCHFIELD => 'nom de colonne invalide',
- DB_ERROR_NOSUCHTABLE => 'table ou vue inexistante',
- DB_ERROR_NOT_CAPABLE => 'fonction optionnelle non installée',
- DB_ERROR_NOT_FOUND => 'pas trouvé',
- DB_ERROR_NOT_LOCKED => 'non verrouillé',
- DB_ERROR_SYNTAX => 'erreur de syntaxe',
- DB_ERROR_UNSUPPORTED => 'non supporté',
- DB_ERROR_VALUE_COUNT_ON_ROW => 'valeur insérée trop grande pour colonne',
- DB_ERROR_INVALID_DSN => 'DSN invalide',
- DB_ERROR_CONNECT_FAILED => 'échec à la connexion',
- 0 => "pas d'erreur", // DB_OK
- DB_ERROR_NEED_MORE_DATA => 'données fournies insuffisantes',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'extension non trouvée',
- DB_ERROR_NOSUCHDB => 'base de données inconnue',
- DB_ERROR_ACCESS_VIOLATION => 'droits insuffisants'
-);
+<?php + +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'fr', + DB_ERROR => 'erreur inconnue', + DB_ERROR_ALREADY_EXISTS => 'existe déjà', + DB_ERROR_CANNOT_CREATE => 'crétion impossible', + DB_ERROR_CANNOT_DELETE => 'effacement impossible', + DB_ERROR_CANNOT_DROP => 'suppression impossible', + DB_ERROR_CONSTRAINT => 'violation de contrainte', + DB_ERROR_DIVZERO => 'division par zéro', + DB_ERROR_INVALID => 'invalide', + DB_ERROR_INVALID_DATE => 'date ou heure invalide', + DB_ERROR_INVALID_NUMBER => 'nombre invalide', + DB_ERROR_MISMATCH => 'erreur de concordance', + DB_ERROR_NODBSELECTED => 'pas de base de donnéessélectionnée', + DB_ERROR_NOSUCHFIELD => 'nom de colonne invalide', + DB_ERROR_NOSUCHTABLE => 'table ou vue inexistante', + DB_ERROR_NOT_CAPABLE => 'fonction optionnelle non installée', + DB_ERROR_NOT_FOUND => 'pas trouvé', + DB_ERROR_NOT_LOCKED => 'non verrouillé', + DB_ERROR_SYNTAX => 'erreur de syntaxe', + DB_ERROR_UNSUPPORTED => 'non supporté', + DB_ERROR_VALUE_COUNT_ON_ROW => 'valeur insérée trop grande pour colonne', + DB_ERROR_INVALID_DSN => 'DSN invalide', + DB_ERROR_CONNECT_FAILED => 'échec à la connexion', + 0 => "pas d'erreur", // DB_OK + DB_ERROR_NEED_MORE_DATA => 'données fournies insuffisantes', + DB_ERROR_EXTENSION_NOT_FOUND=> 'extension non trouvée', + DB_ERROR_NOSUCHDB => 'base de données inconnue', + DB_ERROR_ACCESS_VIOLATION => 'droits insuffisants' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-it.inc.php b/trunk/adodb-for-php4/lang/adodb-it.inc.php index 20c5b93b..ac5cc5a7 100644 --- a/trunk/adodb-for-php4/lang/adodb-it.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-it.inc.php @@ -1,34 +1,34 @@ -<?php
-// Italian language file contributed by Tiraboschi Massimiliano aka TiMax
-// www.maxdev.com timax@maxdev.com
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'it',
- DB_ERROR => 'errore sconosciuto',
- DB_ERROR_ALREADY_EXISTS => 'esiste già',
- DB_ERROR_CANNOT_CREATE => 'non posso creare',
- DB_ERROR_CANNOT_DELETE => 'non posso cancellare',
- DB_ERROR_CANNOT_DROP => 'non posso eliminare',
- DB_ERROR_CONSTRAINT => 'violazione constraint',
- DB_ERROR_DIVZERO => 'divisione per zero',
- DB_ERROR_INVALID => 'non valido',
- DB_ERROR_INVALID_DATE => 'data od ora non valida',
- DB_ERROR_INVALID_NUMBER => 'numero non valido',
- DB_ERROR_MISMATCH => 'diversi',
- DB_ERROR_NODBSELECTED => 'nessun database selezionato',
- DB_ERROR_NOSUCHFIELD => 'nessun campo trovato',
- DB_ERROR_NOSUCHTABLE => 'nessuna tabella trovata',
- DB_ERROR_NOT_CAPABLE => 'DB backend non abilitato',
- DB_ERROR_NOT_FOUND => 'non trovato',
- DB_ERROR_NOT_LOCKED => 'non bloccato',
- DB_ERROR_SYNTAX => 'errore di sintassi',
- DB_ERROR_UNSUPPORTED => 'non supportato',
- DB_ERROR_VALUE_COUNT_ON_ROW => 'valore inserito troppo grande per una colonna',
- DB_ERROR_INVALID_DSN => 'DSN non valido',
- DB_ERROR_CONNECT_FAILED => 'connessione fallita',
- 0 => 'nessun errore', // DB_OK
- DB_ERROR_NEED_MORE_DATA => 'dati inseriti insufficienti',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'estensione non trovata',
- DB_ERROR_NOSUCHDB => 'database non trovato',
- DB_ERROR_ACCESS_VIOLATION => 'permessi insufficienti'
-);
+<?php +// Italian language file contributed by Tiraboschi Massimiliano aka TiMax +// www.maxdev.com timax@maxdev.com +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'it', + DB_ERROR => 'errore sconosciuto', + DB_ERROR_ALREADY_EXISTS => 'esiste già', + DB_ERROR_CANNOT_CREATE => 'non posso creare', + DB_ERROR_CANNOT_DELETE => 'non posso cancellare', + DB_ERROR_CANNOT_DROP => 'non posso eliminare', + DB_ERROR_CONSTRAINT => 'violazione constraint', + DB_ERROR_DIVZERO => 'divisione per zero', + DB_ERROR_INVALID => 'non valido', + DB_ERROR_INVALID_DATE => 'data od ora non valida', + DB_ERROR_INVALID_NUMBER => 'numero non valido', + DB_ERROR_MISMATCH => 'diversi', + DB_ERROR_NODBSELECTED => 'nessun database selezionato', + DB_ERROR_NOSUCHFIELD => 'nessun campo trovato', + DB_ERROR_NOSUCHTABLE => 'nessuna tabella trovata', + DB_ERROR_NOT_CAPABLE => 'DB backend non abilitato', + DB_ERROR_NOT_FOUND => 'non trovato', + DB_ERROR_NOT_LOCKED => 'non bloccato', + DB_ERROR_SYNTAX => 'errore di sintassi', + DB_ERROR_UNSUPPORTED => 'non supportato', + DB_ERROR_VALUE_COUNT_ON_ROW => 'valore inserito troppo grande per una colonna', + DB_ERROR_INVALID_DSN => 'DSN non valido', + DB_ERROR_CONNECT_FAILED => 'connessione fallita', + 0 => 'nessun errore', // DB_OK + DB_ERROR_NEED_MORE_DATA => 'dati inseriti insufficienti', + DB_ERROR_EXTENSION_NOT_FOUND=> 'estensione non trovata', + DB_ERROR_NOSUCHDB => 'database non trovato', + DB_ERROR_ACCESS_VIOLATION => 'permessi insufficienti' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-ru1251.inc.php b/trunk/adodb-for-php4/lang/adodb-ru1251.inc.php index 3a20538a..e273f427 100644 --- a/trunk/adodb-for-php4/lang/adodb-ru1251.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-ru1251.inc.php @@ -1,35 +1,35 @@ -<?php
-
-// Russian language file contributed by "Cyrill Malevanov" cyrill#malevanov.spb.ru.
-
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'ru1251',
- DB_ERROR => '礤桤忮耱磬 铠栳赅',
- DB_ERROR_ALREADY_EXISTS => '箧 耋耱怏弪',
- DB_ERROR_CANNOT_CREATE => '礤忸珈铈眍 耦玟囹',
- DB_ERROR_CANNOT_DELETE => '礤忸珈铈眍 箐嚯栩',
- DB_ERROR_CANNOT_DROP => '礤忸珈铈眍 箐嚯栩 (drop)',
- DB_ERROR_CONSTRAINT => '磬痼龛 篑腩忤 镳钼屦觇',
- DB_ERROR_DIVZERO => '溴脲龛 磬 0',
- DB_ERROR_INVALID => '礤镳噔桦',
- DB_ERROR_INVALID_DATE => '礤觐痧尻蝽 溧蜞 桦 怵屐',
- DB_ERROR_INVALID_NUMBER => '礤觐痧尻蝽铄 麒耠',
- DB_ERROR_MISMATCH => '铠栳赅',
- DB_ERROR_NODBSELECTED => '聊 礤 恹狃囗',
- DB_ERROR_NOSUCHFIELD => '礤 耋耱怏弪 镱脲',
- DB_ERROR_NOSUCHTABLE => '礤 耋耱怏弪 蜞犭桷',
- DB_ERROR_NOT_CAPABLE => '延聊 礤 耦耱龛',
- DB_ERROR_NOT_FOUND => '礤 磬殇屙',
- DB_ERROR_NOT_LOCKED => '礤 玎犭铌桊钼囗',
- DB_ERROR_SYNTAX => '耔眚嚓耔麇耜 铠栳赅',
- DB_ERROR_UNSUPPORTED => '礤 镱滗屦骅忄弪',
- DB_ERROR_VALUE_COUNT_ON_ROW => '聍弪麒 珥圜屙栝 耱痤赍',
- DB_ERROR_INVALID_DSN => '礤镳噔桦 DSN',
- DB_ERROR_CONNECT_FAILED => '耦邃桧屙桢 礤篑镥',
- 0 => '礤 铠栳觇', // DB_OK
- DB_ERROR_NEED_MORE_DATA => '镳邃铖蜞怆屙 礤漕耱囹铟眍 溧眄',
- DB_ERROR_EXTENSION_NOT_FOUND=> '疣聒桊屙桢 礤 磬殇屙',
- DB_ERROR_NOSUCHDB => '礤 耋耱怏弪 聊',
- DB_ERROR_ACCESS_VIOLATION => '礤漕耱囹铟眍 镳噔 漕耱箫'
-);
+<?php + +// Russian language file contributed by "Cyrill Malevanov" cyrill#malevanov.spb.ru. + +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'ru1251', + DB_ERROR => '礤桤忮耱磬 铠栳赅', + DB_ERROR_ALREADY_EXISTS => '箧 耋耱怏弪', + DB_ERROR_CANNOT_CREATE => '礤忸珈铈眍 耦玟囹', + DB_ERROR_CANNOT_DELETE => '礤忸珈铈眍 箐嚯栩', + DB_ERROR_CANNOT_DROP => '礤忸珈铈眍 箐嚯栩 (drop)', + DB_ERROR_CONSTRAINT => '磬痼龛 篑腩忤 镳钼屦觇', + DB_ERROR_DIVZERO => '溴脲龛 磬 0', + DB_ERROR_INVALID => '礤镳噔桦', + DB_ERROR_INVALID_DATE => '礤觐痧尻蝽 溧蜞 桦 怵屐', + DB_ERROR_INVALID_NUMBER => '礤觐痧尻蝽铄 麒耠', + DB_ERROR_MISMATCH => '铠栳赅', + DB_ERROR_NODBSELECTED => '聊 礤 恹狃囗', + DB_ERROR_NOSUCHFIELD => '礤 耋耱怏弪 镱脲', + DB_ERROR_NOSUCHTABLE => '礤 耋耱怏弪 蜞犭桷', + DB_ERROR_NOT_CAPABLE => '延聊 礤 耦耱龛', + DB_ERROR_NOT_FOUND => '礤 磬殇屙', + DB_ERROR_NOT_LOCKED => '礤 玎犭铌桊钼囗', + DB_ERROR_SYNTAX => '耔眚嚓耔麇耜 铠栳赅', + DB_ERROR_UNSUPPORTED => '礤 镱滗屦骅忄弪', + DB_ERROR_VALUE_COUNT_ON_ROW => '聍弪麒 珥圜屙栝 耱痤赍', + DB_ERROR_INVALID_DSN => '礤镳噔桦 DSN', + DB_ERROR_CONNECT_FAILED => '耦邃桧屙桢 礤篑镥', + 0 => '礤 铠栳觇', // DB_OK + DB_ERROR_NEED_MORE_DATA => '镳邃铖蜞怆屙 礤漕耱囹铟眍 溧眄', + DB_ERROR_EXTENSION_NOT_FOUND=> '疣聒桊屙桢 礤 磬殇屙', + DB_ERROR_NOSUCHDB => '礤 耋耱怏弪 聊', + DB_ERROR_ACCESS_VIOLATION => '礤漕耱囹铟眍 镳噔 漕耱箫' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/lang/adodb-sv.inc.php b/trunk/adodb-for-php4/lang/adodb-sv.inc.php index a9fd6981..64a5b4bb 100644 --- a/trunk/adodb-for-php4/lang/adodb-sv.inc.php +++ b/trunk/adodb-for-php4/lang/adodb-sv.inc.php @@ -1,33 +1,33 @@ -<?php
-// Christian Tiberg" christian@commsoft.nu
-$ADODB_LANG_ARRAY = array (
- 'LANG' => 'en',
- DB_ERROR => 'Ok鋘t fel',
- DB_ERROR_ALREADY_EXISTS => 'finns redan',
- DB_ERROR_CANNOT_CREATE => 'kan inte skapa',
- DB_ERROR_CANNOT_DELETE => 'kan inte ta bort',
- DB_ERROR_CANNOT_DROP => 'kan inte sl鋚pa',
- DB_ERROR_CONSTRAINT => 'begr鋘sning kr鋘kt',
- DB_ERROR_DIVZERO => 'division med noll',
- DB_ERROR_INVALID => 'ogiltig',
- DB_ERROR_INVALID_DATE => 'ogiltigt datum eller tid',
- DB_ERROR_INVALID_NUMBER => 'ogiltigt tal',
- DB_ERROR_MISMATCH => 'felaktig matchning',
- DB_ERROR_NODBSELECTED => 'ingen databas vald',
- DB_ERROR_NOSUCHFIELD => 'inget s錮ant f鋖t',
- DB_ERROR_NOSUCHTABLE => 'ingen s錮an tabell',
- DB_ERROR_NOT_CAPABLE => 'DB backend klarar det inte',
- DB_ERROR_NOT_FOUND => 'finns inte',
- DB_ERROR_NOT_LOCKED => 'inte l錽t',
- DB_ERROR_SYNTAX => 'syntaxfel',
- DB_ERROR_UNSUPPORTED => 'st鰀s ej',
- DB_ERROR_VALUE_COUNT_ON_ROW => 'v鋜de r鋕nat p rad',
- DB_ERROR_INVALID_DSN => 'ogiltig DSN',
- DB_ERROR_CONNECT_FAILED => 'anslutning misslyckades',
- 0 => 'inget fel', // DB_OK
- DB_ERROR_NEED_MORE_DATA => 'otillr鋍kligt med data angivet',
- DB_ERROR_EXTENSION_NOT_FOUND=> 'ut鰇ning hittades ej',
- DB_ERROR_NOSUCHDB => 'ingen s錮an databas',
- DB_ERROR_ACCESS_VIOLATION => 'otillr鋍kliga r鋞tigheter'
-);
+<?php +// Christian Tiberg" christian@commsoft.nu +$ADODB_LANG_ARRAY = array ( + 'LANG' => 'en', + DB_ERROR => 'Ok鋘t fel', + DB_ERROR_ALREADY_EXISTS => 'finns redan', + DB_ERROR_CANNOT_CREATE => 'kan inte skapa', + DB_ERROR_CANNOT_DELETE => 'kan inte ta bort', + DB_ERROR_CANNOT_DROP => 'kan inte sl鋚pa', + DB_ERROR_CONSTRAINT => 'begr鋘sning kr鋘kt', + DB_ERROR_DIVZERO => 'division med noll', + DB_ERROR_INVALID => 'ogiltig', + DB_ERROR_INVALID_DATE => 'ogiltigt datum eller tid', + DB_ERROR_INVALID_NUMBER => 'ogiltigt tal', + DB_ERROR_MISMATCH => 'felaktig matchning', + DB_ERROR_NODBSELECTED => 'ingen databas vald', + DB_ERROR_NOSUCHFIELD => 'inget s錮ant f鋖t', + DB_ERROR_NOSUCHTABLE => 'ingen s錮an tabell', + DB_ERROR_NOT_CAPABLE => 'DB backend klarar det inte', + DB_ERROR_NOT_FOUND => 'finns inte', + DB_ERROR_NOT_LOCKED => 'inte l錽t', + DB_ERROR_SYNTAX => 'syntaxfel', + DB_ERROR_UNSUPPORTED => 'st鰀s ej', + DB_ERROR_VALUE_COUNT_ON_ROW => 'v鋜de r鋕nat p rad', + DB_ERROR_INVALID_DSN => 'ogiltig DSN', + DB_ERROR_CONNECT_FAILED => 'anslutning misslyckades', + 0 => 'inget fel', // DB_OK + DB_ERROR_NEED_MORE_DATA => 'otillr鋍kligt med data angivet', + DB_ERROR_EXTENSION_NOT_FOUND=> 'ut鰇ning hittades ej', + DB_ERROR_NOSUCHDB => 'ingen s錮an databas', + DB_ERROR_ACCESS_VIOLATION => 'otillr鋍kliga r鋞tigheter' +); ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/license.txt b/trunk/adodb-for-php4/license.txt index 2353871c..9821fcb7 100644 --- a/trunk/adodb-for-php4/license.txt +++ b/trunk/adodb-for-php4/license.txt @@ -1,182 +1,182 @@ -ADOdb is dual licensed using BSD and LGPL.
-
-In plain English, you do not need to distribute your application in source code form, nor do you need to distribute ADOdb source code, provided you follow the rest of terms of the BSD license.
-
-For more info about ADOdb, visit http://adodb.sourceforge.net/
-
-BSD Style-License
-=================
-
-Copyright (c) 2000, 2001, 2002, 2003, 2004 John Lim
-All rights reserved.
-
-Redistribution and use in source and binary forms, with or without modification,
-are permitted provided that the following conditions are met:
-
-Redistributions of source code must retain the above copyright notice, this list
-of conditions and the following disclaimer.
-
-Redistributions in binary form must reproduce the above copyright notice, this list
-of conditions and the following disclaimer in the documentation and/or other materials
-provided with the distribution.
-
-Neither the name of the John Lim nor the names of its contributors may be used to
-endorse or promote products derived from this software without specific prior written
-permission.
-
-DISCLAIMER:
-THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
-EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
-MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
-JOHN LIM OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
-EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
-SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
-HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
-OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
-SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
-
-==========================================================
-GNU LESSER GENERAL PUBLIC LICENSE
-Version 2.1, February 1999
-
-Copyright (C) 1991, 1999 Free Software Foundation, Inc.
-59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-Everyone is permitted to copy and distribute verbatim copies
-of this license document, but changing it is not allowed.
-
-[This is the first released version of the Lesser GPL. It also counts
- as the successor of the GNU Library Public License, version 2, hence
- the version number 2.1.]
-
-
-Preamble
-The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public Licenses are intended to guarantee your freedom to share and change free software--to make sure the software is free for all its users.
-
-This license, the Lesser General Public License, applies to some specially designated software packages--typically libraries--of the Free Software Foundation and other authors who decide to use it. You can use it too, but we suggest you first think carefully about whether this license or the ordinary General Public License is the better strategy to use in any particular case, based on the explanations below.
-
-When we speak of free software, we are referring to freedom of use, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish); that you receive source code or can get it if you want it; that you can change the software and use pieces of it in new free programs; and that you are informed that you can do these things.
-
-To protect your rights, we need to make restrictions that forbid distributors to deny you these rights or to ask you to surrender these rights. These restrictions translate to certain responsibilities for you if you distribute copies of the library or if you modify it.
-
-For example, if you distribute copies of the library, whether gratis or for a fee, you must give the recipients all the rights that we gave you. You must make sure that they, too, receive or can get the source code. If you link other code with the library, you must provide complete object files to the recipients, so that they can relink them with the library after making changes to the library and recompiling it. And you must show them these terms so they know their rights.
-
-We protect your rights with a two-step method: (1) we copyright the library, and (2) we offer you this license, which gives you legal permission to copy, distribute and/or modify the library.
-
-To protect each distributor, we want to make it very clear that there is no warranty for the free library. Also, if the library is modified by someone else and passed on, the recipients should know that what they have is not the original version, so that the original author's reputation will not be affected by problems that might be introduced by others.
-
-Finally, software patents pose a constant threat to the existence of any free program. We wish to make sure that a company cannot effectively restrict the users of a free program by obtaining a restrictive license from a patent holder. Therefore, we insist that any patent license obtained for a version of the library must be consistent with the full freedom of use specified in this license.
-
-Most GNU software, including some libraries, is covered by the ordinary GNU General Public License. This license, the GNU Lesser General Public License, applies to certain designated libraries, and is quite different from the ordinary General Public License. We use this license for certain libraries in order to permit linking those libraries into non-free programs.
-
-When a program is linked with a library, whether statically or using a shared library, the combination of the two is legally speaking a combined work, a derivative of the original library. The ordinary General Public License therefore permits such linking only if the entire combination fits its criteria of freedom. The Lesser General Public License permits more lax criteria for linking other code with the library.
-
-We call this license the "Lesser" General Public License because it does Less to protect the user's freedom than the ordinary General Public License. It also provides other free software developers Less of an advantage over competing non-free programs. These disadvantages are the reason we use the ordinary General Public License for many libraries. However, the Lesser license provides advantages in certain special circumstances.
-
-For example, on rare occasions, there may be a special need to encourage the widest possible use of a certain library, so that it becomes a de-facto standard. To achieve this, non-free programs must be allowed to use the library. A more frequent case is that a free library does the same job as widely used non-free libraries. In this case, there is little to gain by limiting the free library to free software only, so we use the Lesser General Public License.
-
-In other cases, permission to use a particular library in non-free programs enables a greater number of people to use a large body of free software. For example, permission to use the GNU C Library in non-free programs enables many more people to use the whole GNU operating system, as well as its variant, the GNU/Linux operating system.
-
-Although the Lesser General Public License is Less protective of the users' freedom, it does ensure that the user of a program that is linked with the Library has the freedom and the wherewithal to run that program using a modified version of the Library.
-
-The precise terms and conditions for copying, distribution and modification follow. Pay close attention to the difference between a "work based on the library" and a "work that uses the library". The former contains code derived from the library, whereas the latter must be combined with the library in order to run.
-
-
-TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
-0. This License Agreement applies to any software library or other program which contains a notice placed by the copyright holder or other authorized party saying it may be distributed under the terms of this Lesser General Public License (also called "this License"). Each licensee is addressed as "you".
-
-A "library" means a collection of software functions and/or data prepared so as to be conveniently linked with application programs (which use some of those functions and data) to form executables.
-
-The "Library", below, refers to any such software library or work which has been distributed under these terms. A "work based on the Library" means either the Library or any derivative work under copyright law: that is to say, a work containing the Library or a portion of it, either verbatim or with modifications and/or translated straightforwardly into another language. (Hereinafter, translation is included without limitation in the term "modification".)
-
-"Source code" for a work means the preferred form of the work for making modifications to it. For a library, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the library.
-
-Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running a program using the Library is not restricted, and output from such a program is covered only if its contents constitute a work based on the Library (independent of the use of the Library in a tool for writing it). Whether that is true depends on what the Library does and what the program that uses the Library does.
-
-1. You may copy and distribute verbatim copies of the Library's complete source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and distribute a copy of this License along with the Library.
-
-You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee.
-
-2. You may modify your copy or copies of the Library or any portion of it, thus forming a work based on the Library, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions:
-
-
-a) The modified work must itself be a software library.
-b) You must cause the files modified to carry prominent notices stating that you changed the files and the date of any change.
-c) You must cause the whole of the work to be licensed at no charge to all third parties under the terms of this License.
-d) If a facility in the modified Library refers to a function or a table of data to be supplied by an application program that uses the facility, other than as an argument passed when the facility is invoked, then you must make a good faith effort to ensure that, in the event an application does not supply such function or table, the facility still operates, and performs whatever part of its purpose remains meaningful.
-(For example, a function in a library to compute square roots has a purpose that is entirely well-defined independent of the application. Therefore, Subsection 2d requires that any application-supplied function or table used by this function must be optional: if the application does not supply it, the square root function must still compute square roots.)
-
-These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Library, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Library, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it.
-
-Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Library.
-
-In addition, mere aggregation of another work not based on the Library with the Library (or with a work based on the Library) on a volume of a storage or distribution medium does not bring the other work under the scope of this License.
-
-3. You may opt to apply the terms of the ordinary GNU General Public License instead of this License to a given copy of the Library. To do this, you must alter all the notices that refer to this License, so that they refer to the ordinary GNU General Public License, version 2, instead of to this License. (If a newer version than version 2 of the ordinary GNU General Public License has appeared, then you can specify that version instead if you wish.) Do not make any other change in these notices.
-
-Once this change is made in a given copy, it is irreversible for that copy, so the ordinary GNU General Public License applies to all subsequent copies and derivative works made from that copy.
-
-This option is useful when you wish to copy part of the code of the Library into a program that is not a library.
-
-4. You may copy and distribute the Library (or a portion or derivative of it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange.
-
-If distribution of object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place satisfies the requirement to distribute the source code, even though third parties are not compelled to copy the source along with the object code.
-
-5. A program that contains no derivative of any portion of the Library, but is designed to work with the Library by being compiled or linked with it, is called a "work that uses the Library". Such a work, in isolation, is not a derivative work of the Library, and therefore falls outside the scope of this License.
-
-However, linking a "work that uses the Library" with the Library creates an executable that is a derivative of the Library (because it contains portions of the Library), rather than a "work that uses the library". The executable is therefore covered by this License. Section 6 states terms for distribution of such executables.
-
-When a "work that uses the Library" uses material from a header file that is part of the Library, the object code for the work may be a derivative work of the Library even though the source code is not. Whether this is true is especially significant if the work can be linked without the Library, or if the work is itself a library. The threshold for this to be true is not precisely defined by law.
-
-If such an object file uses only numerical parameters, data structure layouts and accessors, and small macros and small inline functions (ten lines or less in length), then the use of the object file is unrestricted, regardless of whether it is legally a derivative work. (Executables containing this object code plus portions of the Library will still fall under Section 6.)
-
-Otherwise, if the work is a derivative of the Library, you may distribute the object code for the work under the terms of Section 6. Any executables containing that work also fall under Section 6, whether or not they are linked directly with the Library itself.
-
-6. As an exception to the Sections above, you may also combine or link a "work that uses the Library" with the Library to produce a work containing portions of the Library, and distribute that work under terms of your choice, provided that the terms permit modification of the work for the customer's own use and reverse engineering for debugging such modifications.
-
-You must give prominent notice with each copy of the work that the Library is used in it and that the Library and its use are covered by this License. You must supply a copy of this License. If the work during execution displays copyright notices, you must include the copyright notice for the Library among them, as well as a reference directing the user to the copy of this License. Also, you must do one of these things:
-
-
-a) Accompany the work with the complete corresponding machine-readable source code for the Library including whatever changes were used in the work (which must be distributed under Sections 1 and 2 above); and, if the work is an executable linked with the Library, with the complete machine-readable "work that uses the Library", as object code and/or source code, so that the user can modify the Library and then relink to produce a modified executable containing the modified Library. (It is understood that the user who changes the contents of definitions files in the Library will not necessarily be able to recompile the application to use the modified definitions.)
-b) Use a suitable shared library mechanism for linking with the Library. A suitable mechanism is one that (1) uses at run time a copy of the library already present on the user's computer system, rather than copying library functions into the executable, and (2) will operate properly with a modified version of the library, if the user installs one, as long as the modified version is interface-compatible with the version that the work was made with.
-c) Accompany the work with a written offer, valid for at least three years, to give the same user the materials specified in Subsection 6a, above, for a charge no more than the cost of performing this distribution.
-d) If distribution of the work is made by offering access to copy from a designated place, offer equivalent access to copy the above specified materials from the same place.
-e) Verify that the user has already received a copy of these materials or that you have already sent this user a copy.
-For an executable, the required form of the "work that uses the Library" must include any data and utility programs needed for reproducing the executable from it. However, as a special exception, the materials to be distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable.
-
-It may happen that this requirement contradicts the license restrictions of other proprietary libraries that do not normally accompany the operating system. Such a contradiction means you cannot use both them and the Library together in an executable that you distribute.
-
-7. You may place library facilities that are a work based on the Library side-by-side in a single library together with other library facilities not covered by this License, and distribute such a combined library, provided that the separate distribution of the work based on the Library and of the other library facilities is otherwise permitted, and provided that you do these two things:
-
-
-a) Accompany the combined library with a copy of the same work based on the Library, uncombined with any other library facilities. This must be distributed under the terms of the Sections above.
-b) Give prominent notice with the combined library of the fact that part of it is a work based on the Library, and explaining where to find the accompanying uncombined form of the same work.
-8. You may not copy, modify, sublicense, link with, or distribute the Library except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense, link with, or distribute the Library is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance.
-
-9. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Library or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Library (or any work based on the Library), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Library or works based on it.
-
-10. Each time you redistribute the Library (or any work based on the Library), the recipient automatically receives a license from the original licensor to copy, distribute, link with or modify the Library subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties with this License.
-
-11. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Library at all. For example, if a patent license would not permit royalty-free redistribution of the Library by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to refrain entirely from distribution of the Library.
-
-If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply, and the section as a whole is intended to apply in other circumstances.
-
-It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice.
-
-This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License.
-
-12. If the distribution and/or use of the Library is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Library under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License.
-
-13. The Free Software Foundation may publish revised and/or new versions of the Lesser General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns.
-
-Each version is given a distinguishing version number. If the Library specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Library does not specify a license version number, you may choose any version ever published by the Free Software Foundation.
-
-14. If you wish to incorporate parts of the Library into other free programs whose distribution conditions are incompatible with these, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally.
-
-NO WARRANTY
-
-15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
-
-16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
-
-
+ADOdb is dual licensed using BSD and LGPL. + +In plain English, you do not need to distribute your application in source code form, nor do you need to distribute ADOdb source code, provided you follow the rest of terms of the BSD license. + +For more info about ADOdb, visit http://adodb.sourceforge.net/ + +BSD Style-License +================= + +Copyright (c) 2000, 2001, 2002, 2003, 2004 John Lim +All rights reserved. + +Redistribution and use in source and binary forms, with or without modification, +are permitted provided that the following conditions are met: + +Redistributions of source code must retain the above copyright notice, this list +of conditions and the following disclaimer. + +Redistributions in binary form must reproduce the above copyright notice, this list +of conditions and the following disclaimer in the documentation and/or other materials +provided with the distribution. + +Neither the name of the John Lim nor the names of its contributors may be used to +endorse or promote products derived from this software without specific prior written +permission. + +DISCLAIMER: +THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY +EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF +MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL +JOHN LIM OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, +EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF +SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) +HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, +OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS +SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. + +========================================================== +GNU LESSER GENERAL PUBLIC LICENSE +Version 2.1, February 1999 + +Copyright (C) 1991, 1999 Free Software Foundation, Inc. +59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +Everyone is permitted to copy and distribute verbatim copies +of this license document, but changing it is not allowed. + +[This is the first released version of the Lesser GPL. It also counts + as the successor of the GNU Library Public License, version 2, hence + the version number 2.1.] + + +Preamble +The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public Licenses are intended to guarantee your freedom to share and change free software--to make sure the software is free for all its users. + +This license, the Lesser General Public License, applies to some specially designated software packages--typically libraries--of the Free Software Foundation and other authors who decide to use it. You can use it too, but we suggest you first think carefully about whether this license or the ordinary General Public License is the better strategy to use in any particular case, based on the explanations below. + +When we speak of free software, we are referring to freedom of use, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish); that you receive source code or can get it if you want it; that you can change the software and use pieces of it in new free programs; and that you are informed that you can do these things. + +To protect your rights, we need to make restrictions that forbid distributors to deny you these rights or to ask you to surrender these rights. These restrictions translate to certain responsibilities for you if you distribute copies of the library or if you modify it. + +For example, if you distribute copies of the library, whether gratis or for a fee, you must give the recipients all the rights that we gave you. You must make sure that they, too, receive or can get the source code. If you link other code with the library, you must provide complete object files to the recipients, so that they can relink them with the library after making changes to the library and recompiling it. And you must show them these terms so they know their rights. + +We protect your rights with a two-step method: (1) we copyright the library, and (2) we offer you this license, which gives you legal permission to copy, distribute and/or modify the library. + +To protect each distributor, we want to make it very clear that there is no warranty for the free library. Also, if the library is modified by someone else and passed on, the recipients should know that what they have is not the original version, so that the original author's reputation will not be affected by problems that might be introduced by others. + +Finally, software patents pose a constant threat to the existence of any free program. We wish to make sure that a company cannot effectively restrict the users of a free program by obtaining a restrictive license from a patent holder. Therefore, we insist that any patent license obtained for a version of the library must be consistent with the full freedom of use specified in this license. + +Most GNU software, including some libraries, is covered by the ordinary GNU General Public License. This license, the GNU Lesser General Public License, applies to certain designated libraries, and is quite different from the ordinary General Public License. We use this license for certain libraries in order to permit linking those libraries into non-free programs. + +When a program is linked with a library, whether statically or using a shared library, the combination of the two is legally speaking a combined work, a derivative of the original library. The ordinary General Public License therefore permits such linking only if the entire combination fits its criteria of freedom. The Lesser General Public License permits more lax criteria for linking other code with the library. + +We call this license the "Lesser" General Public License because it does Less to protect the user's freedom than the ordinary General Public License. It also provides other free software developers Less of an advantage over competing non-free programs. These disadvantages are the reason we use the ordinary General Public License for many libraries. However, the Lesser license provides advantages in certain special circumstances. + +For example, on rare occasions, there may be a special need to encourage the widest possible use of a certain library, so that it becomes a de-facto standard. To achieve this, non-free programs must be allowed to use the library. A more frequent case is that a free library does the same job as widely used non-free libraries. In this case, there is little to gain by limiting the free library to free software only, so we use the Lesser General Public License. + +In other cases, permission to use a particular library in non-free programs enables a greater number of people to use a large body of free software. For example, permission to use the GNU C Library in non-free programs enables many more people to use the whole GNU operating system, as well as its variant, the GNU/Linux operating system. + +Although the Lesser General Public License is Less protective of the users' freedom, it does ensure that the user of a program that is linked with the Library has the freedom and the wherewithal to run that program using a modified version of the Library. + +The precise terms and conditions for copying, distribution and modification follow. Pay close attention to the difference between a "work based on the library" and a "work that uses the library". The former contains code derived from the library, whereas the latter must be combined with the library in order to run. + + +TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION +0. This License Agreement applies to any software library or other program which contains a notice placed by the copyright holder or other authorized party saying it may be distributed under the terms of this Lesser General Public License (also called "this License"). Each licensee is addressed as "you". + +A "library" means a collection of software functions and/or data prepared so as to be conveniently linked with application programs (which use some of those functions and data) to form executables. + +The "Library", below, refers to any such software library or work which has been distributed under these terms. A "work based on the Library" means either the Library or any derivative work under copyright law: that is to say, a work containing the Library or a portion of it, either verbatim or with modifications and/or translated straightforwardly into another language. (Hereinafter, translation is included without limitation in the term "modification".) + +"Source code" for a work means the preferred form of the work for making modifications to it. For a library, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the library. + +Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running a program using the Library is not restricted, and output from such a program is covered only if its contents constitute a work based on the Library (independent of the use of the Library in a tool for writing it). Whether that is true depends on what the Library does and what the program that uses the Library does. + +1. You may copy and distribute verbatim copies of the Library's complete source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and distribute a copy of this License along with the Library. + +You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee. + +2. You may modify your copy or copies of the Library or any portion of it, thus forming a work based on the Library, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: + + +a) The modified work must itself be a software library. +b) You must cause the files modified to carry prominent notices stating that you changed the files and the date of any change. +c) You must cause the whole of the work to be licensed at no charge to all third parties under the terms of this License. +d) If a facility in the modified Library refers to a function or a table of data to be supplied by an application program that uses the facility, other than as an argument passed when the facility is invoked, then you must make a good faith effort to ensure that, in the event an application does not supply such function or table, the facility still operates, and performs whatever part of its purpose remains meaningful. +(For example, a function in a library to compute square roots has a purpose that is entirely well-defined independent of the application. Therefore, Subsection 2d requires that any application-supplied function or table used by this function must be optional: if the application does not supply it, the square root function must still compute square roots.) + +These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Library, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Library, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it. + +Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Library. + +In addition, mere aggregation of another work not based on the Library with the Library (or with a work based on the Library) on a volume of a storage or distribution medium does not bring the other work under the scope of this License. + +3. You may opt to apply the terms of the ordinary GNU General Public License instead of this License to a given copy of the Library. To do this, you must alter all the notices that refer to this License, so that they refer to the ordinary GNU General Public License, version 2, instead of to this License. (If a newer version than version 2 of the ordinary GNU General Public License has appeared, then you can specify that version instead if you wish.) Do not make any other change in these notices. + +Once this change is made in a given copy, it is irreversible for that copy, so the ordinary GNU General Public License applies to all subsequent copies and derivative works made from that copy. + +This option is useful when you wish to copy part of the code of the Library into a program that is not a library. + +4. You may copy and distribute the Library (or a portion or derivative of it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange. + +If distribution of object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place satisfies the requirement to distribute the source code, even though third parties are not compelled to copy the source along with the object code. + +5. A program that contains no derivative of any portion of the Library, but is designed to work with the Library by being compiled or linked with it, is called a "work that uses the Library". Such a work, in isolation, is not a derivative work of the Library, and therefore falls outside the scope of this License. + +However, linking a "work that uses the Library" with the Library creates an executable that is a derivative of the Library (because it contains portions of the Library), rather than a "work that uses the library". The executable is therefore covered by this License. Section 6 states terms for distribution of such executables. + +When a "work that uses the Library" uses material from a header file that is part of the Library, the object code for the work may be a derivative work of the Library even though the source code is not. Whether this is true is especially significant if the work can be linked without the Library, or if the work is itself a library. The threshold for this to be true is not precisely defined by law. + +If such an object file uses only numerical parameters, data structure layouts and accessors, and small macros and small inline functions (ten lines or less in length), then the use of the object file is unrestricted, regardless of whether it is legally a derivative work. (Executables containing this object code plus portions of the Library will still fall under Section 6.) + +Otherwise, if the work is a derivative of the Library, you may distribute the object code for the work under the terms of Section 6. Any executables containing that work also fall under Section 6, whether or not they are linked directly with the Library itself. + +6. As an exception to the Sections above, you may also combine or link a "work that uses the Library" with the Library to produce a work containing portions of the Library, and distribute that work under terms of your choice, provided that the terms permit modification of the work for the customer's own use and reverse engineering for debugging such modifications. + +You must give prominent notice with each copy of the work that the Library is used in it and that the Library and its use are covered by this License. You must supply a copy of this License. If the work during execution displays copyright notices, you must include the copyright notice for the Library among them, as well as a reference directing the user to the copy of this License. Also, you must do one of these things: + + +a) Accompany the work with the complete corresponding machine-readable source code for the Library including whatever changes were used in the work (which must be distributed under Sections 1 and 2 above); and, if the work is an executable linked with the Library, with the complete machine-readable "work that uses the Library", as object code and/or source code, so that the user can modify the Library and then relink to produce a modified executable containing the modified Library. (It is understood that the user who changes the contents of definitions files in the Library will not necessarily be able to recompile the application to use the modified definitions.) +b) Use a suitable shared library mechanism for linking with the Library. A suitable mechanism is one that (1) uses at run time a copy of the library already present on the user's computer system, rather than copying library functions into the executable, and (2) will operate properly with a modified version of the library, if the user installs one, as long as the modified version is interface-compatible with the version that the work was made with. +c) Accompany the work with a written offer, valid for at least three years, to give the same user the materials specified in Subsection 6a, above, for a charge no more than the cost of performing this distribution. +d) If distribution of the work is made by offering access to copy from a designated place, offer equivalent access to copy the above specified materials from the same place. +e) Verify that the user has already received a copy of these materials or that you have already sent this user a copy. +For an executable, the required form of the "work that uses the Library" must include any data and utility programs needed for reproducing the executable from it. However, as a special exception, the materials to be distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable. + +It may happen that this requirement contradicts the license restrictions of other proprietary libraries that do not normally accompany the operating system. Such a contradiction means you cannot use both them and the Library together in an executable that you distribute. + +7. You may place library facilities that are a work based on the Library side-by-side in a single library together with other library facilities not covered by this License, and distribute such a combined library, provided that the separate distribution of the work based on the Library and of the other library facilities is otherwise permitted, and provided that you do these two things: + + +a) Accompany the combined library with a copy of the same work based on the Library, uncombined with any other library facilities. This must be distributed under the terms of the Sections above. +b) Give prominent notice with the combined library of the fact that part of it is a work based on the Library, and explaining where to find the accompanying uncombined form of the same work. +8. You may not copy, modify, sublicense, link with, or distribute the Library except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense, link with, or distribute the Library is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance. + +9. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Library or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Library (or any work based on the Library), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Library or works based on it. + +10. Each time you redistribute the Library (or any work based on the Library), the recipient automatically receives a license from the original licensor to copy, distribute, link with or modify the Library subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties with this License. + +11. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Library at all. For example, if a patent license would not permit royalty-free redistribution of the Library by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to refrain entirely from distribution of the Library. + +If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply, and the section as a whole is intended to apply in other circumstances. + +It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice. + +This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License. + +12. If the distribution and/or use of the Library is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Library under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License. + +13. The Free Software Foundation may publish revised and/or new versions of the Lesser General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. + +Each version is given a distinguishing version number. If the Library specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Library does not specify a license version number, you may choose any version ever published by the Free Software Foundation. + +14. If you wish to incorporate parts of the Library into other free programs whose distribution conditions are incompatible with these, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally. + +NO WARRANTY + +15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. + +16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. + + END OF TERMS AND CONDITIONS
\ No newline at end of file diff --git a/trunk/adodb-for-php4/old-changelog.htm b/trunk/adodb-for-php4/old-changelog.htm index bf8a1af2..284f3ad1 100644 --- a/trunk/adodb-for-php4/old-changelog.htm +++ b/trunk/adodb-for-php4/old-changelog.htm @@ -1,822 +1,822 @@ -<html><title>Old Changelog: ADOdb</title><body>
-<h3>Old Changelog</h3>
-
-</p><p><b>3.92 22 Sept 2003</b>
-</p><p>Added GetAssoc and CacheGetAssoc to connection object.
-</p><p>Removed TextMax and CharMax functions from adodb.inc.php.
-</p><p>HasFailedTrans() returned false when trans failed. Fixed.
-</p><p>Moved perf driver classes into adodb/perf/*.php.
-</p><p>Misc improvements to performance monitoring, including UI().
-</p><p>RETVAL in mssql Parameter(), we do not append @ now.
-</p><p>Added Param($name) to connection class, returns '?' or ":$name", for defining
- bind parameters portably.
-</p><p>LogSQL traps affected_rows() and saves its value properly now. Also fixed oci8
- _stmt and _affectedrows() bugs.
-</p><p>Session code timestamp check for oci8 works now. Formerly default NLS_DATE_FORMAT
- stripped off time portion. Thx to Tony Blair (tonanbarbarian#hotmail.com). Also
- added new $conn->datetime field to oci8, controls whether MetaType() returns
- 'D' ($this->datetime==false) or 'T' ($this->datetime == true) for DATE type.
-</p><p>Fixed bugs in adodb-cryptsession.inc.php and adodb-session-clob.inc.php.
-</p><p>Fixed misc bugs in adodb_key_exists, GetInsertSQL() and GetUpdateSQL().
-</p><p>Tuned include_once handling to reduce file-system checking overhead.
-</p><p><b>3.91 9 Sept 2003</b>
-</p><p>Only released to InterAkt
-</p><p>Added LogSQL() for sql logging and $ADODB_NEWCONNECTION to override factory
- for driver instantiation.
-</p><p>Added IfNull($field,$ifNull) function, thx to johnwilk#juno.com
-</p><p>Added portable substr support.
-</p><p>Now rs2html() has new parameter, $echo. Set to false to return $html instead
- of echoing it.
-</p><p><b>3.90 5 Sept 2003</b>
-</p><p>First beta of performance monitoring released.
-</p><p>MySQL supports MetaTable() masking.
-</p><p>Fixed key_exists() bug in adodb-lib.inc.php
-</p><p>Added sp_executesql Prepare() support to mssql.
-</p><p>Added bind support to db2.
-</p><p>Added swedish language file - Christian Tiberg" christian#commsoft.nu
-</p><p>Bug in drop index for mssql data dict fixed. Thx to Gert-Rainer Bitterlich.
-</p><p>Left join setting for oci8 was wrong. Thx to johnwilk#juno.com
-</p><p><b>3.80 27 Aug 2003</b>
-</p><p>Patch for PHP 4.3.3 cached recordset csv2rs() fread loop incompatibility.
-</p><p>Added matching mask for MetaTables. Only for oci8, mssql and postgres currently.
-</p><p>Rewrite of "oracle" driver connection code, merging with "oci8", by Gaetano.
-</p><p>Added better debugging for Smart Transactions.
-</p><p>Postgres DBTimeStamp() was wrongly using TO_DATE. Changed to TO_TIMESTAMP.
-</p><p>ADODB_FETCH_CASE check pushed to ADONewConnection to allow people to define
- it after including adodb.inc.php.
-</p><p>Added portugese (brazilian) to languages. Thx to "Levi Fukumori".
-</p><p>Removed arg3 parameter from Execute/SelectLimit/Cache* functions.
-</p><p>Execute() now accepts 2-d array as $inputarray. Also changed docs of fnExecute()
- to note change in sql query counting with 2-d arrays.
-</p><p>Added MONEY to MetaType in PostgreSQL.
-</p><p>Added more debugging output to CacheFlush().
-</p><p><b>3.72 9 Aug 2003</b>
-</p><p>Added qmagic($str), which is a qstr($str) that auto-checks for magic quotes
- and does the right thing...
-</p><p>Fixed CacheFlush() bug - Thx to martin#gmx.de
-</p><p>Walt Boring contributed MetaForeignKeys for postgres7.
-</p><p>_fetch() called _BlobDecode() wrongly in interbase. Fixed.
-</p><p>adodb_time bug fixed with dates after 2038 fixed by Jason Pell. http://phplens.com/lens/lensforum/msgs.php?id=6980
-</p><p><b>3.71 4 Aug 2003</b>
-</p><p>The oci8 driver, MetaPrimaryKeys() did not check the owner correctly when $owner
- == false.
-</p><p>Russian language file contributed by "Cyrill Malevanov" cyrill#malevanov.spb.ru.
-</p><p>Spanish language file contributed by "Horacio Degiorgi" horaciod#codigophp.com.
-</p><p>Error handling in oci8 bugfix - if there was an error in Execute(), then when
- calling ErrorNo() and/or ErrorMsg(), the 1st call would return the error, but
- the 2nd call would return no error.
-</p><p>Error handling in odbc bugfix. ODBC would always return the last error, even
- if it happened 5 queries ago. Now we reset the errormsg to '' and errorno to
- 0 everytime before CacheExecute() and Execute().
-</p><p><b>3.70 29 July 2003</b>
-</p><p>Added new SQLite driver. Tested on PHP 4.3 and PHP 5.
-</p><p>Added limited "sapdb" driver support - mainly date support.
-</p><p>The oci8 driver did not identify NUMBER with no defined precision correctly.
-</p><p>Added ADODB_FORCE_NULLS, if set, then PHP nulls are converted to SQL nulls
- in GetInsertSQL/GetUpdateSQL.
-</p><p>DBDate() and DBTimeStamp() format for postgresql had problems. Fixed.
-</p><p>Added tableoptions to ChangeTableSQL(). Thx to Mike Benoit.
-</p><p>Added charset support to postgresql. Thx to Julian Tarkhanov.
-</p><p>Changed OS check for MS-Windows to prevent confusion with darWIN (MacOS)
-</p><p>Timestamp format for db2 was wrong. Changed to yyyy-mm-dd-hh.mm.ss.nnnnnn.
-</p><p>adodb-cryptsession.php includes wrong. Fixed.
-</p><p>Added MetaForeignKeys(). Supported by mssql, odbc_mssql and oci8.
-</p><p>Fixed some oci8 MetaColumns/MetaPrimaryKeys bugs. Thx to Walt Boring.
-</p><p>adodb_getcount() did not init qryRecs to 0. Missing "WHERE" clause checking
- in GetUpdateSQL fixed. Thx to Sebastiaan van Stijn.
-</p><p>Added support for only 'VIEWS' and "TABLES" in MetaTables. From Walt Boring.
-</p><p>Upgraded to adodb-xmlschema.inc.php 0.0.2.
-</p><p>NConnect for mysql now returns value. Thx to Dennis Verspuij.
-</p><p>ADODB_FETCH_BOTH support added to interbase/firebird.
-</p><p>Czech language file contributed by Kamil Jakubovic jake#host.sk.
-</p><p>PostgreSQL BlobDecode did not use _connectionID properly. Thx to Juraj Chlebec.
-</p><p>Added some new initialization stuff for Informix. Thx to "Andrea Pinnisi" pinnisi#sysnet.it
-</p><p>ADODB_ASSOC_CASE constant wrong in sybase _fetch(). Fixed.
-</p><p><b>3.60 16 June 2003</b>
-</p><p>We now SET CONCAT_NULL_YIELDS_NULL OFF for odbc_mssql driver to be compat with
- mssql driver.
-</p><p>The property $emptyDate missing from connection class. Also changed 1903 to
- constant (TIMESTAMP_FIRST_YEAR=100). Thx to Sebastiaan van Stijn.
-</p><p>ADOdb speedup optimization - we now return all arrays by reference.
-</p><p>Now DBDate() and DBTimeStamp() now accepts the string 'null' as a parameter.
- Suggested by vincent.
-</p><p>Added GetArray() to connection class.
-</p><p>Added not_null check in informix metacolumns().
-</p><p>Connection parameters for postgresql did not work correctly when port was defined.
-</p><p>DB2 is now a tested driver, making adodb 100% compatible. Extensive changes
- to odbc driver for DB2, including implementing serverinfo() and SQLDate(), switching
- to SQL_CUR_USE_ODBC as the cursor mode, and lastAffectedRows and SelectLimit()
- fixes.
-</p><p>The odbc driver's FetchField() field names did not obey ADODB_ASSOC_CASE. Fixed.
-</p><p>Some bugs in adodb_backtrace() fixed.
-</p><p>Added "INT IDENTITY" type to adorecordset::MetaType() to support odbc_mssql
- properly.
-</p><p>MetaColumns() for oci8, mssql, odbc revised to support scale. Also minor revisions
- to odbc MetaColumns() for vfp and db2 compat.
-</p><p>Added unsigned support to mysql datadict class. Thx to iamsure.
-</p><p>Infinite loop in mssql MoveNext() fixed when ADODB_FETCH_ASSOC used. Thx to
- Josh R, Night_Wulfe#hotmail.com.
-</p><p>ChangeTableSQL contributed by Florian Buzin.
-</p><p>The odbc_mssql driver now sets CONCAT_NULL_YIELDS_NULL OFF for compat with
- mssql driver.
-</p>
-
-<p><b>3.50 19 May 2003</b></p>
-<p>Fixed mssql compat with FreeTDS. FreeTDS does not implement mssql_fetch_assoc().
-<p>Merged back connection and recordset code into adodb.inc.php.
-<p>ADOdb sessions using oracle clobs contributed by achim.gosse#ddd.de. See adodb-session-clob.php.
-<p>Added /s modifier to preg_match everywhere, which ensures that regex does not
- stop at /n. Thx Pao-Hsi Huang.
-<p>Fixed error in metacolumns() for mssql.
-<p>Added time format support for SQLDate.
-<p>Image => B added to metatype.
-<p>MetaType now checks empty($this->blobSize) instead of empty($this).
-<p>Datadict has beta support for informix, sybase (mapped to mssql), db2 and generic
- (which is a fudge).
-<p>BlobEncode for postgresql uses pg_escape_bytea, if available. Needed for compat
- with 7.3.
-<p>Added $ADODB_LANG, to support multiple languages in MetaErrorMsg().
-<p>Datadict can now parse table definition as declarative text.
-<p>For DataDict, oci8 autoincrement trigger missing semi-colon. Fixed.
-<p>For DataDict, when REPLACE flag enabled, drop sequence in datadict for autoincrement
- field in postgres and oci8.s
-<p>Postgresql defaults to template1 database if no database defined in connect/pconnect.
-<p>We now clear _resultid in postgresql if query fails.
-<p><b>3.40 19 May 2003</b></p>
-<p>Added insert_id for odbc_mssql.
-<p>Modified postgresql UpdateBlobFile() because it did not work in safe mode.
-<p>Now connection object is passed to raiseErrorFn as last parameter. Needed by
- StartTrans().
-<p>Added StartTrans() and CompleteTrans(). It is recommended that you do not modify
- transOff, but use the above functions.
-<p>oci8po now obeys ADODB_ASSOC_CASE settings.
-<p>Added virtualized error codes, using PEAR DB equivalents. Requires you to manually
- include adodb-error.inc.php yourself, with MetaError() and MetaErrorMsg($errno).
-<p>GetRowAssoc for mysql and pgsql were flawed. Fix by Ross Smith.
-<p>Added to datadict types I1, I2, I4 and I8. Changed datadict type 'T' to map
- to timestamp instead of datetime for postgresql.
-<p>Error handling in ExecuteSQLArray(), adodb-datadict.inc.php did not work.
-<p>We now auto-quote postgresql connection parameters when building connection
- string.
-<p>Added session expiry notification.
-<p>We now test with odbc mysql - made some changes to odbc recordset constructor.
-<p>MetaColumns now special cases access and other databases for odbc.
-<p><b>3.31 17 March 2003</b></p>
-<p>Added row checking for _fetch in postgres.
-<p>Added Interval type to MetaType for postgres.
-<p>Remapped postgres driver to call postgres7 driver internally.
-<p>Adorecordset_array::getarray() did not return array when nRows >= 0.
-<p>Postgresql: at times, no error message returned by pg_result_error() but error
- message returned in pg_last_error(). Recoded again.
-<p>Interbase blob's now use chunking for updateblob.
-<p>Move() did not set EOF correctly. Reported by Jorma T.
-<p>We properly support mysql timestamp fields when we are creating mysql tables
- using the data-dict interface.
-<p>Table regex includes backticks character now.
-<p><b>3.30 3 March 2003</b></p>
-<p>Added $ADODB_EXTENSION and $ADODB_COMPAT_FETCH constant.
-<p>Made blank1stItem configurable using syntax "value:text" in GetMenu/GetMenu2.
- Thx to Gabriel Birke.
-<p>Previously ADOdb differed from the Microsoft standard because it did not define
- what to set $this->fields when EOF was reached. Now at EOF, ADOdb sets $this->fields
- to false for all databases, which is consist with Microsoft's implementation.
- Postgresql and mysql have always worked this way (in 3.11 and earlier). If you
- are experiencing compatibility problems (and you are not using postgresql nor
- mysql) on upgrading to 3.30, try setting the global variables $ADODB_COUNTRECS
- = true (which is the default) and $ADODB_FETCH_COMPAT = true (this is a new
- global variable).
-<p>We now check both pg_result_error and pg_last_error as sometimes pg_result_error
- does not display anything. Iman Mayes
-<p> We no longer check for magic quotes gpc in Quote().
-<p> Misc fixes for table creation in adodb-datadict.inc.php. Thx to iamsure.
-<p> Time calculations use adodb_time library for all negative timestamps due to
- problems in Red Hat 7.3 or later. Formerly, only did this for Windows.
-<p> In mssqlpo, we now check if $sql in _query is a string before we change ||
- to +. This is to support prepared stmts.
-<p> Move() and MoveLast() internals changed to support to support EOF and $this->fields
- change.
-<p> Added ADODB_FETCH_BOTH support to mssql. Thx to Angel Fradejas afradejas#mediafusion.es
-<p> We now check if link resource exists before we run mysql_escape_string in
- qstr().
-<p> Before we flock in csv code, we check that it is not a http url.
-<p><b>3.20 17 Feb 2003</b></p>
-<p>Added new Data Dictionary classes for creating tables and indexes. Warning
- - this is very much alpha quality code. The API can still change. See adodb/tests/test-datadict.php
- for more info.
-<p>We now ignore $ADODB_COUNTRECS for mysql, because PHP truncates incomplete
- recordsets when mysql_unbuffered_query() is called a second time.
-<p>Now postgresql works correctly when $ADODB_COUNTRECS = false.
-<p>Changed _adodb_getcount to properly support SELECT DISTINCT.
-<p>Discovered that $ADODB_COUNTRECS=true has some problems with prepared queries
- - suspect PHP bug.
-<p>Now GetOne and GetRow run in $ADODB_COUNTRECS=false mode for better performance.
-<p>Added support for mysql_real_escape_string() and pg_escape_string() in qstr().
-<p>Added an intermediate variable for mysql _fetch() and MoveNext() to store fields,
- to prevent overwriting field array with boolean when mysql_fetch_array() returns
- false.
-<p>Made arrays for getinsertsql and getupdatesql case-insensitive. Suggested by
- Tim Uckun" tim#diligence.com
-<p><b>3.11 11 Feb 2003</b></p>
-<p>Added check for ADODB_NEVER_PERSIST constant in PConnect(). If defined, then
- PConnect() will actually call non-persistent Connect().
-<p>Modified interbase to properly work with Prepare().
-<p>Added $this->ibase_timefmt to allow you to change the date and time format.
-<p>Added support for $input_array parameter in CacheFlush().
-<p>Added experimental support for dbx, which was then removed when i found that
- it was slower than using native calls.
-<p>Added MetaPrimaryKeys for mssql and ibase/firebird.
-<p>Added new $trim parameter to GetCol and CacheGetCol
-<p>Uses updated adodb-time.inc.php 0.06.
-<p><b>3.10 27 Jan 2003</b>
-<p>Added adodb_date(), adodb_getdate(), adodb_mktime() and adodb-time.inc.php.
-<p>For interbase, added code to handle unlimited number of bind parameters. From
- Daniel Hasan daniel#hasan.cl.
-<p>Added BlobDecode and UpdateBlob for informix. Thx to Fernando Ortiz.
-<p>Added constant ADODB_WINDOWS. If defined, means that running on Windows.
-<p>Added constant ADODB_PHPVER which stores php version as a hex num. Removed
- $ADODB_PHPVER variable.
-<p>Felho Bacsi reported a minor white-space regular expression problem in GetInsertSQL.
-<p>Modified ADO to use variant to store _affectedRows
-<p>Changed ibase to use base class Replace(). Modified base class Replace() to
- support ibase.
-<p>Changed odbc to auto-detect when 0 records returned is wrong due to bad odbc
- drivers.
-<p>Changed mssql to use datetimeconvert ini setting only when 4.30 or later (does
- not work in 4.23).
-<p>ExecuteCursor($stmt, $cursorname, $params) now accepts a new $params array
- of additional bind parameters -- William Lovaton walovaton#yahoo.com.mx.
-<p>Added support for sybase_unbuffered_query if ADODB_COUNTRECS == false. Thx
- to chuck may.
-<p>Fixed FetchNextObj() bug. Thx to Jorma Tuomainen.
-<p>We now use SCOPE_IDENTITY() instead of @@IDENTITY for mssql - thx to marchesini#eside.it
-<p>Changed postgresql movenext logic to prevent illegal row number from being
- passed to pg_fetch_array().
-<p>Postgresql initrs bug found by "Bogdan RIPA" bripa#interakt.ro $f1 accidentally
- named $f
-<p><b>3.00 6 Jan 2003</b>
-<p>Fixed adodb-pear.inc.php syntax error.
-<p>Improved _adodb_getcount() to use SELECT COUNT(*) FROM ($sql) for languages
- that accept it.
-<p>Fixed _adodb_getcount() caching error.
-<p>Added sql to retrive table and column info for odbc_mssql.
-<p><strong>2.91 3 Jan 2003</strong>
-<p>Revised PHP version checking to use $ADODB_PHPVER with legal values 0x4000,
- 0x4050, 0x4200, 0x4300.
-<p>Added support for bytea fields and oid blobs in postgres by allowing BlobDecode()
- to detect and convert non-oid fields. Also added BlobEncode to postgres when
- you want to encode oid blobs.
-<p>Added blobEncodeType property for connections to inform phpLens what encoding
- method to use for blobs.
-<p>Added BlobDecode() and BlobEncode() to base ADOConnection class.
-<p>Added umask() to _gencachename() when creating directories.
-<p>Added charPage for ado drivers, so you can set the code page.
-<pre>
-$conn->charPage = CP_UTF8;
-$conn->Connect($dsn);
-</pre>
-<p>Modified _seek in mysql to check for num rows=0.
-<p>Added to metatypes new informix types for IDS 9.30. Thx Fernando Ortiz.
-<p>_maxrecordcount returned in CachePageExecute $rsreturn
-<p>Fixed sybase cacheselectlimit( ) problems
-<p>MetaColumns() max_length should use precision for types X and C for ms access.
- Fixed.
-<p>Speedup of odbc non-SELECT sql statements.
-<p>Added support in MetaColumns for Wide Char types for ODBC. We halve max_length
- if unicode/wide char.
-<p>Added 'B' to types handled by GetUpdateSQL/GetInsertSQL.
-<p>Fixed warning message in oci8 driver with $persist variable when using PConnect.
-<p><b>2.90 11 Dec 2002</b>
-<p>Mssql and mssqlpo and oci8po now support ADODB_ASSOC_CASE.
-<p>Now MetaType() can accept a field object as the first parameter.
-<p>New $arr = $db->ServerInfo( ) function. Returns $arr['description'] which
- is the string description, and $arr['version'].
-<p>PostgreSQL and MSSQL speedups for insert/updates.
-<p> Implemented new SetFetchMode() that removes the need to use $ADODB_FETCH_MODE.
- Each connection has independant fetchMode.
-<p>ADODB_ASSOC_CASE now defaults to 2, use native defaults. This is because we
- would break backward compat for too many applications otherwise.
-<p>Patched encrypted sessions to use replace()
-<p>The qstr function supports quoting of nulls when escape character is \
-<p>Rewrote bits and pieces of session code to check for time synch and improve
- reliability.
-<p>Added property ADOConnection::hasTransactions = true/false;
-<p>Added CreateSequence and DropSequence functions
-<p>Found misplaced MoveNext() in adodb-postgres.inc.php. Fixed.
-<p>Sybase SelectLimit not reliable because 'set rowcount' not cached - fixed.
-<p>Moved ADOConnection to adodb-connection.inc.php and ADORecordSet to adodb-recordset.inc.php.
- This allows us to use doxygen to generate documentation. Doxygen doesn't like
- the classes in the main adodb.inc.php file for some mysterious reason.
-<p><b>2.50, 14 Nov 2002</b>
-<p>Added transOff and transCnt properties for disabling (transOff = true) and
- tracking transaction status (transCnt>0).
-<p>Added inputarray handling into _adodb_pageexecute_all_rows - "Ross Smith" RossSmith#bnw.com.
-<p>Fixed postgresql inconsistencies in date handling.
-<p>Added support for mssql_fetch_assoc.
-<p>Fixed $ADODB_FETCH_MODE bug in odbc MetaTables() and MetaPrimaryKeys().
-<p>Accidentally declared UnixDate() twice, making adodb incompatible with php
- 4.3.0. Fixed.
-<p>Fixed pager problems with some databases that returned -1 for _currentRow on
- MoveLast() by switching to MoveNext() in adodb-lib.inc.php.
-<p>Also fixed uninited $discard in adodb-lib.inc.php.
-<p><b>2.43, 25 Oct 2002</b></p>
-Added ADODB_ASSOC_CASE constant to better support ibase and odbc field names.
-<p>Added support for NConnect() for oracle OCINLogin.
-<p>Fixed NumCols() bug.
-<p>Changed session handler to use Replace() on write.
-<p>Fixed oci8 SelectLimit aggregate function bug again.
-<p>Rewrote pivoting code.
-<p><b>2.42, 4 Oct 2002</b></p>
-<p>Fixed ibase_fetch() problem with nulls. Also interbase now does automatic blob
- decoding, and is backward compatible. Suggested by Heinz Hombergs heinz#hhombergs.de.
-<p>Fixed postgresql MoveNext() problems when called repeatedly after EOF. Also
- suggested by Heinz Hombergs.
-<p>PageExecute() does not rewrite queries if SELECT DISTINCT is used. Requested
- by hans#velum.net
-<p>Added additional fixes to oci8 SelectLimit handling with aggregate functions
- - thx to Christian Bugge for reporting the problem.
-<p><b>2.41, 2 Oct 2002</b></p>
-<p>Fixed ADODB_COUNTRECS bug in odbc. Thx to Joshua Zoshi jzoshi#hotmail.com.
-<p>Increased buffers for adodb-csvlib.inc.php for extremely long sql from 8192
- to 32000.
-<p>Revised pivottable.inc.php code. Added better support for aggregate fields.
-<p>Fixed mysql text/blob types problem in MetaTypes base class - thx to horacio
- degiorgi.
-<p>Added SQLDate($fmt,$date) function, which allows an sql date format string
- to be generated - useful for group by's.
-<p>Fixed bug in oci8 SelectLimit when offset>100.
-<p><b>2.40 4 Sept 2002</b></p>
-<p>Added new NLS_DATE_FORMAT property to oci8. Suggested by Laurent NAVARRO ln#altidev.com
-<p>Now use bind parameters in oci8 selectlimit for better performance.
-<p>Fixed interbase replaceQuote for dialect != 1. Thx to "BEGUIN Pierre-Henri
- - INFOCOB" phb#infocob.com.
-<p>Added white-space check to QA.
-<p>Changed unixtimestamp to support fractional seconds (we always round down/floor
- the seconds). Thanks to beezly#beezly.org.uk.
-<p>Now you can set the trigger_error type your own user-defined type in adodb-errorhandler.inc.php.
- Suggested by Claudio Bustos clbustos#entelchile.net.
-<p>Added recordset filters with rsfilter.inc.php.
-<p>$conn->_rs2rs does not create a new recordset when it detects it is of type
- array. Some trickery there as there seems to be a bug in Zend Engine
-<p>Added render_pagelinks to adodb-pager.inc.php. Code by "Pablo Costa" pablo#cbsp.com.br.
-<p>MetaType() speedup in adodb.inc.php by using hashing instead of switch. Best
- performance if constant arrays are supported, as they are in PHP5.
-<p>adodb-session.php now updates only the expiry date if the crc32 check indicates
- that the data has not been modified.
-<p><b>2.31 20 Aug 2002</b></p>
-<p>Made changes to pivottable.inc.php due to daniel lucuzaeu's suggestions (we sum the pivottable column if desired).
-<p>Fixed ErrorNo() in postgres so it does not depend on _errorMsg property.
-<p>Robert Tuttle added support for oracle cursors. See ExecuteCursor().
-<p>Fixed Replace() so it works with mysql when updating record where data has not changed. Reported by
-Cal Evans (cal#calevans.com).
-<p><b>2.30 1 Aug 2002</b></p>
-<p>Added pivottable.inc.php. Thanks to daniel.lucazeau#ajornet.com for the original
- concept.
-<p>Added ADOConnection::outp($msg,$newline) to output error and debugging messages. Now
-you can override this using the ADODB_OUTP constant and use your own output handler.
-<p>Changed == to === for 'null' comparison. Reported by ericquil#yahoo.com
-<p>Fixed mssql SelectLimit( ) bug when distinct used.
-<p><b>2.30 1 Aug 2002</b></p>
-<p>New GetCol() and CacheGetCol() from ross#bnw.com that returns the first field as a 1 dim array.
-<p>We have an empty recordset, but RecordCount() could return -1. Fixed. Reported by "Jonathan Polansky" jonathan#polansky.com.
-<p>We now check for session variable changes using strlen($sessval).crc32($sessval).
-Formerly we only used crc32().
-<p>Informix SelectLimit() problem with $ADODB_COUNTRECS fixed.
-<p>Fixed informix SELECT FIRST x DISTINCT, and not SELECT DISTINCT FIRST x - reported by F Riosa
-<p>Now default adodb error handlers ignores error if @ used.
-<p>If you set $conn->autoRollback=true, we auto-rollback persistent connections for odbc, mysql, oci8, mssql.
-Default for autoRollback is false. No need to do so for postgres.
-As interbase requires a transaction id (what a flawed api), we don't do it for interbase.
-<p>Changed PageExecute() to use non-greedy preg_match when searching for "FROM" keyword.
-<p><b>2.20 9 July 2002</b></p>
-<p>Added CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
-<p>Added $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs
- date offsets. Useful for scheduling appointments.
-<p>Added connection properties: leftOuter, rightOuter that hold left and right
- outer join operators.
-<p>Added connection property: ansiOuter to indicate whether ansi outer joins supported.
-<p>New driver <i>mssqlpo</i>, the portable mssql driver, which converts string
- concat operator from || to +.
-<p>Fixed ms access bug - SelectLimit() did not support ties - fixed.
-<p>Karsten Kraus (Karsten.Kraus#web.de), contributed error-handling code to ADONewConnection.
- Unfortunately due to backward compat problems, had to rollback most of the changes.
-<p>Added new parameter to GetAssoc() to allow returning an array of key-value pairs,
-ignoring any additional columns in the recordset. Off by default.
-<p>Corrected mssql $conn->sysDate to return only date using convert().
-<p>CacheExecute() improved debugging output.
-<p>Changed rs2html() so newlines are converted to BR tags. Also optimized rs2html() based
-on feedback by "Jerry Workman" jerry#mtncad.com.
-<p>Added support for Replace() with Interbase, using DELETE and INSERT.
-<p>Some minor optimizations (mostly removing & references when passing arrays).
-<p>Changed GenID() to allows id's larger than the size of an integer.
-<p>Added force_session property to oci8 for better updateblob() support.
-<p>Fixed PageExecute() which did not work properly with sql containing GROUP BY.
-<p><b>2.12 12 June 2002</b></p>
-<p>Added toexport.inc.php to export recordsets in CSV and tab-delimited format.
-<p>CachePageExecute() does not work - fixed - thx John Huong.
-<p>Interbase aliases not set properly in FetchField() - fixed. Thx Stefan Goethals.
-<p>Added cache property to adodb pager class. The number of secs to cache recordsets.
-<p>SQL rewriting bug in pageexecute() due to skipping of newlines due to missing /s modifier. Fixed.
-<p>Max size of cached recordset due to a bug was 256000 bytes. Fixed.
-<p>Speedup of 1st invocation of CacheExecute() by tuning code.
-<p>We compare $rewritesql with $sql in pageexecute code in case of rewrite failure.
-<p><b>2.11 7 June 2002</b></p>
-<p>Fixed PageExecute() rewrite sql problem - COUNT(*) and ORDER BY don't go together with
- mssql, access and postgres. Thx to Alexander Zhukov alex#unipack.ru
-<p>DB2 support for CHARACTER type added - thx John Huong huongch#bigfoot.com
-<p>For ado, $argProvider not properly checked. Fixed - kalimero#ngi.it
-<p>Added $conn->Replace() function for update with automatic insert if the record does not exist.
- Supported by all databases except interbase.
-<p><b>2.10 4 June 2002</b></p>
-<p>Added uniqueSort property to indicate mssql ORDER BY cols must be unique.
-<p>Optimized session handler by crc32 the data. We only write if session data has changed.
-<p>adodb_sess_read in adodb-session.php now returns ''correctly - thanks to Jorma Tuomainen, webmaster#wizactive.com
-<p>Mssql driver did not throw EXECUTE errors correctly because ErrorMsg() and ErrorNo() called in wrong order.
-Pointed out by Alexios Fakos. Fixed.
-<p>Changed ado to use client cursors. This fixes BeginTran() problems with ado.
-<p>Added handling of timestamp type in ado.
-<p>Added to ado_mssql support for insert_id() and affected_rows().
-<p>Added support for mssql.datetimeconvert=0, available since php 4.2.0.
-<p>Made UnixDate() less strict, so that the time is ignored if present.
-<p>Changed quote() so that it checks for magic_quotes_gpc.
-<p>Changed maxblobsize for odbc to default to 64000.
-<p><b>2.00 13 May 2002</b></p>
-<p>Added drivers <i>informix72</i> for pre-7.3 versions, and <i>oci805</i> for
- oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers
- are now identical.
-<p>Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode.
-<p>Proper support for blobs in mssql. Also revised blob support code
-is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency.
-<p>Added support for changed odbc_fetch_into api in php 4.2.0
-with $conn->_has_stupid_odbc_fetch_api_change.
-<p>Fixed spelling of tablock locking hint in GenID( ) for mssql.
-<p>Added RowLock( ) to several databases, including oci8, informix, sybase, etc.
- Fixed where error in mssql RowLock().
-<p>Added sysDate and sysTimeStamp properties to most database drivers. These are the sql
-functions/constants for that database that return the current date and current timestamp, and
-are useful for portable inserts and updates.
-<p>Support for RecordCount() caused date handling in sybase and mssql to break.
-Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for
-both databases. Generalized using arrayClass property. Also to support RecordCount(),
-changed metatype handling for ado drivers. Now the type returned in FetchField
- is no longer a number, but the 1-char data type returned by MetaType.
- At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats.
-Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling.
-Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM).
-<p>Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com
-<p>Added $ok parameter to CommitTrans($ok) for easy rollbacks.
-<p>Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE.
-<p>Some odbc drivers did not call the base connection class constructor. Fixed.
-<p>Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations.
-
-<p><b>1.99 21 April 2002</b></p>
-<p>Added emulated RecordCount() to all database drivers if $ADODB_COUNTRECS = true
- (which it is by default). Inspired by Cristiano Duarte (cunha17#uol.com.br).
-<p>Unified stored procedure support for mssql and oci8. Parameter() and PrepareSP()
- functions implemented.
-<p>Added support for SELECT FIRST in informix, modified hasTop property to support
- this.
-<p>Changed csv driver to handle updates/deletes/inserts properly (when Execute() returns true).
-Bind params also work now, and raiseErrorFn with csv driver. Added csv driver to QA process.
-<p>Better error checking in oci8 UpdateBlob() and UpdateBlobFile().
-<p>Added TIME type to MySQL - patch by Manfred h9125297#zechine.wu-wien.ac.at
-<p>Prepare/Execute implemented for Interbase/Firebird
-<p>Changed some regular expressions to be anchored by /^ $/ for speed.
-<p>Added UnixTimeStamp() and UnixDate() to ADOConnection(). Now these functions
- are in both ADOConnection and ADORecordSet classes.
-<p>Empty recordsets were not cached - fixed.
-<p>Thanks to Gaetano Giunta (g.giunta#libero.it) for the oci8 code review. We
- didn't agree on everything, but i hoped we agreed to disagree!
-<p><b>1.90 6 April 2002</b></p>
-<p>Now all database drivers support fetch modes ADODB_FETCH_NUM and ADODB_FETCH_ASSOC, though
- still not fully tested. Eg. Frontbase, Sybase, Informix.
-<p>NextRecordSet() support for mssql. Contributed by "Sven Axelsson" sven.axelsson#bokochwebb.se
-<p>Added blob support for SQL Anywhere. Contributed by Wade Johnson wade#wadejohnson.de
-<p>Fixed some security loopholes in server.php. Server.php also supports fetch mode.
-<p>Generalized GenID() to support odbc and mssql drivers. Mssql no longer generates GUID's.
-<p>Experimental RowLock($table,$where) for mssql.
-<p>Properly implemented Prepare() in oci8 and ODBC.
-<p>Added Bind() support to oci8 to support Prepare().
-<p>Improved error handler. Catches CacheExecute() and GenID() errors now.
-<p>Now if you are running php from the command line, debugging messages do not output html formating.
-Not 100% complete, but getting there.
-<p><b>1.81 22 March 2002</b></p>
-<p>Restored default $ADODB_FETCH_MODE = ADODB_FETCH_DEFAULT for backward compatibility.
-<p>SelectLimit for oci8 improved - Our FIRST_ROWS optimization now does not overwrite existing hint.
-<p>New Sybase SQL Anywhere driver. Contributed by Wade Johnson wade#wadejohnson.de
-<p><b>1.80 15 March 2002</b></p>
-<p>Redesigned directory structure of ADOdb files. Added new driver directory where
-all database drivers reside.
-<p>Changed caching algorithm to create subdirectories. Now we scale better.
-<p>Informix driver now supports insert_id(). Contribution by "Andrea Pinnisi" pinnisi#sysnet.it
-<p>Added experimental ISO date and FetchField support for informix.
-<p>Fixed a quoting bug in Execute() with bind parameters, causing problems with blobs.
-<p>Mssql driver speedup by 10-15%.
-<p>Now in CacheExecute($secs2cache,$sql,...), $secs2cache is optional. If missing, it will
-take the value defined in $connection->cacheSecs (default is 3600 seconds). Note that
-CacheSelectLimit(), the secs2cache is still compulsory - sigh.
-<p>Sybase SQL Anywhere driver (using ODBC) contributed by Wade Johnson wade#wadejohnson.de
-<p><b>1.72 8 March 2002</b></p>
-<p>Added @ when returning Fields() to prevent spurious error - "Michael William Miller" mille562#pilot.msu.edu
-<p>MetaDatabases() for postgres contributed by Phil pamelant#nerim.net
- <p>Mitchell T. Young (mitch#youngfamily.org) contributed informix driver.
- <p>Fixed rs2html() problem. I cannot reproduce, so probably a problem with pre PHP 4.1.0 versions,
- when supporting new ADODB_FETCH_MODEs.
- <p>Mattia Rossi (mattia#technologist.com) contributed BlobDecode() and UpdateBlobFile() for postgresql
- using the postgres specific pg_lo_import()/pg_lo_open() - i don't use them but hopefully others will
- find this useful. See <a href="http://phplens.com/lens/lensforum/msgs.php?id=1262">this posting</a>
- for an example of usage.
- <p>Added UpdateBlobFile() for uploading files to a database.
- <p>Made UpdateBlob() compatible with oci8po driver.
- <p>Added noNullStrings support to oci8 driver. Oracle changes all ' ' strings to nulls,
- so you need to set strings to ' ' to prevent the nullifying of strings. $conn->noNullStrings = true;
- will do this for you automatically. This is useful when you define a char column as NOT NULL.
- <p>Fixed UnixTimeStamp() bug - wasn't setting minutes and seconds properly. Patch from Agusti Fita i Borrell agusti#anglatecnic.com.
- <p>Toni Tunkkari added patch for sybase dates. Problem with spaces in day part of date fixed.
- <p><b>1.71 18 Jan 2002</b></p>
- <p>Sequence start id support. Now $conn->Gen_ID('seqname', 50) to start sequence from 50.
- <p>CSV driver fix for selectlimit, from Andreas - akaiser#vocote.de.
-<P>Gam3r spotted that a global variable was undefined in the session handler.
-<p>Mssql date regex had error. Fixed - reported by Minh Hoang vb_user#yahoo.com.
-<p>DBTimeStamp() and DBDate() now accept iso dates and unix timestamps. This means
-that the PostgreSQL handling of dates in GetInsertSQL() and GetUpdateSQL() can
-be removed. Also if these functions are passed '' or null or false, we return a SQL null.
-<p>GetInsertSQL() and GetUpdateSQL() now accept a new parameter, $magicq to
-indicate whether quotes should be inserted based on magic quote settings - suggested by
-dj#4ict.com.
-<p>Reformated docs slightly based on suggestions by Chris Small.
- <p><b>1.65 28 Dec 2001</b></p>
- <p>Fixed borland_ibase class naming bug.
- <p>Now instead of using $rs->fields[0] internally, we use reset($rs->fields) so
- that we are compatible with ADODB_FETCH_ASSOC mode. Reported by Nico S.
- <p>Changed recordset constructor and _initrs() for oci8 so that it returns the field definitions even
- if no rows in the recordset. Reported by Rick Hickerson (rhickers#mv.mv.com).
- <p>Improved support for postgresql in GetInsertSQL and GetUpdateSQL by
- "mike" mike#partner2partner.com and "Ryan Bailey" rebel#windriders.com
- <p><b>1.64 20 Dec 2001</b></p>
-<p>Danny Milosavljevic <danny.milo#gmx.net> added some patches for MySQL error handling
-and displaying default values.
-<p>Fixed some ADODB_FETCH_BOTH inconsistencies in odbc and interbase.
-<p>Added more tests to test suite to cover ADODB_FETCH_* and ADODB_ERROR_HANDLER.
-<p>Added firebird (ibase) driver
-<p>Added borland_ibase driver for interbase 6.5
-<p><b>1.63 13 Dec 2001</b></p>
-Absolute to the adodb-lib.inc.php file not set properly. Fixed.<p>
-
-<p><b>1.62 11 Dec 2001</b></p>
-<p>Major speedup of ADOdb for low-end web sites by reducing the php code loading and compiling
-cycle. We conditionally compile not so common functions.
-Moved csv code to adodb-csvlib.inc.php to reduce adodb.inc.php parsing. This file
-is loaded only when the csv/proxy driver is used, or CacheExecute() is run.
-Also moved PageExecute(), GetSelectSQL() and GetUpdateSQL() core code to adodb-lib.inc.php.
-This reduced the 70K main adodb.inc.php file to 55K, and since at least 20K of the file
-is comments, we have reduced 50K of code in adodb.inc.php to 35K. There
- should be 35% reduction in memory and thus 35% speedup in compiling the php code for the
-main adodb.inc.php file.
-<p>Highly tuned SelectLimit() for oci8 for massive speed improvements on large files.
-Selecting 20 rows starting from the 20,000th row of a table is now 7 times faster.
-Thx to Tomas V V Cox.
-<p>Allow . and # in table definitions in GetInsertSQL and GetUpdateSQL.
- See ADODB_TABLE_REGEX constant. Thx to Ari Kuorikoski.
-<p>Added ADODB_PREFETCH_ROWS constant, defaulting to 10. This determines the number
-of records to prefetch in a SELECT statement. Only used by oci8.</p>
-<p>Added high portability Oracle class called oci8po. This uses ? for bind variables, and
-lower cases column names.</p>
-<p>Now all database drivers support $ADODB_FETCH_MODE, including interbase, ado, and odbc:
-ADODB_FETCH_NUM and ADODB_FETCH_ASSOC. ADODB_FETCH_BOTH is not fully implemented for all
-database drivers.
-<p><b>1.61 Nov 2001</b></p>
-<p>Added PO_RecordCount() and PO_Insert_ID(). PO stands for portable. Pablo Roca
- [pabloroca#mvps.org]</p>
-<p>GenID now returns 0 if not available. Safer is that you should check $conn->hasGenID
- for availability.</p>
-<p>M'soft ADO we now correctly close recordset in _close() peterd#telephonetics.co.uk</p>
-<p>MSSQL now supports GenID(). It generates a 16-byte GUID from mssql newid()
- function.</p>
-<p>Changed ereg_replace to preg_replace in SelectLimit. This is a fix for mssql.
- Ereg doesn't support t or n! Reported by marino Carlos xaplo#postnuke-espanol.org</p>
-<p>Added $recordset->connection. This is the ADOConnection object for the recordset.
-Works with cached and normal recordsets. Surprisingly, this had no affect on performance!</p>
-<p><b>1.54 15 Nov 2001</b></p>
-Fixed some more bugs in PageExecute(). I am getting sick of bug in this and will have to
-reconsider my QA here. The main issue is that I don't use PageExecute() and
-to check whether it is working requires a visual inspection of the html generated currently.
-It is possible to write a test script but it would be quite complicated :(
-<p> More speedups of SelectLimit() for DB2, Oci8, access, vfp, mssql.
-<p>
-
-<p><b>1.53 7 Nov 2001</b></p>
-Added support for ADODB_FETCH_ASSOC for ado and odbc drivers.<p>
-Tuned GetRowAssoc(false) in postgresql and mysql.<p>
-Stephen Van Dyke contributed ADOdb icon, accepted with some minor mods.<p>
-Enabled Affected_Rows() for postgresql<p>
-Speedup for Concat() using implode() - Benjamin Curtis ben_curtis#yahoo.com<p>
-Fixed some more bugs in PageExecute() to prevent infinite loops<p>
-<p><b>1.52 5 Nov 2001</b></p>
-Spelling error in CacheExecute() caused it to fail. $ql should be $sql in line 625!<p>
-Added fixes for parsing [ and ] in GetUpdateSQL().
-<p><b>1.51 5 Nov 2001</b></p>
-<p>Oci8 SelectLimit() speedup by using OCIFetch().
-<p>Oci8 was mistakenly reporting errors when $db->debug = true.
-<p>If a connection failed with ODBC, it was not correctly reported - fixed.
-<p>_connectionID was inited to -1, changed to false.
-<p>Added $rs->FetchRow(), to simplify API, ala PEAR DB
-<p>Added PEAR DB compat mode, which is still faster than PEAR! See adodb-pear.inc.php.
-<p>Removed postgres pconnect debugging statement.
-<p><b>1.50 31 Oct 2001</b></p>
-<p>ADOdbConnection renamed to ADOConnection, and ADOdbFieldObject to ADOFieldObject.
-<p>PageExecute() now checks for empty $rs correctly, and the errors in the docs on this subject have been fixed.
-<p>odbc_error() does not return 6 digit error correctly at times. Implemented workaround.
-<p>Added ADORecordSet_empty class. This will speedup INSERTS/DELETES/UPDATES because the return
-object created is much smaller.
-<p>Added Prepare() to odbc, and oci8 (but doesn't work properly for oci8 still).
-<p>Made pgsql a synonym for postgre7, and changed SELECT LIMIT to use OFFSET for compat with
-postgres 7.2.
-<p>Revised adodb-cryptsession.php thanks to Ari.
-<p>Set resources to false on _close, to force freeing of resources.
-<p>Added adodb-errorhandler.inc.php, adodb-errorpear.inc.php and raiseErrorFn on Freek's urging.
-<p>GetRowAssoc($toUpper=true): $toUpper added as default.
-<p>Errors when connecting to a database were not captured formerly. Now we do it correctly.
-<p><b>1.40 19 September 2001</b></p>
-<p>PageExecute() to implement page scrolling added. Code and idea by Iván Oliva.</p>
-<p>Some minor postgresql fixes.</p>
-<p>Added sequence support using GenID() for postgresql, oci8, mysql, interbase.</p>
-<p>Added UpdateBlob support for interbase (untested).</p>
-<p>Added encrypted sessions (see adodb-cryptsession.php). By Ari Kuorikoski <kuoriari#finebyte.com></p>
-<p><b>1.31 21 August 2001</b></p>
-<p>Many bug fixes thanks to "GaM3R (Cameron)" <gamr#outworld.cx>. Some session changes due to Gam3r.
-<p>Fixed qstr() to quote also.
-<p>rs2html() now pretty printed.
-<p>Jonathan Younger jyounger#unilab.com contributed the great idea GetUpdateSQL() and GetInsertSQL() which
-generates SQL to update and insert into a table from a recordset. Modify the recordset fields
-array, then can this function to generate the SQL (the SQL is not executed).
-<p>"Nicola Fankhauser" <nicola.fankhauser#couniq.com> found some bugs in date handling for mssql.</p>
-<p>Added minimal Oracle support for LOBs. Still under development.</p>
-Added $ADODB_FETCH_MODE so you can control whether recordsets return arrays which are
-numeric, associative or both. This is a global variable you set. Currently only MySQL, Oci8, Postgres
-drivers support this.
-<p>PostgreSQL properly closes recordsets now. Reported by several people.
-<p>
-Added UpdateBlob() for Oracle. A hack to make it easier to save blobs.
-<p>
-Oracle timestamps did not display properly. Fixed.
-<p><b>1.20 6 June 2001</b></p>
-<p>Now Oracle can connect using tnsnames.ora or server and service name</p>
-<p>Extensive Oci8 speed optimizations.
-Oci8 code revised to support variable binding, and /*+ FIRST_ROWS */ hint.</p>
-<p>Worked around some 4.0.6 bugs in odbc_fetch_into().</p>
-<p>Paolo S. Asioli paolo.asioli#libero.it suggested GetRowAssoc().</p>
-<p>Escape quotes for oracle wrongly set to '. Now '' is used.</p>
-<p>Variable binding now works in ODBC also.</p>
-<p>Jumped to version 1.20 because I don't like 13 :-)</p>
-<p><b>1.12 6 June 2001</b></p>
-<p>Changed $ADODB_DIR to ADODB_DIR constant to plug a security loophole.</p>
-<p>Changed _close() to close persistent connections also. Prevents connection leaks.</p>
-<p>Major revision of oracle and oci8 drivers.
-Added OCI_RETURN_NULLS and OCI_RETURN_LOBS to OCIFetchInto(). BLOB, CLOB and VARCHAR2 recognition
-in MetaType() improved. MetaColumns() returns columns in correct sort order.</p>
-<p>Interbase timestamp input format was wrong. Fixed.</p>
-<p><b>1.11 20 May 2001</b></p>
-<p>Improved file locking for Windows.</p>
-<p>Probabilistic flushing of cache to avoid avalanche updates when cache timeouts.</p>
-<p>Cached recordset timestamp not saved in some scenarios. Fixed.</p>
-<p><b>1.10 19 May 2001</b></p>
-<p>Added caching. CacheExecute() and CacheSelectLimit().
-<p>Added csv driver. See <a href="http://php.weblogs.com/adodb_csv">http://php.weblogs.com/ADODB_csv</a>.
-<p>Fixed SelectLimit(), SELECT TOP not working under certain circumstances.
-<p>Added better Frontbase support of MetaTypes() by Frank M. Kromann.
-<p><b>1.01 24 April 2001</b></p>
-<p>Fixed SelectLimit bug. not quoted properly.
-<p>SelectLimit: SELECT TOP -1 * FROM TABLE not support by Microsoft. Fixed.</p>
-<p>GetMenu improved by glen.davies#cce.ac.nz to support multiple hilited items<p>
-<p>FetchNextObject() did not work with only 1 record returned. Fixed bug reported by $tim#orotech.net</p>
-<p>Fixed mysql field max_length problem. Fix suggested by Jim Nicholson (jnich#att.com)</p>
-<p><b>1.00 16 April 2001</b></p>
-<p>Given some brilliant suggestions on how to simplify ADOdb by akul. You no longer need to
-setup $ADODB_DIR yourself, and ADOLoadCode() is automatically called by ADONewConnection(),
-simplifying the startup code.</p>
-<p>FetchNextObject() added. Suggested by Jakub Marecek. This makes FetchObject() obsolete, as
-this is more flexible and powerful.</p>
-<p>Misc fixes to SelectLimit() to support Access (top must follow distinct) and Fields()
-in the array recordset. From Reinhard Balling.</p>
-<p><b>0.96 27 Mar 2001</b></p>
-<p>ADOConnection Close() did not return a value correctly. Thanks to akul#otamedia.com.</p>
-<p>When the horrible magic_quotes is enabled, back-slash () is changed to double-backslash (\).
-This doesn't make sense for Microsoft/Sybase databases. We fix this in qstr().</p>
-<p>Fixed Sybase date problem in UnixDate() thanks to Toni Tunkkari. Also fixed MSSQL problem
-in UnixDate() - thanks to milhouse31#hotmail.com.</p>
-<p>MoveNext() moved to leaf classes for speed in MySQL/PostgreSQL. 10-15% speedup.</p>
-<p>Added null handling in bindInputArray in Execute() -- Ron Baldwin suggestion.</p>
-<p>Fixed some option tags. Thanks to john#jrmstudios.com.</p>
-<p><b>0.95 13 Mar 2001</b></p>
-<p>Added postgres7 database driver which supports LIMIT and other version 7 stuff in the future.</p>
-<p>Added SelectLimit to ADOConnection to simulate PostgreSQL's "select * from table limit 10 offset 3".
-Added helper function GetArrayLimit() to ADORecordSet.</p>
-<p>Fixed mysql metacolumns bug. Thanks to Freek Dijkstra (phpeverywhere#macfreek.com).</p>
-<p>Also many PostgreSQL changes by Freek. He almost rewrote the whole PostgreSQL driver!</p>
-<p>Added fix to input parameters in Execute for non-strings by Ron Baldwin.</p>
-<p>Added new metatype, X for TeXt. Formerly, metatype B for Blob also included
-text fields. Now 'B' is for binary/image data. 'X' for textual data.</p>
-<p>Fixed $this->GetArray() in GetRows().</p>
-<p>Oracle and OCI8: 1st parameter is always blank -- now warns if it is filled.</p>
-<p>Now <i>hasLimit</i> and <i>hasTop</i> added to indicate whether
-SELECT * FROM TABLE LIMIT 10 or SELECT TOP 10 * FROM TABLE are supported.</p>
-<p><b>0.94 04 Feb 2001</b></p>
-<p>Added ADORecordSet::GetRows() for compatibility with Microsoft ADO. Synonym for GetArray().</p>
-<p>Added new metatype 'R' to represent autoincrement numbers.</p>
-<p>Added ADORecordSet.FetchObject() to return a row as an object.</p>
-<p>Finally got a Linux box to test PostgreSql. Many fixes.</p>
-<p>Fixed copyright misspellings in 0.93.</p>
-<p>Fixed mssql MetaColumns type bug.</p>
-<p>Worked around odbc bug in PHP4 for sessions.</p>
-<p>Fixed many documentation bugs (affected_rows, metadatabases, qstr).</p>
-<p>Fixed MySQL timestamp format (removed comma).</p>
-<p>Interbase driver did not call ibase_pconnect(). Fixed.</p>
-<p><b>0.93 18 Jan 2002</b></p>
-<p>Fixed GetMenu bug.</p>
-<p>Simplified Interbase commit and rollback.</p>
-<p>Default behaviour on closing a connection is now to rollback all active transactions.</p>
-<p>Added field object handling for array recordset for future XML compatibility.</p>
-<p>Added arr2html() to convert array to html table.</p>
-<p><b>0.92 2 Jan 2002</b></p>
-<p>Interbase Commit and Rollback should be working again.</p>
-<p>Changed initialisation of ADORecordSet. This is internal and should not affect users. We
-are doing this to support cached recordsets in the future.</p>
-
-<p>Implemented ADORecordSet_array class. This allows you to simulate a database recordset
-with an array.</p>
-<p>Added UnixDate() and UnixTimeStamp() to ADORecordSet.</p>
-<p><b>0.91 21 Dec 2000</b></p>
-<p>Fixed ODBC so ErrorMsg() is working.</p>
-<p>Worked around ADO unrecognised null (0x1) value problem in COM.</p>
-<p>Added Sybase support for FetchField() type</p>
-<p>Removed debugging code and unneeded html from various files</p>
-<p>Changed to javadoc style comments to adodb.inc.php.</p>
-<p>Added maxsql as synonym for mysqlt</p>
-<p>Now ODBC downloads first 8K of blob by default
-<p><b>0.90 15 Nov 2000</b></p>
-<p>Lots of testing of Microsoft ADO. Should be more stable now.</p>
-<p>Added $ADODB_COUNTREC. Set to false for high speed selects.</p>
-<p>Added Sybase support. Contributed by Toni Tunkkari (toni.tunkkari#finebyte.com). Bug in Sybase
- API: GetFields is unable to determine date types.</p>
-<p>Changed behaviour of RecordSet.GetMenu() to support size parameter (listbox) properly.</p>
-<p>Added emptyDate and emptyTimeStamp to RecordSet class that defines how to represent
- empty dates.</p>
-<p>Added MetaColumns($table) that returns an array of ADOFieldObject's listing
- the columns of a table.</p>
-<p>Added transaction support for PostgresSQL -- thanks to "Eric G. Werk" egw#netguide.dk.</p>
-<p>Added adodb-session.php for session support.</p>
-<p><b>0.80 30 Nov 2000</b></p>
-<p>Added support for charSet for interbase. Implemented MetaTables for most databases.
- PostgreSQL more extensively tested.</p>
-<p><b>0.71 22 Nov 2000</b></p>
-<p>Switched from using require_once to include/include_once for backward compatability with PHP 4.02 and earlier.</p>
-<p><b>0.70 15 Nov 2000</b></p>
-<p>Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP,
-except in Oracle 7 driver due to a bug in php_oracle.dll.</p>
-<p>PostgreSQL database driver contributed by Alberto Cerezal (acerezalp#dbnet.es).
-</p>
-<p>Oci8 driver for Oracle 8 contributed by George Fourlanos (fou#infomap.gr).</p>
-<p>Added <i>mysqlt</i> database driver to support MySQL 3.23 which has transaction
- support. </p>
-<p>Oracle default date format (DD-MON-YY) did not match ADOdb default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date.</p>
-<p>Error message checking is now included in test suite.</p>
-<p>MoveNext() did not check EOF properly -- fixed.</p>
-<p><b>0.60 Nov 8 2000</b></p>
-<p>Fixed some constructor bugs in ODBC and ADO. Added ErrorNo function to ADOConnection
- class. </p>
-<p><b>0.51 Oct 18 2000</b></p>
-<p>Fixed some interbase bugs.</p>
-<p><b>0.50 Oct 16 2000</b></p>
-<p>Interbase commit/rollback changed to be compatible with PHP 4.03. </p>
-<p>CommitTrans( ) will now return true if transactions not supported. </p>
-<p>Conversely RollbackTrans( ) will return false if transactions not supported.
-</p>
-<p><b>0.46 Oct 12</b></p>
-Many Oracle compatibility issues fixed.
-<p><b>0.40 Sept 26</b></p>
-<p>Many bug fixes</p>
-<p>Now Code for BeginTrans, CommitTrans and RollbackTrans is working. So is the Affected_Rows
-and Insert_ID. Added above functions to test.php.</p>
-<p>ADO type handling was busted in 0.30. Fixed.</p>
-<p>Generalised Move( ) so it works will all databases, including ODBC.</p>
-<p><b>0.30 Sept 18</b></p>
-<p>Renamed ADOLoadDB to ADOLoadCode. This is clearer.</p>
-<p>Added BeginTrans, CommitTrans and RollbackTrans functions.</p>
-<p>Added Affected_Rows() and Insert_ID(), _affectedrows() and _insertID(), ListTables(),
- ListDatabases(), ListColumns().</p>
-<p>Need to add New_ID() and hasInsertID and hasAffectedRows, autoCommit </p>
-<p><b>0.20 Sept 12</b></p>
-<p>Added support for Microsoft's ADO.</p>
-<p>Added new field to ADORecordSet -- canSeek</p>
-<p>Added new parameter to _fetch($ignore_fields = false). Setting to true will
- not update fields array for faster performance.</p>
-<p>Added new field to ADORecordSet/ADOConnection -- dataProvider to indicate whether
- a class is derived from odbc or ado.</p>
-<p>Changed class ODBCFieldObject to ADOFieldObject -- not documented currently.</p>
-<p>Added benchmark.php and testdatabases.inc.php to the test suite.</p>
-<p>Added to ADORecordSet FastForward( ) for future high speed scrolling. Not documented.</p>
-<p>Realised that ADO's Move( ) uses relative positioning. ADOdb uses absolute.
-</p>
-<p><b>0.10 Sept 9 2000</b></p>
-<p>First release</p>
+<html><title>Old Changelog: ADOdb</title><body> +<h3>Old Changelog</h3> + +</p><p><b>3.92 22 Sept 2003</b> +</p><p>Added GetAssoc and CacheGetAssoc to connection object. +</p><p>Removed TextMax and CharMax functions from adodb.inc.php. +</p><p>HasFailedTrans() returned false when trans failed. Fixed. +</p><p>Moved perf driver classes into adodb/perf/*.php. +</p><p>Misc improvements to performance monitoring, including UI(). +</p><p>RETVAL in mssql Parameter(), we do not append @ now. +</p><p>Added Param($name) to connection class, returns '?' or ":$name", for defining + bind parameters portably. +</p><p>LogSQL traps affected_rows() and saves its value properly now. Also fixed oci8 + _stmt and _affectedrows() bugs. +</p><p>Session code timestamp check for oci8 works now. Formerly default NLS_DATE_FORMAT + stripped off time portion. Thx to Tony Blair (tonanbarbarian#hotmail.com). Also + added new $conn->datetime field to oci8, controls whether MetaType() returns + 'D' ($this->datetime==false) or 'T' ($this->datetime == true) for DATE type. +</p><p>Fixed bugs in adodb-cryptsession.inc.php and adodb-session-clob.inc.php. +</p><p>Fixed misc bugs in adodb_key_exists, GetInsertSQL() and GetUpdateSQL(). +</p><p>Tuned include_once handling to reduce file-system checking overhead. +</p><p><b>3.91 9 Sept 2003</b> +</p><p>Only released to InterAkt +</p><p>Added LogSQL() for sql logging and $ADODB_NEWCONNECTION to override factory + for driver instantiation. +</p><p>Added IfNull($field,$ifNull) function, thx to johnwilk#juno.com +</p><p>Added portable substr support. +</p><p>Now rs2html() has new parameter, $echo. Set to false to return $html instead + of echoing it. +</p><p><b>3.90 5 Sept 2003</b> +</p><p>First beta of performance monitoring released. +</p><p>MySQL supports MetaTable() masking. +</p><p>Fixed key_exists() bug in adodb-lib.inc.php +</p><p>Added sp_executesql Prepare() support to mssql. +</p><p>Added bind support to db2. +</p><p>Added swedish language file - Christian Tiberg" christian#commsoft.nu +</p><p>Bug in drop index for mssql data dict fixed. Thx to Gert-Rainer Bitterlich. +</p><p>Left join setting for oci8 was wrong. Thx to johnwilk#juno.com +</p><p><b>3.80 27 Aug 2003</b> +</p><p>Patch for PHP 4.3.3 cached recordset csv2rs() fread loop incompatibility. +</p><p>Added matching mask for MetaTables. Only for oci8, mssql and postgres currently. +</p><p>Rewrite of "oracle" driver connection code, merging with "oci8", by Gaetano. +</p><p>Added better debugging for Smart Transactions. +</p><p>Postgres DBTimeStamp() was wrongly using TO_DATE. Changed to TO_TIMESTAMP. +</p><p>ADODB_FETCH_CASE check pushed to ADONewConnection to allow people to define + it after including adodb.inc.php. +</p><p>Added portugese (brazilian) to languages. Thx to "Levi Fukumori". +</p><p>Removed arg3 parameter from Execute/SelectLimit/Cache* functions. +</p><p>Execute() now accepts 2-d array as $inputarray. Also changed docs of fnExecute() + to note change in sql query counting with 2-d arrays. +</p><p>Added MONEY to MetaType in PostgreSQL. +</p><p>Added more debugging output to CacheFlush(). +</p><p><b>3.72 9 Aug 2003</b> +</p><p>Added qmagic($str), which is a qstr($str) that auto-checks for magic quotes + and does the right thing... +</p><p>Fixed CacheFlush() bug - Thx to martin#gmx.de +</p><p>Walt Boring contributed MetaForeignKeys for postgres7. +</p><p>_fetch() called _BlobDecode() wrongly in interbase. Fixed. +</p><p>adodb_time bug fixed with dates after 2038 fixed by Jason Pell. http://phplens.com/lens/lensforum/msgs.php?id=6980 +</p><p><b>3.71 4 Aug 2003</b> +</p><p>The oci8 driver, MetaPrimaryKeys() did not check the owner correctly when $owner + == false. +</p><p>Russian language file contributed by "Cyrill Malevanov" cyrill#malevanov.spb.ru. +</p><p>Spanish language file contributed by "Horacio Degiorgi" horaciod#codigophp.com. +</p><p>Error handling in oci8 bugfix - if there was an error in Execute(), then when + calling ErrorNo() and/or ErrorMsg(), the 1st call would return the error, but + the 2nd call would return no error. +</p><p>Error handling in odbc bugfix. ODBC would always return the last error, even + if it happened 5 queries ago. Now we reset the errormsg to '' and errorno to + 0 everytime before CacheExecute() and Execute(). +</p><p><b>3.70 29 July 2003</b> +</p><p>Added new SQLite driver. Tested on PHP 4.3 and PHP 5. +</p><p>Added limited "sapdb" driver support - mainly date support. +</p><p>The oci8 driver did not identify NUMBER with no defined precision correctly. +</p><p>Added ADODB_FORCE_NULLS, if set, then PHP nulls are converted to SQL nulls + in GetInsertSQL/GetUpdateSQL. +</p><p>DBDate() and DBTimeStamp() format for postgresql had problems. Fixed. +</p><p>Added tableoptions to ChangeTableSQL(). Thx to Mike Benoit. +</p><p>Added charset support to postgresql. Thx to Julian Tarkhanov. +</p><p>Changed OS check for MS-Windows to prevent confusion with darWIN (MacOS) +</p><p>Timestamp format for db2 was wrong. Changed to yyyy-mm-dd-hh.mm.ss.nnnnnn. +</p><p>adodb-cryptsession.php includes wrong. Fixed. +</p><p>Added MetaForeignKeys(). Supported by mssql, odbc_mssql and oci8. +</p><p>Fixed some oci8 MetaColumns/MetaPrimaryKeys bugs. Thx to Walt Boring. +</p><p>adodb_getcount() did not init qryRecs to 0. Missing "WHERE" clause checking + in GetUpdateSQL fixed. Thx to Sebastiaan van Stijn. +</p><p>Added support for only 'VIEWS' and "TABLES" in MetaTables. From Walt Boring. +</p><p>Upgraded to adodb-xmlschema.inc.php 0.0.2. +</p><p>NConnect for mysql now returns value. Thx to Dennis Verspuij. +</p><p>ADODB_FETCH_BOTH support added to interbase/firebird. +</p><p>Czech language file contributed by Kamil Jakubovic jake#host.sk. +</p><p>PostgreSQL BlobDecode did not use _connectionID properly. Thx to Juraj Chlebec. +</p><p>Added some new initialization stuff for Informix. Thx to "Andrea Pinnisi" pinnisi#sysnet.it +</p><p>ADODB_ASSOC_CASE constant wrong in sybase _fetch(). Fixed. +</p><p><b>3.60 16 June 2003</b> +</p><p>We now SET CONCAT_NULL_YIELDS_NULL OFF for odbc_mssql driver to be compat with + mssql driver. +</p><p>The property $emptyDate missing from connection class. Also changed 1903 to + constant (TIMESTAMP_FIRST_YEAR=100). Thx to Sebastiaan van Stijn. +</p><p>ADOdb speedup optimization - we now return all arrays by reference. +</p><p>Now DBDate() and DBTimeStamp() now accepts the string 'null' as a parameter. + Suggested by vincent. +</p><p>Added GetArray() to connection class. +</p><p>Added not_null check in informix metacolumns(). +</p><p>Connection parameters for postgresql did not work correctly when port was defined. +</p><p>DB2 is now a tested driver, making adodb 100% compatible. Extensive changes + to odbc driver for DB2, including implementing serverinfo() and SQLDate(), switching + to SQL_CUR_USE_ODBC as the cursor mode, and lastAffectedRows and SelectLimit() + fixes. +</p><p>The odbc driver's FetchField() field names did not obey ADODB_ASSOC_CASE. Fixed. +</p><p>Some bugs in adodb_backtrace() fixed. +</p><p>Added "INT IDENTITY" type to adorecordset::MetaType() to support odbc_mssql + properly. +</p><p>MetaColumns() for oci8, mssql, odbc revised to support scale. Also minor revisions + to odbc MetaColumns() for vfp and db2 compat. +</p><p>Added unsigned support to mysql datadict class. Thx to iamsure. +</p><p>Infinite loop in mssql MoveNext() fixed when ADODB_FETCH_ASSOC used. Thx to + Josh R, Night_Wulfe#hotmail.com. +</p><p>ChangeTableSQL contributed by Florian Buzin. +</p><p>The odbc_mssql driver now sets CONCAT_NULL_YIELDS_NULL OFF for compat with + mssql driver. +</p> + +<p><b>3.50 19 May 2003</b></p> +<p>Fixed mssql compat with FreeTDS. FreeTDS does not implement mssql_fetch_assoc(). +<p>Merged back connection and recordset code into adodb.inc.php. +<p>ADOdb sessions using oracle clobs contributed by achim.gosse#ddd.de. See adodb-session-clob.php. +<p>Added /s modifier to preg_match everywhere, which ensures that regex does not + stop at /n. Thx Pao-Hsi Huang. +<p>Fixed error in metacolumns() for mssql. +<p>Added time format support for SQLDate. +<p>Image => B added to metatype. +<p>MetaType now checks empty($this->blobSize) instead of empty($this). +<p>Datadict has beta support for informix, sybase (mapped to mssql), db2 and generic + (which is a fudge). +<p>BlobEncode for postgresql uses pg_escape_bytea, if available. Needed for compat + with 7.3. +<p>Added $ADODB_LANG, to support multiple languages in MetaErrorMsg(). +<p>Datadict can now parse table definition as declarative text. +<p>For DataDict, oci8 autoincrement trigger missing semi-colon. Fixed. +<p>For DataDict, when REPLACE flag enabled, drop sequence in datadict for autoincrement + field in postgres and oci8.s +<p>Postgresql defaults to template1 database if no database defined in connect/pconnect. +<p>We now clear _resultid in postgresql if query fails. +<p><b>3.40 19 May 2003</b></p> +<p>Added insert_id for odbc_mssql. +<p>Modified postgresql UpdateBlobFile() because it did not work in safe mode. +<p>Now connection object is passed to raiseErrorFn as last parameter. Needed by + StartTrans(). +<p>Added StartTrans() and CompleteTrans(). It is recommended that you do not modify + transOff, but use the above functions. +<p>oci8po now obeys ADODB_ASSOC_CASE settings. +<p>Added virtualized error codes, using PEAR DB equivalents. Requires you to manually + include adodb-error.inc.php yourself, with MetaError() and MetaErrorMsg($errno). +<p>GetRowAssoc for mysql and pgsql were flawed. Fix by Ross Smith. +<p>Added to datadict types I1, I2, I4 and I8. Changed datadict type 'T' to map + to timestamp instead of datetime for postgresql. +<p>Error handling in ExecuteSQLArray(), adodb-datadict.inc.php did not work. +<p>We now auto-quote postgresql connection parameters when building connection + string. +<p>Added session expiry notification. +<p>We now test with odbc mysql - made some changes to odbc recordset constructor. +<p>MetaColumns now special cases access and other databases for odbc. +<p><b>3.31 17 March 2003</b></p> +<p>Added row checking for _fetch in postgres. +<p>Added Interval type to MetaType for postgres. +<p>Remapped postgres driver to call postgres7 driver internally. +<p>Adorecordset_array::getarray() did not return array when nRows >= 0. +<p>Postgresql: at times, no error message returned by pg_result_error() but error + message returned in pg_last_error(). Recoded again. +<p>Interbase blob's now use chunking for updateblob. +<p>Move() did not set EOF correctly. Reported by Jorma T. +<p>We properly support mysql timestamp fields when we are creating mysql tables + using the data-dict interface. +<p>Table regex includes backticks character now. +<p><b>3.30 3 March 2003</b></p> +<p>Added $ADODB_EXTENSION and $ADODB_COMPAT_FETCH constant. +<p>Made blank1stItem configurable using syntax "value:text" in GetMenu/GetMenu2. + Thx to Gabriel Birke. +<p>Previously ADOdb differed from the Microsoft standard because it did not define + what to set $this->fields when EOF was reached. Now at EOF, ADOdb sets $this->fields + to false for all databases, which is consist with Microsoft's implementation. + Postgresql and mysql have always worked this way (in 3.11 and earlier). If you + are experiencing compatibility problems (and you are not using postgresql nor + mysql) on upgrading to 3.30, try setting the global variables $ADODB_COUNTRECS + = true (which is the default) and $ADODB_FETCH_COMPAT = true (this is a new + global variable). +<p>We now check both pg_result_error and pg_last_error as sometimes pg_result_error + does not display anything. Iman Mayes +<p> We no longer check for magic quotes gpc in Quote(). +<p> Misc fixes for table creation in adodb-datadict.inc.php. Thx to iamsure. +<p> Time calculations use adodb_time library for all negative timestamps due to + problems in Red Hat 7.3 or later. Formerly, only did this for Windows. +<p> In mssqlpo, we now check if $sql in _query is a string before we change || + to +. This is to support prepared stmts. +<p> Move() and MoveLast() internals changed to support to support EOF and $this->fields + change. +<p> Added ADODB_FETCH_BOTH support to mssql. Thx to Angel Fradejas afradejas#mediafusion.es +<p> We now check if link resource exists before we run mysql_escape_string in + qstr(). +<p> Before we flock in csv code, we check that it is not a http url. +<p><b>3.20 17 Feb 2003</b></p> +<p>Added new Data Dictionary classes for creating tables and indexes. Warning + - this is very much alpha quality code. The API can still change. See adodb/tests/test-datadict.php + for more info. +<p>We now ignore $ADODB_COUNTRECS for mysql, because PHP truncates incomplete + recordsets when mysql_unbuffered_query() is called a second time. +<p>Now postgresql works correctly when $ADODB_COUNTRECS = false. +<p>Changed _adodb_getcount to properly support SELECT DISTINCT. +<p>Discovered that $ADODB_COUNTRECS=true has some problems with prepared queries + - suspect PHP bug. +<p>Now GetOne and GetRow run in $ADODB_COUNTRECS=false mode for better performance. +<p>Added support for mysql_real_escape_string() and pg_escape_string() in qstr(). +<p>Added an intermediate variable for mysql _fetch() and MoveNext() to store fields, + to prevent overwriting field array with boolean when mysql_fetch_array() returns + false. +<p>Made arrays for getinsertsql and getupdatesql case-insensitive. Suggested by + Tim Uckun" tim#diligence.com +<p><b>3.11 11 Feb 2003</b></p> +<p>Added check for ADODB_NEVER_PERSIST constant in PConnect(). If defined, then + PConnect() will actually call non-persistent Connect(). +<p>Modified interbase to properly work with Prepare(). +<p>Added $this->ibase_timefmt to allow you to change the date and time format. +<p>Added support for $input_array parameter in CacheFlush(). +<p>Added experimental support for dbx, which was then removed when i found that + it was slower than using native calls. +<p>Added MetaPrimaryKeys for mssql and ibase/firebird. +<p>Added new $trim parameter to GetCol and CacheGetCol +<p>Uses updated adodb-time.inc.php 0.06. +<p><b>3.10 27 Jan 2003</b> +<p>Added adodb_date(), adodb_getdate(), adodb_mktime() and adodb-time.inc.php. +<p>For interbase, added code to handle unlimited number of bind parameters. From + Daniel Hasan daniel#hasan.cl. +<p>Added BlobDecode and UpdateBlob for informix. Thx to Fernando Ortiz. +<p>Added constant ADODB_WINDOWS. If defined, means that running on Windows. +<p>Added constant ADODB_PHPVER which stores php version as a hex num. Removed + $ADODB_PHPVER variable. +<p>Felho Bacsi reported a minor white-space regular expression problem in GetInsertSQL. +<p>Modified ADO to use variant to store _affectedRows +<p>Changed ibase to use base class Replace(). Modified base class Replace() to + support ibase. +<p>Changed odbc to auto-detect when 0 records returned is wrong due to bad odbc + drivers. +<p>Changed mssql to use datetimeconvert ini setting only when 4.30 or later (does + not work in 4.23). +<p>ExecuteCursor($stmt, $cursorname, $params) now accepts a new $params array + of additional bind parameters -- William Lovaton walovaton#yahoo.com.mx. +<p>Added support for sybase_unbuffered_query if ADODB_COUNTRECS == false. Thx + to chuck may. +<p>Fixed FetchNextObj() bug. Thx to Jorma Tuomainen. +<p>We now use SCOPE_IDENTITY() instead of @@IDENTITY for mssql - thx to marchesini#eside.it +<p>Changed postgresql movenext logic to prevent illegal row number from being + passed to pg_fetch_array(). +<p>Postgresql initrs bug found by "Bogdan RIPA" bripa#interakt.ro $f1 accidentally + named $f +<p><b>3.00 6 Jan 2003</b> +<p>Fixed adodb-pear.inc.php syntax error. +<p>Improved _adodb_getcount() to use SELECT COUNT(*) FROM ($sql) for languages + that accept it. +<p>Fixed _adodb_getcount() caching error. +<p>Added sql to retrive table and column info for odbc_mssql. +<p><strong>2.91 3 Jan 2003</strong> +<p>Revised PHP version checking to use $ADODB_PHPVER with legal values 0x4000, + 0x4050, 0x4200, 0x4300. +<p>Added support for bytea fields and oid blobs in postgres by allowing BlobDecode() + to detect and convert non-oid fields. Also added BlobEncode to postgres when + you want to encode oid blobs. +<p>Added blobEncodeType property for connections to inform phpLens what encoding + method to use for blobs. +<p>Added BlobDecode() and BlobEncode() to base ADOConnection class. +<p>Added umask() to _gencachename() when creating directories. +<p>Added charPage for ado drivers, so you can set the code page. +<pre> +$conn->charPage = CP_UTF8; +$conn->Connect($dsn); +</pre> +<p>Modified _seek in mysql to check for num rows=0. +<p>Added to metatypes new informix types for IDS 9.30. Thx Fernando Ortiz. +<p>_maxrecordcount returned in CachePageExecute $rsreturn +<p>Fixed sybase cacheselectlimit( ) problems +<p>MetaColumns() max_length should use precision for types X and C for ms access. + Fixed. +<p>Speedup of odbc non-SELECT sql statements. +<p>Added support in MetaColumns for Wide Char types for ODBC. We halve max_length + if unicode/wide char. +<p>Added 'B' to types handled by GetUpdateSQL/GetInsertSQL. +<p>Fixed warning message in oci8 driver with $persist variable when using PConnect. +<p><b>2.90 11 Dec 2002</b> +<p>Mssql and mssqlpo and oci8po now support ADODB_ASSOC_CASE. +<p>Now MetaType() can accept a field object as the first parameter. +<p>New $arr = $db->ServerInfo( ) function. Returns $arr['description'] which + is the string description, and $arr['version']. +<p>PostgreSQL and MSSQL speedups for insert/updates. +<p> Implemented new SetFetchMode() that removes the need to use $ADODB_FETCH_MODE. + Each connection has independant fetchMode. +<p>ADODB_ASSOC_CASE now defaults to 2, use native defaults. This is because we + would break backward compat for too many applications otherwise. +<p>Patched encrypted sessions to use replace() +<p>The qstr function supports quoting of nulls when escape character is \ +<p>Rewrote bits and pieces of session code to check for time synch and improve + reliability. +<p>Added property ADOConnection::hasTransactions = true/false; +<p>Added CreateSequence and DropSequence functions +<p>Found misplaced MoveNext() in adodb-postgres.inc.php. Fixed. +<p>Sybase SelectLimit not reliable because 'set rowcount' not cached - fixed. +<p>Moved ADOConnection to adodb-connection.inc.php and ADORecordSet to adodb-recordset.inc.php. + This allows us to use doxygen to generate documentation. Doxygen doesn't like + the classes in the main adodb.inc.php file for some mysterious reason. +<p><b>2.50, 14 Nov 2002</b> +<p>Added transOff and transCnt properties for disabling (transOff = true) and + tracking transaction status (transCnt>0). +<p>Added inputarray handling into _adodb_pageexecute_all_rows - "Ross Smith" RossSmith#bnw.com. +<p>Fixed postgresql inconsistencies in date handling. +<p>Added support for mssql_fetch_assoc. +<p>Fixed $ADODB_FETCH_MODE bug in odbc MetaTables() and MetaPrimaryKeys(). +<p>Accidentally declared UnixDate() twice, making adodb incompatible with php + 4.3.0. Fixed. +<p>Fixed pager problems with some databases that returned -1 for _currentRow on + MoveLast() by switching to MoveNext() in adodb-lib.inc.php. +<p>Also fixed uninited $discard in adodb-lib.inc.php. +<p><b>2.43, 25 Oct 2002</b></p> +Added ADODB_ASSOC_CASE constant to better support ibase and odbc field names. +<p>Added support for NConnect() for oracle OCINLogin. +<p>Fixed NumCols() bug. +<p>Changed session handler to use Replace() on write. +<p>Fixed oci8 SelectLimit aggregate function bug again. +<p>Rewrote pivoting code. +<p><b>2.42, 4 Oct 2002</b></p> +<p>Fixed ibase_fetch() problem with nulls. Also interbase now does automatic blob + decoding, and is backward compatible. Suggested by Heinz Hombergs heinz#hhombergs.de. +<p>Fixed postgresql MoveNext() problems when called repeatedly after EOF. Also + suggested by Heinz Hombergs. +<p>PageExecute() does not rewrite queries if SELECT DISTINCT is used. Requested + by hans#velum.net +<p>Added additional fixes to oci8 SelectLimit handling with aggregate functions + - thx to Christian Bugge for reporting the problem. +<p><b>2.41, 2 Oct 2002</b></p> +<p>Fixed ADODB_COUNTRECS bug in odbc. Thx to Joshua Zoshi jzoshi#hotmail.com. +<p>Increased buffers for adodb-csvlib.inc.php for extremely long sql from 8192 + to 32000. +<p>Revised pivottable.inc.php code. Added better support for aggregate fields. +<p>Fixed mysql text/blob types problem in MetaTypes base class - thx to horacio + degiorgi. +<p>Added SQLDate($fmt,$date) function, which allows an sql date format string + to be generated - useful for group by's. +<p>Fixed bug in oci8 SelectLimit when offset>100. +<p><b>2.40 4 Sept 2002</b></p> +<p>Added new NLS_DATE_FORMAT property to oci8. Suggested by Laurent NAVARRO ln#altidev.com +<p>Now use bind parameters in oci8 selectlimit for better performance. +<p>Fixed interbase replaceQuote for dialect != 1. Thx to "BEGUIN Pierre-Henri + - INFOCOB" phb#infocob.com. +<p>Added white-space check to QA. +<p>Changed unixtimestamp to support fractional seconds (we always round down/floor + the seconds). Thanks to beezly#beezly.org.uk. +<p>Now you can set the trigger_error type your own user-defined type in adodb-errorhandler.inc.php. + Suggested by Claudio Bustos clbustos#entelchile.net. +<p>Added recordset filters with rsfilter.inc.php. +<p>$conn->_rs2rs does not create a new recordset when it detects it is of type + array. Some trickery there as there seems to be a bug in Zend Engine +<p>Added render_pagelinks to adodb-pager.inc.php. Code by "Pablo Costa" pablo#cbsp.com.br. +<p>MetaType() speedup in adodb.inc.php by using hashing instead of switch. Best + performance if constant arrays are supported, as they are in PHP5. +<p>adodb-session.php now updates only the expiry date if the crc32 check indicates + that the data has not been modified. +<p><b>2.31 20 Aug 2002</b></p> +<p>Made changes to pivottable.inc.php due to daniel lucuzaeu's suggestions (we sum the pivottable column if desired). +<p>Fixed ErrorNo() in postgres so it does not depend on _errorMsg property. +<p>Robert Tuttle added support for oracle cursors. See ExecuteCursor(). +<p>Fixed Replace() so it works with mysql when updating record where data has not changed. Reported by +Cal Evans (cal#calevans.com). +<p><b>2.30 1 Aug 2002</b></p> +<p>Added pivottable.inc.php. Thanks to daniel.lucazeau#ajornet.com for the original + concept. +<p>Added ADOConnection::outp($msg,$newline) to output error and debugging messages. Now +you can override this using the ADODB_OUTP constant and use your own output handler. +<p>Changed == to === for 'null' comparison. Reported by ericquil#yahoo.com +<p>Fixed mssql SelectLimit( ) bug when distinct used. +<p><b>2.30 1 Aug 2002</b></p> +<p>New GetCol() and CacheGetCol() from ross#bnw.com that returns the first field as a 1 dim array. +<p>We have an empty recordset, but RecordCount() could return -1. Fixed. Reported by "Jonathan Polansky" jonathan#polansky.com. +<p>We now check for session variable changes using strlen($sessval).crc32($sessval). +Formerly we only used crc32(). +<p>Informix SelectLimit() problem with $ADODB_COUNTRECS fixed. +<p>Fixed informix SELECT FIRST x DISTINCT, and not SELECT DISTINCT FIRST x - reported by F Riosa +<p>Now default adodb error handlers ignores error if @ used. +<p>If you set $conn->autoRollback=true, we auto-rollback persistent connections for odbc, mysql, oci8, mssql. +Default for autoRollback is false. No need to do so for postgres. +As interbase requires a transaction id (what a flawed api), we don't do it for interbase. +<p>Changed PageExecute() to use non-greedy preg_match when searching for "FROM" keyword. +<p><b>2.20 9 July 2002</b></p> +<p>Added CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql). +<p>Added $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs + date offsets. Useful for scheduling appointments. +<p>Added connection properties: leftOuter, rightOuter that hold left and right + outer join operators. +<p>Added connection property: ansiOuter to indicate whether ansi outer joins supported. +<p>New driver <i>mssqlpo</i>, the portable mssql driver, which converts string + concat operator from || to +. +<p>Fixed ms access bug - SelectLimit() did not support ties - fixed. +<p>Karsten Kraus (Karsten.Kraus#web.de), contributed error-handling code to ADONewConnection. + Unfortunately due to backward compat problems, had to rollback most of the changes. +<p>Added new parameter to GetAssoc() to allow returning an array of key-value pairs, +ignoring any additional columns in the recordset. Off by default. +<p>Corrected mssql $conn->sysDate to return only date using convert(). +<p>CacheExecute() improved debugging output. +<p>Changed rs2html() so newlines are converted to BR tags. Also optimized rs2html() based +on feedback by "Jerry Workman" jerry#mtncad.com. +<p>Added support for Replace() with Interbase, using DELETE and INSERT. +<p>Some minor optimizations (mostly removing & references when passing arrays). +<p>Changed GenID() to allows id's larger than the size of an integer. +<p>Added force_session property to oci8 for better updateblob() support. +<p>Fixed PageExecute() which did not work properly with sql containing GROUP BY. +<p><b>2.12 12 June 2002</b></p> +<p>Added toexport.inc.php to export recordsets in CSV and tab-delimited format. +<p>CachePageExecute() does not work - fixed - thx John Huong. +<p>Interbase aliases not set properly in FetchField() - fixed. Thx Stefan Goethals. +<p>Added cache property to adodb pager class. The number of secs to cache recordsets. +<p>SQL rewriting bug in pageexecute() due to skipping of newlines due to missing /s modifier. Fixed. +<p>Max size of cached recordset due to a bug was 256000 bytes. Fixed. +<p>Speedup of 1st invocation of CacheExecute() by tuning code. +<p>We compare $rewritesql with $sql in pageexecute code in case of rewrite failure. +<p><b>2.11 7 June 2002</b></p> +<p>Fixed PageExecute() rewrite sql problem - COUNT(*) and ORDER BY don't go together with + mssql, access and postgres. Thx to Alexander Zhukov alex#unipack.ru +<p>DB2 support for CHARACTER type added - thx John Huong huongch#bigfoot.com +<p>For ado, $argProvider not properly checked. Fixed - kalimero#ngi.it +<p>Added $conn->Replace() function for update with automatic insert if the record does not exist. + Supported by all databases except interbase. +<p><b>2.10 4 June 2002</b></p> +<p>Added uniqueSort property to indicate mssql ORDER BY cols must be unique. +<p>Optimized session handler by crc32 the data. We only write if session data has changed. +<p>adodb_sess_read in adodb-session.php now returns ''correctly - thanks to Jorma Tuomainen, webmaster#wizactive.com +<p>Mssql driver did not throw EXECUTE errors correctly because ErrorMsg() and ErrorNo() called in wrong order. +Pointed out by Alexios Fakos. Fixed. +<p>Changed ado to use client cursors. This fixes BeginTran() problems with ado. +<p>Added handling of timestamp type in ado. +<p>Added to ado_mssql support for insert_id() and affected_rows(). +<p>Added support for mssql.datetimeconvert=0, available since php 4.2.0. +<p>Made UnixDate() less strict, so that the time is ignored if present. +<p>Changed quote() so that it checks for magic_quotes_gpc. +<p>Changed maxblobsize for odbc to default to 64000. +<p><b>2.00 13 May 2002</b></p> +<p>Added drivers <i>informix72</i> for pre-7.3 versions, and <i>oci805</i> for + oracle 8.0.5, and postgres64 for postgresql 6.4 and earlier. The postgres and postgres7 drivers + are now identical. +<p>Interbase now partially supports ADODB_FETCH_BOTH, by defaulting to ASSOC mode. +<p>Proper support for blobs in mssql. Also revised blob support code +is base class. Now UpdateBlobFile() calls UpdateBlob() for consistency. +<p>Added support for changed odbc_fetch_into api in php 4.2.0 +with $conn->_has_stupid_odbc_fetch_api_change. +<p>Fixed spelling of tablock locking hint in GenID( ) for mssql. +<p>Added RowLock( ) to several databases, including oci8, informix, sybase, etc. + Fixed where error in mssql RowLock(). +<p>Added sysDate and sysTimeStamp properties to most database drivers. These are the sql +functions/constants for that database that return the current date and current timestamp, and +are useful for portable inserts and updates. +<p>Support for RecordCount() caused date handling in sybase and mssql to break. +Fixed, thanks to Toni Tunkkari, by creating derived classes for ADORecordSet_array for +both databases. Generalized using arrayClass property. Also to support RecordCount(), +changed metatype handling for ado drivers. Now the type returned in FetchField + is no longer a number, but the 1-char data type returned by MetaType. + At the same time, fixed a lot of date handling. Now mssql support dmy and mdy date formats. +Also speedups in sybase and mssql with preg_match and ^ in date/timestamp handling. +Added support in sybase and mssql for 24 hour clock in timestamps (no AM/PM). +<p>Extensive revisions to informix driver - thanks to Samuel CARRIERE samuel_carriere#hotmail.com +<p>Added $ok parameter to CommitTrans($ok) for easy rollbacks. +<p>Fixed odbc MetaColumns and MetaTables to save and restore $ADODB_FETCH_MODE. +<p>Some odbc drivers did not call the base connection class constructor. Fixed. +<p>Fixed regex for GetUpdateSQL() and GetInsertSQL() to support more legal character combinations. + +<p><b>1.99 21 April 2002</b></p> +<p>Added emulated RecordCount() to all database drivers if $ADODB_COUNTRECS = true + (which it is by default). Inspired by Cristiano Duarte (cunha17#uol.com.br). +<p>Unified stored procedure support for mssql and oci8. Parameter() and PrepareSP() + functions implemented. +<p>Added support for SELECT FIRST in informix, modified hasTop property to support + this. +<p>Changed csv driver to handle updates/deletes/inserts properly (when Execute() returns true). +Bind params also work now, and raiseErrorFn with csv driver. Added csv driver to QA process. +<p>Better error checking in oci8 UpdateBlob() and UpdateBlobFile(). +<p>Added TIME type to MySQL - patch by Manfred h9125297#zechine.wu-wien.ac.at +<p>Prepare/Execute implemented for Interbase/Firebird +<p>Changed some regular expressions to be anchored by /^ $/ for speed. +<p>Added UnixTimeStamp() and UnixDate() to ADOConnection(). Now these functions + are in both ADOConnection and ADORecordSet classes. +<p>Empty recordsets were not cached - fixed. +<p>Thanks to Gaetano Giunta (g.giunta#libero.it) for the oci8 code review. We + didn't agree on everything, but i hoped we agreed to disagree! +<p><b>1.90 6 April 2002</b></p> +<p>Now all database drivers support fetch modes ADODB_FETCH_NUM and ADODB_FETCH_ASSOC, though + still not fully tested. Eg. Frontbase, Sybase, Informix. +<p>NextRecordSet() support for mssql. Contributed by "Sven Axelsson" sven.axelsson#bokochwebb.se +<p>Added blob support for SQL Anywhere. Contributed by Wade Johnson wade#wadejohnson.de +<p>Fixed some security loopholes in server.php. Server.php also supports fetch mode. +<p>Generalized GenID() to support odbc and mssql drivers. Mssql no longer generates GUID's. +<p>Experimental RowLock($table,$where) for mssql. +<p>Properly implemented Prepare() in oci8 and ODBC. +<p>Added Bind() support to oci8 to support Prepare(). +<p>Improved error handler. Catches CacheExecute() and GenID() errors now. +<p>Now if you are running php from the command line, debugging messages do not output html formating. +Not 100% complete, but getting there. +<p><b>1.81 22 March 2002</b></p> +<p>Restored default $ADODB_FETCH_MODE = ADODB_FETCH_DEFAULT for backward compatibility. +<p>SelectLimit for oci8 improved - Our FIRST_ROWS optimization now does not overwrite existing hint. +<p>New Sybase SQL Anywhere driver. Contributed by Wade Johnson wade#wadejohnson.de +<p><b>1.80 15 March 2002</b></p> +<p>Redesigned directory structure of ADOdb files. Added new driver directory where +all database drivers reside. +<p>Changed caching algorithm to create subdirectories. Now we scale better. +<p>Informix driver now supports insert_id(). Contribution by "Andrea Pinnisi" pinnisi#sysnet.it +<p>Added experimental ISO date and FetchField support for informix. +<p>Fixed a quoting bug in Execute() with bind parameters, causing problems with blobs. +<p>Mssql driver speedup by 10-15%. +<p>Now in CacheExecute($secs2cache,$sql,...), $secs2cache is optional. If missing, it will +take the value defined in $connection->cacheSecs (default is 3600 seconds). Note that +CacheSelectLimit(), the secs2cache is still compulsory - sigh. +<p>Sybase SQL Anywhere driver (using ODBC) contributed by Wade Johnson wade#wadejohnson.de +<p><b>1.72 8 March 2002</b></p> +<p>Added @ when returning Fields() to prevent spurious error - "Michael William Miller" mille562#pilot.msu.edu +<p>MetaDatabases() for postgres contributed by Phil pamelant#nerim.net + <p>Mitchell T. Young (mitch#youngfamily.org) contributed informix driver. + <p>Fixed rs2html() problem. I cannot reproduce, so probably a problem with pre PHP 4.1.0 versions, + when supporting new ADODB_FETCH_MODEs. + <p>Mattia Rossi (mattia#technologist.com) contributed BlobDecode() and UpdateBlobFile() for postgresql + using the postgres specific pg_lo_import()/pg_lo_open() - i don't use them but hopefully others will + find this useful. See <a href="http://phplens.com/lens/lensforum/msgs.php?id=1262">this posting</a> + for an example of usage. + <p>Added UpdateBlobFile() for uploading files to a database. + <p>Made UpdateBlob() compatible with oci8po driver. + <p>Added noNullStrings support to oci8 driver. Oracle changes all ' ' strings to nulls, + so you need to set strings to ' ' to prevent the nullifying of strings. $conn->noNullStrings = true; + will do this for you automatically. This is useful when you define a char column as NOT NULL. + <p>Fixed UnixTimeStamp() bug - wasn't setting minutes and seconds properly. Patch from Agusti Fita i Borrell agusti#anglatecnic.com. + <p>Toni Tunkkari added patch for sybase dates. Problem with spaces in day part of date fixed. + <p><b>1.71 18 Jan 2002</b></p> + <p>Sequence start id support. Now $conn->Gen_ID('seqname', 50) to start sequence from 50. + <p>CSV driver fix for selectlimit, from Andreas - akaiser#vocote.de. +<P>Gam3r spotted that a global variable was undefined in the session handler. +<p>Mssql date regex had error. Fixed - reported by Minh Hoang vb_user#yahoo.com. +<p>DBTimeStamp() and DBDate() now accept iso dates and unix timestamps. This means +that the PostgreSQL handling of dates in GetInsertSQL() and GetUpdateSQL() can +be removed. Also if these functions are passed '' or null or false, we return a SQL null. +<p>GetInsertSQL() and GetUpdateSQL() now accept a new parameter, $magicq to +indicate whether quotes should be inserted based on magic quote settings - suggested by +dj#4ict.com. +<p>Reformated docs slightly based on suggestions by Chris Small. + <p><b>1.65 28 Dec 2001</b></p> + <p>Fixed borland_ibase class naming bug. + <p>Now instead of using $rs->fields[0] internally, we use reset($rs->fields) so + that we are compatible with ADODB_FETCH_ASSOC mode. Reported by Nico S. + <p>Changed recordset constructor and _initrs() for oci8 so that it returns the field definitions even + if no rows in the recordset. Reported by Rick Hickerson (rhickers#mv.mv.com). + <p>Improved support for postgresql in GetInsertSQL and GetUpdateSQL by + "mike" mike#partner2partner.com and "Ryan Bailey" rebel#windriders.com + <p><b>1.64 20 Dec 2001</b></p> +<p>Danny Milosavljevic <danny.milo#gmx.net> added some patches for MySQL error handling +and displaying default values. +<p>Fixed some ADODB_FETCH_BOTH inconsistencies in odbc and interbase. +<p>Added more tests to test suite to cover ADODB_FETCH_* and ADODB_ERROR_HANDLER. +<p>Added firebird (ibase) driver +<p>Added borland_ibase driver for interbase 6.5 +<p><b>1.63 13 Dec 2001</b></p> +Absolute to the adodb-lib.inc.php file not set properly. Fixed.<p> + +<p><b>1.62 11 Dec 2001</b></p> +<p>Major speedup of ADOdb for low-end web sites by reducing the php code loading and compiling +cycle. We conditionally compile not so common functions. +Moved csv code to adodb-csvlib.inc.php to reduce adodb.inc.php parsing. This file +is loaded only when the csv/proxy driver is used, or CacheExecute() is run. +Also moved PageExecute(), GetSelectSQL() and GetUpdateSQL() core code to adodb-lib.inc.php. +This reduced the 70K main adodb.inc.php file to 55K, and since at least 20K of the file +is comments, we have reduced 50K of code in adodb.inc.php to 35K. There + should be 35% reduction in memory and thus 35% speedup in compiling the php code for the +main adodb.inc.php file. +<p>Highly tuned SelectLimit() for oci8 for massive speed improvements on large files. +Selecting 20 rows starting from the 20,000th row of a table is now 7 times faster. +Thx to Tomas V V Cox. +<p>Allow . and # in table definitions in GetInsertSQL and GetUpdateSQL. + See ADODB_TABLE_REGEX constant. Thx to Ari Kuorikoski. +<p>Added ADODB_PREFETCH_ROWS constant, defaulting to 10. This determines the number +of records to prefetch in a SELECT statement. Only used by oci8.</p> +<p>Added high portability Oracle class called oci8po. This uses ? for bind variables, and +lower cases column names.</p> +<p>Now all database drivers support $ADODB_FETCH_MODE, including interbase, ado, and odbc: +ADODB_FETCH_NUM and ADODB_FETCH_ASSOC. ADODB_FETCH_BOTH is not fully implemented for all +database drivers. +<p><b>1.61 Nov 2001</b></p> +<p>Added PO_RecordCount() and PO_Insert_ID(). PO stands for portable. Pablo Roca + [pabloroca#mvps.org]</p> +<p>GenID now returns 0 if not available. Safer is that you should check $conn->hasGenID + for availability.</p> +<p>M'soft ADO we now correctly close recordset in _close() peterd#telephonetics.co.uk</p> +<p>MSSQL now supports GenID(). It generates a 16-byte GUID from mssql newid() + function.</p> +<p>Changed ereg_replace to preg_replace in SelectLimit. This is a fix for mssql. + Ereg doesn't support t or n! Reported by marino Carlos xaplo#postnuke-espanol.org</p> +<p>Added $recordset->connection. This is the ADOConnection object for the recordset. +Works with cached and normal recordsets. Surprisingly, this had no affect on performance!</p> +<p><b>1.54 15 Nov 2001</b></p> +Fixed some more bugs in PageExecute(). I am getting sick of bug in this and will have to +reconsider my QA here. The main issue is that I don't use PageExecute() and +to check whether it is working requires a visual inspection of the html generated currently. +It is possible to write a test script but it would be quite complicated :( +<p> More speedups of SelectLimit() for DB2, Oci8, access, vfp, mssql. +<p> + +<p><b>1.53 7 Nov 2001</b></p> +Added support for ADODB_FETCH_ASSOC for ado and odbc drivers.<p> +Tuned GetRowAssoc(false) in postgresql and mysql.<p> +Stephen Van Dyke contributed ADOdb icon, accepted with some minor mods.<p> +Enabled Affected_Rows() for postgresql<p> +Speedup for Concat() using implode() - Benjamin Curtis ben_curtis#yahoo.com<p> +Fixed some more bugs in PageExecute() to prevent infinite loops<p> +<p><b>1.52 5 Nov 2001</b></p> +Spelling error in CacheExecute() caused it to fail. $ql should be $sql in line 625!<p> +Added fixes for parsing [ and ] in GetUpdateSQL(). +<p><b>1.51 5 Nov 2001</b></p> +<p>Oci8 SelectLimit() speedup by using OCIFetch(). +<p>Oci8 was mistakenly reporting errors when $db->debug = true. +<p>If a connection failed with ODBC, it was not correctly reported - fixed. +<p>_connectionID was inited to -1, changed to false. +<p>Added $rs->FetchRow(), to simplify API, ala PEAR DB +<p>Added PEAR DB compat mode, which is still faster than PEAR! See adodb-pear.inc.php. +<p>Removed postgres pconnect debugging statement. +<p><b>1.50 31 Oct 2001</b></p> +<p>ADOdbConnection renamed to ADOConnection, and ADOdbFieldObject to ADOFieldObject. +<p>PageExecute() now checks for empty $rs correctly, and the errors in the docs on this subject have been fixed. +<p>odbc_error() does not return 6 digit error correctly at times. Implemented workaround. +<p>Added ADORecordSet_empty class. This will speedup INSERTS/DELETES/UPDATES because the return +object created is much smaller. +<p>Added Prepare() to odbc, and oci8 (but doesn't work properly for oci8 still). +<p>Made pgsql a synonym for postgre7, and changed SELECT LIMIT to use OFFSET for compat with +postgres 7.2. +<p>Revised adodb-cryptsession.php thanks to Ari. +<p>Set resources to false on _close, to force freeing of resources. +<p>Added adodb-errorhandler.inc.php, adodb-errorpear.inc.php and raiseErrorFn on Freek's urging. +<p>GetRowAssoc($toUpper=true): $toUpper added as default. +<p>Errors when connecting to a database were not captured formerly. Now we do it correctly. +<p><b>1.40 19 September 2001</b></p> +<p>PageExecute() to implement page scrolling added. Code and idea by Iván Oliva.</p> +<p>Some minor postgresql fixes.</p> +<p>Added sequence support using GenID() for postgresql, oci8, mysql, interbase.</p> +<p>Added UpdateBlob support for interbase (untested).</p> +<p>Added encrypted sessions (see adodb-cryptsession.php). By Ari Kuorikoski <kuoriari#finebyte.com></p> +<p><b>1.31 21 August 2001</b></p> +<p>Many bug fixes thanks to "GaM3R (Cameron)" <gamr#outworld.cx>. Some session changes due to Gam3r. +<p>Fixed qstr() to quote also. +<p>rs2html() now pretty printed. +<p>Jonathan Younger jyounger#unilab.com contributed the great idea GetUpdateSQL() and GetInsertSQL() which +generates SQL to update and insert into a table from a recordset. Modify the recordset fields +array, then can this function to generate the SQL (the SQL is not executed). +<p>"Nicola Fankhauser" <nicola.fankhauser#couniq.com> found some bugs in date handling for mssql.</p> +<p>Added minimal Oracle support for LOBs. Still under development.</p> +Added $ADODB_FETCH_MODE so you can control whether recordsets return arrays which are +numeric, associative or both. This is a global variable you set. Currently only MySQL, Oci8, Postgres +drivers support this. +<p>PostgreSQL properly closes recordsets now. Reported by several people. +<p> +Added UpdateBlob() for Oracle. A hack to make it easier to save blobs. +<p> +Oracle timestamps did not display properly. Fixed. +<p><b>1.20 6 June 2001</b></p> +<p>Now Oracle can connect using tnsnames.ora or server and service name</p> +<p>Extensive Oci8 speed optimizations. +Oci8 code revised to support variable binding, and /*+ FIRST_ROWS */ hint.</p> +<p>Worked around some 4.0.6 bugs in odbc_fetch_into().</p> +<p>Paolo S. Asioli paolo.asioli#libero.it suggested GetRowAssoc().</p> +<p>Escape quotes for oracle wrongly set to '. Now '' is used.</p> +<p>Variable binding now works in ODBC also.</p> +<p>Jumped to version 1.20 because I don't like 13 :-)</p> +<p><b>1.12 6 June 2001</b></p> +<p>Changed $ADODB_DIR to ADODB_DIR constant to plug a security loophole.</p> +<p>Changed _close() to close persistent connections also. Prevents connection leaks.</p> +<p>Major revision of oracle and oci8 drivers. +Added OCI_RETURN_NULLS and OCI_RETURN_LOBS to OCIFetchInto(). BLOB, CLOB and VARCHAR2 recognition +in MetaType() improved. MetaColumns() returns columns in correct sort order.</p> +<p>Interbase timestamp input format was wrong. Fixed.</p> +<p><b>1.11 20 May 2001</b></p> +<p>Improved file locking for Windows.</p> +<p>Probabilistic flushing of cache to avoid avalanche updates when cache timeouts.</p> +<p>Cached recordset timestamp not saved in some scenarios. Fixed.</p> +<p><b>1.10 19 May 2001</b></p> +<p>Added caching. CacheExecute() and CacheSelectLimit(). +<p>Added csv driver. See <a href="http://php.weblogs.com/adodb_csv">http://php.weblogs.com/ADODB_csv</a>. +<p>Fixed SelectLimit(), SELECT TOP not working under certain circumstances. +<p>Added better Frontbase support of MetaTypes() by Frank M. Kromann. +<p><b>1.01 24 April 2001</b></p> +<p>Fixed SelectLimit bug. not quoted properly. +<p>SelectLimit: SELECT TOP -1 * FROM TABLE not support by Microsoft. Fixed.</p> +<p>GetMenu improved by glen.davies#cce.ac.nz to support multiple hilited items<p> +<p>FetchNextObject() did not work with only 1 record returned. Fixed bug reported by $tim#orotech.net</p> +<p>Fixed mysql field max_length problem. Fix suggested by Jim Nicholson (jnich#att.com)</p> +<p><b>1.00 16 April 2001</b></p> +<p>Given some brilliant suggestions on how to simplify ADOdb by akul. You no longer need to +setup $ADODB_DIR yourself, and ADOLoadCode() is automatically called by ADONewConnection(), +simplifying the startup code.</p> +<p>FetchNextObject() added. Suggested by Jakub Marecek. This makes FetchObject() obsolete, as +this is more flexible and powerful.</p> +<p>Misc fixes to SelectLimit() to support Access (top must follow distinct) and Fields() +in the array recordset. From Reinhard Balling.</p> +<p><b>0.96 27 Mar 2001</b></p> +<p>ADOConnection Close() did not return a value correctly. Thanks to akul#otamedia.com.</p> +<p>When the horrible magic_quotes is enabled, back-slash () is changed to double-backslash (\). +This doesn't make sense for Microsoft/Sybase databases. We fix this in qstr().</p> +<p>Fixed Sybase date problem in UnixDate() thanks to Toni Tunkkari. Also fixed MSSQL problem +in UnixDate() - thanks to milhouse31#hotmail.com.</p> +<p>MoveNext() moved to leaf classes for speed in MySQL/PostgreSQL. 10-15% speedup.</p> +<p>Added null handling in bindInputArray in Execute() -- Ron Baldwin suggestion.</p> +<p>Fixed some option tags. Thanks to john#jrmstudios.com.</p> +<p><b>0.95 13 Mar 2001</b></p> +<p>Added postgres7 database driver which supports LIMIT and other version 7 stuff in the future.</p> +<p>Added SelectLimit to ADOConnection to simulate PostgreSQL's "select * from table limit 10 offset 3". +Added helper function GetArrayLimit() to ADORecordSet.</p> +<p>Fixed mysql metacolumns bug. Thanks to Freek Dijkstra (phpeverywhere#macfreek.com).</p> +<p>Also many PostgreSQL changes by Freek. He almost rewrote the whole PostgreSQL driver!</p> +<p>Added fix to input parameters in Execute for non-strings by Ron Baldwin.</p> +<p>Added new metatype, X for TeXt. Formerly, metatype B for Blob also included +text fields. Now 'B' is for binary/image data. 'X' for textual data.</p> +<p>Fixed $this->GetArray() in GetRows().</p> +<p>Oracle and OCI8: 1st parameter is always blank -- now warns if it is filled.</p> +<p>Now <i>hasLimit</i> and <i>hasTop</i> added to indicate whether +SELECT * FROM TABLE LIMIT 10 or SELECT TOP 10 * FROM TABLE are supported.</p> +<p><b>0.94 04 Feb 2001</b></p> +<p>Added ADORecordSet::GetRows() for compatibility with Microsoft ADO. Synonym for GetArray().</p> +<p>Added new metatype 'R' to represent autoincrement numbers.</p> +<p>Added ADORecordSet.FetchObject() to return a row as an object.</p> +<p>Finally got a Linux box to test PostgreSql. Many fixes.</p> +<p>Fixed copyright misspellings in 0.93.</p> +<p>Fixed mssql MetaColumns type bug.</p> +<p>Worked around odbc bug in PHP4 for sessions.</p> +<p>Fixed many documentation bugs (affected_rows, metadatabases, qstr).</p> +<p>Fixed MySQL timestamp format (removed comma).</p> +<p>Interbase driver did not call ibase_pconnect(). Fixed.</p> +<p><b>0.93 18 Jan 2002</b></p> +<p>Fixed GetMenu bug.</p> +<p>Simplified Interbase commit and rollback.</p> +<p>Default behaviour on closing a connection is now to rollback all active transactions.</p> +<p>Added field object handling for array recordset for future XML compatibility.</p> +<p>Added arr2html() to convert array to html table.</p> +<p><b>0.92 2 Jan 2002</b></p> +<p>Interbase Commit and Rollback should be working again.</p> +<p>Changed initialisation of ADORecordSet. This is internal and should not affect users. We +are doing this to support cached recordsets in the future.</p> + +<p>Implemented ADORecordSet_array class. This allows you to simulate a database recordset +with an array.</p> +<p>Added UnixDate() and UnixTimeStamp() to ADORecordSet.</p> +<p><b>0.91 21 Dec 2000</b></p> +<p>Fixed ODBC so ErrorMsg() is working.</p> +<p>Worked around ADO unrecognised null (0x1) value problem in COM.</p> +<p>Added Sybase support for FetchField() type</p> +<p>Removed debugging code and unneeded html from various files</p> +<p>Changed to javadoc style comments to adodb.inc.php.</p> +<p>Added maxsql as synonym for mysqlt</p> +<p>Now ODBC downloads first 8K of blob by default +<p><b>0.90 15 Nov 2000</b></p> +<p>Lots of testing of Microsoft ADO. Should be more stable now.</p> +<p>Added $ADODB_COUNTREC. Set to false for high speed selects.</p> +<p>Added Sybase support. Contributed by Toni Tunkkari (toni.tunkkari#finebyte.com). Bug in Sybase + API: GetFields is unable to determine date types.</p> +<p>Changed behaviour of RecordSet.GetMenu() to support size parameter (listbox) properly.</p> +<p>Added emptyDate and emptyTimeStamp to RecordSet class that defines how to represent + empty dates.</p> +<p>Added MetaColumns($table) that returns an array of ADOFieldObject's listing + the columns of a table.</p> +<p>Added transaction support for PostgresSQL -- thanks to "Eric G. Werk" egw#netguide.dk.</p> +<p>Added adodb-session.php for session support.</p> +<p><b>0.80 30 Nov 2000</b></p> +<p>Added support for charSet for interbase. Implemented MetaTables for most databases. + PostgreSQL more extensively tested.</p> +<p><b>0.71 22 Nov 2000</b></p> +<p>Switched from using require_once to include/include_once for backward compatability with PHP 4.02 and earlier.</p> +<p><b>0.70 15 Nov 2000</b></p> +<p>Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP, +except in Oracle 7 driver due to a bug in php_oracle.dll.</p> +<p>PostgreSQL database driver contributed by Alberto Cerezal (acerezalp#dbnet.es). +</p> +<p>Oci8 driver for Oracle 8 contributed by George Fourlanos (fou#infomap.gr).</p> +<p>Added <i>mysqlt</i> database driver to support MySQL 3.23 which has transaction + support. </p> +<p>Oracle default date format (DD-MON-YY) did not match ADOdb default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date.</p> +<p>Error message checking is now included in test suite.</p> +<p>MoveNext() did not check EOF properly -- fixed.</p> +<p><b>0.60 Nov 8 2000</b></p> +<p>Fixed some constructor bugs in ODBC and ADO. Added ErrorNo function to ADOConnection + class. </p> +<p><b>0.51 Oct 18 2000</b></p> +<p>Fixed some interbase bugs.</p> +<p><b>0.50 Oct 16 2000</b></p> +<p>Interbase commit/rollback changed to be compatible with PHP 4.03. </p> +<p>CommitTrans( ) will now return true if transactions not supported. </p> +<p>Conversely RollbackTrans( ) will return false if transactions not supported. +</p> +<p><b>0.46 Oct 12</b></p> +Many Oracle compatibility issues fixed. +<p><b>0.40 Sept 26</b></p> +<p>Many bug fixes</p> +<p>Now Code for BeginTrans, CommitTrans and RollbackTrans is working. So is the Affected_Rows +and Insert_ID. Added above functions to test.php.</p> +<p>ADO type handling was busted in 0.30. Fixed.</p> +<p>Generalised Move( ) so it works will all databases, including ODBC.</p> +<p><b>0.30 Sept 18</b></p> +<p>Renamed ADOLoadDB to ADOLoadCode. This is clearer.</p> +<p>Added BeginTrans, CommitTrans and RollbackTrans functions.</p> +<p>Added Affected_Rows() and Insert_ID(), _affectedrows() and _insertID(), ListTables(), + ListDatabases(), ListColumns().</p> +<p>Need to add New_ID() and hasInsertID and hasAffectedRows, autoCommit </p> +<p><b>0.20 Sept 12</b></p> +<p>Added support for Microsoft's ADO.</p> +<p>Added new field to ADORecordSet -- canSeek</p> +<p>Added new parameter to _fetch($ignore_fields = false). Setting to true will + not update fields array for faster performance.</p> +<p>Added new field to ADORecordSet/ADOConnection -- dataProvider to indicate whether + a class is derived from odbc or ado.</p> +<p>Changed class ODBCFieldObject to ADOFieldObject -- not documented currently.</p> +<p>Added benchmark.php and testdatabases.inc.php to the test suite.</p> +<p>Added to ADORecordSet FastForward( ) for future high speed scrolling. Not documented.</p> +<p>Realised that ADO's Move( ) uses relative positioning. ADOdb uses absolute. +</p> +<p><b>0.10 Sept 9 2000</b></p> +<p>First release</p> </body></html>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/pear/Auth/Container/ADOdb.php b/trunk/adodb-for-php4/pear/Auth/Container/ADOdb.php index 4122d1ed..f5020aa8 100644 --- a/trunk/adodb-for-php4/pear/Auth/Container/ADOdb.php +++ b/trunk/adodb-for-php4/pear/Auth/Container/ADOdb.php @@ -1,413 +1,413 @@ -<?php
-//
-// +----------------------------------------------------------------------+
-// | PHP Version 4 |
-// +----------------------------------------------------------------------+
-// | |
-// +----------------------------------------------------------------------+
-// | This source file is subject to version 2.02 of the PHP license, |
-// | that is bundled with this package in the file LICENSE, and is |
-// | available at through the world-wide-web at |
-// | http://www.php.net/license/2_02.txt. |
-// | If you did not receive a copy of the PHP license and are unable to |
-// | obtain it through the world-wide-web, please send a note to |
-// | license@php.net so we can mail you a copy immediately. |
-// +----------------------------------------------------------------------+
-// | Authors: Martin Jansen <mj@php.net>
-// | Richard Tango-Lowy <richtl@arscognita.com> |
-// +----------------------------------------------------------------------+
-//
-// $Id: ADOdb.php,v 1.3 2005/05/18 06:58:47 jlim Exp $
-//
-
-require_once 'Auth/Container.php';
-require_once 'adodb.inc.php';
-require_once 'adodb-pear.inc.php';
-require_once 'adodb-errorpear.inc.php';
-
-/**
- * Storage driver for fetching login data from a database using ADOdb-PHP.
- *
- * This storage driver can use all databases which are supported
- * by the ADBdb DB abstraction layer to fetch login data.
- * See http://php.weblogs.com/adodb for information on ADOdb.
- * NOTE: The ADOdb directory MUST be in your PHP include_path!
- *
- * @author Richard Tango-Lowy <richtl@arscognita.com>
- * @package Auth
- * @version $Revision: 1.3 $
- */
-class Auth_Container_ADOdb extends Auth_Container
-{
-
- /**
- * Additional options for the storage container
- * @var array
- */
- var $options = array();
-
- /**
- * DB object
- * @var object
- */
- var $db = null;
- var $dsn = '';
-
- /**
- * User that is currently selected from the DB.
- * @var string
- */
- var $activeUser = '';
-
- // {{{ Constructor
-
- /**
- * Constructor of the container class
- *
- * Initate connection to the database via PEAR::ADOdb
- *
- * @param string Connection data or DB object
- * @return object Returns an error object if something went wrong
- */
- function Auth_Container_ADOdb($dsn)
- {
- $this->_setDefaults();
-
- if (is_array($dsn)) {
- $this->_parseOptions($dsn);
-
- if (empty($this->options['dsn'])) {
- PEAR::raiseError('No connection parameters specified!');
- }
- } else {
- // Extract db_type from dsn string.
- $this->options['dsn'] = $dsn;
- }
- }
-
- // }}}
- // {{{ _connect()
-
- /**
- * Connect to database by using the given DSN string
- *
- * @access private
- * @param string DSN string
- * @return mixed Object on error, otherwise bool
- */
- function _connect($dsn)
- {
- if (is_string($dsn) || is_array($dsn)) {
- if(!$this->db) {
- $this->db = &ADONewConnection($dsn);
- if( $err = ADODB_Pear_error() ) {
- return PEAR::raiseError($err);
- }
- }
-
- } else {
- return PEAR::raiseError('The given dsn was not valid in file ' . __FILE__ . ' at line ' . __LINE__,
- 41,
- PEAR_ERROR_RETURN,
- null,
- null
- );
- }
-
- if(!$this->db) {
- return PEAR::raiseError(ADODB_Pear_error());
- } else {
- return true;
- }
- }
-
- // }}}
- // {{{ _prepare()
-
- /**
- * Prepare database connection
- *
- * This function checks if we have already opened a connection to
- * the database. If that's not the case, a new connection is opened.
- *
- * @access private
- * @return mixed True or a DB error object.
- */
- function _prepare()
- {
- if(!$this->db) {
- $res = $this->_connect($this->options['dsn']);
- }
- return true;
- }
-
- // }}}
- // {{{ query()
-
- /**
- * Prepare query to the database
- *
- * This function checks if we have already opened a connection to
- * the database. If that's not the case, a new connection is opened.
- * After that the query is passed to the database.
- *
- * @access public
- * @param string Query string
- * @return mixed a DB_result object or DB_OK on success, a DB
- * or PEAR error on failure
- */
- function query($query)
- {
- $err = $this->_prepare();
- if ($err !== true) {
- return $err;
- }
- return $this->db->query($query);
- }
-
- // }}}
- // {{{ _setDefaults()
-
- /**
- * Set some default options
- *
- * @access private
- * @return void
- */
- function _setDefaults()
- {
- $this->options['db_type'] = 'mysql';
- $this->options['table'] = 'auth';
- $this->options['usernamecol'] = 'username';
- $this->options['passwordcol'] = 'password';
- $this->options['dsn'] = '';
- $this->options['db_fields'] = '';
- $this->options['cryptType'] = 'md5';
- }
-
- // }}}
- // {{{ _parseOptions()
-
- /**
- * Parse options passed to the container class
- *
- * @access private
- * @param array
- */
- function _parseOptions($array)
- {
- foreach ($array as $key => $value) {
- if (isset($this->options[$key])) {
- $this->options[$key] = $value;
- }
- }
-
- /* Include additional fields if they exist */
- if(!empty($this->options['db_fields'])){
- if(is_array($this->options['db_fields'])){
- $this->options['db_fields'] = join($this->options['db_fields'], ', ');
- }
- $this->options['db_fields'] = ', '.$this->options['db_fields'];
- }
- }
-
- // }}}
- // {{{ fetchData()
-
- /**
- * Get user information from database
- *
- * This function uses the given username to fetch
- * the corresponding login data from the database
- * table. If an account that matches the passed username
- * and password is found, the function returns true.
- * Otherwise it returns false.
- *
- * @param string Username
- * @param string Password
- * @return mixed Error object or boolean
- */
- function fetchData($username, $password)
- {
- // Prepare for a database query
- $err = $this->_prepare();
- if ($err !== true) {
- return PEAR::raiseError($err->getMessage(), $err->getCode());
- }
-
- // Find if db_fields contains a *, i so assume all col are selected
- if(strstr($this->options['db_fields'], '*')){
- $sql_from = "*";
- }
- else{
- $sql_from = $this->options['usernamecol'] . ", ".$this->options['passwordcol'].$this->options['db_fields'];
- }
-
- $query = "SELECT ".$sql_from.
- " FROM ".$this->options['table'].
- " WHERE ".$this->options['usernamecol']." = " . $this->db->Quote($username);
-
- $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
- $rset = $this->db->Execute( $query );
- $res = $rset->fetchRow();
-
- if (DB::isError($res)) {
- return PEAR::raiseError($res->getMessage(), $res->getCode());
- }
- if (!is_array($res)) {
- $this->activeUser = '';
- return false;
- }
- if ($this->verifyPassword(trim($password, "\r\n"),
- trim($res[$this->options['passwordcol']], "\r\n"),
- $this->options['cryptType'])) {
- // Store additional field values in the session
- foreach ($res as $key => $value) {
- if ($key == $this->options['passwordcol'] ||
- $key == $this->options['usernamecol']) {
- continue;
- }
- // Use reference to the auth object if exists
- // This is because the auth session variable can change so a static call to setAuthData does not make sence
- if(is_object($this->_auth_obj)){
- $this->_auth_obj->setAuthData($key, $value);
- } else {
- Auth::setAuthData($key, $value);
- }
- }
-
- return true;
- }
-
- $this->activeUser = $res[$this->options['usernamecol']];
- return false;
- }
-
- // }}}
- // {{{ listUsers()
-
- function listUsers()
- {
- $err = $this->_prepare();
- if ($err !== true) {
- return PEAR::raiseError($err->getMessage(), $err->getCode());
- }
-
- $retVal = array();
-
- // Find if db_fileds contains a *, i so assume all col are selected
- if(strstr($this->options['db_fields'], '*')){
- $sql_from = "*";
- }
- else{
- $sql_from = $this->options['usernamecol'] . ", ".$this->options['passwordcol'].$this->options['db_fields'];
- }
-
- $query = sprintf("SELECT %s FROM %s",
- $sql_from,
- $this->options['table']
- );
- $res = $this->db->getAll($query, null, DB_FETCHMODE_ASSOC);
-
- if (DB::isError($res)) {
- return PEAR::raiseError($res->getMessage(), $res->getCode());
- } else {
- foreach ($res as $user) {
- $user['username'] = $user[$this->options['usernamecol']];
- $retVal[] = $user;
- }
- }
- return $retVal;
- }
-
- // }}}
- // {{{ addUser()
-
- /**
- * Add user to the storage container
- *
- * @access public
- * @param string Username
- * @param string Password
- * @param mixed Additional information that are stored in the DB
- *
- * @return mixed True on success, otherwise error object
- */
- function addUser($username, $password, $additional = "")
- {
- if (function_exists($this->options['cryptType'])) {
- $cryptFunction = $this->options['cryptType'];
- } else {
- $cryptFunction = 'md5';
- }
-
- $additional_key = '';
- $additional_value = '';
-
- if (is_array($additional)) {
- foreach ($additional as $key => $value) {
- $additional_key .= ', ' . $key;
- $additional_value .= ", '" . $value . "'";
- }
- }
-
- $query = sprintf("INSERT INTO %s (%s, %s%s) VALUES ('%s', '%s'%s)",
- $this->options['table'],
- $this->options['usernamecol'],
- $this->options['passwordcol'],
- $additional_key,
- $username,
- $cryptFunction($password),
- $additional_value
- );
-
- $res = $this->query($query);
-
- if (DB::isError($res)) {
- return PEAR::raiseError($res->getMessage(), $res->getCode());
- } else {
- return true;
- }
- }
-
- // }}}
- // {{{ removeUser()
-
- /**
- * Remove user from the storage container
- *
- * @access public
- * @param string Username
- *
- * @return mixed True on success, otherwise error object
- */
- function removeUser($username)
- {
- $query = sprintf("DELETE FROM %s WHERE %s = '%s'",
- $this->options['table'],
- $this->options['usernamecol'],
- $username
- );
-
- $res = $this->query($query);
-
- if (DB::isError($res)) {
- return PEAR::raiseError($res->getMessage(), $res->getCode());
- } else {
- return true;
- }
- }
-
- // }}}
-}
-
-function showDbg( $string ) {
- print "
--- $string</P>";
-}
-function dump( $var, $str, $vardump = false ) {
- print "<H4>$str</H4><pre>";
- ( !$vardump ) ? ( print_r( $var )) : ( var_dump( $var ));
- print "</pre>";
-}
-?>
+<?php +// +// +----------------------------------------------------------------------+ +// | PHP Version 4 | +// +----------------------------------------------------------------------+ +// | | +// +----------------------------------------------------------------------+ +// | This source file is subject to version 2.02 of the PHP license, | +// | that is bundled with this package in the file LICENSE, and is | +// | available at through the world-wide-web at | +// | http://www.php.net/license/2_02.txt. | +// | If you did not receive a copy of the PHP license and are unable to | +// | obtain it through the world-wide-web, please send a note to | +// | license@php.net so we can mail you a copy immediately. | +// +----------------------------------------------------------------------+ +// | Authors: Martin Jansen <mj@php.net> +// | Richard Tango-Lowy <richtl@arscognita.com> | +// +----------------------------------------------------------------------+ +// +// $Id: ADOdb.php,v 1.3 2005/05/18 06:58:47 jlim Exp $ +// + +require_once 'Auth/Container.php'; +require_once 'adodb.inc.php'; +require_once 'adodb-pear.inc.php'; +require_once 'adodb-errorpear.inc.php'; + +/** + * Storage driver for fetching login data from a database using ADOdb-PHP. + * + * This storage driver can use all databases which are supported + * by the ADBdb DB abstraction layer to fetch login data. + * See http://php.weblogs.com/adodb for information on ADOdb. + * NOTE: The ADOdb directory MUST be in your PHP include_path! + * + * @author Richard Tango-Lowy <richtl@arscognita.com> + * @package Auth + * @version $Revision: 1.3 $ + */ +class Auth_Container_ADOdb extends Auth_Container +{ + + /** + * Additional options for the storage container + * @var array + */ + var $options = array(); + + /** + * DB object + * @var object + */ + var $db = null; + var $dsn = ''; + + /** + * User that is currently selected from the DB. + * @var string + */ + var $activeUser = ''; + + // {{{ Constructor + + /** + * Constructor of the container class + * + * Initate connection to the database via PEAR::ADOdb + * + * @param string Connection data or DB object + * @return object Returns an error object if something went wrong + */ + function Auth_Container_ADOdb($dsn) + { + $this->_setDefaults(); + + if (is_array($dsn)) { + $this->_parseOptions($dsn); + + if (empty($this->options['dsn'])) { + PEAR::raiseError('No connection parameters specified!'); + } + } else { + // Extract db_type from dsn string. + $this->options['dsn'] = $dsn; + } + } + + // }}} + // {{{ _connect() + + /** + * Connect to database by using the given DSN string + * + * @access private + * @param string DSN string + * @return mixed Object on error, otherwise bool + */ + function _connect($dsn) + { + if (is_string($dsn) || is_array($dsn)) { + if(!$this->db) { + $this->db = &ADONewConnection($dsn); + if( $err = ADODB_Pear_error() ) { + return PEAR::raiseError($err); + } + } + + } else { + return PEAR::raiseError('The given dsn was not valid in file ' . __FILE__ . ' at line ' . __LINE__, + 41, + PEAR_ERROR_RETURN, + null, + null + ); + } + + if(!$this->db) { + return PEAR::raiseError(ADODB_Pear_error()); + } else { + return true; + } + } + + // }}} + // {{{ _prepare() + + /** + * Prepare database connection + * + * This function checks if we have already opened a connection to + * the database. If that's not the case, a new connection is opened. + * + * @access private + * @return mixed True or a DB error object. + */ + function _prepare() + { + if(!$this->db) { + $res = $this->_connect($this->options['dsn']); + } + return true; + } + + // }}} + // {{{ query() + + /** + * Prepare query to the database + * + * This function checks if we have already opened a connection to + * the database. If that's not the case, a new connection is opened. + * After that the query is passed to the database. + * + * @access public + * @param string Query string + * @return mixed a DB_result object or DB_OK on success, a DB + * or PEAR error on failure + */ + function query($query) + { + $err = $this->_prepare(); + if ($err !== true) { + return $err; + } + return $this->db->query($query); + } + + // }}} + // {{{ _setDefaults() + + /** + * Set some default options + * + * @access private + * @return void + */ + function _setDefaults() + { + $this->options['db_type'] = 'mysql'; + $this->options['table'] = 'auth'; + $this->options['usernamecol'] = 'username'; + $this->options['passwordcol'] = 'password'; + $this->options['dsn'] = ''; + $this->options['db_fields'] = ''; + $this->options['cryptType'] = 'md5'; + } + + // }}} + // {{{ _parseOptions() + + /** + * Parse options passed to the container class + * + * @access private + * @param array + */ + function _parseOptions($array) + { + foreach ($array as $key => $value) { + if (isset($this->options[$key])) { + $this->options[$key] = $value; + } + } + + /* Include additional fields if they exist */ + if(!empty($this->options['db_fields'])){ + if(is_array($this->options['db_fields'])){ + $this->options['db_fields'] = join($this->options['db_fields'], ', '); + } + $this->options['db_fields'] = ', '.$this->options['db_fields']; + } + } + + // }}} + // {{{ fetchData() + + /** + * Get user information from database + * + * This function uses the given username to fetch + * the corresponding login data from the database + * table. If an account that matches the passed username + * and password is found, the function returns true. + * Otherwise it returns false. + * + * @param string Username + * @param string Password + * @return mixed Error object or boolean + */ + function fetchData($username, $password) + { + // Prepare for a database query + $err = $this->_prepare(); + if ($err !== true) { + return PEAR::raiseError($err->getMessage(), $err->getCode()); + } + + // Find if db_fields contains a *, i so assume all col are selected + if(strstr($this->options['db_fields'], '*')){ + $sql_from = "*"; + } + else{ + $sql_from = $this->options['usernamecol'] . ", ".$this->options['passwordcol'].$this->options['db_fields']; + } + + $query = "SELECT ".$sql_from. + " FROM ".$this->options['table']. + " WHERE ".$this->options['usernamecol']." = " . $this->db->Quote($username); + + $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC; + $rset = $this->db->Execute( $query ); + $res = $rset->fetchRow(); + + if (DB::isError($res)) { + return PEAR::raiseError($res->getMessage(), $res->getCode()); + } + if (!is_array($res)) { + $this->activeUser = ''; + return false; + } + if ($this->verifyPassword(trim($password, "\r\n"), + trim($res[$this->options['passwordcol']], "\r\n"), + $this->options['cryptType'])) { + // Store additional field values in the session + foreach ($res as $key => $value) { + if ($key == $this->options['passwordcol'] || + $key == $this->options['usernamecol']) { + continue; + } + // Use reference to the auth object if exists + // This is because the auth session variable can change so a static call to setAuthData does not make sence + if(is_object($this->_auth_obj)){ + $this->_auth_obj->setAuthData($key, $value); + } else { + Auth::setAuthData($key, $value); + } + } + + return true; + } + + $this->activeUser = $res[$this->options['usernamecol']]; + return false; + } + + // }}} + // {{{ listUsers() + + function listUsers() + { + $err = $this->_prepare(); + if ($err !== true) { + return PEAR::raiseError($err->getMessage(), $err->getCode()); + } + + $retVal = array(); + + // Find if db_fileds contains a *, i so assume all col are selected + if(strstr($this->options['db_fields'], '*')){ + $sql_from = "*"; + } + else{ + $sql_from = $this->options['usernamecol'] . ", ".$this->options['passwordcol'].$this->options['db_fields']; + } + + $query = sprintf("SELECT %s FROM %s", + $sql_from, + $this->options['table'] + ); + $res = $this->db->getAll($query, null, DB_FETCHMODE_ASSOC); + + if (DB::isError($res)) { + return PEAR::raiseError($res->getMessage(), $res->getCode()); + } else { + foreach ($res as $user) { + $user['username'] = $user[$this->options['usernamecol']]; + $retVal[] = $user; + } + } + return $retVal; + } + + // }}} + // {{{ addUser() + + /** + * Add user to the storage container + * + * @access public + * @param string Username + * @param string Password + * @param mixed Additional information that are stored in the DB + * + * @return mixed True on success, otherwise error object + */ + function addUser($username, $password, $additional = "") + { + if (function_exists($this->options['cryptType'])) { + $cryptFunction = $this->options['cryptType']; + } else { + $cryptFunction = 'md5'; + } + + $additional_key = ''; + $additional_value = ''; + + if (is_array($additional)) { + foreach ($additional as $key => $value) { + $additional_key .= ', ' . $key; + $additional_value .= ", '" . $value . "'"; + } + } + + $query = sprintf("INSERT INTO %s (%s, %s%s) VALUES ('%s', '%s'%s)", + $this->options['table'], + $this->options['usernamecol'], + $this->options['passwordcol'], + $additional_key, + $username, + $cryptFunction($password), + $additional_value + ); + + $res = $this->query($query); + + if (DB::isError($res)) { + return PEAR::raiseError($res->getMessage(), $res->getCode()); + } else { + return true; + } + } + + // }}} + // {{{ removeUser() + + /** + * Remove user from the storage container + * + * @access public + * @param string Username + * + * @return mixed True on success, otherwise error object + */ + function removeUser($username) + { + $query = sprintf("DELETE FROM %s WHERE %s = '%s'", + $this->options['table'], + $this->options['usernamecol'], + $username + ); + + $res = $this->query($query); + + if (DB::isError($res)) { + return PEAR::raiseError($res->getMessage(), $res->getCode()); + } else { + return true; + } + } + + // }}} +} + +function showDbg( $string ) { + print " +-- $string</P>"; +} +function dump( $var, $str, $vardump = false ) { + print "<H4>$str</H4><pre>"; + ( !$vardump ) ? ( print_r( $var )) : ( var_dump( $var )); + print "</pre>"; +} +?> diff --git a/trunk/adodb-for-php4/pear/auth_adodb_example.php b/trunk/adodb-for-php4/pear/auth_adodb_example.php index ed642f90..f31ff3de 100644 --- a/trunk/adodb-for-php4/pear/auth_adodb_example.php +++ b/trunk/adodb-for-php4/pear/auth_adodb_example.php @@ -1,27 +1,27 @@ -<?php
-// NOTE: The ADOdb and PEAR directories MUST be in your PHP include_path!
-require_once "Auth/Auth.php";
-
-function loginFunction() {
-?>
- <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
- <input type="text" name="username">
- <input type="password" name="password">
- <input type="submit">
- </form>
-<?php
-}
-
-$dsn = 'mysql://username:password@hostname/database';
-// To use encrypted passwords, change cryptType to 'md5'
-$params = array('dsn' => $dsn, 'table' => 'auth', 'cryptType' => 'none',
- 'usernamecol' => 'username', 'passwordcol' => 'password');
-$a = new Auth("ADOdb", $params, "loginFunction");
-$a->start();
-
-if ($a->getAuth()) {
- echo "Success";
- // * The output of your site goes here.
-}
-
-?>
+<?php +// NOTE: The ADOdb and PEAR directories MUST be in your PHP include_path! +require_once "Auth/Auth.php"; + +function loginFunction() { +?> + <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"> + <input type="text" name="username"> + <input type="password" name="password"> + <input type="submit"> + </form> +<?php +} + +$dsn = 'mysql://username:password@hostname/database'; +// To use encrypted passwords, change cryptType to 'md5' +$params = array('dsn' => $dsn, 'table' => 'auth', 'cryptType' => 'none', + 'usernamecol' => 'username', 'passwordcol' => 'password'); +$a = new Auth("ADOdb", $params, "loginFunction"); +$a->start(); + +if ($a->getAuth()) { + echo "Success"; + // * The output of your site goes here. +} + +?> diff --git a/trunk/adodb-for-php4/pear/readme.Auth.txt b/trunk/adodb-for-php4/pear/readme.Auth.txt index db283197..b6b0c157 100644 --- a/trunk/adodb-for-php4/pear/readme.Auth.txt +++ b/trunk/adodb-for-php4/pear/readme.Auth.txt @@ -1,20 +1,20 @@ -From: Rich Tango-Lowy (richtl#arscognita.com)
-Date: Sat, May 29, 2004 11:20 am
-
-OK, I hacked out an ADOdb container for PEAR-Auth. The error handling's
-a bit of a mess, but all the methods work.
-
-Copy ADOdb.php to your pear/Auth/Container/ directory.
-
-Use the ADOdb container exactly as you would the DB
-container, but specify 'ADOdb' instead of 'DB':
-
-$dsn = "mysql://myuser:mypass@localhost/authdb";
-$a = new Auth("ADOdb", $dsn, "loginFunction");
-
-
--------------------
-
-John Lim adds:
-
-See http://pear.php.net/manual/en/package.authentication.php
+From: Rich Tango-Lowy (richtl#arscognita.com) +Date: Sat, May 29, 2004 11:20 am + +OK, I hacked out an ADOdb container for PEAR-Auth. The error handling's +a bit of a mess, but all the methods work. + +Copy ADOdb.php to your pear/Auth/Container/ directory. + +Use the ADOdb container exactly as you would the DB +container, but specify 'ADOdb' instead of 'DB': + +$dsn = "mysql://myuser:mypass@localhost/authdb"; +$a = new Auth("ADOdb", $dsn, "loginFunction"); + + +------------------- + +John Lim adds: + +See http://pear.php.net/manual/en/package.authentication.php diff --git a/trunk/adodb-for-php4/readme.htm b/trunk/adodb-for-php4/readme.htm index 4780cb78..e2c0bb54 100644 --- a/trunk/adodb-for-php4/readme.htm +++ b/trunk/adodb-for-php4/readme.htm @@ -1,68 +1,68 @@ -<html>
-<head>
-<title>ADODB Manual</title>
-<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
-<XSTYLE
- body,td {font-family:Arial,Helvetica,sans-serif;font-size:11pt}
- pre {font-size:9pt}
- .toplink {font-size:8pt}
- />
-</head>
-<body bgcolor="#FFFFFF">
-
-<h3>ADOdb Library for PHP</h3>
-<p>ADOdb is a suite of database libraries that allow you to connect to multiple
- databases in a portable manner. Download from <a href=http://adodb.sourceforge.net/>http://adodb.sourceforge.net/</a>.
-<ul><li>The ADOdb documentation has moved to <a href=docs-adodb.htm>docs-adodb.htm</a>
- This allows you to query, update and insert records using a portable API.
-<p><li>The ADOdb data dictionary docs are at <a href=docs-datadict.htm>docs-datadict.htm</a>.
- This allows you to create database tables and indexes in a portable manner.
-<p><li>The ADOdb database performance monitoring docs are at <a href=docs-perf.htm>docs-perf.htm</a>.
- This allows you to perform health checks, tune and monitor your database.
-<p><li>The ADOdb database-backed session docs are at <a href=docs-session.htm>docs-session.htm</a>.
-</ul>
-<p>
-<h3>Installation</h3>
-Make sure you are running PHP4.0.4 or later. Unpack all the files into a directory accessible by your webserver.
-<p>
-To test, try modifying some of the tutorial examples. Make sure you customize the connection settings correctly. You can debug using:
-<pre>
-<?php
-include('adodb/adodb.inc.php');
-
-$db = <b>ADONewConnection</b>($driver); # eg. 'mysql' or 'oci8'
-$db->debug = true;
-$db-><b>Connect</b>($server, $user, $password, $database);
-$rs = $db-><b>Execute</b>('select * from some_small_table');
-print "<pre>";
-print_r($rs-><b>GetRows</b>());
-print "</pre>";
-?>
-</pre>
-<h3>How are people using ADOdb</h3>
-Here are some examples of how people are using ADOdb:
-<ul>
- <li> <strong>PhpLens</strong> is a commercial data grid component that allows
- both cool Web designers and serious unshaved programmers to develop and
- maintain databases on the Web easily. Developed by the author of ADOdb.
- </li>
- <li> <strong>PHAkt</strong>: PHP Extension for DreamWeaver Ultradev allows
- you to script PHP in the popular Web page editor. Database handling provided
- by ADOdb. </li>
- <li> <strong>Analysis Console for Intrusion Databases (ACID)</strong>: PHP-based
- analysis engine to search and process a database of security incidents
- generated by security-related software such as IDSes and firewalls (e.g.
- Snort, ipchains). By Roman Danyliw. </li>
- <li> <strong>PostNuke</strong> is a very popular free content management system
- and weblog system. It offers full CSS support, HTML 4.01 transitional
- compliance throughout, an advanced blocks system, and is fully multi-lingual
- enabled. </li>
- <li><strong> EasyPublish CMS</strong> is another free content management system
- for managing information and integrated modules on your internet, intranet-
- and extranet-sites. From Norway. </li>
- <li> <strong>NOLA</strong> is a full featured accounting, inventory, and job
- tracking application. It is licensed under the GPL, and developed by Noguska.
- </li>
-</ul>
-</body>
-</html>
+<html> +<head> +<title>ADODB Manual</title> +<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> +<XSTYLE + body,td {font-family:Arial,Helvetica,sans-serif;font-size:11pt} + pre {font-size:9pt} + .toplink {font-size:8pt} + /> +</head> +<body bgcolor="#FFFFFF"> + +<h3>ADOdb Library for PHP</h3> +<p>ADOdb is a suite of database libraries that allow you to connect to multiple + databases in a portable manner. Download from <a href=http://adodb.sourceforge.net/>http://adodb.sourceforge.net/</a>. +<ul><li>The ADOdb documentation has moved to <a href=docs-adodb.htm>docs-adodb.htm</a> + This allows you to query, update and insert records using a portable API. +<p><li>The ADOdb data dictionary docs are at <a href=docs-datadict.htm>docs-datadict.htm</a>. + This allows you to create database tables and indexes in a portable manner. +<p><li>The ADOdb database performance monitoring docs are at <a href=docs-perf.htm>docs-perf.htm</a>. + This allows you to perform health checks, tune and monitor your database. +<p><li>The ADOdb database-backed session docs are at <a href=docs-session.htm>docs-session.htm</a>. +</ul> +<p> +<h3>Installation</h3> +Make sure you are running PHP4.0.4 or later. Unpack all the files into a directory accessible by your webserver. +<p> +To test, try modifying some of the tutorial examples. Make sure you customize the connection settings correctly. You can debug using: +<pre> +<?php +include('adodb/adodb.inc.php'); + +$db = <b>ADONewConnection</b>($driver); # eg. 'mysql' or 'oci8' +$db->debug = true; +$db-><b>Connect</b>($server, $user, $password, $database); +$rs = $db-><b>Execute</b>('select * from some_small_table'); +print "<pre>"; +print_r($rs-><b>GetRows</b>()); +print "</pre>"; +?> +</pre> +<h3>How are people using ADOdb</h3> +Here are some examples of how people are using ADOdb: +<ul> + <li> <strong>PhpLens</strong> is a commercial data grid component that allows + both cool Web designers and serious unshaved programmers to develop and + maintain databases on the Web easily. Developed by the author of ADOdb. + </li> + <li> <strong>PHAkt</strong>: PHP Extension for DreamWeaver Ultradev allows + you to script PHP in the popular Web page editor. Database handling provided + by ADOdb. </li> + <li> <strong>Analysis Console for Intrusion Databases (ACID)</strong>: PHP-based + analysis engine to search and process a database of security incidents + generated by security-related software such as IDSes and firewalls (e.g. + Snort, ipchains). By Roman Danyliw. </li> + <li> <strong>PostNuke</strong> is a very popular free content management system + and weblog system. It offers full CSS support, HTML 4.01 transitional + compliance throughout, an advanced blocks system, and is fully multi-lingual + enabled. </li> + <li><strong> EasyPublish CMS</strong> is another free content management system + for managing information and integrated modules on your internet, intranet- + and extranet-sites. From Norway. </li> + <li> <strong>NOLA</strong> is a full featured accounting, inventory, and job + tracking application. It is licensed under the GPL, and developed by Noguska. + </li> +</ul> +</body> +</html> diff --git a/trunk/adodb-for-php4/readme.txt b/trunk/adodb-for-php4/readme.txt index 97bdd9ea..009b94c5 100644 --- a/trunk/adodb-for-php4/readme.txt +++ b/trunk/adodb-for-php4/readme.txt @@ -1,62 +1,62 @@ ->> ADODB Library for PHP4
-
-(c) 2000-2004 John Lim (jlim@natsoft.com.my)
-
-Released under both BSD and GNU Lesser GPL library license.
-This means you can use it in proprietary products.
-
-
->> Introduction
-
-PHP's database access functions are not standardised. This creates a
-need for a database class library to hide the differences between the
-different databases (encapsulate the differences) so we can easily
-switch databases.
-
-We currently support MySQL, Interbase, Sybase, PostgreSQL, Oracle,
-Microsoft SQL server, Foxpro ODBC, Access ODBC, Informix, DB2,
-Sybase SQL Anywhere, generic ODBC and Microsoft's ADO.
-
-We hope more people will contribute drivers to support other databases.
-
-
->> Documentation and Examples
-
-Refer to the adodb/docs directory for full documentation and examples.
-There is also a tutorial tute.htm that contrasts ADODB code with
-mysql code.
-
-
->>> Files
-Adodb.inc.php is the main file. You need to include only this file.
-
-Adodb-*.inc.php are the database specific driver code.
-
-Test.php contains a list of test commands to exercise the class library.
-
-Adodb-session.php is the PHP4 session handling code.
-
-Testdatabases.inc.php contains the list of databases to apply the tests on.
-
-Benchmark.php is a simple benchmark to test the throughput of a simple SELECT
-statement for databases described in testdatabases.inc.php. The benchmark
-tables are created in test.php.
-
-readme.htm is the main documentation.
-
-tute.htm is the tutorial.
-
-
->> More Info
-
-For more information, including installation see readme.htm
-or visit
- http://adodb.sourceforge.net/
-
-
->> Feature Requests and Bug Reports
-
-Email to jlim@natsoft.com.my
-
-
+>> ADODB Library for PHP4 + +(c) 2000-2004 John Lim (jlim@natsoft.com.my) + +Released under both BSD and GNU Lesser GPL library license. +This means you can use it in proprietary products. + + +>> Introduction + +PHP's database access functions are not standardised. This creates a +need for a database class library to hide the differences between the +different databases (encapsulate the differences) so we can easily +switch databases. + +We currently support MySQL, Interbase, Sybase, PostgreSQL, Oracle, +Microsoft SQL server, Foxpro ODBC, Access ODBC, Informix, DB2, +Sybase SQL Anywhere, generic ODBC and Microsoft's ADO. + +We hope more people will contribute drivers to support other databases. + + +>> Documentation and Examples + +Refer to the adodb/docs directory for full documentation and examples. +There is also a tutorial tute.htm that contrasts ADODB code with +mysql code. + + +>>> Files +Adodb.inc.php is the main file. You need to include only this file. + +Adodb-*.inc.php are the database specific driver code. + +Test.php contains a list of test commands to exercise the class library. + +Adodb-session.php is the PHP4 session handling code. + +Testdatabases.inc.php contains the list of databases to apply the tests on. + +Benchmark.php is a simple benchmark to test the throughput of a simple SELECT +statement for databases described in testdatabases.inc.php. The benchmark +tables are created in test.php. + +readme.htm is the main documentation. + +tute.htm is the tutorial. + + +>> More Info + +For more information, including installation see readme.htm +or visit + http://adodb.sourceforge.net/ + + +>> Feature Requests and Bug Reports + +Email to jlim@natsoft.com.my + +
\ No newline at end of file diff --git a/trunk/adodb-for-php4/session/adodb-sess.txt b/trunk/adodb-for-php4/session/adodb-sess.txt index d23dac42..c6c76858 100644 --- a/trunk/adodb-for-php4/session/adodb-sess.txt +++ b/trunk/adodb-for-php4/session/adodb-sess.txt @@ -1,131 +1,131 @@ -John,
-
-I have been an extremely satisfied ADODB user for several years now.
-
-To give you something back for all your hard work, I've spent the last 3
-days rewriting the adodb-session.php code.
-
-----------
-What's New
-----------
-
-Here's a list of the new code's benefits:
-
-* Combines the functionality of the three files:
-
-adodb-session.php
-adodb-session-clob.php
-adodb-cryptsession.php
-
-each with very similar functionality, into a single file adodb-session.php.
-This will ease maintenance and support issues.
-
-* Supports multiple encryption and compression schemes.
- Currently, we support:
-
- MD5Crypt (crypt.inc.php)
- MCrypt
- Secure (Horde's emulation of MCrypt, if MCrypt module is not available.)
- GZip
- BZip2
-
-These can be stacked, so if you want to compress and then encrypt your
-session data, it's easy.
-Also, the built-in MCrypt functions will be *much* faster, and more secure,
-than the MD5Crypt code.
-
-* adodb-session.php contains a single class ADODB_Session that encapsulates
-all functionality.
- This eliminates the use of global vars and defines (though they are
-supported for backwards compatibility).
-
-* All user defined parameters are now static functions in the ADODB_Session
-class.
-
-New parameters include:
-
-* encryptionKey(): Define the encryption key used to encrypt the session.
-Originally, it was a hard coded string.
-
-* persist(): Define if the database will be opened in persistent mode.
-Originally, the user had to call adodb_sess_open().
-
-* dataFieldName(): Define the field name used to store the session data, as
-'DATA' appears to be a reserved word in the following cases:
- ANSI SQL
- IBM DB2
- MS SQL Server
- Postgres
- SAP
-
-* filter(): Used to support multiple, simulataneous encryption/compression
-schemes.
-
-* Debug support is improved thru _rsdump() function, which is called after
-every database call.
-
-------------
-What's Fixed
-------------
-
-The new code includes several bug fixes and enhancements:
-
-* sesskey is compared in BINARY mode for MySQL, to avoid problems with
-session keys that differ only by case.
- Of course, the user should define the sesskey field as BINARY, to
-correctly fix this problem, otherwise performance will suffer.
-
-* In ADODB_Session::gc(), if $expire_notify is true, the multiple DELETES in
-the original code have been optimized to a single DELETE.
-
-* In ADODB_Session::destroy(), since "SELECT expireref, sesskey FROM $table
-WHERE sesskey = $qkey" will only return a single value, we don't loop on the
-result, we simply process the row, if any.
-
-* We close $rs after every use.
-
----------------
-What's the Same
----------------
-
-I know backwards compatibility is *very* important to you. Therefore, the
-new code is 100% backwards compatible.
-
-If you like my code, but don't "trust" it's backwards compatible, maybe we
-offer it as beta code, in a new directory for a release or two?
-
-------------
-What's To Do
-------------
-
-I've vascillated over whether to use a single function to get/set
-parameters:
-
-$user = ADODB_Session::user(); // get
-ADODB_Session::user($user); // set
-
-or to use separate functions (which is the PEAR/Java way):
-
-$user = ADODB_Session::getUser();
-ADODB_Session::setUser($user);
-
-I've chosen the former as it's makes for a simpler API, and reduces the
-amount of code, but I'd be happy to change it to the latter.
-
-Also, do you think the class should be a singleton class, versus a static
-class?
-
-Let me know if you find this code useful, and will be including it in the
-next release of ADODB.
-
-If so, I will modify the current documentation to detail the new
-functionality. To that end, what file(s) contain the documentation? Please
-send them to me if they are not publically available.
-
-Also, if there is *anything* in the code that you like to see changed, let
-me know.
-
-Thanks,
-
-Ross
-
+John, + +I have been an extremely satisfied ADODB user for several years now. + +To give you something back for all your hard work, I've spent the last 3 +days rewriting the adodb-session.php code. + +---------- +What's New +---------- + +Here's a list of the new code's benefits: + +* Combines the functionality of the three files: + +adodb-session.php +adodb-session-clob.php +adodb-cryptsession.php + +each with very similar functionality, into a single file adodb-session.php. +This will ease maintenance and support issues. + +* Supports multiple encryption and compression schemes. + Currently, we support: + + MD5Crypt (crypt.inc.php) + MCrypt + Secure (Horde's emulation of MCrypt, if MCrypt module is not available.) + GZip + BZip2 + +These can be stacked, so if you want to compress and then encrypt your +session data, it's easy. +Also, the built-in MCrypt functions will be *much* faster, and more secure, +than the MD5Crypt code. + +* adodb-session.php contains a single class ADODB_Session that encapsulates +all functionality. + This eliminates the use of global vars and defines (though they are +supported for backwards compatibility). + +* All user defined parameters are now static functions in the ADODB_Session +class. + +New parameters include: + +* encryptionKey(): Define the encryption key used to encrypt the session. +Originally, it was a hard coded string. + +* persist(): Define if the database will be opened in persistent mode. +Originally, the user had to call adodb_sess_open(). + +* dataFieldName(): Define the field name used to store the session data, as +'DATA' appears to be a reserved word in the following cases: + ANSI SQL + IBM DB2 + MS SQL Server + Postgres + SAP + +* filter(): Used to support multiple, simulataneous encryption/compression +schemes. + +* Debug support is improved thru _rsdump() function, which is called after +every database call. + +------------ +What's Fixed +------------ + +The new code includes several bug fixes and enhancements: + +* sesskey is compared in BINARY mode for MySQL, to avoid problems with +session keys that differ only by case. + Of course, the user should define the sesskey field as BINARY, to +correctly fix this problem, otherwise performance will suffer. + +* In ADODB_Session::gc(), if $expire_notify is true, the multiple DELETES in +the original code have been optimized to a single DELETE. + +* In ADODB_Session::destroy(), since "SELECT expireref, sesskey FROM $table +WHERE sesskey = $qkey" will only return a single value, we don't loop on the +result, we simply process the row, if any. + +* We close $rs after every use. + +--------------- +What's the Same +--------------- + +I know backwards compatibility is *very* important to you. Therefore, the +new code is 100% backwards compatible. + +If you like my code, but don't "trust" it's backwards compatible, maybe we +offer it as beta code, in a new directory for a release or two? + +------------ +What's To Do +------------ + +I've vascillated over whether to use a single function to get/set +parameters: + +$user = ADODB_Session::user(); // get +ADODB_Session::user($user); // set + +or to use separate functions (which is the PEAR/Java way): + +$user = ADODB_Session::getUser(); +ADODB_Session::setUser($user); + +I've chosen the former as it's makes for a simpler API, and reduces the +amount of code, but I'd be happy to change it to the latter. + +Also, do you think the class should be a singleton class, versus a static +class? + +Let me know if you find this code useful, and will be including it in the +next release of ADODB. + +If so, I will modify the current documentation to detail the new +functionality. To that end, what file(s) contain the documentation? Please +send them to me if they are not publically available. + +Also, if there is *anything* in the code that you like to see changed, let +me know. + +Thanks, + +Ross + diff --git a/trunk/adodb-for-php4/tests/test-perf.php b/trunk/adodb-for-php4/tests/test-perf.php index 37406d2d..bdeae281 100644 --- a/trunk/adodb-for-php4/tests/test-perf.php +++ b/trunk/adodb-for-php4/tests/test-perf.php @@ -1,50 +1,50 @@ -<?php
-
-include_once('../adodb-perf.inc.php');
-
-error_reporting(E_ALL);
-session_start();
-
-if (isset($_GET)) {
- foreach($_GET as $k => $v) {
- if (strncmp($k,'test',4) == 0) $_SESSION['_db'] = $k;
- }
-}
-
-if (isset($_SESSION['_db'])) {
- $_db = $_SESSION['_db'];
- $_GET[$_db] = 1;
- $$_db = 1;
-}
-
-echo "<h1>Performance Monitoring</h1>";
-include_once('testdatabases.inc.php');
-
-
-function testdb($db)
-{
- if (!$db) return;
- echo "<font size=1>";print_r($db->ServerInfo()); echo " user=".$db->user."</font>";
-
- $perf = NewPerfMonitor($db);
-
- # unit tests
- if (0) {
- //$DB->debug=1;
- echo "Data Cache Size=".$perf->DBParameter('data cache size').'<p>';
- echo $perf->HealthCheck();
- echo($perf->SuspiciousSQL());
- echo($perf->ExpensiveSQL());
- echo($perf->InvalidSQL());
- echo $perf->Tables();
-
- echo "<pre>";
- echo $perf->HealthCheckCLI();
- $perf->Poll(3);
- die();
- }
-
- if ($perf) $perf->UI(3);
-}
-
-?>
+<?php + +include_once('../adodb-perf.inc.php'); + +error_reporting(E_ALL); +session_start(); + +if (isset($_GET)) { + foreach($_GET as $k => $v) { + if (strncmp($k,'test',4) == 0) $_SESSION['_db'] = $k; + } +} + +if (isset($_SESSION['_db'])) { + $_db = $_SESSION['_db']; + $_GET[$_db] = 1; + $$_db = 1; +} + +echo "<h1>Performance Monitoring</h1>"; +include_once('testdatabases.inc.php'); + + +function testdb($db) +{ + if (!$db) return; + echo "<font size=1>";print_r($db->ServerInfo()); echo " user=".$db->user."</font>"; + + $perf = NewPerfMonitor($db); + + # unit tests + if (0) { + //$DB->debug=1; + echo "Data Cache Size=".$perf->DBParameter('data cache size').'<p>'; + echo $perf->HealthCheck(); + echo($perf->SuspiciousSQL()); + echo($perf->ExpensiveSQL()); + echo($perf->InvalidSQL()); + echo $perf->Tables(); + + echo "<pre>"; + echo $perf->HealthCheckCLI(); + $perf->Poll(3); + die(); + } + + if ($perf) $perf->UI(3); +} + +?> diff --git a/trunk/adodb-for-php4/tests/test2.php b/trunk/adodb-for-php4/tests/test2.php index 3b1dafea..169aa0cc 100644 --- a/trunk/adodb-for-php4/tests/test2.php +++ b/trunk/adodb-for-php4/tests/test2.php @@ -1,26 +1,26 @@ -<?php
-
-// BASIC ADO test
-
- include_once('../adodb.inc.php');
-
- $db = &ADONewConnection("ado_access");
- $db->debug=1;
- $access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
- $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
- . 'DATA SOURCE=' . $access . ';';
-
- echo "<p>PHP ",PHP_VERSION,"</p>";
-
- $db->Connect($myDSN) || die('fail');
-
- print_r($db->ServerInfo());
-
- try {
- $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx");
- print_r($rs->fields);
- } catch(exception $e) {
- print_r($e);
- echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y');
- }
+<?php + +// BASIC ADO test + + include_once('../adodb.inc.php'); + + $db = &ADONewConnection("ado_access"); + $db->debug=1; + $access = 'd:\inetpub\wwwroot\php\NWIND.MDB'; + $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;' + . 'DATA SOURCE=' . $access . ';'; + + echo "<p>PHP ",PHP_VERSION,"</p>"; + + $db->Connect($myDSN) || die('fail'); + + print_r($db->ServerInfo()); + + try { + $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx"); + print_r($rs->fields); + } catch(exception $e) { + print_r($e); + echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y'); + } ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/tests/testgenid.php b/trunk/adodb-for-php4/tests/testgenid.php index 14b48ce3..bc54adac 100644 --- a/trunk/adodb-for-php4/tests/testgenid.php +++ b/trunk/adodb-for-php4/tests/testgenid.php @@ -1,36 +1,36 @@ -<?php
-/*
- V4.50 6 July 2004
-
- Run multiple copies of this php script at the same time
- to test unique generation of id's in multiuser mode
-*/
-include_once('../adodb.inc.php');
-$testaccess = true;
-include_once('testdatabases.inc.php');
-
-function testdb(&$db,$createtab="create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")
-{
- $table = 'adodbseq';
-
- $db->Execute("drop table $table");
- //$db->debug=true;
-
- $ctr = 5000;
- $lastnum = 0;
-
- while (--$ctr >= 0) {
- $num = $db->GenID($table);
- if ($num === false) {
- print "GenID returned false";
- break;
- }
- if ($lastnum + 1 == $num) print " $num ";
- else {
- print " <font color=red>$num</font> ";
- flush();
- }
- $lastnum = $num;
- }
-}
+<?php +/* + V4.50 6 July 2004 + + Run multiple copies of this php script at the same time + to test unique generation of id's in multiuser mode +*/ +include_once('../adodb.inc.php'); +$testaccess = true; +include_once('testdatabases.inc.php'); + +function testdb(&$db,$createtab="create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)") +{ + $table = 'adodbseq'; + + $db->Execute("drop table $table"); + //$db->debug=true; + + $ctr = 5000; + $lastnum = 0; + + while (--$ctr >= 0) { + $num = $db->GenID($table); + if ($num === false) { + print "GenID returned false"; + break; + } + if ($lastnum + 1 == $num) print " $num "; + else { + print " <font color=red>$num</font> "; + flush(); + } + $lastnum = $num; + } +} ?>
\ No newline at end of file diff --git a/trunk/adodb-for-php4/tute.htm b/trunk/adodb-for-php4/tute.htm index b060a985..3f2261e6 100644 --- a/trunk/adodb-for-php4/tute.htm +++ b/trunk/adodb-for-php4/tute.htm @@ -1,290 +1,290 @@ -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
-
-<html>
-<head>
- <title>Tutorial: Moving from MySQL to ADODB</title>
-</head>
-
-<body bgcolor=white>
-<h1>Tutorial: Moving from MySQL to ADODB</h1>
-
-<pre> You say eether and I say eyether,
- You say neether and I say nyther;
- Eether, eyether, neether, nyther -
- Let's call the whole thing off !
-<br>
- You like potato and I like po-tah-to,
- You like tomato and I like to-mah-to;
- Potato, po-tah-to, tomato, to-mah-to -
- Let's call the whole thing off !
-</pre>
-<p>I love this song, especially the version with Louis Armstrong and Ella singing
- duet. It is all about how hard it is for two people in love to be compatible
- with each other. It's about compromise and finding a common ground, and that's
- what this article is all about.
-<p>PHP is all about creating dynamic web-sites with the least fuss and the most
- fun. To create these websites we need to use databases to retrieve login information,
- to splash dynamic news onto the web page and store forum postings. So let's
- say we were using the popular MySQL database for this. Your company has done
- such a fantastic job that the Web site is more popular than your wildest dreams.
- You find that MySQL cannot scale to handle the workload; time to switch databases.
-<p> Unfortunately in PHP every database is accessed slightly differently. To connect
- to MySQL, you would use <i>mysql_connect()</i>; when you decide to upgrade to
- Oracle or Microsoft SQL Server, you would use <i>ocilogon() </i>or <i>mssql_connect()</i>
- respectively. What is worse is that the parameters you use for the different
- connect functions are different also.. One database says po-tato, the other
- database says pota-to. Oh-oh.
-<h3>Let's NOT call the whole thing off</h3>
-<p>A database wrapper library such as ADODB comes in handy when you need to ensure portability. It provides
- you with a common API to communicate with any supported database so you don't have to call things off. <p>
-
-<p>ADODB stands for Active Data Objects DataBase (sorry computer guys are sometimes
- not very original). ADODB currently supports MySQL, PostgreSQL, Oracle, Interbase,
- Microsoft SQL Server, Access, FoxPro, Sybase, ODBC and ADO. You can download
- ADODB from <a href=http://php.weblogs.com/adodb></a><a href="http://php.weblogs.com/adodb">http://php.weblogs.com/adodb</a>.
-<h3>MySQL Example</h3>
-<p>The most common database used with PHP is MySQL, so I guess you should be familiar
- with the following code. It connects to a MySQL server at <i>localhost</i>,
- database <i>mydb</i>, and executes an SQL select statement. The results are
- printed, one line per row.
-<pre><font color="#666600">$db = <b>mysql_connect</b>("localhost", "root", "password");
-<b>mysql_select_db</b>("mydb",$db);</font>
-<font color="#660000">$result = <b>mysql_query</b>("SELECT * FROM employees",$db)</font><code><font color="#663300">;
-if ($result === false) die("failed");</font></code>
-<font color="#006666"><b>while</b> ($fields =<b> mysql_fetch_row</b>($result)) {
- <b>for</b> ($i=0, $max=sizeof($fields); $i < $max; $i++) {
- <b>print</b> $fields[$i].' ';
- }
- <b>print</b> "<br>\n";
-}</font>
-</pre>
-<p>The above code has been color-coded by section. The first section is the connection
- phase. The second is the execution of the SQL, and the last section is displaying
- the fields. The <i>while</i> loop scans the rows of the result, while the <i>for</i>
- loop scans the fields in one row.</p>
-<p>Here is the equivalent code in ADODB</p>
-<pre><b><font color="#666600"> include("adodb.inc.php");</font></b><font color="#666600">
- $db = <b>NewADOConnection</b>('mysql');
- $db-><b>Connect</b>("localhost", "root", "password", "mydb");</font>
- <font color="#663300">$result = $db-><b>Execute</b>("SELECT * FROM employees");
- </font><font color="#663300"></font><code><font color="#663300">if ($result === false) die("failed")</font></code><code><font color="#663300">;</font></code>
- <font color="#006666"><b>while</b> (!$result->EOF) {
- <b>for</b> ($i=0, $max=$result-><b>FieldCount</b>(); $i < $max; $i++)
- <b>print</b> $result->fields[$i].' ';
- $result-><b>MoveNext</b>();
- <b>print</b> "<br>\n";
- }</font> </pre>
-<p></p>
-<p>Now porting to Oracle is as simple as changing the second line to <code>NewADOConnection('oracle')</code>.
- Let's walk through the code...</p>
-<h3>Connecting to the Database</h3>
-<p></p>
-<pre><b><font color="#666600">include("adodb.inc.php");</font></b><font color="#666600">
-$db = <b>NewADOConnection</b>('mysql');
-$db-><b>Connect</b>("localhost", "root", "password", "mydb");</font></pre>
-<p>The connection code is a bit more sophisticated than MySQL's because our needs
- are more sophisticated. In ADODB, we use an object-oriented approach to managing
- the complexity of handling multiple databases. We have different classes to
- handle different databases. If you aren't familiar with object-oriented programing,
- don't worry -- the complexity is all hidden away in the<code> NewADOConnection()</code>
- function.</p>
-<p>To conserve memory, we only load the PHP code specific to the database you
- are connecting to. We do this by calling <code>NewADOConnection(databasedriver)</code>.
- Legal database drivers include <i>mysql, mssql, oracle, oci8, postgres, sybase,
- vfp, access, ibase </i>and many others.</p>
-<p>Then we create a new instance of the connection class by calling <code>NewADOConnection()</code>.
- Finally we connect to the database using <code>$db->Connect(). </code></p>
-<h3>Executing the SQL</h3>
-<p><code><font color="#663300">$result = $db-><b>Execute</b>("SELECT *
- FROM employees");<br>
- if ($result === false) die("failed")</font></code><code><font color="#663300">;</font></code>
- <br>
-</p>
-<p>Sending the SQL statement to the server is straight forward. Execute() will
- return a recordset object on successful execution. You should check $result
- as we do above.
-<p>An issue that confuses beginners is the fact that we have two types of objects
- in ADODB, the connection object and the recordset object. When do we use each?
-<p>The connection object ($db) is responsible for connecting to the database,
- formatting your SQL and querying the database server. The recordset object ($result)
- is responsible for retrieving the results and formatting the reply as text or
- as an array.
-<p>The only thing I need to add is that ADODB provides several helper functions
- for making INSERT and UPDATE statements easier, which we will cover in the Advanced
- section.
-<h3>Retrieving the Data<br>
-</h3>
-<pre><font color="#006666"><b>while</b> (!$result->EOF) {
- <b>for</b> ($i=0, $max=$result-><b>FieldCount</b>(); $i < $max; $i++)
- <b>print</b> $result->fields[$i].' ';
- $result-><b>MoveNext</b>();
- <b>print</b> "<br>\n";
-}</font></pre>
-<p>The paradigm for getting the data is that it's like reading a file. For every
- line, we check first whether we have reached the end-of-file (EOF). While not
- end-of-file, loop through each field in the row. Then move to the next line
- (MoveNext) and repeat.
-<p>The <code>$result->fields[]</code> array is generated by the PHP database
- extension. Some database extensions do not index the array by field name.
- To force indexing by name - that is associative arrays -
- use the $ADODB_FETCH_MODE global variable.
-<pre>
- $<b>ADODB_FETCH_MODE</b> = ADODB_FETCH_NUM;
- $rs1 = $db->Execute('select * from table');
- $<b>ADODB_FETCH_MODE</b> = ADODB_FETCH_ASSOC;
- $rs2 = $db->Execute('select * from table');
- print_r($rs1->fields); // shows <i>array([0]=>'v0',[1] =>'v1')</i>
- print_r($rs2->fields); // shows <i>array(['col1']=>'v0',['col2'] =>'v1')</i>
-</pre>
-<p>
-As you can see in the above example, both recordsets store and use different fetch modes
-based on the $ADODB_FETCH_MODE setting when the recordset was created by Execute().</p>
-<h2>ADOConnection<a name="ADOConnection"></a></h2>
-<p>Object that performs the connection to the database, executes SQL statements
- and has a set of utility functions for standardising the format of SQL statements
- for issues such as concatenation and date formats.</p>
-
-<h3>Other Useful Functions</h3>
-<p><code>$recordset->Move($pos)</code> scrolls to that particular row. ADODB supports forward
- scrolling for all databases. Some databases will not support backwards scrolling.
- This is normally not a problem as you can always cache records to simulate backwards
- scrolling.
-<p><code>$recordset->RecordCount()</code> returns the number of records accessed by the
- SQL statement. Some databases will return -1 because it is not supported.
-<p><code>$recordset->GetArray()</code> returns the result as an array.
-<p><code>rs2html($recordset)</code> is a function that is generates a HTML table based on the
- $recordset passed to it. An example with the relevant lines in bold:
-<pre> include('adodb.inc.php');
- <b>include('tohtml.inc.php');</b> /* includes the rs2html function */
- $conn = &ADONewConnection('mysql');
- $conn->PConnect('localhost','userid','password','database');
- $rs = $conn->Execute('select * from table');
- <b> rs2html($rs)</b>; /* recordset to html table */ </pre>
-<p>There are many other helper functions that are listed in the documentation available at <a href="http://php.weblogs.com/adodb_manual"></a><a href="http://php.weblogs.com/adodb_manual">http://php.weblogs.com/adodb_manual</a>.
-<h2>Advanced Material</h2>
-<h3>Inserts and Updates </h3>
-<p>Let's say you want to insert the following data into a database.
-<p><b>ID</b> = 3<br>
- <b>TheDate</b>=mktime(0,0,0,8,31,2001) /* 31st August 2001 */<br>
- <b>Note</b>= sugar why don't we call it off
-<p>When you move to another database, your insert might no longer work.</p>
-<p>The first problem is that each database has a different default date format.
- MySQL expects YYYY-MM-DD format, while other databases have different defaults.
- ADODB has a function called DBDate() that addresses this issue by converting
- converting the date to the correct format.</p>
-<p>The next problem is that the <b>don't</b> in the Note needs to be quoted. In
- MySQL, we use <b>don\'t</b> but in some other databases (Sybase, Access, Microsoft
- SQL Server) we use <b>don''t. </b>The qstr() function addresses this issue.</p>
-<p>So how do we use the functions? Like this:</p>
-<pre>$sql = "INSERT INTO table (id, thedate,note) values ("
- . $<b>ID</b> . ','
- . $db->DBDate($<b>TheDate</b>) .','
- . $db->qstr($<b>Note</b>).")";
-$db->Execute($sql);</pre>
-<p>ADODB also supports <code>$connection->Affected_Rows()</code> (returns the
- number of rows affected by last update or delete) and <code>$recordset->Insert_ID()</code>
- (returns last autoincrement number generated by an insert statement). Be forewarned
- that not all databases support the two functions.<br>
-</p>
-<h3>MetaTypes</h3>
-<p>You can find out more information about each of the fields (I use the words
- fields and columns interchangebly) you are selecting by calling the recordset
- method <code>FetchField($fieldoffset)</code>. This will return an object with
- 3 properties: name, type and max_length.
-<pre>For example:</pre>
-<pre>$recordset = $conn->Execute("select adate from table");<br>$f0 = $recordset->FetchField(0);
-</pre>
-<p>Then <code>$f0->name</code> will hold <i>'adata'</i>, <code>$f0->type</code>
- will be set to '<i>date'</i>. If the max_length is unknown, it will be set to
- -1.
-<p>One problem with handling different databases is that each database often calls
- the same type by a different name. For example a <i>timestamp</i> type is called
- <i>datetime</i> in one database and <i>time</i> in another. So ADODB has a special
- <code>MetaType($type, $max_length)</code> function that standardises the types
- to the following:
-<p>C: character and varchar types<br>
- X: text or long character (eg. more than 255 bytes wide).<br>
- B: blob or binary image<br>
- D: date<br>
- T: timestamp<br>
- L: logical (boolean)<br>
- I: integer<br>
- N: numeric (float, double, money)
-<p>In the above date example,
-<p><code>$recordset = $conn->Execute("select adate from table");<br>
- $f0 = $recordset->FetchField(0);<br>
- $type = $recordset->MetaType($f0->type, $f0->max_length);<br>
- print $type; /* should print 'D'</code> */
-<p>
-<p><b>Select Limit and Top Support</b>
-<p>ADODB has a function called $connection->SelectLimit($sql,$nrows,$offset) that allows
-you to retrieve a subset of the recordset. This will take advantage of native
-SELECT TOP on Microsoft products and SELECT ... LIMIT with PostgreSQL and MySQL, and
-emulated if the database does not support it.
-<p><b>Caching Support</b>
-<p>ADODB allows you to cache recordsets in your file system, and only requery the database
-server after a certain timeout period with $connection->CacheExecute($secs2cache,$sql) and
-$connection->CacheSelectLimit($secs2cache,$sql,$nrows,$offset).
-<p><b>PHP4 Session Handler Support</b>
-<p>ADODB also supports PHP4 session handlers. You can store your session variables
- in a database for true scalability using ADODB. For further information, visit
- <a href="http://php.weblogs.com/adodb-sessions"></a><a href="http://php.weblogs.com/adodb-sessions">http://php.weblogs.com/adodb-sessions</a>
-<h3>Commercial Use Encouraged</h3>
-<p>If you plan to write commercial PHP applications that you want to resell, you should consider ADODB. It has been released using the lesser GPL, which means you can legally include it in commercial applications, while keeping your code proprietary. Commercial use of ADODB is strongly encouraged! We are using it internally for this reason.<p>
-
-<h2>Conclusion</h2>
-<p>As a thank you for finishing this article, here are the complete lyrics for
- <i>let's call the whole thing off</i>.<br>
- <br>
-<pre>
- Refrain
-<br>
- You say eether and I say eyether,
- You say neether and I say nyther;
- Eether, eyether, neether, nyther -
- Let's call the whole thing off !
-<br>
- You like potato and I like po-tah-to,
- You like tomato and I like to-mah-to;
- Potato, po-tah-to, tomato, to-mah-to -
- Let's call the whole thing off !
-<br>
-But oh, if we call the whole thing off, then we must part.
-And oh, if we ever part, then that might break my heart.
-<br>
- So, if you like pajamas and I like pa-jah-mas,
- I'll wear pajamas and give up pa-jah-mas.
- For we know we
- Need each other, so we
- Better call the calling off off.
- Let's call the whole thing off !
-<br>
- Second Refrain
-<br>
- You say laughter and I say lawfter,
- You say after and I say awfter;
- Laughter, lawfter, after, awfter -
- Let's call the whole thing off !
-<br>
- You like vanilla and I like vanella,
- You, sa's'parilla and I sa's'parella;
- Vanilla, vanella, choc'late, strawb'ry -
- Let's call the whole thing off !
-<br>
-But oh, if we call the whole thing off, then we must part.
-And oh, if we ever part, then that might break my heart.
-<br>
- So, if you go for oysters and I go for ersters,
- I'll order oysters and cancel the ersters.
- For we know we
- Need each other, so we
- Better call the calling off off.
- Let's call the whole thing off !
- </pre>
-<p><font size=2>Song and lyrics by George and Ira Gershwin, introduced by Fred Astaire and Ginger Rogers
-in the film "Shall We Dance?" </font><p>
-<p>
-(c)2001-2002 John Lim.
-
-</body>
-</html>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> + +<html> +<head> + <title>Tutorial: Moving from MySQL to ADODB</title> +</head> + +<body bgcolor=white> +<h1>Tutorial: Moving from MySQL to ADODB</h1> + +<pre> You say eether and I say eyether, + You say neether and I say nyther; + Eether, eyether, neether, nyther - + Let's call the whole thing off ! +<br> + You like potato and I like po-tah-to, + You like tomato and I like to-mah-to; + Potato, po-tah-to, tomato, to-mah-to - + Let's call the whole thing off ! +</pre> +<p>I love this song, especially the version with Louis Armstrong and Ella singing + duet. It is all about how hard it is for two people in love to be compatible + with each other. It's about compromise and finding a common ground, and that's + what this article is all about. +<p>PHP is all about creating dynamic web-sites with the least fuss and the most + fun. To create these websites we need to use databases to retrieve login information, + to splash dynamic news onto the web page and store forum postings. So let's + say we were using the popular MySQL database for this. Your company has done + such a fantastic job that the Web site is more popular than your wildest dreams. + You find that MySQL cannot scale to handle the workload; time to switch databases. +<p> Unfortunately in PHP every database is accessed slightly differently. To connect + to MySQL, you would use <i>mysql_connect()</i>; when you decide to upgrade to + Oracle or Microsoft SQL Server, you would use <i>ocilogon() </i>or <i>mssql_connect()</i> + respectively. What is worse is that the parameters you use for the different + connect functions are different also.. One database says po-tato, the other + database says pota-to. Oh-oh. +<h3>Let's NOT call the whole thing off</h3> +<p>A database wrapper library such as ADODB comes in handy when you need to ensure portability. It provides + you with a common API to communicate with any supported database so you don't have to call things off. <p> + +<p>ADODB stands for Active Data Objects DataBase (sorry computer guys are sometimes + not very original). ADODB currently supports MySQL, PostgreSQL, Oracle, Interbase, + Microsoft SQL Server, Access, FoxPro, Sybase, ODBC and ADO. You can download + ADODB from <a href=http://php.weblogs.com/adodb></a><a href="http://php.weblogs.com/adodb">http://php.weblogs.com/adodb</a>. +<h3>MySQL Example</h3> +<p>The most common database used with PHP is MySQL, so I guess you should be familiar + with the following code. It connects to a MySQL server at <i>localhost</i>, + database <i>mydb</i>, and executes an SQL select statement. The results are + printed, one line per row. +<pre><font color="#666600">$db = <b>mysql_connect</b>("localhost", "root", "password"); +<b>mysql_select_db</b>("mydb",$db);</font> +<font color="#660000">$result = <b>mysql_query</b>("SELECT * FROM employees",$db)</font><code><font color="#663300">; +if ($result === false) die("failed");</font></code> +<font color="#006666"><b>while</b> ($fields =<b> mysql_fetch_row</b>($result)) { + <b>for</b> ($i=0, $max=sizeof($fields); $i < $max; $i++) { + <b>print</b> $fields[$i].' '; + } + <b>print</b> "<br>\n"; +}</font> +</pre> +<p>The above code has been color-coded by section. The first section is the connection + phase. The second is the execution of the SQL, and the last section is displaying + the fields. The <i>while</i> loop scans the rows of the result, while the <i>for</i> + loop scans the fields in one row.</p> +<p>Here is the equivalent code in ADODB</p> +<pre><b><font color="#666600"> include("adodb.inc.php");</font></b><font color="#666600"> + $db = <b>NewADOConnection</b>('mysql'); + $db-><b>Connect</b>("localhost", "root", "password", "mydb");</font> + <font color="#663300">$result = $db-><b>Execute</b>("SELECT * FROM employees"); + </font><font color="#663300"></font><code><font color="#663300">if ($result === false) die("failed")</font></code><code><font color="#663300">;</font></code> + <font color="#006666"><b>while</b> (!$result->EOF) { + <b>for</b> ($i=0, $max=$result-><b>FieldCount</b>(); $i < $max; $i++) + <b>print</b> $result->fields[$i].' '; + $result-><b>MoveNext</b>(); + <b>print</b> "<br>\n"; + }</font> </pre> +<p></p> +<p>Now porting to Oracle is as simple as changing the second line to <code>NewADOConnection('oracle')</code>. + Let's walk through the code...</p> +<h3>Connecting to the Database</h3> +<p></p> +<pre><b><font color="#666600">include("adodb.inc.php");</font></b><font color="#666600"> +$db = <b>NewADOConnection</b>('mysql'); +$db-><b>Connect</b>("localhost", "root", "password", "mydb");</font></pre> +<p>The connection code is a bit more sophisticated than MySQL's because our needs + are more sophisticated. In ADODB, we use an object-oriented approach to managing + the complexity of handling multiple databases. We have different classes to + handle different databases. If you aren't familiar with object-oriented programing, + don't worry -- the complexity is all hidden away in the<code> NewADOConnection()</code> + function.</p> +<p>To conserve memory, we only load the PHP code specific to the database you + are connecting to. We do this by calling <code>NewADOConnection(databasedriver)</code>. + Legal database drivers include <i>mysql, mssql, oracle, oci8, postgres, sybase, + vfp, access, ibase </i>and many others.</p> +<p>Then we create a new instance of the connection class by calling <code>NewADOConnection()</code>. + Finally we connect to the database using <code>$db->Connect(). </code></p> +<h3>Executing the SQL</h3> +<p><code><font color="#663300">$result = $db-><b>Execute</b>("SELECT * + FROM employees");<br> + if ($result === false) die("failed")</font></code><code><font color="#663300">;</font></code> + <br> +</p> +<p>Sending the SQL statement to the server is straight forward. Execute() will + return a recordset object on successful execution. You should check $result + as we do above. +<p>An issue that confuses beginners is the fact that we have two types of objects + in ADODB, the connection object and the recordset object. When do we use each? +<p>The connection object ($db) is responsible for connecting to the database, + formatting your SQL and querying the database server. The recordset object ($result) + is responsible for retrieving the results and formatting the reply as text or + as an array. +<p>The only thing I need to add is that ADODB provides several helper functions + for making INSERT and UPDATE statements easier, which we will cover in the Advanced + section. +<h3>Retrieving the Data<br> +</h3> +<pre><font color="#006666"><b>while</b> (!$result->EOF) { + <b>for</b> ($i=0, $max=$result-><b>FieldCount</b>(); $i < $max; $i++) + <b>print</b> $result->fields[$i].' '; + $result-><b>MoveNext</b>(); + <b>print</b> "<br>\n"; +}</font></pre> +<p>The paradigm for getting the data is that it's like reading a file. For every + line, we check first whether we have reached the end-of-file (EOF). While not + end-of-file, loop through each field in the row. Then move to the next line + (MoveNext) and repeat. +<p>The <code>$result->fields[]</code> array is generated by the PHP database + extension. Some database extensions do not index the array by field name. + To force indexing by name - that is associative arrays - + use the $ADODB_FETCH_MODE global variable. +<pre> + $<b>ADODB_FETCH_MODE</b> = ADODB_FETCH_NUM; + $rs1 = $db->Execute('select * from table'); + $<b>ADODB_FETCH_MODE</b> = ADODB_FETCH_ASSOC; + $rs2 = $db->Execute('select * from table'); + print_r($rs1->fields); // shows <i>array([0]=>'v0',[1] =>'v1')</i> + print_r($rs2->fields); // shows <i>array(['col1']=>'v0',['col2'] =>'v1')</i> +</pre> +<p> +As you can see in the above example, both recordsets store and use different fetch modes +based on the $ADODB_FETCH_MODE setting when the recordset was created by Execute().</p> +<h2>ADOConnection<a name="ADOConnection"></a></h2> +<p>Object that performs the connection to the database, executes SQL statements + and has a set of utility functions for standardising the format of SQL statements + for issues such as concatenation and date formats.</p> + +<h3>Other Useful Functions</h3> +<p><code>$recordset->Move($pos)</code> scrolls to that particular row. ADODB supports forward + scrolling for all databases. Some databases will not support backwards scrolling. + This is normally not a problem as you can always cache records to simulate backwards + scrolling. +<p><code>$recordset->RecordCount()</code> returns the number of records accessed by the + SQL statement. Some databases will return -1 because it is not supported. +<p><code>$recordset->GetArray()</code> returns the result as an array. +<p><code>rs2html($recordset)</code> is a function that is generates a HTML table based on the + $recordset passed to it. An example with the relevant lines in bold: +<pre> include('adodb.inc.php'); + <b>include('tohtml.inc.php');</b> /* includes the rs2html function */ + $conn = &ADONewConnection('mysql'); + $conn->PConnect('localhost','userid','password','database'); + $rs = $conn->Execute('select * from table'); + <b> rs2html($rs)</b>; /* recordset to html table */ </pre> +<p>There are many other helper functions that are listed in the documentation available at <a href="http://php.weblogs.com/adodb_manual"></a><a href="http://php.weblogs.com/adodb_manual">http://php.weblogs.com/adodb_manual</a>. +<h2>Advanced Material</h2> +<h3>Inserts and Updates </h3> +<p>Let's say you want to insert the following data into a database. +<p><b>ID</b> = 3<br> + <b>TheDate</b>=mktime(0,0,0,8,31,2001) /* 31st August 2001 */<br> + <b>Note</b>= sugar why don't we call it off +<p>When you move to another database, your insert might no longer work.</p> +<p>The first problem is that each database has a different default date format. + MySQL expects YYYY-MM-DD format, while other databases have different defaults. + ADODB has a function called DBDate() that addresses this issue by converting + converting the date to the correct format.</p> +<p>The next problem is that the <b>don't</b> in the Note needs to be quoted. In + MySQL, we use <b>don\'t</b> but in some other databases (Sybase, Access, Microsoft + SQL Server) we use <b>don''t. </b>The qstr() function addresses this issue.</p> +<p>So how do we use the functions? Like this:</p> +<pre>$sql = "INSERT INTO table (id, thedate,note) values (" + . $<b>ID</b> . ',' + . $db->DBDate($<b>TheDate</b>) .',' + . $db->qstr($<b>Note</b>).")"; +$db->Execute($sql);</pre> +<p>ADODB also supports <code>$connection->Affected_Rows()</code> (returns the + number of rows affected by last update or delete) and <code>$recordset->Insert_ID()</code> + (returns last autoincrement number generated by an insert statement). Be forewarned + that not all databases support the two functions.<br> +</p> +<h3>MetaTypes</h3> +<p>You can find out more information about each of the fields (I use the words + fields and columns interchangebly) you are selecting by calling the recordset + method <code>FetchField($fieldoffset)</code>. This will return an object with + 3 properties: name, type and max_length. +<pre>For example:</pre> +<pre>$recordset = $conn->Execute("select adate from table");<br>$f0 = $recordset->FetchField(0); +</pre> +<p>Then <code>$f0->name</code> will hold <i>'adata'</i>, <code>$f0->type</code> + will be set to '<i>date'</i>. If the max_length is unknown, it will be set to + -1. +<p>One problem with handling different databases is that each database often calls + the same type by a different name. For example a <i>timestamp</i> type is called + <i>datetime</i> in one database and <i>time</i> in another. So ADODB has a special + <code>MetaType($type, $max_length)</code> function that standardises the types + to the following: +<p>C: character and varchar types<br> + X: text or long character (eg. more than 255 bytes wide).<br> + B: blob or binary image<br> + D: date<br> + T: timestamp<br> + L: logical (boolean)<br> + I: integer<br> + N: numeric (float, double, money) +<p>In the above date example, +<p><code>$recordset = $conn->Execute("select adate from table");<br> + $f0 = $recordset->FetchField(0);<br> + $type = $recordset->MetaType($f0->type, $f0->max_length);<br> + print $type; /* should print 'D'</code> */ +<p> +<p><b>Select Limit and Top Support</b> +<p>ADODB has a function called $connection->SelectLimit($sql,$nrows,$offset) that allows +you to retrieve a subset of the recordset. This will take advantage of native +SELECT TOP on Microsoft products and SELECT ... LIMIT with PostgreSQL and MySQL, and +emulated if the database does not support it. +<p><b>Caching Support</b> +<p>ADODB allows you to cache recordsets in your file system, and only requery the database +server after a certain timeout period with $connection->CacheExecute($secs2cache,$sql) and +$connection->CacheSelectLimit($secs2cache,$sql,$nrows,$offset). +<p><b>PHP4 Session Handler Support</b> +<p>ADODB also supports PHP4 session handlers. You can store your session variables + in a database for true scalability using ADODB. For further information, visit + <a href="http://php.weblogs.com/adodb-sessions"></a><a href="http://php.weblogs.com/adodb-sessions">http://php.weblogs.com/adodb-sessions</a> +<h3>Commercial Use Encouraged</h3> +<p>If you plan to write commercial PHP applications that you want to resell, you should consider ADODB. It has been released using the lesser GPL, which means you can legally include it in commercial applications, while keeping your code proprietary. Commercial use of ADODB is strongly encouraged! We are using it internally for this reason.<p> + +<h2>Conclusion</h2> +<p>As a thank you for finishing this article, here are the complete lyrics for + <i>let's call the whole thing off</i>.<br> + <br> +<pre> + Refrain +<br> + You say eether and I say eyether, + You say neether and I say nyther; + Eether, eyether, neether, nyther - + Let's call the whole thing off ! +<br> + You like potato and I like po-tah-to, + You like tomato and I like to-mah-to; + Potato, po-tah-to, tomato, to-mah-to - + Let's call the whole thing off ! +<br> +But oh, if we call the whole thing off, then we must part. +And oh, if we ever part, then that might break my heart. +<br> + So, if you like pajamas and I like pa-jah-mas, + I'll wear pajamas and give up pa-jah-mas. + For we know we + Need each other, so we + Better call the calling off off. + Let's call the whole thing off ! +<br> + Second Refrain +<br> + You say laughter and I say lawfter, + You say after and I say awfter; + Laughter, lawfter, after, awfter - + Let's call the whole thing off ! +<br> + You like vanilla and I like vanella, + You, sa's'parilla and I sa's'parella; + Vanilla, vanella, choc'late, strawb'ry - + Let's call the whole thing off ! +<br> +But oh, if we call the whole thing off, then we must part. +And oh, if we ever part, then that might break my heart. +<br> + So, if you go for oysters and I go for ersters, + I'll order oysters and cancel the ersters. + For we know we + Need each other, so we + Better call the calling off off. + Let's call the whole thing off ! + </pre> +<p><font size=2>Song and lyrics by George and Ira Gershwin, introduced by Fred Astaire and Ginger Rogers +in the film "Shall We Dance?" </font><p> +<p> +(c)2001-2002 John Lim. + +</body> +</html> diff --git a/trunk/adodb-for-php4/xmlschema03.dtd b/trunk/adodb-for-php4/xmlschema03.dtd index a7c8864f..97850bc7 100644 --- a/trunk/adodb-for-php4/xmlschema03.dtd +++ b/trunk/adodb-for-php4/xmlschema03.dtd @@ -1,43 +1,43 @@ -<?xml version="1.0"?>
-<!DOCTYPE adodb_schema [
-<!ELEMENT schema (table*, sql*)>
-<!ATTLIST schema version CDATA #REQUIRED>
-<!ELEMENT table (descr?, (field+|DROP), constraint*, opt*, index*, data*)>
-<!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED>
-<!ELEMENT field (descr?, (NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?, NOQUOTE?, UNSIGNED?, constraint*, opt*)>
-<!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED opts CDATA #IMPLIED>
-<!ELEMENT data (descr?, row+)>
-<!ATTLIST data platform CDATA #IMPLIED>
-<!ELEMENT row (f+)>
-<!ELEMENT f (#CDATA)>
-<!ATTLIST f name CDATA #IMPLIED>
-<!ELEMENT descr (#CDATA)>
-<!ELEMENT NOTNULL EMPTY>
-<!ELEMENT KEY EMPTY>
-<!ELEMENT PRIMARY EMPTY>
-<!ELEMENT AUTO EMPTY>
-<!ELEMENT AUTOINCREMENT EMPTY>
-<!ELEMENT DEFAULT EMPTY>
-<!ATTLIST DEFAULT value CDATA #REQUIRED>
-<!ELEMENT DEFDATE EMPTY>
-<!ELEMENT DEFTIMESTAMP EMPTY>
-<!ELEMENT NOQUOTE EMPTY>
-<!ELEMENT UNSIGNED EMPTY>
-<!ELEMENT DROP EMPTY>
-<!ELEMENT constraint (#CDATA)>
-<!ATTLIST constraint platform CDATA #IMPLIED>
-<!ELEMENT opt (#CDATA)>
-<!ATTLIST opt platform CDATA #IMPLIED>
-<!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)>
-<!ATTLIST index name CDATA #REQUIRED platform CDATA #IMPLIED>
-<!ELEMENT col (#CDATA)>
-<!ELEMENT CLUSTERED EMPTY>
-<!ELEMENT BITMAP EMPTY>
-<!ELEMENT UNIQUE EMPTY>
-<!ELEMENT FULLTEXT EMPTY>
-<!ELEMENT HASH EMPTY>
-<!ELEMENT sql (query+, descr?)>
-<!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE)>
-<!ELEMENT query (#CDATA)>
-<!ATTLIST query platform CDATA #IMPLIED>
+<?xml version="1.0"?> +<!DOCTYPE adodb_schema [ +<!ELEMENT schema (table*, sql*)> +<!ATTLIST schema version CDATA #REQUIRED> +<!ELEMENT table (descr?, (field+|DROP), constraint*, opt*, index*, data*)> +<!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED> +<!ELEMENT field (descr?, (NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?, NOQUOTE?, UNSIGNED?, constraint*, opt*)> +<!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED opts CDATA #IMPLIED> +<!ELEMENT data (descr?, row+)> +<!ATTLIST data platform CDATA #IMPLIED> +<!ELEMENT row (f+)> +<!ELEMENT f (#CDATA)> +<!ATTLIST f name CDATA #IMPLIED> +<!ELEMENT descr (#CDATA)> +<!ELEMENT NOTNULL EMPTY> +<!ELEMENT KEY EMPTY> +<!ELEMENT PRIMARY EMPTY> +<!ELEMENT AUTO EMPTY> +<!ELEMENT AUTOINCREMENT EMPTY> +<!ELEMENT DEFAULT EMPTY> +<!ATTLIST DEFAULT value CDATA #REQUIRED> +<!ELEMENT DEFDATE EMPTY> +<!ELEMENT DEFTIMESTAMP EMPTY> +<!ELEMENT NOQUOTE EMPTY> +<!ELEMENT UNSIGNED EMPTY> +<!ELEMENT DROP EMPTY> +<!ELEMENT constraint (#CDATA)> +<!ATTLIST constraint platform CDATA #IMPLIED> +<!ELEMENT opt (#CDATA)> +<!ATTLIST opt platform CDATA #IMPLIED> +<!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)> +<!ATTLIST index name CDATA #REQUIRED platform CDATA #IMPLIED> +<!ELEMENT col (#CDATA)> +<!ELEMENT CLUSTERED EMPTY> +<!ELEMENT BITMAP EMPTY> +<!ELEMENT UNIQUE EMPTY> +<!ELEMENT FULLTEXT EMPTY> +<!ELEMENT HASH EMPTY> +<!ELEMENT sql (query+, descr?)> +<!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE)> +<!ELEMENT query (#CDATA)> +<!ATTLIST query platform CDATA #IMPLIED> ]>
\ No newline at end of file |