xoops forums

wishcraft

Module Developer
Posted on: 2010/2/18 21:45
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#1

ADOdb - Database other than MySQL

3rd Party Recommendation

Homepage: http://adodb.sourceforge.net/
Sourceforge Download: http://sourceforge.net/projects/adodb/
Project Title: ADOdb Database Abstraction Library for PHP
Requirements: PHP 5.0 or later. There is a version available that works with PHP 4.1 to 5.2 also.

This class I have constructed tonight will allow XOOPS to talk to :: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, andgeneric ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP --- Database systems.

ADOdb is a workhorse when it comes to pdo libraries for Xoops. And it is all tested.. Bundling this with a small function similar to text sanitization for SQL Parsing between systems, so a module only has to come with one SQL file and convert it on the fly.

The full database system for XOOPS would with what I have envisaged is this sort of spectrum of support for databases, I think it should be adopted as the PDO for 3.0 as well.. then they will be cross compatible.

So far with xoops2_class_database_adodb_0.10.zip - the pre alpha of this code the sessions and loggin on has crashed and burned.. but the database works fine.

Give it a test on mysql, seems to be runnin fine, replace your database directory with this one. The archive xoops2_class_database_adodb_0.10.zip is a prealpha and contains the following paths and files:


docs
htdocs
docsdirlist.txt
docsINSTALL
htdocsclass
htdocsclassdatabase
htdocsclassdatabaseaccess_adodb.php
htdocsclassdatabaseado5_adodb.php
htdocsclassdatabaseadodb
htdocsclassdatabaseado_access_adodb.php
htdocsclassdatabaseado_adodb.php
htdocsclassdatabaseado_mssql_adodb.php
htdocsclassdatabaseads_adodb.php
htdocsclassdatabaseborland_ibase_adodb.php
htdocsclassdatabasecsv_adodb.php
htdocsclassdatabasedatabase.php
htdocsclassdatabasedatabasefactory.php
htdocsclassdatabasedb2oci_adodb.php
htdocsclassdatabasedb2_adodb.php
htdocsclassdatabasefbsql_adodb.php
htdocsclassdatabasefirebird_adodb.php
htdocsclassdatabaseibase_adodb.php
htdocsclassdatabaseindex.html
htdocsclassdatabaseinformix72_adodb.php
htdocsclassdatabaseinformix_adodb.php
htdocsclassdatabaseldap_adodb.php
htdocsclassdatabasemssqlnative_adodb.php
htdocsclassdatabasemssqlpo_adodb.php
htdocsclassdatabasemssql_adodb.php
htdocsclassdatabasemssql_n_adodb.php
htdocsclassdatabasemysqli_adodb.php
htdocsclassdatabasemysqlpo_adodb.php
htdocsclassdatabasemysqlt_adodb.php
htdocsclassdatabasemysql_adodb.php
htdocsclassdatabasenetezza_adodb.php
htdocsclassdatabaseoci805_adodb.php
htdocsclassdatabaseoci8po_adodb.php
htdocsclassdatabaseoci8_adodb.php
htdocsclassdatabaseodbc_adodb.php
htdocsclassdatabaseodbc_db2_adodb.php
htdocsclassdatabaseodbc_mssql_adodb.php
htdocsclassdatabaseodbc_oracle_adodb.php
htdocsclassdatabaseodbtp_adodb.php
htdocsclassdatabaseodbtp_unicode_adodb.php
htdocsclassdatabaseoracle_adodb.php
htdocsclassdatabasepdo
htdocsclassdatabasepdo_adodb.php
htdocsclassdatabasepdo_mssql_adodb.php
htdocsclassdatabasepdo_mysql_adodb.php
htdocsclassdatabasepdo_oci_adodb.php
htdocsclassdatabasepdo_pgsql_adodb.php
htdocsclassdatabasepdo_sqlite_adodb.php
htdocsclassdatabasepostgres7_adodb.php
htdocsclassdatabasepostgres8_adodb.php
htdocsclassdatabasepostgres_adodb.php
htdocsclassdatabaseproxy_adodb.php
htdocsclassdatabasesapdb_adodb.php
htdocsclassdatabasesqlanywhere_adodb.php
htdocsclassdatabasesqlitepo_adodb.php
htdocsclassdatabasesqlite_adodb.php
htdocsclassdatabasesqlutility.php
htdocsclassdatabasesybase_adodb.php
htdocsclassdatabasesybase_ase_adodb.php
htdocsclassdatabasevfp_adodb.php
htdocsclassdatabaseadodbadodb-active-record.inc.php
htdocsclassdatabaseadodbadodb-active-recordx.inc.php
htdocsclassdatabaseadodbadodb-csvlib.inc.php
htdocsclassdatabaseadodbadodb-datadict.inc.php
htdocsclassdatabaseadodbadodb-error.inc.php
htdocsclassdatabaseadodbadodb-errorhandler.inc.php
htdocsclassdatabaseadodbadodb-errorpear.inc.php
htdocsclassdatabaseadodbadodb-exceptions.inc.php
htdocsclassdatabaseadodbadodb-iterator.inc.php
htdocsclassdatabaseadodbadodb-lib.inc.php
htdocsclassdatabaseadodbadodb-memcache.lib.inc.php
htdocsclassdatabaseadodbadodb-pager.inc.php
htdocsclassdatabaseadodbadodb-pear.inc.php
htdocsclassdatabaseadodbadodb-perf.inc.php
htdocsclassdatabaseadodbadodb-php4.inc.php
htdocsclassdatabaseadodbadodb-time.inc.php
htdocsclassdatabaseadodbadodb-xmlschema.inc.php
htdocsclassdatabaseadodbadodb-xmlschema03.inc.php
htdocsclassdatabaseadodbadodb.inc.php
htdocsclassdatabaseadodbadodb5
htdocsclassdatabaseadodbcontrib
htdocsclassdatabaseadodbcute_icons_for_site
htdocsclassdatabaseadodbdatadict
htdocsclassdatabaseadodbdocs
htdocsclassdatabaseadodbdrivers
htdocsclassdatabaseadodblang
htdocsclassdatabaseadodblicense.txt
htdocsclassdatabaseadodbpear
htdocsclassdatabaseadodbperf
htdocsclassdatabaseadodbpivottable.inc.php
htdocsclassdatabaseadodbreadme.txt
htdocsclassdatabaseadodbrsfilter.inc.php
htdocsclassdatabaseadodbserver.php
htdocsclassdatabaseadodbsession
htdocsclassdatabaseadodbtests
htdocsclassdatabaseadodbtoexport.inc.php
htdocsclassdatabaseadodbtohtml.inc.php
htdocsclassdatabaseadodbxmlschema.dtd
htdocsclassdatabaseadodbxmlschema03.dtd
htdocsclassdatabaseadodbxsl
htdocsclassdatabaseadodbcontribtoxmlrpc.inc.php
htdocsclassdatabaseadodbcute_icons_for_siteadodb.gif
htdocsclassdatabaseadodbcute_icons_for_siteadodb2.gif
htdocsclassdatabaseadodbdatadictdatadict-access.inc.php
htdocsclassdatabaseadodbdatadictdatadict-db2.inc.php
htdocsclassdatabaseadodbdatadictdatadict-firebird.inc.php
htdocsclassdatabaseadodbdatadictdatadict-generic.inc.php
htdocsclassdatabaseadodbdatadictdatadict-ibase.inc.php
htdocsclassdatabaseadodbdatadictdatadict-informix.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mssql.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mssqlnative.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mysql.inc.php
htdocsclassdatabaseadodbdatadictdatadict-oci8.inc.php
htdocsclassdatabaseadodbdatadictdatadict-postgres.inc.php
htdocsclassdatabaseadodbdatadictdatadict-sapdb.inc.php
htdocsclassdatabaseadodbdatadictdatadict-sybase.inc.php
htdocsclassdatabaseadodbdocsdocs-active-record.htm
htdocsclassdatabaseadodbdocsdocs-adodb.htm
htdocsclassdatabaseadodbdocsdocs-datadict.htm
htdocsclassdatabaseadodbdocsdocs-oracle.htm
htdocsclassdatabaseadodbdocsdocs-perf.htm
htdocsclassdatabaseadodbdocsdocs-session.htm
htdocsclassdatabaseadodbdocsdocs-session.old.htm
htdocsclassdatabaseadodbdocsold-changelog.htm
htdocsclassdatabaseadodbdocsreadme.htm
htdocsclassdatabaseadodbdocstips_portable_sql.htm
htdocsclassdatabaseadodbdocstute.htm
htdocsclassdatabaseadodbdriversadodb-access.inc.php
htdocsclassdatabaseadodbdriversadodb-ado.inc.php
htdocsclassdatabaseadodbdriversadodb-ado5.inc.php
htdocsclassdatabaseadodbdriversadodb-ado_access.inc.php
htdocsclassdatabaseadodbdriversadodb-ado_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-ads.inc.php
htdocsclassdatabaseadodbdriversadodb-borland_ibase.inc.php
htdocsclassdatabaseadodbdriversadodb-csv.inc.php
htdocsclassdatabaseadodbdriversadodb-db2.inc.php
htdocsclassdatabaseadodbdriversadodb-db2oci.inc.php
htdocsclassdatabaseadodbdriversadodb-fbsql.inc.php
htdocsclassdatabaseadodbdriversadodb-firebird.inc.php
htdocsclassdatabaseadodbdriversadodb-ibase.inc.php
htdocsclassdatabaseadodbdriversadodb-informix.inc.php
htdocsclassdatabaseadodbdriversadodb-informix72.inc.php
htdocsclassdatabaseadodbdriversadodb-ldap.inc.php
htdocsclassdatabaseadodbdriversadodb-mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-mssqlnative.inc.php
htdocsclassdatabaseadodbdriversadodb-mssqlpo.inc.php
htdocsclassdatabaseadodbdriversadodb-mssql_n.inc.php
htdocsclassdatabaseadodbdriversadodb-mysql.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqli.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqlpo.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqlt.inc.php
htdocsclassdatabaseadodbdriversadodb-netezza.inc.php
htdocsclassdatabaseadodbdriversadodb-oci8.inc.php
htdocsclassdatabaseadodbdriversadodb-oci805.inc.php
htdocsclassdatabaseadodbdriversadodb-oci8po.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_db2.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_oracle.inc.php
htdocsclassdatabaseadodbdriversadodb-odbtp.inc.php
htdocsclassdatabaseadodbdriversadodb-odbtp_unicode.inc.php
htdocsclassdatabaseadodbdriversadodb-oracle.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_mysql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_oci.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_pgsql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_sqlite.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres64.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres7.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres8.inc.php
htdocsclassdatabaseadodbdriversadodb-proxy.inc.php
htdocsclassdatabaseadodbdriversadodb-sapdb.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlanywhere.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlite.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlitepo.inc.php
htdocsclassdatabaseadodbdriversadodb-sybase.inc.php
htdocsclassdatabaseadodbdriversadodb-sybase_ase.inc.php
htdocsclassdatabaseadodbdriversadodb-vfp.inc.php
htdocsclassdatabaseadodblangadodb-ar.inc.php
htdocsclassdatabaseadodblangadodb-bg.inc.php
htdocsclassdatabaseadodblangadodb-bgutf8.inc.php
htdocsclassdatabaseadodblangadodb-ca.inc.php
htdocsclassdatabaseadodblangadodb-cn.inc.php
htdocsclassdatabaseadodblangadodb-cz.inc.php
htdocsclassdatabaseadodblangadodb-da.inc.php
htdocsclassdatabaseadodblangadodb-de.inc.php
htdocsclassdatabaseadodblangadodb-en.inc.php
htdocsclassdatabaseadodblangadodb-es.inc.php
htdocsclassdatabaseadodblangadodb-esperanto.inc.php
htdocsclassdatabaseadodblangadodb-fa.inc.php
htdocsclassdatabaseadodblangadodb-fr.inc.php
htdocsclassdatabaseadodblangadodb-hu.inc.php
htdocsclassdatabaseadodblangadodb-it.inc.php
htdocsclassdatabaseadodblangadodb-nl.inc.php
htdocsclassdatabaseadodblangadodb-pl.inc.php
htdocsclassdatabaseadodblangadodb-pt-br.inc.php
htdocsclassdatabaseadodblangadodb-ro.inc.php
htdocsclassdatabaseadodblangadodb-ru1251.inc.php
htdocsclassdatabaseadodblangadodb-sv.inc.php
htdocsclassdatabaseadodblangadodb-uk1251.inc.php
htdocsclassdatabaseadodblangadodb_th.inc.php
htdocsclassdatabaseadodbpearAuth
htdocsclassdatabaseadodbpearreadme.Auth.txt
htdocsclassdatabaseadodbpearAuthContainer
htdocsclassdatabaseadodbpearAuthContainerADOdb.php
htdocsclassdatabaseadodbperfperf-db2.inc.php
htdocsclassdatabaseadodbperfperf-informix.inc.php
htdocsclassdatabaseadodbperfperf-mssql.inc.php
htdocsclassdatabaseadodbperfperf-mssqlnative.inc.php
htdocsclassdatabaseadodbperfperf-mysql.inc.php
htdocsclassdatabaseadodbperfperf-oci8.inc.php
htdocsclassdatabaseadodbperfperf-postgres.inc.php
htdocsclassdatabaseadodbsessionadodb-compress-bzip2.php
htdocsclassdatabaseadodbsessionadodb-compress-gzip.php
htdocsclassdatabaseadodbsessionadodb-cryptsession.php
htdocsclassdatabaseadodbsessionadodb-cryptsession2.php
htdocsclassdatabaseadodbsessionadodb-encrypt-mcrypt.php
htdocsclassdatabaseadodbsessionadodb-encrypt-md5.php
htdocsclassdatabaseadodbsessionadodb-encrypt-secret.php
htdocsclassdatabaseadodbsessionadodb-encrypt-sha1.php
htdocsclassdatabaseadodbsessionadodb-sess.txt
htdocsclassdatabaseadodbsessionadodb-session-clob.php
htdocsclassdatabaseadodbsessionadodb-session-clob2.php
htdocsclassdatabaseadodbsessionadodb-session.php
htdocsclassdatabaseadodbsessionadodb-session2.php
htdocsclassdatabaseadodbsessionadodb-sessions.mysql.sql
htdocsclassdatabaseadodbsessionadodb-sessions.oracle.clob.sql
htdocsclassdatabaseadodbsessionadodb-sessions.oracle.sql
htdocsclassdatabaseadodbsessioncrypt.inc.php
htdocsclassdatabaseadodbsessionold
htdocsclassdatabaseadodbsessionsession_schema.xml
htdocsclassdatabaseadodbsessionsession_schema2.xml
htdocsclassdatabaseadodbsessionoldadodb-cryptsession.php
htdocsclassdatabaseadodbsessionoldadodb-session-clob.php
htdocsclassdatabaseadodbsessionoldadodb-session.php
htdocsclassdatabaseadodbsessionoldcrypt.inc.php
htdocsclassdatabaseadodbtestsbenchmark.php
htdocsclassdatabaseadodbtestsclient.php
htdocsclassdatabaseadodbtestspdo.php
htdocsclassdatabaseadodbteststest-active-record.php
htdocsclassdatabaseadodbteststest-active-recs2.php
htdocsclassdatabaseadodbteststest-active-relations.php
htdocsclassdatabaseadodbteststest-active-relationsx.php
htdocsclassdatabaseadodbteststest-datadict.php
htdocsclassdatabaseadodbteststest-perf.php
htdocsclassdatabaseadodbteststest-pgblob.php
htdocsclassdatabaseadodbteststest-php5.php
htdocsclassdatabaseadodbteststest-xmlschema.php
htdocsclassdatabaseadodbteststest.php
htdocsclassdatabaseadodbteststest2.php
htdocsclassdatabaseadodbteststest3.php
htdocsclassdatabaseadodbteststest4.php
htdocsclassdatabaseadodbteststest5.php
htdocsclassdatabaseadodbteststestcache.php
htdocsclassdatabaseadodbteststestdatabases.inc.php
htdocsclassdatabaseadodbteststestgenid.php
htdocsclassdatabaseadodbteststestmssql.php
htdocsclassdatabaseadodbteststestoci8.php
htdocsclassdatabaseadodbteststestoci8cursor.php
htdocsclassdatabaseadodbteststestpaging.php
htdocsclassdatabaseadodbteststestpear.php
htdocsclassdatabaseadodbteststestsessions.php
htdocsclassdatabaseadodbteststest_rs_array.php
htdocsclassdatabaseadodbteststime.php
htdocsclassdatabaseadodbteststmssql.php
htdocsclassdatabaseadodbtestsxmlschema-mssql.xml
htdocsclassdatabaseadodbtestsxmlschema.xml
htdocsclassdatabaseadodbxslconvert-0.1-0.2.xsl
htdocsclassdatabaseadodbxslconvert-0.1-0.3.xsl
htdocsclassdatabaseadodbxslconvert-0.2-0.1.xsl
htdocsclassdatabaseadodbxslconvert-0.2-0.3.xsl
htdocsclassdatabaseadodbxslremove-0.2.xsl
htdocsclassdatabaseadodbxslremove-0.3.xsl

wishcraft

Module Developer
Posted on: 2010/2/19 4:44
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#2

Re: ADOdb - Database other than MySQL

xoops2_class_database_adodb_0.15.zip

Archive Contains:
docs
htdocs
docsdirlist.txt
docsINSTALL
htdocsclass
htdocsclassdatabase
htdocsclassdatabaseaccess_adodb.php
htdocsclassdatabaseado5_adodb.php
htdocsclassdatabaseadodb
htdocsclassdatabaseado_access_adodb.php
htdocsclassdatabaseado_adodb.php
htdocsclassdatabaseado_mssql_adodb.php
htdocsclassdatabaseads_adodb.php
htdocsclassdatabaseborland_ibase_adodb.php
htdocsclassdatabasecsv_adodb.php
htdocsclassdatabasedatabase.php
htdocsclassdatabasedatabasefactory.php
htdocsclassdatabasedb2oci_adodb.php
htdocsclassdatabasedb2_adodb.php
htdocsclassdatabasefbsql_adodb.php
htdocsclassdatabasefirebird_adodb.php
htdocsclassdatabaseibase_adodb.php
htdocsclassdatabaseindex.html
htdocsclassdatabaseinformix72_adodb.php
htdocsclassdatabaseinformix_adodb.php
htdocsclassdatabaseldap_adodb.php
htdocsclassdatabasemssqlnative_adodb.php
htdocsclassdatabasemssqlpo_adodb.php
htdocsclassdatabasemssql_adodb.php
htdocsclassdatabasemssql_n_adodb.php
htdocsclassdatabasemysqli_adodb.php
htdocsclassdatabasemysqlpo_adodb.php
htdocsclassdatabasemysqlt_adodb.php
htdocsclassdatabasemysql_adodb.php
htdocsclassdatabasenetezza_adodb.php
htdocsclassdatabaseoci805_adodb.php
htdocsclassdatabaseoci8po_adodb.php
htdocsclassdatabaseoci8_adodb.php
htdocsclassdatabaseodbc_adodb.php
htdocsclassdatabaseodbc_db2_adodb.php
htdocsclassdatabaseodbc_mssql_adodb.php
htdocsclassdatabaseodbc_oracle_adodb.php
htdocsclassdatabaseodbtp_adodb.php
htdocsclassdatabaseodbtp_unicode_adodb.php
htdocsclassdatabaseoracle_adodb.php
htdocsclassdatabasepdo
htdocsclassdatabasepdo_adodb.php
htdocsclassdatabasepdo_mssql_adodb.php
htdocsclassdatabasepdo_mysql_adodb.php
htdocsclassdatabasepdo_oci_adodb.php
htdocsclassdatabasepdo_pgsql_adodb.php
htdocsclassdatabasepdo_sqlite_adodb.php
htdocsclassdatabasepostgres7_adodb.php
htdocsclassdatabasepostgres8_adodb.php
htdocsclassdatabasepostgres_adodb.php
htdocsclassdatabaseproxy_adodb.php
htdocsclassdatabasesapdb_adodb.php
htdocsclassdatabasesqlanywhere_adodb.php
htdocsclassdatabasesqlitepo_adodb.php
htdocsclassdatabasesqlite_adodb.php
htdocsclassdatabasesqlutility.php
htdocsclassdatabasesybase_adodb.php
htdocsclassdatabasesybase_ase_adodb.php
htdocsclassdatabasevfp_adodb.php
htdocsclassdatabaseadodbadodb-active-record.inc.php
htdocsclassdatabaseadodbadodb-active-recordx.inc.php
htdocsclassdatabaseadodbadodb-csvlib.inc.php
htdocsclassdatabaseadodbadodb-datadict.inc.php
htdocsclassdatabaseadodbadodb-error.inc.php
htdocsclassdatabaseadodbadodb-errorhandler.inc.php
htdocsclassdatabaseadodbadodb-errorpear.inc.php
htdocsclassdatabaseadodbadodb-exceptions.inc.php
htdocsclassdatabaseadodbadodb-iterator.inc.php
htdocsclassdatabaseadodbadodb-lib.inc.php
htdocsclassdatabaseadodbadodb-memcache.lib.inc.php
htdocsclassdatabaseadodbadodb-pager.inc.php
htdocsclassdatabaseadodbadodb-pear.inc.php
htdocsclassdatabaseadodbadodb-perf.inc.php
htdocsclassdatabaseadodbadodb-php4.inc.php
htdocsclassdatabaseadodbadodb-time.inc.php
htdocsclassdatabaseadodbadodb-xmlschema.inc.php
htdocsclassdatabaseadodbadodb-xmlschema03.inc.php
htdocsclassdatabaseadodbadodb.inc.php
htdocsclassdatabaseadodbadodb5
htdocsclassdatabaseadodbcontrib
htdocsclassdatabaseadodbcute_icons_for_site
htdocsclassdatabaseadodbdatadict
htdocsclassdatabaseadodbdocs
htdocsclassdatabaseadodbdrivers
htdocsclassdatabaseadodblang
htdocsclassdatabaseadodblicense.txt
htdocsclassdatabaseadodbpear
htdocsclassdatabaseadodbperf
htdocsclassdatabaseadodbpivottable.inc.php
htdocsclassdatabaseadodbreadme.txt
htdocsclassdatabaseadodbrsfilter.inc.php
htdocsclassdatabaseadodbserver.php
htdocsclassdatabaseadodbsession
htdocsclassdatabaseadodbtests
htdocsclassdatabaseadodbtoexport.inc.php
htdocsclassdatabaseadodbtohtml.inc.php
htdocsclassdatabaseadodbxmlschema.dtd
htdocsclassdatabaseadodbxmlschema03.dtd
htdocsclassdatabaseadodbxsl
htdocsclassdatabaseadodbcontribtoxmlrpc.inc.php
htdocsclassdatabaseadodbcute_icons_for_siteadodb.gif
htdocsclassdatabaseadodbcute_icons_for_siteadodb2.gif
htdocsclassdatabaseadodbdatadictdatadict-access.inc.php
htdocsclassdatabaseadodbdatadictdatadict-db2.inc.php
htdocsclassdatabaseadodbdatadictdatadict-firebird.inc.php
htdocsclassdatabaseadodbdatadictdatadict-generic.inc.php
htdocsclassdatabaseadodbdatadictdatadict-ibase.inc.php
htdocsclassdatabaseadodbdatadictdatadict-informix.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mssql.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mssqlnative.inc.php
htdocsclassdatabaseadodbdatadictdatadict-mysql.inc.php
htdocsclassdatabaseadodbdatadictdatadict-oci8.inc.php
htdocsclassdatabaseadodbdatadictdatadict-postgres.inc.php
htdocsclassdatabaseadodbdatadictdatadict-sapdb.inc.php
htdocsclassdatabaseadodbdatadictdatadict-sybase.inc.php
htdocsclassdatabaseadodbdocsdocs-active-record.htm
htdocsclassdatabaseadodbdocsdocs-adodb.htm
htdocsclassdatabaseadodbdocsdocs-datadict.htm
htdocsclassdatabaseadodbdocsdocs-oracle.htm
htdocsclassdatabaseadodbdocsdocs-perf.htm
htdocsclassdatabaseadodbdocsdocs-session.htm
htdocsclassdatabaseadodbdocsdocs-session.old.htm
htdocsclassdatabaseadodbdocsold-changelog.htm
htdocsclassdatabaseadodbdocsreadme.htm
htdocsclassdatabaseadodbdocstips_portable_sql.htm
htdocsclassdatabaseadodbdocstute.htm
htdocsclassdatabaseadodbdriversadodb-access.inc.php
htdocsclassdatabaseadodbdriversadodb-ado.inc.php
htdocsclassdatabaseadodbdriversadodb-ado5.inc.php
htdocsclassdatabaseadodbdriversadodb-ado_access.inc.php
htdocsclassdatabaseadodbdriversadodb-ado_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-ads.inc.php
htdocsclassdatabaseadodbdriversadodb-borland_ibase.inc.php
htdocsclassdatabaseadodbdriversadodb-csv.inc.php
htdocsclassdatabaseadodbdriversadodb-db2.inc.php
htdocsclassdatabaseadodbdriversadodb-db2oci.inc.php
htdocsclassdatabaseadodbdriversadodb-fbsql.inc.php
htdocsclassdatabaseadodbdriversadodb-firebird.inc.php
htdocsclassdatabaseadodbdriversadodb-ibase.inc.php
htdocsclassdatabaseadodbdriversadodb-informix.inc.php
htdocsclassdatabaseadodbdriversadodb-informix72.inc.php
htdocsclassdatabaseadodbdriversadodb-ldap.inc.php
htdocsclassdatabaseadodbdriversadodb-mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-mssqlnative.inc.php
htdocsclassdatabaseadodbdriversadodb-mssqlpo.inc.php
htdocsclassdatabaseadodbdriversadodb-mssql_n.inc.php
htdocsclassdatabaseadodbdriversadodb-mysql.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqli.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqlpo.inc.php
htdocsclassdatabaseadodbdriversadodb-mysqlt.inc.php
htdocsclassdatabaseadodbdriversadodb-netezza.inc.php
htdocsclassdatabaseadodbdriversadodb-oci8.inc.php
htdocsclassdatabaseadodbdriversadodb-oci805.inc.php
htdocsclassdatabaseadodbdriversadodb-oci8po.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_db2.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-odbc_oracle.inc.php
htdocsclassdatabaseadodbdriversadodb-odbtp.inc.php
htdocsclassdatabaseadodbdriversadodb-odbtp_unicode.inc.php
htdocsclassdatabaseadodbdriversadodb-oracle.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_mssql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_mysql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_oci.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_pgsql.inc.php
htdocsclassdatabaseadodbdriversadodb-pdo_sqlite.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres64.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres7.inc.php
htdocsclassdatabaseadodbdriversadodb-postgres8.inc.php
htdocsclassdatabaseadodbdriversadodb-proxy.inc.php
htdocsclassdatabaseadodbdriversadodb-sapdb.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlanywhere.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlite.inc.php
htdocsclassdatabaseadodbdriversadodb-sqlitepo.inc.php
htdocsclassdatabaseadodbdriversadodb-sybase.inc.php
htdocsclassdatabaseadodbdriversadodb-sybase_ase.inc.php
htdocsclassdatabaseadodbdriversadodb-vfp.inc.php
htdocsclassdatabaseadodblangadodb-ar.inc.php
htdocsclassdatabaseadodblangadodb-bg.inc.php
htdocsclassdatabaseadodblangadodb-bgutf8.inc.php
htdocsclassdatabaseadodblangadodb-ca.inc.php
htdocsclassdatabaseadodblangadodb-cn.inc.php
htdocsclassdatabaseadodblangadodb-cz.inc.php
htdocsclassdatabaseadodblangadodb-da.inc.php
htdocsclassdatabaseadodblangadodb-de.inc.php
htdocsclassdatabaseadodblangadodb-en.inc.php
htdocsclassdatabaseadodblangadodb-es.inc.php
htdocsclassdatabaseadodblangadodb-esperanto.inc.php
htdocsclassdatabaseadodblangadodb-fa.inc.php
htdocsclassdatabaseadodblangadodb-fr.inc.php
htdocsclassdatabaseadodblangadodb-hu.inc.php
htdocsclassdatabaseadodblangadodb-it.inc.php
htdocsclassdatabaseadodblangadodb-nl.inc.php
htdocsclassdatabaseadodblangadodb-pl.inc.php
htdocsclassdatabaseadodblangadodb-pt-br.inc.php
htdocsclassdatabaseadodblangadodb-ro.inc.php
htdocsclassdatabaseadodblangadodb-ru1251.inc.php
htdocsclassdatabaseadodblangadodb-sv.inc.php
htdocsclassdatabaseadodblangadodb-uk1251.inc.php
htdocsclassdatabaseadodblangadodb_th.inc.php
htdocsclassdatabaseadodbpearAuth
htdocsclassdatabaseadodbpearreadme.Auth.txt
htdocsclassdatabaseadodbpearAuthContainer
htdocsclassdatabaseadodbpearAuthContainerADOdb.php
htdocsclassdatabaseadodbperfperf-db2.inc.php
htdocsclassdatabaseadodbperfperf-informix.inc.php
htdocsclassdatabaseadodbperfperf-mssql.inc.php
htdocsclassdatabaseadodbperfperf-mssqlnative.inc.php
htdocsclassdatabaseadodbperfperf-mysql.inc.php
htdocsclassdatabaseadodbperfperf-oci8.inc.php
htdocsclassdatabaseadodbperfperf-postgres.inc.php
htdocsclassdatabaseadodbsessionadodb-compress-bzip2.php
htdocsclassdatabaseadodbsessionadodb-compress-gzip.php
htdocsclassdatabaseadodbsessionadodb-cryptsession.php
htdocsclassdatabaseadodbsessionadodb-cryptsession2.php
htdocsclassdatabaseadodbsessionadodb-encrypt-mcrypt.php
htdocsclassdatabaseadodbsessionadodb-encrypt-md5.php
htdocsclassdatabaseadodbsessionadodb-encrypt-secret.php
htdocsclassdatabaseadodbsessionadodb-encrypt-sha1.php
htdocsclassdatabaseadodbsessionadodb-sess.txt
htdocsclassdatabaseadodbsessionadodb-session-clob.php
htdocsclassdatabaseadodbsessionadodb-session-clob2.php
htdocsclassdatabaseadodbsessionadodb-session.php
htdocsclassdatabaseadodbsessionadodb-session2.php
htdocsclassdatabaseadodbsessionadodb-sessions.mysql.sql
htdocsclassdatabaseadodbsessionadodb-sessions.oracle.clob.sql
htdocsclassdatabaseadodbsessionadodb-sessions.oracle.sql
htdocsclassdatabaseadodbsessioncrypt.inc.php
htdocsclassdatabaseadodbsessionold
htdocsclassdatabaseadodbsessionsession_schema.xml
htdocsclassdatabaseadodbsessionsession_schema2.xml
htdocsclassdatabaseadodbsessionoldadodb-cryptsession.php
htdocsclassdatabaseadodbsessionoldadodb-session-clob.php
htdocsclassdatabaseadodbsessionoldadodb-session.php
htdocsclassdatabaseadodbsessionoldcrypt.inc.php
htdocsclassdatabaseadodbtestsbenchmark.php
htdocsclassdatabaseadodbtestsclient.php
htdocsclassdatabaseadodbtestspdo.php
htdocsclassdatabaseadodbteststest-active-record.php
htdocsclassdatabaseadodbteststest-active-recs2.php
htdocsclassdatabaseadodbteststest-active-relations.php
htdocsclassdatabaseadodbteststest-active-relationsx.php
htdocsclassdatabaseadodbteststest-datadict.php
htdocsclassdatabaseadodbteststest-perf.php
htdocsclassdatabaseadodbteststest-pgblob.php
htdocsclassdatabaseadodbteststest-php5.php
htdocsclassdatabaseadodbteststest-xmlschema.php
htdocsclassdatabaseadodbteststest.php
htdocsclassdatabaseadodbteststest2.php
htdocsclassdatabaseadodbteststest3.php
htdocsclassdatabaseadodbteststest4.php
htdocsclassdatabaseadodbteststest5.php
htdocsclassdatabaseadodbteststestcache.php
htdocsclassdatabaseadodbteststestdatabases.inc.php
htdocsclassdatabaseadodbteststestgenid.php
htdocsclassdatabaseadodbteststestmssql.php
htdocsclassdatabaseadodbteststestoci8.php
htdocsclassdatabaseadodbteststestoci8cursor.php
htdocsclassdatabaseadodbteststestpaging.php
htdocsclassdatabaseadodbteststestpear.php
htdocsclassdatabaseadodbteststestsessions.php
htdocsclassdatabaseadodbteststest_rs_array.php
htdocsclassdatabaseadodbteststime.php
htdocsclassdatabaseadodbteststmssql.php
htdocsclassdatabaseadodbtestsxmlschema-mssql.xml
htdocsclassdatabaseadodbtestsxmlschema.xml
htdocsclassdatabaseadodbxslconvert-0.1-0.2.xsl
htdocsclassdatabaseadodbxslconvert-0.1-0.3.xsl
htdocsclassdatabaseadodbxslconvert-0.2-0.1.xsl
htdocsclassdatabaseadodbxslconvert-0.2-0.3.xsl
htdocsclassdatabaseadodbxslremove-0.2.xsl
htdocsclassdatabaseadodbxslremove-0.3.xsl
htdocsclassdatabasepdoado.php
htdocsclassdatabasepdoado5.php
htdocsclassdatabasepdoado_access.php
htdocsclassdatabasepdoado_mssql.php
htdocsclassdatabasepdoads.php
htdocsclassdatabasepdoborland_ibase.php
htdocsclassdatabasepdocsv.php
htdocsclassdatabasepdodb2.php
htdocsclassdatabasepdodb2oci.php
htdocsclassdatabasepdofirebird.php
htdocsclassdatabasepdoibase.php
htdocsclassdatabasepdoindex.html
htdocsclassdatabasepdoinformix.php
htdocsclassdatabasepdoinformix72.php
htdocsclassdatabasepdoldap.php
htdocsclassdatabasepdomssql.php
htdocsclassdatabasepdomssqlnative.php
htdocsclassdatabasepdomssqlpo.php
htdocsclassdatabasepdomssql_n.php
htdocsclassdatabasepdomysql.php
htdocsclassdatabasepdomysqli.php
htdocsclassdatabasepdomysqlpo.php
htdocsclassdatabasepdomysqlt.php
htdocsclassdatabasepdonetezza.php
htdocsclassdatabasepdooci8.php
htdocsclassdatabasepdooci805.php
htdocsclassdatabasepdooci8po.php
htdocsclassdatabasepdoodbc_adodb.php
htdocsclassdatabasepdoodbc_db2.php
htdocsclassdatabasepdoodbc_mssql.php
htdocsclassdatabasepdoodbc_oracle.php
htdocsclassdatabasepdoodbtp.php
htdocsclassdatabasepdoodbtp_unicode.php
htdocsclassdatabasepdooracle.php
htdocsclassdatabasepdopdo.php
htdocsclassdatabasepdopdo_mssql.php
htdocsclassdatabasepdopdo_mysql.php
htdocsclassdatabasepdopdo_oci.php
htdocsclassdatabasepdopdo_pgsql.php
htdocsclassdatabasepdopdo_sqlite.php
htdocsclassdatabasepdopivot.php
htdocsclassdatabasepdopostgres.php
htdocsclassdatabasepdopostgres7.php
htdocsclassdatabasepdopostgres8.php
htdocsclassdatabasepdoproxy.php
htdocsclassdatabasepdosapdb.php
htdocsclassdatabasepdosqlanywhere.php
htdocsclassdatabasepdosqlite.php
htdocsclassdatabasepdosqlitepo.php
htdocsclassdatabasepdosybase.php
htdocsclassdatabasepdosybase_ase.php
htdocsclassdatabasepdovfp.php

is the framework, i still have to put in the field types for the data sets for SQL formating of types and lengths on ALTER TABLE and CREATE TABLE.

It is based on a MySQL pivot, which means none of the sql files change, they sill remain MySQL, but with this XOOPS can on the fly alter the SQL so it runs on other systems.

wishcraft

Module Developer
Posted on: 2010/2/19 5:45
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#3

Re: ADOdb - Database Source DSN - mainfile.php

There is this great thing called a DSN in ADODb, you can set it in the mainfile at the bottom of the database section before the group definitions.

// Database
    // Choose the database to be used
    
define('XOOPS_DB_TYPE''mysql');

    
// Set the database charset if applicable
    
if (defined("XOOPS_DB_CHARSET")) die('Restricted Access');
    
define('XOOPS_DB_CHARSET''utf8');

    
// Table Prefix
    // This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default "xoops".
    
define('XOOPS_DB_PREFIX''pdo_');

    
// Database Hostname
    // Hostname of the database server. If you are unsure, "localhost" works in most cases.
    
define('XOOPS_DB_HOST''localhost');

    
// Database Username
    // Your database user account on the host
    
define('XOOPS_DB_USER''pdo');

    
// Database Password
    // Password for your database user account
    
define('XOOPS_DB_PASS''password');

    
// Database Name
    // The name of database on the host. The installer will attempt to create the database if not exist
    
define('XOOPS_DB_NAME''pdo');

    
// Use persistent connection? (Yes=1 No=0)
    // Default is "Yes". Choose "Yes" if you are unsure.
    
define('XOOPS_DB_PCONNECT'0);

    
// Database DSN
    // P_CONNECT or Not.
    
if (!defined('XOOPS_DB_DSN')&&XOOPS_DB_PCONNECT == 1)
        
define('XOOPS_DB_DSN'XOOPS_DB_TYPE.'://'.XOOPS_DB_USER.':'.XOOPS_DB_PASS.'@'.XOOPS_DB_HOST.'/'.XOOPS_DB_NAME.'?persist');
    if (!
defined('XOOPS_DB_DSN')&&XOOPS_DB_PCONNECT == 0)
        
define('XOOPS_DB_DSN'XOOPS_DB_TYPE.'://'.XOOPS_DB_USER.':'.XOOPS_DB_PASS.'@'.XOOPS_DB_HOST.'/'.XOOPS_DB_NAME);

wishcraft

Module Developer
Posted on: 2010/2/24 1:57
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#4

Re: ADOdb - Database other than MySQL

I have been now working with ADOdblite which is another 3rd party based on this code -- For some reason it crashes on the 3rd SQL injection.

But the ADOdbLite (http://adodblite.sourceforge.net/) is normally a drop in replacement for ADOdb but uses a smaller foot print and doesn't; well shouldn't have the sessioning issues with ADOdb I am having.

I will be working on this more today..

wishcraft

Module Developer
Posted on: 2010/2/26 4:09
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#5

Re: ADOdb - Database other than MySQL

So I had a go at building a version of this from ADODBLite but it is missing the object handling which is required. But it also didn't fix the sessioning issue..

Here is 2.5.0 alpha with the ADODB Database running on MySQL..

http://wishcraft.thruhere.net/250/

Username: wishcraft
Password: password

The great thing about ADODB is it has query caching. Which means you can cache lookups or questions to the database by using any of the look up cache functions, which I will build into Queryf and Query


For example the path for the cache is established in the connect string of the database this is from the function connect in mysql_adodb.php

// If you are using recordset caching, this is the directory to save your recordsets in. Define this before you call any caching
        // functions such as CacheExecute( ). We recommend setting register_globals=off in php.ini if you use this feature for security reasons.
        
$ADODB_CACHE_DIR XOOPS_VAR_PATH DIRECTORY_SEPARATOR 'caches'DIRECTORY_SEPARATOR .'adodb_cache';
        if (!
is_dir($ADODB_CACHE_DIR))
            foreach(
explode(DIRECTORY_SEPARATOR$ADODB_CACHE_DIR) as $id => $folder) {
                
$tmppath .= DIRECTORY_SEPARATOR $folder;
                if (!
is_dir($tmppath))
                    
mkdir($tmppath777);
            }

ADODB 0.15 with session working is a performance enhancement, the data physically loads quicker on the screen on my test bed - loading faster with the timers to show compair to the old 1996 class structure of handling database in a class structure.

The PDO needs a regular expression replacement as well with the format SQL function, this is with the base model of the database

wishcraft

Module Developer
Posted on: 2010/7/17 3:31
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#6

Re: ADOdb - Cure the Bottleneck

One thing I noticed about the PDO is that XOOPS slow to load as some people note from time to time, is actually a bottleneck in the old database system that dates back to 1996.

ADOdb as it is a well used library and is used in alot of gpL including tools like mantis seems to handle the database connect rather more proficently than the existsing system.

This PDO Cures that bottle neck and even though it is more code seems to handle the database connect better and instead of waiting a second or two on my test bed for a refresh it is doing it the instance the session is established, Even the XOOPS timers are down from the addition of this code.
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/SimonXaies
github.com/Chronolabs-Cooperative
facebook.com/SimonSXaies

mojtabajml

Just popping in
Posted on: 2012/1/22 12:32
mojtabajml
mojtabajml (Show more)
Just popping in
Posts: 67
Since: 2007/7/16
#7

Re: ADOdb - Database other than MySQL

Is there any help to install Xoops with Postgresql database? I need Postgis for Gis functionality

mojtabajml

Just popping in
Posted on: 2013/2/8 11:37
mojtabajml
mojtabajml (Show more)
Just popping in
Posts: 67
Since: 2007/7/16
#8

Re: ADOdb - Database other than MySQL

I use ADODB 0.25 class in xoops 2.6 without any problem.
can you help me to use postgresql instead of mysql?

redheadedrod

Home away from home
Posted on: 2013/2/8 14:42
redheadedrod
redheadedrod (Show more)
Home away from home
Posts: 1296
Since: 2008/2/26
#9

Re: ADOdb - Database other than MySQL

I am hopefully releasing a PDO class for 2.5.5 this weekend and a 2.6 class will be close behind. 2.6 xoops is currently in Alpha and not intended for use.


The PDO class I have now should work easily with postgresql with minor changes to support it. If you are willing to test it out for me I will be more than happy to make one available for you but please let me know if it works for you or not.

Be aware that any module written to access mysql directly will fail with any other database connector and will require minimal rewriting.

Rodney

mojtabajml

Just popping in
Posted on: 2013/2/8 21:11
mojtabajml
mojtabajml (Show more)
Just popping in
Posts: 67
Since: 2007/7/16
#10

Re: ADOdb - Database other than MySQL

I need Gis capabilities of postgresql in xoops and don't need any module. thanks redheadedrod, I'm waiting for this class.