\DB

Summary

Methods

Properties

Constants

getPDO()
__construct()
connect()
prepare()
query()
fetchcolumn()
fetch()
fetchall()
get()
getall()
getslice()
getcolumn()
update()
insert()
insertid()
delete()
exists()
count()
begin()
commit()
rollback()
run()
fieldexists()
fieldmatch()
indexexists()
tablename()
debug()
tableexists()

No public properties found

No constants found

No protected methods found

$pdo
$cfg
$tablepre
$result
$statement
$errors
$link

N/A

logging()
performance()

No private properties found

N/A

File: framework/class/db.class.php
Package: Default
Class hierarchy: \DB

Properties

$pdo

$pdo :

Type

$cfg

$cfg :

Type

$tablepre

$tablepre :

Type

$result

$result :

Type

$statement

$statement :

Type

$errors

$errors :

Type

$link

$link :

Type

Methods

getPDO()

getPDO()

__construct()

__construct(  $name = 'master')

Parameters

$name

connect()

connect(  $name = 'master')

Parameters

$name

prepare()

prepare(  $sql)

Parameters

$sql

query()

query(  $sql,   $params = array())

Parameters

	$sql
	$params

fetchcolumn()

fetchcolumn(  $sql,   $params = array(),   $column)

Parameters

	$sql
	$params
	$column

fetch()

fetch(  $sql,   $params = array())

Parameters

	$sql
	$params

fetchall()

fetchall(  $sql,   $params = array(),   $keyfield = '')

Parameters

	$sql
	$params
	$keyfield

get()

get(  $tablename,   $params = array(),   $fields = array(),   $orderby = array())

Parameters

	$tablename
	$params
	$fields
	$orderby

getall()

getall(  $tablename,   $params = array(),   $fields = array(),   $keyfield = '',   $orderby = array(),   $limit = array())

Parameters

	$tablename
	$params
	$fields
	$keyfield
	$orderby
	$limit

getslice()

getslice(  $tablename,   $params = array(),   $limit = array(),   $total = null,   $fields = array(),   $keyfield = '',   $orderby = array())

Parameters

	$tablename
	$params
	$limit
	$total
	$fields
	$keyfield
	$orderby

getcolumn()

getcolumn(  $tablename,   $params = array(),   $field = '')

Parameters

	$tablename
	$params
	$field

update()

update(  $table,   $data = array(),   $params = array(),   $glue = 'AND')

Parameters

	$table
	$data
	$params
	$glue

insert()

insert(  $table,   $data = array(),   $replace = FALSE)

Parameters

	$table
	$data
	$replace

insertid()

insertid()

delete()

delete(  $table,   $params = array(),   $glue = 'AND')

Parameters

	$table
	$params
	$glue

exists()

exists(  $tablename,   $params = array())

Parameters

	$tablename
	$params

count()

count(  $tablename,   $params = array(),   $cachetime = 30)

Parameters

	$tablename
	$params
	$cachetime

begin()

begin()

commit()

commit()

rollback()

rollback()

run()

run(  $sql,   $stuff = 'ims_')

Parameters

	$sql
	$stuff

fieldexists()

fieldexists(  $tablename,   $fieldname)

Parameters

	$tablename
	$fieldname

fieldmatch()

fieldmatch(  $tablename,   $fieldname,   $datatype = '',   $length = '')

Parameters

	$tablename
	$fieldname
	$datatype
	$length

indexexists()

indexexists(  $tablename,   $indexname)

Parameters

	$tablename
	$indexname

tablename()

tablename(  $table)

Parameters

$table

debug()

debug(  $output = true,   $append = array())

Parameters

	$output
	$append

tableexists()

tableexists(  $table)

Parameters

$table

logging()

logging(  $sql,   $params = array(),   $message = '')

Parameters

	$sql
	$params
	$message

performance()

performance(  $sql,   $runtime)

Parameters

	$sql
	$runtime