<?php
/*
* test_database_table.php
*
* @(#) $Header: /home/mlemos/cvsroot/PHPlibrary/test_database_table.php,v 1.4 2008/06/08 22:32:03 mlemos Exp $
*
*/
?><html>
<head>
<title>Test for Manuel Lemos' database table class</title>
</head>
<body>
<h1><center>Test for Manuel Lemos' PHP database table class</center></h1>
<hr />
<?php
/*
* Include Metabase package code.
*/
require("metabase/metabase_database.php");
require("metabase/metabase_interface.php");
/*
* Include table and database table class code.
*/
require("tableclass.php");
require("databasetableclass.php");
/*
* Define a subclass of the database table class to customise any output aspects.
*/
class my_database_table_class extends database_table_class
{
};
/*
* Create a database table object.
*/
$database_table=new my_database_table_class;
/*
* Setup database connection environment.
*/
require("database_setup.php");
if(!strcmp($error=MetabaseSetupDatabase($database_arguments, $database_table->database),""))
{
MetabaseSetDatabase($database_table->database,"currencies");
/*
* Define table columns layout.
*/
$database_table->columns=array(
array(
"title"=>"ID",
"columnname"=>"id",
"type"=>"INTEGER"
),
array(
"title"=>"Symbol",
"columnname"=>"currency",
"type"=>"TEXT"
),
array(
"title"=>"World zone",
"columnname"=>"zone",
"type"=>"TEXT"
),
array(
"title"=>"Name",
"columnname"=>"name",
"type"=>"TEXT"
),
array(
"title"=>"Current value",
"columnname"=>"current_value",
"type"=>"DECIMAL"
)
);
/*
* Define table output parameters
*/
$database_table->page=0;
$database_table->rowsperpage=5;
$database_table->border=0;
$database_table->headersrowbackgroundcolor="#CCCCCC";
$database_table->oddrowsbackgroundcolor="#EEEE00";
$database_table->evenrowsbackgroundcolor="#CCCC00";
$database_table->highlightrowcolor="#00CCCC";
$database_table->listpages=3;
$database_table->firstprefix="<< First";
$database_table->previousprefix="< Previous";
$database_table->nextsuffix="Next >";
$database_table->lastsuffix="Last >>";
$database_table->rangeinfirstlast=0;
$database_table->rangeinpreviousnext=0;
/*
* Adjust table display parameters according to CGI option values
*/
if(IsSet($_REQUEST['page'])
&& !strcmp($_REQUEST['page'],strval(intval($_REQUEST['page'])))
&& intval($_REQUEST['page'])>=0)
$database_table->page=intval($_REQUEST['page']);
if(IsSet($_REQUEST['rowsperpage'])
&& !strcmp($_REQUEST['rowsperpage'],strval(intval($_REQUEST['rowsperpage'])))
&& intval($_REQUEST['rowsperpage'])>=0
&& intval($_REQUEST['rowsperpage'])<=100)
$database_table->rowsperpage=intval($_REQUEST['rowsperpage']);
$database_table->pagelinkvalues=array(
"rowsperpage"=>$database_table->rowsperpage
);
/*
* Output the database query result table.
*/
if(strcmp($output=$database_table->outputquery("SELECT * FROM currencies","SELECT COUNT(*) FROM currencies"),""))
echo $output;
else
$error=$database_table->error;
/*
* Output the database query result table using prepared query statements.
*
* if(($select_statement=MetabasePrepareQuery($database_table->database,"SELECT * FROM currencies")))
* {
* if(($count_statement=MetabasePrepareQuery($database_table->database,"SELECT COUNT(*) FROM currencies")))
* {
*
* // query arguments should be set here.
*
* if(strcmp($output=$database_table->outputpreparedquery($select_statement,$count_statement),""))
* echo $output;
* else
* $error=$database_table->error;
* MetabaseFreePreparedQuery($database_table->database,$count_statement);
* }
* else
* $error=MetabaseError($database_table->database);
* MetabaseFreePreparedQuery($database_table->database,$select_statement);
* }
* else
* $error=MetabaseError($database_table->database);
*/
}
/*
* Output error message in case something failed.
*/
if(strcmp($error,""))
echo "<h2><center>Database error: $error.</center></h2>\n";
?>
<hr />
</body>
</html>
|
Download
