com-tecnick-tcexam-shared-postgresql
[ class tree: com-tecnick-tcexam-shared-postgresql ] [ index: com-tecnick-tcexam-shared-postgresql ] [ all elements ]

Procedural File: tce_db_dal_postgresql.php

Source Location: /shared/code/tce_db_dal_postgresql.php



Page Details:

PostgreSQL driver for TCExam Database Abstraction Layer (DAL).

This abstraction layer uses the same SQL syntax of MySQL.




Tags:

author:  Nicola Asuni
copyright:  Copyright © 2004-2008, Nicola Asuni - Tecnick.com S.r.l. - ITALY - www.tecnick.com - info@tecnick.com
link:  www.tecnick.com
since:  2004-12-21
license:  GNU General Public License








F_db_affected_rows [line 119]

Number F_db_affected_rows( resource $link_identifier, resource $result)

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



Tags:

return:  of rows.


Parameters

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



F_db_close [line 78]

bool F_db_close( resource $link_identifier)

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



Tags:

return:  TRUE on success or FALSE on failure


Parameters

resource   $link_identifier   database link identifier.
[ Top ]



F_db_connect [line 65]

PostgreSQL F_db_connect( [ $host = 'localhost'], [ $port = '5432'], [string $username = 'postgres'], [string $password = ''], [string $database = 'template1'], string $server)

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

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




Tags:

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


Parameters

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.
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.
   $host  
   $port  
[ Top ]



F_db_error [line 86]

string F_db_error( )

Returns the text of the error message from previous database operation



Tags:

return:  error message.


[ Top ]



F_db_fetch_array [line 109]

Returns F_db_fetch_array( resource $result)

Fetch a result row as an associative and numeric array.

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




Tags:

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


Parameters

resource   $result   result resource to the query result.
[ Top ]



F_db_insert_id [line 139]

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

Get the ID generated from the previous INSERT operation



Tags:

return:  ID generated from the last INSERT operation.


Parameters

resource   $link_identifier   database link identifier.
string   $tablename   Table name.
string   $fieldname   Field name (column name).
[ Top ]



F_db_num_rows [line 128]

Number F_db_num_rows( resource $result)

Get number of rows in result.



Tags:

return:  of affected rows.


Parameters

resource   $result   result resource to the query result.
[ Top ]



F_db_query [line 97]

FALSE F_db_query( string $query, resource $link_identifier)

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



Tags:

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


Parameters

string   $query   The query tosend. The query string should not end with a semicolon.
resource   $link_identifier   database link identifier.
[ Top ]



F_escape_sql [line 154]

string F_escape_sql( string $str)

Escape a string for insertion into a SQL text field (avoiding SQL injection).



Tags:

return:  Returns the escaped string, or FALSE on error.
since:  5.0.005 2007-12-05


Parameters

string   $str   The string that is to be escaped.
[ Top ]



Documentation generated on Thu, 05 Feb 2009 12:44:38 +0100 by phpDocumentor 1.4.1