XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. General XOOPS.org forums / 
  3. XOOPS Project Teams
  4. XOOPS Core Team 
  5.  / ADOdb - Database other than MySQL
Register
1
wishcraft
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
2
wishcraft
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.

3
wishcraft
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);
4
wishcraft
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..

5
wishcraft
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($tmppath, 777);
            }

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
6
wishcraft
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.
vCard (*.vcf): Dr. Simon Antony Roberts.vcf
Follow, Like & Read:-

x.com/EmpressFX
facebook.com/DrAntonyRoberts
7
mojtabajml
Re: ADOdb - Database other than MySQL

  • 2012/1/22 12:32

  • mojtabajml

  • Just popping in

  • Posts: 67

  • Since: 2007/7/16


Is there any help to install Xoops with Postgresql database? I need Postgis for Gis functionality
8
mojtabajml
Re: ADOdb - Database other than MySQL

  • 2013/2/8 11:37

  • mojtabajml

  • Just popping in

  • Posts: 67

  • Since: 2007/7/16


I use ADODB 0.25 class in xoops 2.6 without any problem.
can you help me to use postgresql instead of mysql?
9
redheadedrod
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
10
mojtabajml
Re: ADOdb - Database other than MySQL

  • 2013/2/8 21:11

  • mojtabajml

  • Just popping in

  • Posts: 67

  • Since: 2007/7/16


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

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

381 user(s) are online (220 user(s) are browsing Support Forums)

Members: 0

Guests: 381

more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits