<?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(); }