CYap_mysql Class Reference

Inheritance diagram for CYap_mysql:

Public Member Functions
	CYap_mysql ()
	OpenDb ($DBSystem, $DBUser="", $DBPasswd="")
	SelectDb ($DBname)
	DbExecSql ($sql)
	QueryLimit ($select, $start=0, $many=-1)
	DbGetNumRow ($result)
	DbGetNumFields ($result)
	DbFetchField ($result, $FieldNo)
	DbFieldFlags ($result, $FieldNo)
	DbFreeResult ($result)
	DbGetValue ($result)
	Db_Close ()
	DbEscape ($value)
	DbRegexCond ($FieldName, $pattern)
	DbBetweenCond ($FieldName, $ValueFrom, $ValueTo, $ValueType)
Public Member Functions inherited from CYapDB
	CYapDB ()
	OpenDB ($Server, $User="", $Password="")
	SelectDb ($DBname)
	DbExecSql ($sql)
	QueryLimit ($select, $start=0, $many=-1)
	DbGetNumRow ($result)
	DbGetNumFields ($result)
	DbFetchField ($result, $FieldNo)
	DbFieldFlags ($result, $FieldNo)
	DbFreeResult ($result)
	DbEscape ($value)
	DbError ()
	DbaddSql ($row, $fieldsType, $KeyField)
	DbmodifySql ($row, $fieldsType)
	DbRegexCond ($FieldName, $pattern)
	DbBetweenCond ($FieldName, $ValueFrom, $ValueTo, $ValueType)

Additional Inherited Members
Data Fields inherited from CYapDB
	$DbConn
	$Db_Open
	$txtError
	$Dbresult
	$CurrentRow
	$LastQuery

Detailed Description

Definition at line 38 of file CYap_Mysql.php.

Member Function Documentation

CYap_mysql

(

)

Definition at line 40 of file CYap_Mysql.php.

Db_Close

(

)

Close the connection to the database

Returns

bool true

Definition at line 190 of file CYap_Mysql.php.

DbBetweenCond	(		$FieldName,
			$ValueFrom,
			$ValueTo,
			$ValueType
	)

Build the condition statement for $FieldName using the 'between' expression

Parameters

string	$FieldName
mixed	$ValueFrom
mixed	$ValueTo
string	$ValueType

Returns

string

Definition at line 239 of file CYap_Mysql.php.

DbEscape

(

$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

Returns

string the escaped string

Definition at line 209 of file CYap_Mysql.php.

DbExecSql

(

$sql

)

Execute the given query

Parameters

string

$sql

sql statement

Returns

mixed the result id, false on failure

Definition at line 92 of file CYap_Mysql.php.

DbFetchField	(		$result,
			$FieldNo
	)

Get column information from a result and return as an object

Parameters

integer	$result
integer	$FieldNo

Returns

object DbMeta

Definition at line 147 of file CYap_Mysql.php.

DbFieldFlags	(		$result,
			$FieldNo
	)

Get the flags associated with the specified field in a result

Parameters

resource	$result
integer	$FieldNo

Returns

string

Definition at line 157 of file CYap_Mysql.php.

DbFreeResult

(

$result

)

Free the given result

Parameters

integer

$result

Returns

bool true on success, false on failure

Definition at line 166 of file CYap_Mysql.php.

DbGetNumFields

(

$result

)

Retrieve the number of fields retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 136 of file CYap_Mysql.php.

DbGetNumRow

(

$result

)

Retrieve the number of rows retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 127 of file CYap_Mysql.php.

DbGetValue

(

$result

)

Return the current row as associative array

Parameters

resource

$result

Returns

array row data or false on failure

Definition at line 177 of file CYap_Mysql.php.

DbRegexCond	(		$FieldName,
			$pattern
	)

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

Parameters

string
string

Returns

string

Definition at line 226 of file CYap_Mysql.php.

OpenDb	(		$DBSystem,
			$DBUser = "",
			$DBPasswd = ""
	)

Open the database connection

Parameters

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

Returns

bool true on success, false on failure

Definition at line 51 of file CYap_Mysql.php.

QueryLimit	(		$select,
			$start = 0,
			$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

Returns

bool true on success, false on failure

Definition at line 115 of file CYap_Mysql.php.

SelectDb

(

$DBname

)

database selection

Parameters

string

$DBname

database name

Returns

bool true on success, false on failure

Definition at line 72 of file CYap_Mysql.php.

---

The documentation for this class was generated from the following file:

• D:/programmi/WebDarvin/classistd/yap/CYap_Mysql.php