CYap_odbc Class Reference

Inheritance diagram for CYap_odbc:

Public Member Functions
	CYap_odbc ()
	OpenDb ($DBSystem, $DBUser="", $DBPasswd="")
	SelectDb ($DBname)
	DbExecSql ($sql)
	QueryLimit ($select, $start=0, $many=-1)
	DbGetNumRow ($result)
	CalculateNumRows ($result)
	DbGetNumFields ($result)
	DbFetchField ($result, $FieldNo)
	DbFieldFlags ($result, $FieldNo)
	DbFreeResult ($result)
	DbGetValue ($result)
	Db_Close ()
	DbaddSql ($row, $fieldsType, $KeyField)
	DbmodifySql ($row, $fieldsType)
	DbRegexCond ($FieldName, $pattern)
	DbEscape ($value)
	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)

Data Fields
	$UseLimit
	$LimitToEnd
	$LimitStart
	$LimitEnd
	$LastRow
	$SaveUser
	$SavePasswd
Data Fields inherited from CYapDB
	$DbConn
	$Db_Open
	$txtError
	$Dbresult
	$CurrentRow
	$LastQuery

Detailed Description

Definition at line 38 of file CYap_ODBC.php.

Member Function Documentation

CalculateNumRows

(

$result

)

Definition at line 200 of file CYap_ODBC.php.

CYap_odbc

(

)

Definition at line 78 of file CYap_ODBC.php.

Db_Close

(

)

Close the connection to the database

Returns

bool true

Definition at line 340 of file CYap_ODBC.php.

DbaddSql	(		$row,
			$fieldsType,
			$KeyField
	)

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

Parameters

array	array of values. The key is the field name
array	type of each fields
string	name of the key field public

Definition at line 361 of file CYap_ODBC.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 445 of file CYap_ODBC.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

Parameters

string

$value

sql statement public

Returns

string the escaped string

Definition at line 427 of file CYap_ODBC.php.

DbExecSql

(

$sql

)

Execute the given query

Parameters

string

$sql

sql statement

Returns

mixed the result id, false on failure

Definition at line 131 of file CYap_ODBC.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 245 of file CYap_ODBC.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 292 of file CYap_ODBC.php.

DbFreeResult

(

$result

)

Free the given result

Parameters

resource

$result

Returns

bool true on success, false on failure

Definition at line 309 of file CYap_ODBC.php.

DbGetNumFields

(

$result

)

Retrieve the number of fields retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 233 of file CYap_ODBC.php.

DbGetNumRow

(

$result

)

Retrieve the number of rows retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 183 of file CYap_ODBC.php.

DbGetValue

(

$result

)

Return the current row as associative array

Parameters

resource

$result

Returns

array row data or false on failure

Definition at line 321 of file CYap_ODBC.php.

DbmodifySql	(		$row,
			$fieldsType
	)

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

Parameters

array	array of values. The key is the field name
array	type of each fields public

Definition at line 393 of file CYap_ODBC.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 414 of file CYap_ODBC.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 93 of file CYap_ODBC.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 159 of file CYap_ODBC.php.

SelectDb

(

$DBname

)

database selection. Always true, the ODBC function don't allow to select any database

Parameters

string

$DBname

database name

Returns

bool true on success, false on failure

Definition at line 110 of file CYap_ODBC.php.

Field Documentation

$LastRow

Definition at line 66 of file CYap_ODBC.php.

$LimitEnd

Definition at line 60 of file CYap_ODBC.php.

$LimitStart

Definition at line 55 of file CYap_ODBC.php.

$LimitToEnd

Definition at line 50 of file CYap_ODBC.php.

$SavePasswd

See Also

SelectDb()

Definition at line 76 of file CYap_ODBC.php.

$SaveUser

See Also

SelectDb()

Definition at line 71 of file CYap_ODBC.php.

$UseLimit

Definition at line 44 of file CYap_ODBC.php.

---

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

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