[1002] PHP入門班
<?php
error_reporting(0);
$link=@mysql_connect("localhost" , "tad0616" ,"12345");
if(!$link) echo "資料庫連不上!";
//設定使用UTF8編碼
mysql_query("SET NAMES 'utf8'");
//選擇資料庫
mysql_select_db('tad0616');
//設定SQL語法
$sql="select * from tncomu_class";
//執行SQL語法
$result = mysql_query($sql) or die("無法執行:".mysql_error());
$main="<table border=1>";
while($data=mysql_fetch_assoc($result)){
$main.="
<tr>
<td>{$data['class_sn']}</td>
<td>{$data['seme']}</td>
<td>{$data['subject']}</td>
<td>{$data['class_name']}</td>
<td>{$data['teacher']}</td>
<td>{$data['passwd']}</td>
<td>{$data['access']}</td>
</tr>";
}
$main.="</table>";
echo $main;
//mysq_fetch_row()
//mysq_fetch_array()
?>