utyDbMySql Class Reference
[Database mysql API]

MySql Data Access abstraction. More...

Inheritance diagram for utyDbMySql:

List of all members.

Public Member Functions
	open ($server, $dbname, $username, $password, $options=NULL)
	close ()
	escape ($text)
	query ($sql, &$result)
	exec ($sql)
	fetch ($result)
	insertID ()
	queryCount ($result)
	execCount ()

---

Detailed Description

MySql Data Access abstraction.

---

Member Function Documentation

close

(

)

Close the connection (if opened)

Implements utyDb.

escape

(

$

text

)

Returns:

MySql escaped sql value (use mysql_real_escape_string with the current conn)

Implements utyDb.

exec

(

$

sql

)

Exec the sql statement (INSERT,UPDATE,DELETE, etc) to the connected database.

Parameters:

sql

(string) the sql statement

Returns:

NULL if OK, utyResult if ERROR

NOTABENE: use escape for data values

See also:

use execCount() to retrieve the number of rows affected

Implements utyDb.

execCount

(

)

Returns:

the number of rows affected by the last executed sql statement (INSERT,UPDATE,DELETE, etc)

Implements utyDb.

fetch

(

$

result

)

Fetches the result of a query.

Returns:

the next row in the result or FALSE if at the end.

See also:

use queryCount() to retrieve the number of rows selected

Implements utyDb.

insertID

(

)

Returns:

the ID of the last executed INSERT when the table has an AUTOINCREMENT primary key field

Implements utyDb.

open	(	$	server,
		$	dbname,
		$	username,
		$	password,
		$	options = NULL
	)

Opens the connection to the database.

Parameters:

	server	(string) hostname_or_ip:port of the server
	dbname	(string) the database to select
	username	(string) username
	password	(string) password
	[options]	(array) IGNORED, default=NULL

Returns:

NULL if OK, utyResult if ERROR

NOTABENE: use the @ silent operator to avoid unwanted sensitive data logging

Implements utyDb.

query	(	$	sql,
		&$	result
	)

Query the sql SELECT statement to the connected database.

Parameters:

	sql	(string) the sql SELECT statement
	$result	(resource) pointer to an empty resource (any declared variable). Will be set to the query output.

Returns:

NULL if OK, utyResult if ERROR

NOTABENE: use escape for data values

See also:

use queryCount() to retrieve the number of rows selected

Implements utyDb.

queryCount

(

$

result

)

Returns:

the number of rows in result

Implements utyDb.

---

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

• C:/_prog/_source/UTillyty/utillyty.php/lib/db/utydb.mysql.php