//基本设定
$mysql_server_name="localhost";
$mysql_username ="saturn";
$mysql_password ="123456";
$mysql_database ="saturn";
$sql = "select * from test";
//基本设定完成
$conn =mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$result=mysql_db_query($mysql_database,$sql,$conn);
$row =mysql_fetch_row($result);
//表格开始
echo "
//显示栏位名称
echo "
\n";for($i=0;$i
{
echo "
" . mysql_field_name($result,$i) ."\n";}
echo "
\n";//将记录指针移动回第一笔
mysql_data_seek($result,0);
//列出记录内容
while($row=mysql_fetch_row($result))
{
echo"
\n";for ($i=0;$i
{
echo "
$row[$i]\n";}
echo "
\n";}
//表格结束
echo"
";mysql_free_result($result);
?>