コード例 #1
0
<?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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name<br/>";
foreach ($athletes as $athlete) {
    // Access data using object syntax
    echo $athlete->code . "&nbsp;&nbsp;&nbsp;";
    echo $athlete->name . "<br />";
}
$var = $db->get_var("SELECT count(*) FROM athlete");
echo "Number of athletes: " . $var;
$db->debug();
コード例 #2
0
ファイル: demo.php プロジェクト: xFanly/ezSQL 
/**********************************************************************
 *  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();
}