\DbManager

Handles the actual database communication. This DbManager is for MySQL. (Set $GLOBALS['SQL_DEBUG_MODE'] to true to print all SQL requests.)

Summary

Methods

Constants

__construct()
SetDatabaseName()
GetDatabaseName()
Select()
Insert()
Update()
Delete()
Query()
FetchAssocList()
FetchArrayList()
FetchAssoc()
FetchArray()
NumRows()
NextResult()
FlushResults()
Error()
InsertId()
AffectedRows()
OpenConnection()
CloseConnection()
IsOperator()
IsCondition()
IsKeyword()
DatabaseExists()
CreateDatabase()
DropDatabase()
CopyDatabase()
UserExists()
CreateUser()
DropUser()
TableExists()
DropTable()
GrantUserPermissions()
GrantGlobalFilePermissions()
RevokeUserPermissions()

No constants found

No protected methods found

N/A

No private methods found

N/A

Methods

__construct()

__construct(  $server,   $user,   $password,   $databaseName = null,   $extra_params = array())

Parameters

	$server
	$user
	$password
	$databaseName
	$extra_params

SetDatabaseName()

SetDatabaseName(  $databaseName,   $options = null)

Parameters

	$databaseName
	$options

GetDatabaseName()

GetDatabaseName()

Select()

Select(  $array_select_fields,   $table,   $array_where = '',   $array_order = '',   $limit = '',   $options = null)

Parameters

	$array_select_fields
	$table
	$array_where
	$array_order
	$limit
	$options

Insert()

Insert(  $table,   $array,   $options = null)

Parameters

	$table
	$array
	$options

Update()

Update(  $table,   $array,   $array_where = '',   $limit = '',   $options = null)

Parameters

	$table
	$array
	$array_where
	$limit
	$options

Delete()

Delete(  $table,   $array_where = '',   $limit = '',   $options = null)

Parameters

	$table
	$array_where
	$limit
	$options

Query()

Query(  $query,   $options = null)

Parameters

	$query
	$options

FetchAssocList()

FetchAssocList()

FetchArrayList()

FetchArrayList()

FetchAssoc()

FetchAssoc()

FetchArray()

FetchArray()

NumRows()

NumRows()

NextResult()

NextResult()

FlushResults()

FlushResults()

Error()

Error()

InsertId()

InsertId()

AffectedRows()

AffectedRows()

OpenConnection()

OpenConnection(  $options = null)

Parameters

$options

CloseConnection()

CloseConnection()

IsOperator()

IsOperator(  $keyword)

Parameters

$keyword

IsCondition()

IsCondition(  $keyword)

Parameters

$keyword

IsKeyword()

IsKeyword(  $keyword)

Parameters

$keyword

DatabaseExists()

DatabaseExists(  $databaseName)

Parameters

$databaseName

CreateDatabase()

CreateDatabase(  $databaseName)

Parameters

$databaseName

DropDatabase()

DropDatabase(  $databaseName)

Parameters

$databaseName

CopyDatabase()

CopyDatabase(  $srouceDatabaseName,   $destDatabaseName,   $options = null)

Parameters

	$srouceDatabaseName
	$destDatabaseName
	$options

UserExists()

UserExists(  $username,   $host = "localhost")

Parameters

	$username
	$host

CreateUser()

CreateUser(  $username,   $password,   $host = "localhost")

Parameters

	$username
	$password
	$host

DropUser()

DropUser(  $username)

Parameters

$username

TableExists()

TableExists(  $databaseName,   $tableName)

Parameters

	$databaseName
	$tableName

DropTable()

DropTable(  $databaseName,   $tableName)

Parameters

	$databaseName
	$tableName

GrantUserPermissions()

GrantUserPermissions(  $databaseName,   $uesrname,   $host = "localhost")

Parameters

	$databaseName
	$uesrname
	$host

GrantGlobalFilePermissions()

GrantGlobalFilePermissions(  $username,   $host = "localhost")

Parameters

	$username
	$host

RevokeUserPermissions()

RevokeUserPermissions(  $databaseName,   $uesrname,   $host = "localhost")

Parameters

	$databaseName
	$uesrname
	$host