## /shared/code/tce_db_dal_mysql.php

Description

MySQL driver for TCExam Database Abstraction Layer (DAL).

This abstraction layer uses the same SQL syntax of MySQL.

- since: 2003-10-12
- link: www.tecnick.com
- copyright: Copyright &copy; 2004-2006, Tecnick.com S.r.l. - Via Ugo Foscolo n.19 - 09045 Quartu Sant'Elena (CA) - ITALY - www.tecnick.com - info@tecnick.com
- author: Nicola Asuni

Functions
F_db_affected_rows (line 105)

Returns number of rows (tuples) affected by the last INSERT, UPDATE or DELETE query associated with link_identifier.

- return: of rows.

Number F_db_affected_rows (resource $link_identifier, resource $result)

- resource $link_identifier: database link identifier.
- resource $result: result resource to the query result [UNUSED].

F_db_close (line 63)

Closes the non-persistent connection to a database associated with the given connection resource.

- return: TRUE on success or FALSE on failure

bool F_db_close (resource $link_identifier)

- resource $link_identifier: database link identifier.

F_db_connect (line 45)

Open a connection to a MySQL Server and select a database.

If a second call is made to mysql_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned.

- return: link identifier on success, or FALSE on failure.

MySQL F_db_connect ([mixed $host = 'localhost'], [mixed $port = '3306'], [string $username = 'root'], [string $password = ''], [string $database = ''], string $server)

- string $server: Database server path. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost. Note: Whenever you specify "localhost" or "localhost:port" as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use "127.0.0.1" instead of "localhost". If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as mysql.default_host in your PHP configuration and leave the server field blank.
- string $username: Name of the user that owns the server process.
- string $password: Password of the user that owns the server process.
- string $database: Database name.

F_db_error (line 71)

Returns the text of the error message from previous database operation

- return: error message.

string F_db_error ()
F_db_fetch_array (line 95)

Fetch a result row as an associative and numeric array.

Note: This function sets NULL fields to PHP NULL value.

- return: an array that corresponds to the fetched row, or FALSE if there are no more rows.

Returns F_db_fetch_array (resource $result)

- resource $result: result resource to the query result.

F_db_insert_id (line 125)

Get the ID generated from the previous INSERT operation

- return: ID generated from the last INSERT operation.

int F_db_insert_id (resource $link_identifier, [string $tablename = ''], [string $fieldname = ''])

- resource $link_identifier: database link identifier.
- string $tablename: Table name.
- string $fieldname: Field name (column name).

F_db_num_rows (line 114)

Get number of rows in result.

- return: of affected rows.

Number F_db_num_rows (resource $result)

- resource $result: result resource to the query result.

F_db_query (line 83)

Sends a query to the currently active database on the server that's associated with the specified link identifier.
NOTE: Convert PostgreSQL RANDOM() function to MySQL RAND() on ORDER BY clause of selection queries.

- return: in case of error, TRUE or resource-identifier in case of success.

FALSE F_db_query (string $query, resource $link_identifier)

- string $query: The query tosend. The query string should not end with a semicolon.
- resource $link_identifier: database link identifier.

Documentation generated on Fri, 24 Nov 2006 21:16:18 +0100 by phpDocumentor 1.3.0RC3