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>
some picture of the table :
the display of the result on the web
good good study DDup~~~
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
