Class ezSQL_oracle8_9

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

ezSQL Database specific class - Oracle 8 and 9 Desc..: Oracle 8i/9i component (part of ezSQL databse abstraction library)

Located in /oracle8_9/ez_sql_oracle8_9.php (line 14) 

ezSQLcore
   |
   --ezSQL_oracle8_9
Variable Summary
Description | Vars (details) | Methods (details) Constants
boolean $show_errors
Method Summary
Description | Constants Vars (details) | Methods (details)
ezSQL_oracle8_9 __construct ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
boolean connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
void disconnect ()
string escape (string $str)
string getDBName ()
string insert_id (string $seq_name)
string is_equal_int (string $int)
string is_equal_str ([string $str = ''])
string nextVal (string $seq_name)
object query (string $query)
boolean quick_connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
boolean select ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
string sysdate ()
Variables
Description | Vars (details) Constants | Methods (details)
boolean $show_errors = true (line 48)

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 62)

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

  • throws: Exception Requires Orcle OCI Lib and ez_sql_core.php
  • access: public
ezSQL_oracle8_9 __construct ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
  • string $dbuser: The database user name Default is empty string
  • string $dbpassword: The database users password Default is empty string
  • string $dbname: The name of the database Default is empty string
Redefinition of:
ezSQLcore::__construct()
Constructor of ezSQL
connect (line 92)

Try to connect to Oracle database server

  • access: public
boolean connect ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
  • string $dbuser: The database user name Default is empty string
  • string $dbpassword: The database users password Default is empty string
  • string $dbname: The name of the database Default is empty string
disconnect (line 348)

Close the database connection

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

Format a Oracle string correctly for safe Oracle insert

  • access: public
string escape (string $str)
  • string $str
getDBName (line 360)

Returns the current database name

  • access: public
string getDBName ()
insert_id (line 230)

Another oracle specific function - if you have set up a sequence this function returns the next ID from that sequence If the sequence is not defined, the sequence is created by this method.

Though be shure, that you use the correct sequence name not to end in more than one sequence for a primary key of a table.

  • access: public
string insert_id (string $seq_name)
  • string $seq_name: Name of the sequenze
is_equal_int (line 216)

Returns an equal string for integer values

  • access: public
string is_equal_int (string $int)
  • string $int
is_equal_str (line 206)

Returns an escaped equal string

  • access: public
string is_equal_str ([string $str = ''])
  • string $str
nextVal (line 250)

An alias for insert_id using the original Oracle function name.

  • access: public
string nextVal (string $seq_name)
  • string $seq_name: Name of the sequenze
query (line 260)

Perform Oracle query and try to determine result value

  • access: public
object query (string $query)
  • string $query
quick_connect (line 128)

In the case of Oracle 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 $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
  • string $dbuser: The database user name Default is empty string
  • string $dbpassword: The database users password Default is empty string
  • string $dbname: The name of the database Default is empty string
select (line 144)

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

  • access: public
boolean select ([string $dbuser = ''], [string $dbpassword = ''], [string $dbname = ''])
  • string $dbuser: The database user name Default is empty string
  • string $dbpassword: The database users password Default is empty string
  • string $dbname: The name of the database Default is empty string
sysdate (line 187)

Return Oracle 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:22 +0200 by phpDocumentor 1.4.4