CYap_MsSQL Class Reference

Inheritance diagram for CYap_MsSQL:

Public Member Functions
	CYap_MsSQL ()
	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 ()
	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_Mssql.php.

Member Function Documentation

CYap_MsSQL

(

)

Definition at line 78 of file CYap_Mssql.php.

Db_Close

(

)

Close the connection to the database

Returns

bool true

Definition at line 320 of file CYap_Mssql.php.

DbaddSql	(		$row,
			$fieldsType,
			$KeyField
	)

From an array of values, make 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 341 of file CYap_Mssql.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 425 of file CYap_Mssql.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 407 of file CYap_Mssql.php.

DbExecSql

(

$sql

)

Execute the given query

Parameters

string

$sql

sql statement

Returns

mixed the result id, false on failure

Definition at line 137 of file CYap_Mssql.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 217 of file CYap_Mssql.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 264 of file CYap_Mssql.php.

DbFreeResult

(

$result

)

Free the given result

Parameters

resource

$result

Returns

bool true on success, false on failure

Definition at line 281 of file CYap_Mssql.php.

DbGetNumFields

(

$result

)

Retrieve the number of fields retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 206 of file CYap_Mssql.php.

DbGetNumRow

(

$result

)

Retrieve the number of rows retrieved by the given result

Parameters

integer

$result

Returns

integer

Definition at line 189 of file CYap_Mssql.php.

DbGetValue

(

$result

)

Return the current row as associative array

Parameters

resource

$result

Returns

array row data or false on failure

Definition at line 293 of file CYap_Mssql.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 373 of file CYap_Mssql.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 394 of file CYap_Mssql.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_Mssql.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 165 of file CYap_Mssql.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 117 of file CYap_Mssql.php.

Field Documentation

$LastRow

Definition at line 66 of file CYap_Mssql.php.

$LimitEnd

Definition at line 60 of file CYap_Mssql.php.

$LimitStart

Definition at line 55 of file CYap_Mssql.php.

$LimitToEnd

Definition at line 50 of file CYap_Mssql.php.

$SavePasswd

See Also

SelectDb()

Definition at line 76 of file CYap_Mssql.php.

$SaveUser

See Also

SelectDb()

Definition at line 71 of file CYap_Mssql.php.

$UseLimit

Definition at line 44 of file CYap_Mssql.php.

---

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

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