Docs For Class CYapDB

Methods

Constructor CYapDB [line 67]

CYapDB CYapDB(
)

[ Top ]

DbaddSql [line 191]

void DbaddSql(
array
$row, array
$fieldsType, string
$KeyField 
)

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

Parameters:

array	$row:	array of values. The key is the field name
array	$fieldsType:	type of each fields
string	$KeyField:	name of the key field

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbaddSql() : From an array of values, make the sql for adding the row
CYap_odbc::DbaddSql() : From an array of values, made the sql for adding the row

[ Top ]

DbError [line 177]

string DbError(
)

Return the error descritpion from last command

API Tags:

Access:

public

[ Top ]

DbEscape [line 163]

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

Parameters:

string

$value:

sql statement

API Tags:

Return:	the escaped string
Access:	public

Redefined in descendants as:

CYap_MsSQL::DbEscape() : Escape the string using the db functions, if provided It don't apply the escape string if magic_quotes_gpc is enabled
CYap_mysql::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
CYap_odbc::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]

bool DbExecSql(
string
$sql 
)

Execute the given query

Parameters:

string

$sql:

sql statement

API Tags:

Return:	true on success, false on failure
Access:	public

Redefined in descendants as:

CYap_MsSQL::DbExecSql() : Execute the given query
CYap_mysql::DbExecSql() : Execute the given query
CYap_odbc::DbExecSql() : Execute the given query

[ Top ]

DbFetchField [line 133]

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

Get column information from a result and return as an object

Parameters:

integer	$result:
integer	$FieldNo:

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbFetchField() : Get column information from a result and return as an object
CYap_mysql::DbFetchField() : Get column information from a result and return as an object
CYap_odbc::DbFetchField() : Get column information from a result and return as an object

[ Top ]

DbFieldFlags [line 143]

string DbFieldFlags(
resource
$result, integer
$FieldNo 
)

Get the flags associated with the specified field in a result

Parameters:

resource	$result:
integer	$FieldNo:

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbFieldFlags() : Get the flags associated with the specified field in a result
CYap_mysql::DbFieldFlags() : Get the flags associated with the specified field in a result
CYap_odbc::DbFieldFlags() : Get the flags associated with the specified field in a result

[ Top ]

DbFreeResult [line 152]

bool DbFreeResult(
integer
$result 
)

Free the given result

Parameters:

integer

$result:

API Tags:

Return:	true on success, false on failure
Access:	public

Redefined in descendants as:

CYap_MsSQL::DbFreeResult() : Free the given result
CYap_mysql::DbFreeResult() : Free the given result
CYap_odbc::DbFreeResult() : Free the given result

[ Top ]

DbGetNumFields [line 122]

integer DbGetNumFields(
integer
$result 
)

Retrieve the number of fields retrieved by the given result

Parameters:

integer

$result:

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbGetNumFields() : Retrieve the number of fields retrieved by the given result
CYap_mysql::DbGetNumFields() : Retrieve the number of fields retrieved by the given result
CYap_odbc::DbGetNumFields() : Retrieve the number of fields retrieved by the given result

[ Top ]

DbGetNumRow [line 113]

integer DbGetNumRow(
integer
$result 
)

Retrieve the number of rows retrieved by the given result

Parameters:

integer

$result:

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbGetNumRow() : Retrieve the number of rows retrieved by the given result
CYap_mysql::DbGetNumRow() : Retrieve the number of rows retrieved by the given result
CYap_odbc::DbGetNumRow() : Retrieve the number of rows retrieved by the given result

[ Top ]

DbmodifySql [line 223]

void DbmodifySql(
array
$row, array
$fieldsType 
)

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

Parameters:

array	$row:	array of values. The key is the field name
array	$fieldsType:	type of each fields

API Tags:

Access:

public

Redefined in descendants as:

CYap_MsSQL::DbmodifySql() : From an array of values, made the sql for modify the row
CYap_odbc::DbmodifySql() : From an array of values, made the sql for modify the row

[ Top ]

DbRegexCond [line 245]

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

Redefined in descendants as:

CYap_MsSQL::DbRegexCond() : Build the condition string for the $FieldName using the pattern matching
CYap_mysql::DbRegexCond() : Build the condition string for the $FieldName using the pattern matching
CYap_odbc::DbRegexCond() : Build the condition string for the $FieldName using the pattern matching

[ Top ]

OpenDB [line 80]

bool OpenDB(
mixed
$Server, [string
$User = ""], [string
$Password = ""], string
$server 
)

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
Access:	public

[ Top ]

QueryLimit [line 104]

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
Access:	public

Redefined in descendants as:

CYap_MsSQL::QueryLimit() : Perform a select statement using range to limits the
CYap_mysql::QueryLimit() : Perform a select statement using range to limits the
CYap_odbc::QueryLimit() : Perform a select statement using range to limits the

[ Top ]

SelectDb [line 83]

void SelectDb(
mixed
$DBname 
)

Redefined in descendants as:

CYap_MsSQL::SelectDb() : database selection. Always true, the ODBC function don't allow to
CYap_mysql::SelectDb() : database selection
CYap_odbc::SelectDb() : database selection. Always true, the ODBC function don't allow to

[ Top ]

	CYap

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

Class: CYapDB

Class CYapDB