Zebra_Database Zebra Database

Project's homepage

Classes:

Stefan Gabos Hi there!

That's me, Stefan Gabos, the author of this library.

If you like this project, please star it on GitHub — thank you!

I have a few other projects that you might be interested in — check them out if you have the time.

Element index for Zebra_Database

[ a ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ z ] [ _ ]

_

__construct
in file Zebra_Database.php, method Zebra_Database::__construct()
    Constructor of the class
top

a

$affected_rows
in file Zebra_Database.php, variable Zebra_Database::$affected_rows
    The number of rows affected after running an INSERT, UPDATE, REPLACE or DELETE query.
$auto_quote_replacements
in file Zebra_Database.php, variable Zebra_Database::$auto_quote_replacements
    Should escaped variables be also enclosed in single quotes?
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_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

l

$log_path
in file Zebra_Database.php, variable Zebra_Database::$log_path

    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

n

$notification_address
in file Zebra_Database.php, variable Zebra_Database::$notification_address
    Email address to which notification emails to be sent when a query's execution time exceeds the number of seconds set by max_query_time. The notification email will be automatically sent to the address defined by notification_address and having notifier_domain in subject.
$notifier_domain
in file Zebra_Database.php, variable Zebra_Database::$notifier_domain
    Domain name to be used in the subject of notification emails sent when a query's execution time exceeds the number of seconds set by max_query_time.
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

p

parse_file
in file Zebra_Database.php, method Zebra_Database::parse_file()
    Parses a MySQL dump file (like an export from phpMyAdmin)
top

q

query
in file Zebra_Database.php, method Zebra_Database::query()
    Runs a MySQL query
query_unbuffered
in file Zebra_Database.php, method Zebra_Database::query_unbuffered()
    Runs a MySQL unbuffered query.
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

s

seek
in file Zebra_Database.php, method Zebra_Database::seek()
    Moves the internal row pointer of the MySQL result associated with the specified result identifier to the specified row number
select
in file Zebra_Database.php, method Zebra_Database::select()
    Shorthand for simple SELECT queries
select_database
in file Zebra_Database.php, method Zebra_Database::select_database()
    Selects the default database for queries
set_charset
in file Zebra_Database.php, method Zebra_Database::set_charset()
    Sets MySQL character set and collation
top

t

table_exists
in file Zebra_Database.php, method Zebra_Database::table_exists()
    Checks whether a table exists in a database
transaction_complete
in file Zebra_Database.php, method Zebra_Database::transaction_complete()
    Ends a transaction
transaction_start
in file Zebra_Database.php, method Zebra_Database::transaction_start()
    Starts the transaction system.
truncate
in file Zebra_Database.php, method Zebra_Database::truncate()
    Shorthand for TRUNCATE queries
top

u

update
in file Zebra_Database.php, method Zebra_Database::update()
    Shorthand for UPDATE queries
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