Esempio n. 1
0
<?php

/**********************************************************************
 *  ezSQL initialisation for Oracle
 */
// Include ezSQL core
include_once "../shared/ez_sql_core.php";
// Include ezSQL database specific component
include_once "ez_sql_oracle8_9.php";
// Initialise database object and establish a connection
// at the same time - db_user / db_password / db_name
$db = new ezSQL_oracle8_9('user', 'password', 'oracle.instance');
/**********************************************************************
 *  ezSQL demo for Oracle database
 */
// Demo of getting a single variable from the db
// (and using abstracted function sysdate)
$current_date = $db->get_var("SELECT " . $db->sysdate() . " FROM DUAL");
print "ezSQL demo for mySQL database run on {$current_date}";
// Get list of tables from current database..
$my_tables = $db->get_results("SELECT TABLE_NAME FROM USER_TABLES", ARRAY_N);
// Print out last query and results..
$db->debug();
// Loop through each row of results..
foreach ($my_tables as $table) {
    // Get results of DESC table..
    $db->get_results("SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION FROM USER_TAB_COLUMNS WHERE TABLE_NAME = '{$table['0']}'");
    // Print out last query and results..
    $db->debug();
}
Esempio n. 2
0
<?php

// Standard ezSQL Libs
include_once "../shared/ez_sql_core.php";
// Include ezSQL database specific component
include_once "ez_sql_oracle8_9.php";
// Initialise database object and establish a connection
// at the same time - db_user / db_password / db_name
$db = new ezSQL_oracle8_9('user', 'password', 'oracle.instance');
// Cache expiry
$db->cache_timeout = 24;
// Note: this is hours
// Specify a cache dir. Path is taken from calling script
$db->cache_dir = 'ezsql_cache';
// (1. You must create this dir. first!)
// (2. Might need to do chmod 775)
// Global override setting to turn disc caching off
// (but not on)
$db->use_disk_cache = true;
// By wrapping up queries you can ensure that the default
// is NOT to cache unless specified
$db->cache_queries = true;
// At last.. a query!
$db->get_var("SELECT " . $db->sysdate() . " FROM DUAL");
$db->debug();
// Now get it from the cache
$db->get_var("SELECT " . $db->sysdate() . " FROM DUAL");
$db->debug();
// This ensures only the above querys are cached
$db->cache_queries = false;
// This query is NOT cached