Class ezSQL_mysql

Description
Description | Vars (details) | Methods (details) Constants

ezSQL Database specific class - mySQL Desc..: mySQL component (part of ezSQL databse abstraction library)

Located in /mysql/ez_sql_mysql.php (line 14) 

ezSQLcore
   |
   --ezSQL_mysql
Variable Summary
Description | Vars (details) | Methods (details) Constants
boolean $show_errors
Method Summary
Description | Constants Vars (details) | Methods (details)
ezSQL_mysql __construct ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''], [string $dbhost = 'localhost'], [string $charset = ''])
boolean connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbhost = 'localhost'], [type $charset = ''])
void disconnect ()
string escape (string $str)
string getCharset ()
string getDBHost ()
int getInsertId ()
boolean query (type $query)
boolean quick_connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''], [string $dbhost = 'localhost'])
boolean select ([string $dbname = ''])
string sysdate ()
Variables
Description | Vars (details) Constants | Methods (details)
boolean $show_errors = true (line 64)

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
Description | Vars (details) Constants Methods (details)
Constructor __construct (line 78)

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

  • access: public
ezSQL_mysql __construct ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''], [string $dbhost = 'localhost'], [string $charset = ''])
  • string $dbuser: The database user name
  • string $dbpassword: The database users password
  • string $dbname: The name of the database
  • string $dbhost: The host name or IP address of the database server. Default is localhost
  • string $charset: The database charset Default is empty string
Redefinition of:
ezSQLcore::__construct()
Constructor of ezSQL
connect (line 126)

Try to connect to mySQL database server

  • access: public
boolean connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbhost = 'localhost'], [type $charset = ''])
  • string $dbuser: The database user name
  • string $dbpassword: The database users password
  • string $dbhost: The host name or IP address of the database server. Default is localhost
  • type $charset: The database charset Default is empty string
disconnect (line 302)

Close the database connection

  • access: public
void disconnect ()
escape (line 189)

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

  • access: public
string escape (string $str)
  • string $str
getCharset (line 325)

Returns the current connection charset

  • access: public
string getCharset ()
getDBHost (line 316)

Returns the current database server host

  • access: public
string getDBHost ()
getInsertId (line 334)

Returns the last inserted autoincrement

  • access: public
int getInsertId ()
query (line 209)

Perform mySQL query and try to determine result value

  • access: public
boolean query (type $query)
  • type $query
quick_connect (line 108)

Short hand way to connect to mssql database server and select a mssql database at the same time

  • access: public
boolean quick_connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''], [string $dbhost = 'localhost'])
  • string $dbuser: The database user name
  • string $dbpassword: The database users password
  • string $dbname: The name of the database
  • string $dbhost: The host name or IP address of the database server. Default is localhost
select (line 156)

Try to select a mySQL database

  • access: public
boolean select ([string $dbname = ''])
  • string $dbname: The name of the database
sysdate (line 199)

Return mySQL 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
Description | Constants (details) Vars (details) | Methods (details)

Inherited Constants

Inherited from ezSQLcore

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

Documentation generated on Mon, 26 Aug 2013 23:22:21 +0200 by phpDocumentor 1.4.4