Docs For Class ezSQL

Description

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

author: Justin Vincent (jv@jvmultimedia.com)
author: Stefanie Janine Stoelting <mail@stefanie-stoelting.de>
link: http://twitter.com/justinvincent
name: ezSQL_pdo
license: FREE

Located in /pdo/ez_sql_pdo.php (line 14)

ezSQLcore
   |
   --ezSQL_pdo

Variable Summary

boolean $show_errors

Method Summary

ezSQL_pdo __construct ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

string catch_error ()

boolean connect ([string $dsn = ''], [string $dbuser = ''], [string $dbpassword = ''], [array $options = array()], [boolean $isFileBased = false])

void disconnect ()

string escape (string $str)

string get_set (array $params)

object query (type $query)

boolean quick_connect ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

boolean select ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

string sysdate ()

Variables

boolean $show_errors = true (line 61)

Show errors

var: Default is true
access: public

Inherited Variables

Inherited from ezSQLcore

ezSQLcore::$affectedRows
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::$from_disk_cache
ezSQLcore::$last_error
ezSQLcore::$last_query
ezSQLcore::$last_result
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 81)

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

access: public

ezSQL_pdo __construct ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

string $dsn: The connection parameter string Default is empty string
string $user: The database user name Default is empty string
string $password: The database password Default is empty string
array $options: Array for setting connection options as MySQL charset for example Default is an empty array
boolean $isFileBased: File based databases like SQLite don't need user and password, they work with path in the dsn parameter Default is false

Redefinition of:

ezSQLcore::__construct(): Constructor of ezSQL

catch_error (line 249)

Hooks into PDO error system and reports it to user

access: public

string catch_error ()

connect (line 118)

Try to connect to the database server in the DSN parameters

access: public

boolean connect ([string $dsn = ''], [string $dbuser = ''], [string $dbpassword = ''], [array $options = array()], [boolean $isFileBased = false])

string $dsn: The connection parameter string Default is empty string
string $dbuser: The database user name Default is empty string
string $dbpassword: The database password Default is empty string
array $options: Array for setting connection options as MySQL charset for example Default is an empty array
boolean $isFileBased: File based databases like SQLite don't need user and password, they work with path in the dsn parameter Default is false

disconnect (line 400)

Close the database connection

access: public

void disconnect ()

escape (line 222)

Escape a string with the PDO method

access: public

string escape (string $str)

string $str

get_set (line 425)

Creates a SET nvp sql string from an associative array (and escapes all values)

$db_data = array('login'=>'jv','email'=>'jv@vip.ie', 'user_id' => 1, 'created' => 'NOW()');

$db->query("INSERT INTO users SET ".$db->get_set($db_data));

...OR...

$db->query("UPDATE users SET ".$db->get_set($db_data)." WHERE user_id = 1");

Output:

login = 'jv', email = 'jv@vip.ie', user_id = 1, created = NOW()

access: public

string get_set (array $params)

array $params

query (line 278)

Basic Query - see docs for more detail

access: public

object query (type $query)

type $query

quick_connect (line 180)

With PDO it is only an alias for the connect method

access: public

boolean quick_connect ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

string $dsn: The connection parameter string Default is empty string
string $user: The database user name Default is empty string
string $password: The database password Default is empty string
array $options: Array for setting connection options as MySQL charset for example Default is an empty array
boolean $isFileBased: File based databases like SQLite don't need user and password, they work with path in the dsn parameter Default is false

select (line 207)

With PDO it is only an alias for the connect method

access: public

boolean select ([string $dsn = ''], [string $user = ''], [string $password = ''], [array $options = array()], [boolean $isFileBased = false])

string $dsn: The connection parameter string Default is empty string
string $user: The database user name Default is empty string
string $password: The database password Default is empty string
array $options: Array for setting connection options as MySQL charset for example Default is an empty array
boolean $isFileBased: File based databases like SQLite don't need user and password, they work with path in the dsn parameter Default is false

sysdate (line 240)

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

access: public

string sysdate ()

Inherited Methods

Inherited From ezSQLcore

ezSQLcore::__construct()
ezSQLcore::affectedRows()
ezSQLcore::debug()
ezSQLcore::donation()
ezSQLcore::dumpvar()
ezSQLcore::flush()
ezSQLcore::getShowErrors()
ezSQLcore::get_cache()
ezSQLcore::get_col()
ezSQLcore::get_col_info()
ezSQLcore::get_results()
ezSQLcore::get_row()
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_pdo

Inherited Variables

Inherited Methods

Inherited Constants