the program:
<html>
<head>
<title>MyFirstTestInPhpLinkMySql</title>
</head>
<body>
<H1>o(-)_(-)o,我的php代码第一次连接MySql</H1>
<?php
$connect =@mysql_connect('localhost','root',"") or die('Unable to connect database server');
mysql_select_db('test') or die('Unable to connect database server');
$query ='SELECT * FROM friends';
$result = mysql_query($query);
if(mysql_error())
{
echo "ERROR:".mysql_error()." ".mysql_error();
}
else
{
$rowno =mysql_num_rows($result);
if(!$rowno)
{
echo "<front color =red>对不起,没有找到记录!</front>";
}
else
{
$fieldno=mysql_num_fields($result);
$tbname=mysql_field_table($result,0);
mysql_data_seek($result,0);
echo "我现在有".$rowno."个朋友记录在库";
echo "<table border=1 bgcolor=grey>";
echo "<caption>$tbname</caption>";
//echo "<th>";
echo "<tr>";
for($i=0;$i<$fieldno;$i++)
{
echo "<th>".mysql_field_name($result,$i)."</th>";
}
echo "</tr>\n";//一行一行的来
echo "</th>";
echo "<tbody>";
while($row=mysql_fetch_row($result))
{
echo "<tr>";
for($i=0;$i<$fieldno;$i++)
{
echo "<td>$row[$i]</td>";//td是表格标准单元格
}
echo "</tr>";
}
echo "</tbody>";
}
}
?>
<H1>测试</H1>
</body>
</html>
the display of the result on the web
good good study DDup~~~