Docs For Class ezSQL

Description

ezSQL Database specific class with TNS connection Desc..: Oracle TNS component (part of ezSQL databse abstraction library)

author: Stefanie Janine Stoelting (mail@stefanie-stoelting.de)
name: ezSQL_oracleTNS
license: FREE

Located in /oracle8_9/ez_sql_oracleTNS.php (line 12)

ezSQLcore
   |
   --ezSQL_oracleTNS

Variable Summary

boolean $show_errors

Method Summary

ezSQL_oracleTNS __construct (string $host, integer $port, string $serviceName, [string $dbuser = ''], [string $dbpassword = ''], [string $characterSet = ''], [boolean $pooling = false])

boolean connect ([string $dbuser = ''], [string $dbpassword = ''])

void disconnect ()

string escape (string $str)

string insert_id (string $seq_name)

string is_equal_int (string $int)

string is_equal_str ([string $str = ''])

string nextVal (string $seq_name)

boolean pconnect ([string $dbuser = ''], [string $dbpassword = ''])

object query (string $query)

boolean quick_connect ([string $dbuser = ''], [string $dbpassword = ''])

boolean select ([string $dbuser = ''], [string $dbpassword = ''])

string sysdate ()

Variables

boolean $show_errors = true (line 78)

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

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

throws: Exception Requires Orcle OCI Lib and ez_sql_core.php
access: public

ezSQL_oracleTNS __construct (string $host, integer $port, string $serviceName, [string $dbuser = ''], [string $dbpassword = ''], [string $characterSet = ''], [boolean $pooling = false])

string $host: The server name or the IP address of the server
integer $port: The TCP port of the server
string $serviceName: The service name
string $dbuser: The database user name Default is empty string
string $dbpassword: The database users password Default is empty string
string $characterSet: The Oracle NLS_LANG character string Default is empty string
boolean $pooling: Use connection pooling with pconnect instead of connect Default is false

Redefinition of:

ezSQLcore::__construct(): Constructor of ezSQL

connect (line 132)

Try to connect to Oracle database server

access: public

boolean connect ([string $dbuser = ''], [string $dbpassword = ''])

string $dbuser: The database user name Default is empty string
string $dbpassword: The database users password Default is empty string

disconnect (line 483)

Close the database connection

access: public

void disconnect ()

escape (line 289)

Format a Oracle string correctly for safe Oracle insert

access: public

string escape (string $str)

string $str

insert_id (line 365)

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

Returns an equal string for integer values

access: public

string is_equal_int (string $int)

string $int

is_equal_str (line 341)

Returns an escaped equal string

access: public

string is_equal_str ([string $str = ''])

string $str

nextVal (line 385)

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

pconnect (line 170)

Try to connect to Oracle database server with connection pooling

access: public

boolean pconnect ([string $dbuser = ''], [string $dbpassword = ''])

string $dbuser: The database user name Default is empty string
string $dbpassword: The database users password Default is empty string

query (line 395)

Perform Oracle query and try to determine result value

access: public

object query (string $query)

string $query

quick_connect (line 265)

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 $dbuser: The database user name Default is empty string
string $dbpassword: The database users password Default is empty string

select (line 279)

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 $dbuser: The database user name Default is empty string
string $dbpassword: The database users password Default is empty string

sysdate (line 322)

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

Inherited Constants

Inherited from ezSQLcore

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

Class ezSQL_oracleTNS

Inherited Variables

Inherited Methods

Inherited Constants