Package: Zebra_Database

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
__destruct
in file Zebra_Database.php, method Zebra_Database::__destruct()Frees the memory associated with the last result.
top

a

$affected_rows
in file Zebra_Database.php, variable Zebra_Database::$affected_rowsAfter an INSERT, UPDATE, REPLACE or DELETE query this property will hold the number of rows that were affected by its execution.
top

c

$cache_path
in file Zebra_Database.php, variable Zebra_Database::$cache_pathPath (with trailing slash) where to cache queries results.
$caching_method
in file Zebra_Database.php, variable Zebra_Database::$caching_methodThe 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 selects a database.
top

d

$debug
in file Zebra_Database.php, variable Zebra_Database::$debugThese property can take one of the following values:
$debugger_ip
in file Zebra_Database.php, variable Zebra_Database::$debugger_ipAn 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_show_backtrace
in file Zebra_Database.php, variable Zebra_Database::$debug_show_backtraceIndicates backtrace information should be shown in the debugging console.
$debug_show_explain
in file Zebra_Database.php, variable Zebra_Database::$debug_show_explainIndicates whether queries should be EXPLAINed in the debugging console.
$debug_show_records
in file Zebra_Database.php, variable Zebra_Database::$debug_show_recordsSets the number records returned by SELECT queries to be shown in the debugging console.
$disable_warnings
in file Zebra_Database.php, variable Zebra_Database::$disable_warningsBy default, if set_charset() method is not called, 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 a string 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 that's to be used in an SQL statement in order to prevent SQL injections.
top

f

$found_rows
in file Zebra_Database.php, variable Zebra_Database::$found_rowsAfter 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_errorsWhen the value of this property is set to TRUE, the execution of the script will be halted for any 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 this method escape()'s arguments.
insert
in file Zebra_Database.php, method Zebra_Database::insert()Shorthand for INSERT queries.
insert_bulk
in file Zebra_Database.php, method Zebra_Database::insert_bulk()Shorthand for inserting multiple rows in a single query.
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()When using this method, if a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row is performed.
top

l

$log_path
in file Zebra_Database.php, variable Zebra_Database::$log_pathPath where to store the log files when the debug property is set to an array.
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_timeTime (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_compressedSetting this property to TRUE will instruct to library to compress (using zlib) the cached results.
$memcache_host
in file Zebra_Database.php, variable Zebra_Database::$memcache_hostThe host where memcache is listening for connections.
$memcache_key_prefix
in file Zebra_Database.php, variable Zebra_Database::$memcache_key_prefixThe 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_portThe port where memcache is listening for connections.
$minimize_console
in file Zebra_Database.php, variable Zebra_Database::$minimize_consoleBy 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_addressEmail 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_domainDomain 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

$resource_path
in file Zebra_Database.php, variable Zebra_Database::$resource_pathPath (without leading slash) to parent of public folder containing the css and javascript folders.
$returned_rows
in file Zebra_Database.php, variable Zebra_Database::$returned_rowsAfter running a SELECT query through select(), query() or query_unbuffered() methods, this property will contain the number 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 the current database.
transaction_complete
in file Zebra_Database.php, method Zebra_Database::transaction_complete()Ends a transaction which means that if all the queries since transaction_start() are valid, it writes the data to the database, but if any of the queries had an error, ignore all queries and treat them as if they never happened.
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 truncating tables.
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_DatabaseA compact (one-file only), 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