Class: CYap_mysql

Source Location: /CYap_Mysql.php

Class CYap_mysql

Class Overview

CYapDB
   |
   --CYap_mysql

Methods

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From CYapDB

CYapDB::$CurrentRow

CYapDB::$DbConn

CYapDB::$Dbresult

CYapDB::$Db_Open

CYapDB::$LastQuery

CYapDB::$txtError

Inherited From CYapDB

CYapDB::CYapDB()

CYapDB::DbaddSql()

From an array of values, made the sql for adding the row

CYapDB::DbError()

Return the error descritpion from last command

CYapDB::DbEscape()

Escape the string using the db functions, if provided It don't apply the escape string if magic_quotes_gpc is enabled

CYapDB::DbExecSql()

Execute the given query

CYapDB::DbFetchField()

Get column information from a result and return as an object

CYapDB::DbFieldFlags()

Get the flags associated with the specified field in a result

CYapDB::DbFreeResult()

Free the given result

CYapDB::DbGetNumFields()

Retrieve the number of fields retrieved by the given result

CYapDB::DbGetNumRow()

Retrieve the number of rows retrieved by the given result

CYapDB::DbmodifySql()

From an array of values, made the sql for modify the row

CYapDB::DbRegexCond()

Build the condition string for the $FieldName using the pattern matching

CYapDB::OpenDB()

Open the database connection

CYapDB::QueryLimit()

Perform a select statement using range to limits the

CYapDB::SelectDb()

[ Top ]

Method Summary

CYap_mysql	CYap_mysql()
string	DbEscape()	Escape the string using the db functions, if provided It don't apply the escape string if magic_quotes_gpc is enabled Mysql version. It uses the mysql_escape string function instead of addslashes
mixed	DbExecSql()	Execute the given query
object DbMeta	DbFetchField()	Get column information from a result and return as an object
string	DbFieldFlags()	Get the flags associated with the specified field in a result
bool	DbFreeResult()	Free the given result
integer	DbGetNumFields()	Retrieve the number of fields retrieved by the given result
integer	DbGetNumRow()	Retrieve the number of rows retrieved by the given result
array	DbGetValue()	Return the current row as associative array
string	DbRegexCond()	Build the condition string for the $FieldName using the pattern matching
bool	Db_Close()	Close the connection to the database
bool	OpenDb()	Open the database connection
bool	QueryLimit()	Perform a select statement using range to limits the
bool	SelectDb()	database selection

[ Top ]

Properties

Methods

Constructor CYap_mysql [line 40]

CYap_mysql CYap_mysql(
)

[ Top ]

DbEscape [line 209]

string DbEscape(
string
$value 
)

Escape the string using the db functions, if provided It don't apply the escape string if magic_quotes_gpc is enabled Mysql version. It uses the mysql_escape string function instead of addslashes

Parameters:

string

$value:

sql statement

API Tags:

Return:

the escaped string

Redefinition of:

CYapDB::DbEscape(): Escape the string using the db functions, if provided It don't apply the escape string if magic_quotes_gpc is enabled

[ Top ]

DbExecSql [line 92]

mixed DbExecSql(
string
$sql 
)

Execute the given query

Parameters:

string

$sql:

sql statement

API Tags:

Return:

the result id, false on failure

Redefinition of:

CYapDB::DbExecSql(): Execute the given query

[ Top ]

DbFetchField [line 147]

object DbMeta DbFetchField(
integer
$result, integer
$FieldNo 
)

Get column information from a result and return as an object

Parameters:

integer	$result:
integer	$FieldNo:

Redefinition of:

CYapDB::DbFetchField(): Get column information from a result and return as an object

[ Top ]

DbFieldFlags [line 157]

string DbFieldFlags(
resource
$result, integer
$FieldNo 
)

Get the flags associated with the specified field in a result

Parameters:

resource	$result:
integer	$FieldNo:

Redefinition of:

CYapDB::DbFieldFlags(): Get the flags associated with the specified field in a result

[ Top ]

DbFreeResult [line 166]

bool DbFreeResult(
integer
$result 
)

Free the given result

Parameters:

integer

$result:

API Tags:

Return:

true on success, false on failure

Redefinition of:

CYapDB::DbFreeResult(): Free the given result

[ Top ]

DbGetNumFields [line 136]

integer DbGetNumFields(
integer
$result 
)

Retrieve the number of fields retrieved by the given result

Parameters:

integer

$result:

Redefinition of:

CYapDB::DbGetNumFields(): Retrieve the number of fields retrieved by the given result

[ Top ]

DbGetNumRow [line 127]

integer DbGetNumRow(
integer
$result 
)

Retrieve the number of rows retrieved by the given result

Parameters:

integer

$result:

Redefinition of:

CYapDB::DbGetNumRow(): Retrieve the number of rows retrieved by the given result

[ Top ]

DbGetValue [line 177]

array DbGetValue(
resource
$result 
)

Return the current row as associative array

Parameters:

resource

$result:

API Tags:

Return:

row data or false on failure

[ Top ]

DbRegexCond [line 226]

string DbRegexCond(
string
$FieldName, string
$pattern 
)

Build the condition string for the $FieldName using the pattern matching

syntax

Parameters:

string	$FieldName:
string	$pattern:

API Tags:

Access:

public

Redefinition of:

CYapDB::DbRegexCond(): Build the condition string for the $FieldName using the pattern matching

[ Top ]

Db_Close [line 190]

bool Db_Close(
)

Close the connection to the database

API Tags:

Return:

true

[ Top ]

OpenDb [line 51]

bool OpenDb(
mixed
$DBSystem, [mixed
$DBUser = ""], [mixed
$DBPasswd = ""], string
$server, string
$User, string
$Password 
)

Open the database connection

Parameters:

string	$server:	database server
string	$User:	username
string	$Password:	User password

API Tags:

Return:

true on success, false on failure

[ Top ]

QueryLimit [line 115]

bool QueryLimit(
string
$select, [integer
$start = 0], [integer
$many = -1] 
)

Perform a select statement using range to limits the

rows to return

Parameters:

string	$select:	select statement
integer	$start:	no. rows to start
integer	$many:	how many rows sholud be returned

API Tags:

Return:

true on success, false on failure

Redefinition of:

CYapDB::QueryLimit(): Perform a select statement using range to limits the

[ Top ]

SelectDb [line 72]

bool SelectDb(
string
$DBname 
)

database selection

Parameters:

string

$DBname:

database name

API Tags:

Return:

true on success, false on failure

Redefinition of:

CYapDB::SelectDb()

[ Top ]

Documentation generated on Sat, 26 Feb 2005 14:10:02 +0100 by phpDocumentor 1.3.0RC3

	CYap

[ Back ] [ class tree: CYap ] [ index: CYap ] [ all elements ]