function sql()
{
/*{{{*/
if (!$_REQUEST['query']) {
echo "<b>ERROR: Missing parameters.</b>\n";
return false;
}
// allow only SELECT, SHOW or DESCRIBE queries
$allowed = "^(select|show|describe)";
if (!eregi($allowed, trim($_REQUEST['query']))) {
echo "<b>ERROR: Only 'SELECT', 'SHOW', or 'DESCRIBE' queries are allowed.</b>\n";
return false;
}
$result = sqlquery(MDB_DATA_DSN, $_REQUEST['query']);
if (is_object($result) && DB::isError($result)) {
echo "<b>ERROR " . $result->getCode() . ": " . $result->getMessage() . "</b>\n";
return false;
}
$format = isset($_REQUEST['format']) ? strtolower($_REQUEST['format']) : "csv";
switch ($format) {
case "wddx":
$out = wddx_serialize_value($result);
break;
case "serialize":
$out = serialize($result);
break;
case "table":
$out = toTable($result);
break;
case "csv":
default:
$fields = array_keys($result[0]);
$out = toCSV($fields);
for ($i = 0; $i < count($result); $i++) {
$out .= toCSV(array_values($result[$i]));
}
break;
}
echo $out;
return true;
}
/*
talbeStyle功能：
1 .table 樣式
2. 自動設定 雙數行的 .odd class
To Aplly:
1. include Me
2. set .table to table
3. 標題請設定 .heading 或使用 <thead><tfoot> 以正確計算雙數行
To Design:
預設 css/table_lightgray.css
2008-3/15 Curtiss
*/
toTable();
function toTable()
{
$nowSrvPath = str_replace('\\', '/', dirname(__FILE__));
$nowWebPath = substr_replace($nowSrvPath, '', 0, strpos($nowSrvPath, $_SERVER['DOCUMENT_ROOT']) + strlen($_SERVER['DOCUMENT_ROOT']));
?>
<script src="<?php
echo $nowWebPath;
?>
/js/jquery.js" type="text/javascript"></script>
<script type="text/javascript">
//submit 按鈕的 hover 效果
$(function(){
//為 table 加上條紋
$('.table tbody tr[@class!="heading"]:odd').attr('class','odd');
//去除 table 如果原本有設定的 border 屬性 (for IE7)
