welcome
\n";
mysql_select_db("test")
or die("select database error!");
print "select db successfully!
\n";
mysql_query("SET NAMES 'GBK'");
$query=$_POST["sqlstat"];
if(empty($query))die("statement error!");
$result=mysql_query($query)
or die("Query failed:".mysql_error()); //执行语句
print "Query successfully!\n";
if($result===TRUE) //无返回记录指令
echo "Execute susccessfully!\n";
else{
echo "
\n\t\n\t\t";
$i=0;
while($i < mysql_num_fields($result)){ //处理属性名
$meta=mysql_fetch_field($result);
if($meta)
echo "| ".$meta->name." | ";
$i++;
}
echo "\n\t
\n";
while($row=mysql_fetch_row($result)){ //处理数据
echo "\t\n\t\t";
foreach($row as $col_value)
echo "| $col_value | ";
echo "\n\t
\n";
}
}
}
?>