Element index for Zebra_Database
[ a ]
[ c ]
[ d ]
[ e ]
[ f ]
[ g ]
[ h ]
[ i ]
[ l ]
[ m ]
[ n ]
[ o ]
[ p ]
[ q ]
[ r ]
[ s ]
[ t ]
[ u ]
[ z ]
[ _ ]
top
top
c
- $cache_path
- in file Zebra_Database.php, variable Zebra_Database::$cache_path
Path where to store cached queries results.
- $caching_method
- in file Zebra_Database.php, variable Zebra_Database::$caching_method
The method to be used for caching query results.
- close
- in file Zebra_Database.php, method Zebra_Database::close()
Closes the MySQL connection and optionally unsets the connection options previously set with the option() method
- connect
- in file Zebra_Database.php, method Zebra_Database::connect()
Opens a connection to a MySQL server and optionally selects a database
top
d
- $debug
- in file Zebra_Database.php, variable Zebra_Database::$debug
Turns debugging on or off.
- $debugger_ip
- in file Zebra_Database.php, variable Zebra_Database::$debugger_ip
An array of IP addresses for which to show the debugging console / write to log file, if the debug property is not set to FALSE .
- $debug_ajax
- in file Zebra_Database.php, variable Zebra_Database::$debug_ajax
Enables logging of queries done through AJAX requests.
- $debug_cookie_name
- in file Zebra_Database.php, variable Zebra_Database::$debug_cookie_name
If debugging is enabled on the fly via the presence of a query string argument (see the debug property), a cookie is set so that the query string is not required to be present in subsequent requests.
- $debug_info
- in file Zebra_Database.php, variable Zebra_Database::$debug_info
All debugging information is stored in this array.
- $debug_show_backtrace
- in file Zebra_Database.php, variable Zebra_Database::$debug_show_backtrace
Indicates whether backtrace information should be shown in the debugging console.
- $debug_show_database_manager
- in file Zebra_Database.php, variable Zebra_Database::$debug_show_database_manager
Show a link for editing the query in your favorite database manager like (like phpMyAdmin or Adminer).
- $debug_show_explain
- in file Zebra_Database.php, variable Zebra_Database::$debug_show_explain
Indicates whether queries should be EXPLAINed in the debugging console.
- $debug_show_globals
- in file Zebra_Database.php, variable Zebra_Database::$debug_show_globals
Indicates which of $_REQUEST , $_POST , $_GET , $_SESSION , $_COOKIE , $_FILES and $_SERVER superglobals should be available in the debugging console, under the globals section.
- $debug_show_records
- in file Zebra_Database.php, variable Zebra_Database::$debug_show_records
Sets the number of records returned by SELECT queries to be shown in the debugging console.
- $disable_warnings
- in file Zebra_Database.php, variable Zebra_Database::$disable_warnings
By default, if set_charset() method is not called, caching is used and memcache or redis are available but none of them is used, a warning message will be displayed in the debugging console.
- dcount
- in file Zebra_Database.php, method Zebra_Database::dcount()
Counts the values in a column of a table
- delete
- in file Zebra_Database.php, method Zebra_Database::delete()
Deletes rows from a table
- dlookup
- in file Zebra_Database.php, method Zebra_Database::dlookup()
Returns one or more columns from ONE row of a table
- dmax
- in file Zebra_Database.php, method Zebra_Database::dmax()
Looks up the maximum value in a column of a table
- dsum
- in file Zebra_Database.php, method Zebra_Database::dsum()
Sums the values in a column of a table
top
e
- error
- in file Zebra_Database.php, method Zebra_Database::error()
Returns the description of the last error, or an empty string if no error occurred
- escape
- in file Zebra_Database.php, method Zebra_Database::escape()
Escapes special characters in a string making it safe to be used in an MySQL statement, in order to prevent SQL injections
top
f
- $found_rows
- in file Zebra_Database.php, variable Zebra_Database::$found_rows
After running a SELECT query through select(), query() or query_unbuffered() methods and having the calc_rows argument set to TRUE , this property will contain the number of records that would have been returned if there was no LIMIT applied to the query.
- fetch_assoc
- in file Zebra_Database.php, method Zebra_Database::fetch_assoc()
Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. The data is taken from the resource created by the previous query or from the resource given as argument.
- fetch_assoc_all
- in file Zebra_Database.php, method Zebra_Database::fetch_assoc_all()
Returns an associative array containing all the rows from the resource created by the previous query or from the resource given as argument and moves the internal pointer to the end
- fetch_obj
- in file Zebra_Database.php, method Zebra_Database::fetch_obj()
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead.
- fetch_obj_all
- in file Zebra_Database.php, method Zebra_Database::fetch_obj_all()
Returns an associative array containing all the rows (as objects) from the resource created by the previous query or from the resource given as argument and moves the internal pointer to the end
- free_result
- in file Zebra_Database.php, method Zebra_Database::free_result()
Frees the memory associated with a result
top
g
- get_columns
- in file Zebra_Database.php, method Zebra_Database::get_columns()
Returns an array of associative arrays with information about the columns in the MySQL result associated with the specified result identifier
- get_link
- in file Zebra_Database.php, method Zebra_Database::get_link()
Returns the MySQL link identifier associated with the current connection to the MySQL server
- get_selected_database
- in file Zebra_Database.php, method Zebra_Database::get_selected_database()
Returns the name of the currently selected database
- get_tables
- in file Zebra_Database.php, method Zebra_Database::get_tables()
Returns an array with all the tables in a database
- get_table_columns
- in file Zebra_Database.php, method Zebra_Database::get_table_columns()
Returns information about the columns of a given table as an associative array
- get_table_status
- in file Zebra_Database.php, method Zebra_Database::get_table_status()
Returns an associative array with a lot of useful information on all or specific tables only
top
h
- $halt_on_errors
- in file Zebra_Database.php, variable Zebra_Database::$halt_on_errors
When the value of this property is set to TRUE , the execution of the script will be halted after the first unsuccessful query and the debugging console will be shown (or debug information will be written to the log file if configured so), if the value of the debug property is not FALSE and the viewer's IP address is in the debugger_ip array (or debugger_ip is an empty array).
top
i
- implode
- in file Zebra_Database.php, method Zebra_Database::implode()
Works similarly to PHP's implode() function with the difference that the glue is always the comma and that all the values are automatically escaped
- insert
- in file Zebra_Database.php, method Zebra_Database::insert()
Shorthand for INSERT queries with additional IGNORE / ON DUPLICATE KEY support
- insert_bulk
- in file Zebra_Database.php, method Zebra_Database::insert_bulk()
Shorthand for inserting multiple rows in a single query with additional IGNORE / ON DUPLICATE KEY support
- insert_id
- in file Zebra_Database.php, method Zebra_Database::insert_id()
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query
- insert_update
- in file Zebra_Database.php, method Zebra_Database::insert_update()
This method is deprecated since 2.9.12 and will be removed in 3.0. Please use the insert_bulk() method
top
Path where to store the log files when the debug property is set to an array OR a callback function to pass the log information to instead of being written to a file.
- language
- in file Zebra_Database.php, method Zebra_Database::language()
Sets the language to be used for the messages in the debugging console and in the log files
top
m
- $max_query_time
- in file Zebra_Database.php, variable Zebra_Database::$max_query_time
Time (in seconds) after which a query will be considered as running for too long.
- $memcache_compressed
- in file Zebra_Database.php, variable Zebra_Database::$memcache_compressed
Setting this property to TRUE will instruct to library to compress the cached results (using zlib ).
- $memcache_host
- in file Zebra_Database.php, variable Zebra_Database::$memcache_host
The host where the memcache server is listening for connections.
- $memcache_key_prefix
- in file Zebra_Database.php, variable Zebra_Database::$memcache_key_prefix
The prefix for the keys used to identify cached queries in memcache. This allows separate caching of the same queries by multiple instances of the libraries, or the same instance handling multiple domains on the same memcache server.
- $memcache_port
- in file Zebra_Database.php, variable Zebra_Database::$memcache_port
The port on which the memcache server is listening for connections.
- $minimize_console
- in file Zebra_Database.php, variable Zebra_Database::$minimize_console
By setting this property to TRUE a minimized version of the debugging console will be shown by default instead of the full-sized one.
top
top
o
- optimize
- in file Zebra_Database.php, method Zebra_Database::optimize()
Optimizes all tables that have overhead (unused, lost space) in a database
- option
- in file Zebra_Database.php, method Zebra_Database::option()
Sets one or more options that affect the behavior of a connection
top
top
top
r
- $redis_compressed
- in file Zebra_Database.php, variable Zebra_Database::$redis_compressed
Setting this property to TRUE will instruct to library to compress the cached results (using zlib ).
- $redis_host
- in file Zebra_Database.php, variable Zebra_Database::$redis_host
The host where the redis server is listening for connections.
- $redis_key_prefix
- in file Zebra_Database.php, variable Zebra_Database::$redis_key_prefix
The prefix for the keys used to identify cached queries in redis. This allows separate caching of the same queries by multiple instances of the libraries, or the same instance handling multiple domains on the same redis server.
- $redis_port
- in file Zebra_Database.php, variable Zebra_Database::$redis_port
The port on which the redis server is listening for connections.
- $resource_path
- in file Zebra_Database.php, variable Zebra_Database::$resource_path
Path to parent of public folder containing the css and javascript folders.
- $returned_rows
- in file Zebra_Database.php, variable Zebra_Database::$returned_rows
After running a SELECT query through select(), query() or query_unbuffered() methods, this property will contain the number of returned rows.
top
top
top
top
z
- Zebra_Database
- in file Zebra_Database.php, class Zebra_Database
A compact, lightweight yet feature-rich PHP MySQLi database wrapper providing methods for interacting with MySQL databases that are more secure, powerful and intuitive than PHP's default ones.
- Zebra_Database.php
- procedural page Zebra_Database.php
top
|