functions-db.php
Deprecated database core functions - Legacy backward compatibility wrapper for the active database handler class
Use the global database object variable $_zp_db and the class methods instead
Use the global object $_zp_db and its methods of the same name instead of these functions.
Within main object classes like album, image etc. the db handler object is generally also available via $this->db.
Tags
Table of Contents
Functions
- db_connect() : true
- Connect to the database server and select the database.
- query() : results
- The main query function. Runs the SQL on the connection and handles errors.
- query_single_row() : results
- Runs a SQL query and returns an associative array of the first row.
- query_full_array() : results
- Runs a SQL query and returns an array of associative arrays of every row returned.
- db_quote() : string
- mysqli_real_escape_string standin that insures the DB connection is passed.
- db_insert_id() : mixed
- returns the insert id of the last database insert
- db_fetch_assoc() : mixed
- Fetch a result row as an associative array
- db_error() : mixed
- Returns the text of the error message from previous operation
- db_affected_rows() : mixed
- Get number of affected rows in previous operation
- db_fetch_row() : mixed
- Get a result row as an enumerated array
- db_num_rows() : mixed
- Get number of rows in result
- db_close() : mixed
- Closes the database
- db_software() : mixed
- report the software of the database
- db_create() : mixed
- create the database
- db_permissions() : mixed
- Returns user's permissions on the database
- db_setSQLmode() : mixed
- Sets the SQL session mode to empty
- db_getSQLmode() : mixed
- Queries the SQL session mode
- db_collation() : mixed
- db_create_table() : mixed
- db_table_update() : mixed
- db_show() : mixed
- db_list_fields() : mixed
- db_truncate_table() : mixed
- db_LIKE_escape() : mixed
- db_free_result() : mixed
- prefix() : prefixed
- Prefix a table name with a user-defined string to avoid conflicts.
- getWhereClause() : contructed
- Constructs a WHERE clause ("WHERE uniqueid1='uniquevalue1' AND uniqueid2='uniquevalue2' ...") from an array (map) of variables and their values which identifies a unique record in the database table.
- getSetClause() : contructed
- Constructs a SET clause ("SET uniqueid1='uniquevalue1', uniqueid2='uniquevalue2' ...") from an array (map) of variables and their values which identifies a unique record in the database table. Used to 'move' records. Note: does not check anything.
- db_name() : mixed
- returns the connected database name
- db_count() : int
- Counts entries in a db table
- db_getServerInfo() : string
- Returns the server info
- db_getClientInfo() : string
- Returns the client info
- db_getVersion() : int
- Gets the plain version number
Functions
db_connect()
Connect to the database server and select the database.
Use the global object $_zp_db and the class method connect() instead.
db_connect(array<string|int, mixed> $config[, bool $errorstop = true ]) : true
Parameters
- $config : array<string|int, mixed>
-
the db configuration parameters
- $errorstop : bool = true
-
set to false to omit error messages
Tags
Return values
true —if successful connection
query()
The main query function. Runs the SQL on the connection and handles errors.
Use the global object $_zp_db and the class method of the same name instead.
query(string $sql[, bool $errorstop = true ]) : results
Parameters
- $sql : string
-
sql code
- $errorstop : bool = true
-
set to false to supress the error message
Tags
Return values
results —of the sql statements
query_single_row()
Runs a SQL query and returns an associative array of the first row.
Use the global object $_zp_db and the class method querySingleRow() instead.
query_single_row(string $sql[, bool $errorstop = true ]) : results
Doesn't handle multiple rows, so this should only be used for unique entries.
Parameters
- $sql : string
-
sql code
- $errorstop : bool = true
-
set to false to supress the error message
Tags
Return values
results —of the sql statements
query_full_array()
Runs a SQL query and returns an array of associative arrays of every row returned.
Use the global object $_zp_db and the class method queryFullArray() instead.
query_full_array(string $sql[, bool $errorstop = true ][, string $key = NULL ]) : results
Parameters
- $sql : string
-
sql code
- $errorstop : bool = true
-
set to false to supress the error message
- $key : string = NULL
-
optional array index key
Tags
Return values
results —of the sql statements
db_quote()
mysqli_real_escape_string standin that insures the DB connection is passed.
Use the global object $_zp_db and the class method quote() instead.
db_quote(string $string[, mixed $addquotes = true ]) : string
Parameters
- $string : string
- $addquotes : mixed = true
Tags
Return values
stringdb_insert_id()
returns the insert id of the last database insert
Use the global object $_zp_db and the class method insertID() instead.
db_insert_id() : mixed
Tags
db_fetch_assoc()
Fetch a result row as an associative array
Use the global object $_zp_db and the class method fetchAssoc() instead.
db_fetch_assoc(mixed $resource) : mixed
Parameters
- $resource : mixed
Tags
db_error()
Returns the text of the error message from previous operation
Use the global object $_zp_db and the class method getError() instead.
db_error() : mixed
Tags
db_affected_rows()
Get number of affected rows in previous operation
Use the global object $_zp_db and the class method getAffectedRows() instead.
db_affected_rows() : mixed
Tags
db_fetch_row()
Get a result row as an enumerated array
Use the global object $_zp_db and the class method fetchRow() instead.
db_fetch_row(mixed $result) : mixed
Parameters
- $result : mixed
Tags
db_num_rows()
Get number of rows in result
Use the global object $_zp_db and the class method getNumRows() instead.
db_num_rows(mixed $result) : mixed
Parameters
- $result : mixed
Tags
db_close()
Closes the database
Use the global object $_zp_db and the class method close() instead.
db_close() : mixed
Tags
db_software()
report the software of the database
Use the global object $_zp_db and the class method getSoftware() instead.
db_software() : mixed
Tags
db_create()
create the database
Use the global object $_zp_db and the class method create() instead
db_create() : mixed
Tags
db_permissions()
Returns user's permissions on the database
Use the global object $_zp_db and the class method getPermissions() instead.
db_permissions() : mixed
Tags
db_setSQLmode()
Sets the SQL session mode to empty
Use the global object $_zp_db and the class method setSQLmode() instead.
db_setSQLmode() : mixed
Tags
db_getSQLmode()
Queries the SQL session mode
Use the global object $_zp_db and the class method getSQLmode() instead.
db_getSQLmode() : mixed
Tags
db_collation()
Use the global object $_zp_db and the class method getCollation() instead.
db_collation() : mixed
Tags
db_create_table()
Use the global object $_zp_db and the class method createTable() instead.
db_create_table(mixed $sql) : mixed
Parameters
- $sql : mixed
Tags
db_table_update()
Use the global object $_zp_db and the class method tableUpdate() instead.
db_table_update(mixed $sql) : mixed
Parameters
- $sql : mixed
Tags
db_show()
Use the global object $_zp_db and the class method show() instead.
db_show(mixed $what[, mixed $aux = '' ]) : mixed
Parameters
- $what : mixed
- $aux : mixed = ''
Tags
db_list_fields()
Use the global object $_zp_db and the class method listFields() instead.
db_list_fields(mixed $table) : mixed
Parameters
- $table : mixed
Tags
db_truncate_table()
Use the global object $_zp_db and the class method truncateTable() instead.
db_truncate_table(mixed $table) : mixed
Parameters
- $table : mixed
Tags
db_LIKE_escape()
Use the global object $_zp_db and the class method likeEscape() instead.
db_LIKE_escape(mixed $str) : mixed
Parameters
- $str : mixed
Tags
db_free_result()
Use the global object $_zp_db and the class method freeResult() instead.
db_free_result(mixed $result) : mixed
Parameters
- $result : mixed
Tags
prefix()
Prefix a table name with a user-defined string to avoid conflicts.
Use the global object $_zp_db and the class method of the same name instead.
prefix([string $tablename = NULL ]) : prefixed
This MUST be used in all database queries.
Parameters
- $tablename : string = NULL
-
name of the table
Tags
Return values
prefixed —table name
getWhereClause()
Constructs a WHERE clause ("WHERE uniqueid1='uniquevalue1' AND uniqueid2='uniquevalue2' ...") from an array (map) of variables and their values which identifies a unique record in the database table.
Use the global object $_zp_db and the class method of the same name instead
getWhereClause(string $unique_set) : contructed
Parameters
- $unique_set : string
-
what to add to the WHERE clause
Tags
Return values
contructed —WHERE cleause
getSetClause()
Constructs a SET clause ("SET uniqueid1='uniquevalue1', uniqueid2='uniquevalue2' ...") from an array (map) of variables and their values which identifies a unique record in the database table. Used to 'move' records. Note: does not check anything.
Use the global object $_zp_db and the class method of the same name instead
getSetClause(string $new_unique_set) : contructed
Parameters
- $new_unique_set : string
-
what to add to the SET clause
Tags
Return values
contructed —SET cleause
db_name()
returns the connected database name
Use the global object $_zp_db and the class method getDBName() instead.
db_name() : mixed
Tags
db_count()
Counts entries in a db table
Use the global object $_zp_db and the class method count() instead.
db_count(string $table[, string $clause = NULL ][, string $field = "id" ]) : int
Parameters
- $table : string
-
Table name
- $clause : string = NULL
-
Where clause for the count query
- $field : string = "id"
-
Which fields to count (default: id)
Tags
Return values
intdb_getServerInfo()
Returns the server info
Use the global object $_zp_db and the class method getServerInfo() instead.
db_getServerInfo() : string
Tags
Return values
stringdb_getClientInfo()
Returns the client info
Use the global object $_zp_db and the class method getClientInfo() instead.
db_getClientInfo() : string
Tags
Return values
stringdb_getVersion()
Gets the plain version number
db_getVersion() : int