Docs For Class ezSQL

Description

ezSQL class - SQLite Desc..: SQLite component (part of ezSQL databse abstraction library)

author: Justin Vincent (jv@jvmultimedia.com)
author: Stefanie Janine Stoelting
link: http://twitter.com/justinvincent
name: ezSQL_sqlite
license: FREE

Located in /sqlite/ez_sql_sqlite.php (line 14)

ezSQLcore
   |
   --ezSQL_sqlite

Variable Summary

boolean $show_errors

Method Summary

ezSQL_sqlite __construct ([string $dbpath = ''], [string $dbname = ''])

boolean connect ([string $dbpath = ''], [string $dbname = ''])

void disconnect ()

string escape (string $str)

object query (string $query)

boolean quick_connect ([string $dbpath = ''], [string $dbname = ''])

boolean select ([string $dbpath = ''], [string $dbname = ''])

string sysdate ()

Variables

boolean $show_errors = true (line 29)

Show errors

var: Default is true
access: public

Inherited Variables

Inherited from ezSQLcore

ezSQLcore::$cache_dir
ezSQLcore::$cache_inserts
ezSQLcore::$cache_queries
ezSQLcore::$cache_timeout
ezSQLcore::$captured_errors
ezSQLcore::$col_info
ezSQLcore::$connected
ezSQLcore::$dbh
ezSQLcore::$db_connect_time
ezSQLcore::$debug_all
ezSQLcore::$debug_called
ezSQLcore::$debug_echo_is_on
ezSQLcore::$do_profile
ezSQLcore::$last_error
ezSQLcore::$last_query
ezSQLcore::$num_queries
ezSQLcore::$profile_times
ezSQLcore::$sql_log_file
ezSQLcore::$timers
ezSQLcore::$total_query_time
ezSQLcore::$trace
ezSQLcore::$trace_log
ezSQLcore::$use_disk_cache
ezSQLcore::$use_trace_log
ezSQLcore::$vardump_called

Methods

Constructor __construct (line 40)

Constructor - allow the user to perform a qucik connect at the same time as initialising the ezSQL_sqlite class

access: public

ezSQL_sqlite __construct ([string $dbpath = ''], [string $dbname = ''])

string $dbpath: Path to the SQLite file Default is empty string
string $dbname: Name of the database Default is empty string

Redefinition of:

ezSQLcore::__construct(): Constructor of ezSQL

connect (line 67)

Try to connect to SQLite database server

access: public

boolean connect ([string $dbpath = ''], [string $dbname = ''])

string $dbpath: Path to the SQLite file Default is empty string
string $dbname: Name of the database Default is empty string

disconnect (line 221)

Close the database connection

access: public

void disconnect ()

escape (line 121)

Format a SQLite string correctly for safe SQLite insert (no matter if magic quotes are on or not)

access: public

string escape (string $str)

string $str

query (line 142)

Perform SQLite query and try to detirmin result value Basic Query - see docs for more detail

access: public

object query (string $query)

string $query

quick_connect (line 96)

In the case of SQLite quick_connect is not really needed because std.

connect already does what quick connect does - but for the sake of consistency it has been included

access: public

boolean quick_connect ([string $dbpath = ''], [string $dbname = ''])

string $dbpath: Path to the SQLite file Default is empty string
string $dbname: Name of the database Default is empty string

select (line 110)

No real equivalent of mySQL select in SQLite once again, function included for the sake of consistency

access: public

boolean select ([string $dbpath = ''], [string $dbname = ''])

string $dbpath: Path to the SQLite file Default is empty string
string $dbname: Name of the database Default is empty string

sysdate (line 131)

Return SQLite specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()

access: public

string sysdate ()

Inherited Methods

Inherited From ezSQLcore

ezSQLcore::__construct()
ezSQLcore::debug()
ezSQLcore::donation()
ezSQLcore::dumpvar()
ezSQLcore::flush()
ezSQLcore::get_cache()
ezSQLcore::get_col()
ezSQLcore::get_col_info()
ezSQLcore::get_results()
ezSQLcore::get_row()
ezSQLcore::get_set()
ezSQLcore::get_var()
ezSQLcore::hide_errors()
ezSQLcore::isConnected()
ezSQLcore::register_error()
ezSQLcore::show_errors()
ezSQLcore::store_cache()
ezSQLcore::timer_elapsed()
ezSQLcore::timer_get_cur()
ezSQLcore::timer_start()
ezSQLcore::timer_update_global()
ezSQLcore::vardump()

Class Constants

Inherited Constants

Inherited from ezSQLcore

ezSQLcore::ARRAY_A
ezSQLcore::ARRAY_N
ezSQLcore::EZSQL_VERSION
ezSQLcore::OBJECT

Class ezSQL_sqlite

Inherited Variables

Inherited Methods

Inherited Constants