Docs For Class DBConn

Description

Located in /model/dbconn.class.php (line 19)

Class Constant Summary

USE_CACHE = true

Method Summary

DBConn __construct ([ $user = NULL], [ $pass = NULL], [ $schema = NULL], [ $host = NULL])

void allowCreate ([ $value = true])

void columnComment ([ $table = NULL], [ $column = NULL])

void columnDefault ([ $table = NULL], [ $column = NULL])

void columnType ([ $table = NULL], [ $column = NULL])

void compression ()

void count ( $table, [ $where = NULL])

void createTable ([ $table = ''], [ $sql = ''])

void delete ( $table, $rows)

void getColumns ( $table)

void getTables ()

void hasColumn ([ $table = NULL], [ $column = false])

void hasTable ([ $table = NULL])

void insert ( $table, $values, [ $insertUserID = NULL])

void join ( $tables, [ $columns = array('*')], [ $where = NULL], [ $sort = NULL], [ $limitUserID = NULL])

void load ( &$obj, [ $ID = NULL], [ $table = NULL])

void populate ( &$obj, $values)

void save ( &$obj, [ $table = NULL])

void savecache ()

void select ( $table, [ $columns = NULL], [ $where = NULL], [ $sort = NULL], [ $limit = NULL], [ $offset = NULL])

void selectID ( $table, $ID, [ $columns = NULL], [ $limitUserID = NULL])

void shell ([ $command = NULL])

Methods

Constructor __construct (line 39)

access: public

DBConn __construct ([ $user = NULL], [ $pass = NULL], [ $schema = NULL], [ $host = NULL])

$user
$pass
$schema
$host

allowCreate (line 82)

access: public

void allowCreate ([ $value = true])

$value

columnComment (line 202)

access: public

void columnComment ([ $table = NULL], [ $column = NULL])

$table
$column

columnDefault (line 219)

access: public

void columnDefault ([ $table = NULL], [ $column = NULL])

$table
$column

columnType (line 194)

access: public

void columnType ([ $table = NULL], [ $column = NULL])

$table
$column

compression (line 255)

access: public

void compression ()

count (line 675)

access: public

void count ( $table, [ $where = NULL])

$table
$where

createTable (line 87)

access: public

void createTable ([ $table = ''], [ $sql = ''])

$table
$sql

delete (line 427)

access: public

void delete ( $table, $rows)

$table
$rows

getColumns (line 142)

access: public

void getColumns ( $table)

$table

getTables (line 129)

access: public

void getTables ()

hasColumn (line 183)

access: public

void hasColumn ([ $table = NULL], [ $column = false])

$table
$column

hasTable (line 236)

access: public

void hasTable ([ $table = NULL])

$table

insert (line 410)

access: public

void insert ( $table, $values, [ $insertUserID = NULL])

$table
$values
$insertUserID

join (line 484)

access: public

void join ( $tables, [ $columns = array('*')], [ $where = NULL], [ $sort = NULL], [ $limitUserID = NULL])

$tables
$columns
$where
$sort
$limitUserID

load (line 337)

access: public

void load ( &$obj, [ $ID = NULL], [ $table = NULL])

&$obj
$ID
$table

populate (line 375)

access: public

void populate ( &$obj, $values)

&$obj
$values

save (line 298)

access: public

void save ( &$obj, [ $table = NULL])

&$obj
$table

savecache (line 63)

access: public

void savecache ()

select (line 696)

access: public

void select ( $table, [ $columns = NULL], [ $where = NULL], [ $sort = NULL], [ $limit = NULL], [ $offset = NULL])

$table
$columns
$where
$sort
$limit
$offset

selectID (line 456)

access: public

void selectID ( $table, $ID, [ $columns = NULL], [ $limitUserID = NULL])

$table
$ID
$columns
$limitUserID

shell (line 271)

access: public

void shell ([ $command = NULL])

$command

Class Constants

USE_CACHE = true (line 37)