PEAR DB DataObject

From Triangle Wiki

{{Wrapper|NavigationFile=Navigation

• Overview
• Required Packages
• Archive Zip
• Benchmark
• Calendar
• Date
• DB
• DataObject
• Formbuilder
• Quickform
• HTML Page 2
• HTML Table
• HTTP Download
• HTTP Request
• HTTP Upload
• Log
• Mail
• Mail Mime
• MDB2
• FTP
• Pager
• PHPDoc
• Exchange Rates
• Tempate Sigma
• Datagrid
  • Datasource DO
  • Render Table
• CAPTCHA
• Translation 2
• PEAR Site

[Edit Navigation]|PageContent=

Auto Building The Database Schema

Creating The ini File

[DB_DataObject]
database         = mysqli://user:pass@localhost/[DATABAASE]
schema_location  = /common/data_objects/[SITE]/schema
class_location   = /common/data_objects/[SITE]/
require_prefix   = /common/data_objects/[SITE]/
class_prefix     = DO_
extends_location = DB/DataObject.php
extends          = DB_DataObject

Options In Config

Notice the option to use MDB2 is set, remove this to use PEAR:DB.

// Create the array of options for DataObjects $config['DB_DataObject'] = array(

   'database'         => 'mysqli://USER:PASS@localhost/admin',
   'schema_location'  => ADMIN_DO . 'admin/schema',
   'class_location'   => ADMIN_DO . 'admin',
   'require_prefix'   => ADMIN_DO . 'admin',
   'class_prefix'     => 'DO_',
   'db_driver'        => 'MDB2',
   'extends_location' => ADMIN_DO . 'admin/Inter.php',
   'extends'          => 'DB_Inter');

$options =