湖濱散記部落格的樹心幽徑[<a href=login.php>login</a>][<a href= . >主頁</a>]<hr>
455:20181224設計PHP函數dumpTable來列出selldb資料庫的custs資料表的全部資料錄(a3.php)<br><table width=800 border=8><tr><td bgcolor=cyan><p>(1) code&nbsp;</p>
<p>&nbsp;</p>
<p>&lt;body background=dog.png&gt;<br />&lt;?phpfunction dumpTable($table,$con,$bgcolor){&nbsp; &nbsp; $sql= "select * from $table";&nbsp; &nbsp; if( $query= mysqli_query($con, $sql) ){ echo " $sql OK!&lt;br&gt; "; }&nbsp;&nbsp; &nbsp; else { echo " $sql Failure!&lt;br&gt; "; }&nbsp;&nbsp; &nbsp; echo "&lt;table bgcolor=$bgcolor border=3&gt;";&nbsp; &nbsp; echo "&lt;tr&gt;";&nbsp; &nbsp; $fc= mysqli_num_fields($query) ;&nbsp; &nbsp; while ($field = mysqli_fetch_field($query)){&nbsp; &nbsp; &nbsp; &nbsp; printf("&lt;td&gt;%s", $field-&gt;name);&nbsp; &nbsp; }&nbsp; &nbsp; $rowc=0;&nbsp; &nbsp; while ($row = mysqli_fetch_array($query)){&nbsp; &nbsp; &nbsp; &nbsp; echo "&lt;tr&gt;";&nbsp; &nbsp; &nbsp; &nbsp; for ($i=0;$i&lt;$fc;$i++){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; "&lt;td&gt;" . $row[$i];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $rowc++;&nbsp; &nbsp; }&nbsp; &nbsp; echo "&lt;/table&gt;";&nbsp; &nbsp; echo "資料表 $table 共計有 $rowc 筆資料。&lt;br&gt;&lt;br&gt;";}<br />$con = mysqli_connect('127.0.0.1', 'root', 'w1xxxx???', 'selldb');if (!$con) { echo "Error"; exit(); }dumpTable("custs",$con,"red");dumpTable("custs",$con,"pink");dumpTable("custs",$con,"purple");<br />mysqli_close ($con);?&gt;&lt;/body&gt;</p>
<p>(2)result</p>
<p><span>select * from custs OK!</span></p>
<table border="3" bgcolor="red">
<tbody>
<tr>
<td>id</td>
<td>name</td>
<td>amount</td>
<td>tel</td>
</tr>
<tr>
<td>10001</td>
<td>小草</td>
<td>1000</td>
<td>08-233375</td>
</tr>
<tr>
<td>10002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>20002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>30002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
</tbody>
</table>
<p><span>資料表 custs 共計有 4 筆資料。</span><br /><br /><span>select * from custs OK!</span></p>
<table border="3" bgcolor="pink">
<tbody>
<tr>
<td>id</td>
<td>name</td>
<td>amount</td>
<td>tel</td>
</tr>
<tr>
<td>10001</td>
<td>小草</td>
<td>1000</td>
<td>08-233375</td>
</tr>
<tr>
<td>10002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>20002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>30002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
</tbody>
</table>
<p><span>資料表 custs 共計有 4 筆資料。</span><br /><br /><span>select * from custs OK!</span></p>
<table border="3" bgcolor="purple">
<tbody>
<tr>
<td>id</td>
<td>name</td>
<td>amount</td>
<td>tel</td>
</tr>
<tr>
<td>10001</td>
<td>小草</td>
<td>1000</td>
<td>08-233375</td>
</tr>
<tr>
<td>10002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>20002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
<tr>
<td>30002</td>
<td>天牛</td>
<td>3000</td>
<td>03-933375</td>
</tr>
</tbody>
</table>
<p><span>資料表 custs 共計有 4 筆資料。</span><br /><br /></p>
<p>&nbsp;</p></table><br> select id,article_id,topic,text from lt_articles_text where article_id =455; ok.
update lt_articles set num_reads=num_reads +1 where id=455; ok.