*
• * input -> returns *
*
• * null -> the string NULL *
*
• * integer or double -> the unquoted number *
*
• * bool -> output depends on the driver in use * Most drivers return integers: 1 if * true or 0 if * false. * Some return strings: TRUE if * true or FALSE if * false. * Finally one returns strings: T if * true or F if * false. Here is a list of each DBMS, * the values returned and the suggested column type: *
  *
  • * dbase -> T/F * (Logical) *
  *
  • * fbase -> TRUE/FALSE * (BOOLEAN) *
  *
  • * ibase -> 1/0 * (SMALLINT) [1] *
  *
  • * ifx -> 1/0 * (SMALLINT) [1] *
  *
  • * msql -> 1/0 * (INTEGER) *
  *
  • * mssql -> 1/0 * (BIT) *
  *
  • * mysql -> 1/0 * (TINYINT(1)) *
  *
  • * mysqli -> 1/0 * (TINYINT(1)) *
  *
  • * oci8 -> 1/0 * (NUMBER(1)) *
  *
  • * odbc -> 1/0 * (SMALLINT) [1] *
  *
  • * pgsql -> TRUE/FALSE * (BOOLEAN) *
  *
  • * sqlite -> 1/0 * (INTEGER) *
  *
  • * sybase -> 1/0 * (TINYINT(1)) *
  *
  * [1] Accommodate the lowest common denominator because not all * versions of have BOOLEAN. *
*
• * other (including strings and numeric strings) -> * the data with single quotes escaped by preceeding * single quotes, backslashes are escaped by preceeding * backslashes, then the whole string is encapsulated * between single quotes *
*

*
• * autofree boolean = false *
  should results be freed automatically when there are no * more rows? *
• * result_buffering integer = 500 *
  how many rows of the result set should be buffered? *
  In mysql: mysql_unbuffered_query() is used instead of * mysql_query() if this value is 0. (Release 1.7.0) *
  In oci8: this value is passed to ocisetprefetch(). * (Release 1.7.0) *
• * debug integer = 0 *
  debug level *
• * persistent boolean = false *
  should the connection be persistent? *
• * portability integer = DB_PORTABILITY_NONE *
  portability mode constant (see below) *
• * seqname_format string = %s_seq *
  the sprintf() format string used on sequence names. This * format is applied to sequence names passed to * createSequence(), nextID() and dropSequence(). *
• * ssl boolean = false *
  use ssl to connect? *
*

     *    "UPDATE foo SET col=? WHERE col='over \& under'"
     * 

     * buildManipSQL('table_sql', array('field1', 'field2', 'field3'),
     *               DB_AUTOQUERY_INSERT);
     * 

     *  ID      TEXT       DATE
     * --------------------------------
     *  1       'one'      944679408
     *  2       'two'      944679408
     *  3       'three'    944679408
     * 

     *   array(
     *     '1' => 'one',
     *     '2' => 'two',
     *     '3' => 'three',
     *   )
     * 

     *   array(
     *     '1' => array('one', '944679408'),
     *     '2' => array('two', '944679408'),
     *     '3' => array('three', '944679408')
     *   )
     * 

     * getAssoc('SELECT category,id,name FROM mytable', false, null,
     *          DB_FETCHMODE_ASSOC, true) returns:
     *
     *   array(
     *     '1' => array(array('id' => '4', 'name' => 'number four'),
     *                  array('id' => '6', 'name' => 'number six')
     *            ),
     *     '9' => array(array('id' => '4', 'name' => 'number four'),
     *                  array('id' => '6', 'name' => 'number six')
     *            )
     *   )
     * 

     *    SELECT tblFoo.fldID, tblFoo.fldPhone, tblBar.fldId
     *    FROM tblFoo
     *    JOIN tblBar ON tblFoo.fldId = tblBar.fldId
     * 

*
• * * null (default) *

       *   [0] => Array (
       *       [table] => tblFoo
       *       [name] => fldId
       *       [type] => int
       *       [len] => 11
       *       [flags] => primary_key not_null
       *   )
       *   [1] => Array (
       *       [table] => tblFoo
       *       [name] => fldPhone
       *       [type] => string
       *       [len] => 20
       *       [flags] =>
       *   )
       *   [2] => Array (
       *       [table] => tblBar
       *       [name] => fldId
       *       [type] => int
       *       [len] => 11
       *       [flags] => primary_key not_null
       *   )
       *   

  * *
• * * DB_TABLEINFO_ORDER * *

  In addition to the information found in the default output, * a notation of the number of columns is provided by the * num_fields element while the order * element provides an array with the column names as the keys and * their location index number (corresponding to the keys in the * the default output) as the values.

  * *

  If a result set has identical field names, the last one is * used.

  * *

       *   [num_fields] => 3
       *   [order] => Array (
       *       [fldId] => 2
       *       [fldTrans] => 1
       *   )
       *   

  * *
• * * DB_TABLEINFO_ORDERTABLE * *

  Similar to DB_TABLEINFO_ORDER but adds more * dimensions to the array in which the table names are keys and * the field names are sub-keys. This is helpful for queries that * join tables which have identical field names.

  * *

       *   [num_fields] => 3
       *   [ordertable] => Array (
       *       [tblFoo] => Array (
       *           [fldId] => 0
       *           [fldPhone] => 1
       *       )
       *       [tblBar] => Array (
       *           [fldId] => 2
       *       )
       *   )
       *   

  * *
*