<?php // Standard ezSQL Libs include_once "../shared/ez_sql_core.php"; include_once "ez_sql_cubrid.php"; // Initialise singleton $db = new ezSQL_cubrid('dba', '', 'demodb'); $athletes = $db->get_results("SELECT code, name FROM athlete"); echo "Code Name<br/>"; foreach ($athletes as $athlete) { // Access data using object syntax echo $athlete->code . " "; echo $athlete->name . "<br />"; } $var = $db->get_var("SELECT count(*) FROM athlete"); echo "Number of athletes: " . $var; $db->debug();
<?php // Standard ezSQL Libs include_once "../shared/ez_sql_core.php"; include_once "ez_sql_cubrid.php"; // Initialise singleton $db = new ezSQL_cubrid('dba', '', 'demodb'); // 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_results("SHOW TABLES"); $db->debug(); // Select * from use $db->get_results("SELECT * FROM athlete"); $db->debug(); // This ensures only the above querys are cached $db->cache_queries = false; // This query is NOT cached $db->get_results("SELECT * FROM athlete LIMIT 0,1"); $db->debug();
<?php /********************************************************************** * ezSQL initialisation for CUBRID */ // Include ezSQL core include_once "../shared/ez_sql_core.php"; // Include ezSQL database specific component include_once "ez_sql_cubrid.php"; // Initialise database object and establish a connection // at the same time - db_user / db_password / db_name / db_host / db_port $db = new ezSQL_cubrid('dba', '', 'demodb', 'localhost', 33000); /********************************************************************** * ezSQL demo for CUBRID database */ // Demo of getting a single variable from the db // (and using abstracted function sysdate) $current_time = $db->get_var("SELECT " . $db->sysdate()); print "ezSQL demo for CUBRID database run @ {$current_time}"; // Print out last query and results.. $db->debug(); // Get list of tables from current database.. $my_tables = $db->get_results("SHOW 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("DESC {$table['0']}"); // Print out last query and results.. $db->debug();