File/program/lib/database/mysql.class.php

Description

/program/lib/database/mysql.class.php - access to mysql via database class

This file is included from the poor mans database factory in databaselib.php. It provides all necessary functionality to use MySQL as the underlying database server.

This file defines two classes: DatabaseMysql and DatabaseMysqlResult. Typical usage would be:

    $DB = new Database($table_prefix);          // once at program start $DB->connect($host,$usr,$pwd,$dbname);      // once at program start $sql = "SELECT * FROM {$DB->prefix}foo";    // select all rows from table foo, $DBResult = $DB->query($sql); $all_rows = $DBResult->fetch_all_assoc()    // store everything in an array, $DBResult->close();                         // and free the memory ...                                         // do something with $all_rows $DB->close();                               // once at program end

Classes
Class Description
 class DatabaseMysql MySQL database
 class DatabaseMysqlResult MySQL database result
Constants
SQL_FALSE = 0 (line 48)

this circumvents the sub-optimal implementation of booleans in MySQL

SQL_TRUE = 1 (line 51)

this circumvents the sub-optimal implementation of booleans in MySQL

Documentation generated on Wed, 11 May 2011 23:45:28 +0200 by phpDocumentor 1.4.0