processShowData.php
<html>
<head>
<title>查詢數據庫表信息</title>
</head>
<body>
<center>
<form name="myForm" action="processShowData.php">
<table border="1" cellspacing="0" cellpadding="0">
<caption>學生一覽表</caption>
<th>學號</th>
<th>姓名</th>
<th>年齡</th>
<th>性別</th>
<th>地址</th>
<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("rorely");
$exec="select * from test";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result)){
$id=$rs->id;
$name=$rs->name;
$age=$rs->age;
$sex=$rs->sex;
$address=$rs->address;
?>
<tr align="center">
<td><?php echo $id ?></td>
<td><?php echo $name ?></td>
<td><?php echo $age ?></td>
<td><?php echo $sex ?></td>
<td><?php echo $address ?></td>
</tr>
<?php
}
mysql_close();
?>
</table>
</form>
</center>
</body>
</html>
結果如下：
| 學號 |
姓名 |
年齡 |
性別 |
地址 |
| 1 |
Jane |
26 |
female |
wenming cun 123# |
| 3 |
Tome |
21 |
male |
wenming cun 32# |
| 4 |
Lily |
25 |
female |
wenming cun 2# |
| 5 |
Lucy |
25 |
female |
wenming cun 2# |
| 6 |
Jim |
22 |
male |
wenmin cun 45# |
| 7 |
Jim |
22 |
male |
wenmin cun 45# |
| 8 |
Jim |
22 |
male |
wenmin cun 45# |
| 9 |
Jim |
22 |
male |
wenmin cun 45# |
| 10 |
Jim |
22 |
male |
wenmin cun 45# |
| 11 |
Jim |
22 |
male |
wenmin cun 45# |
| 12 |
Jim |
22 |
male |
wenmin cun 45# |
| 13 |
Jim |
22 |
male |
wenmin cun 45# |
| 14 |
Jim |
22 |
male |
wenmin cun 45# |
| 15 |
Jim |
22 |
male |
wenmin cun 45# |
| 18 |
Jim |
22 |
male |
wenmin cun 45# |
| 20 |
Jim |
22 |
male |
wenmin cun 45# |
| 78 |
lili |
22 |
female |
wenming cun 23# |
| 79 |
hj |
30 |
male |
wenming cun 23# |
| 80 |
hj |
30 |
male |
wenming cun 23# |
posted on 2009-07-01 15:51
期待明天 閱讀(2066)
評論(1) 編輯 收藏 所屬分類:
PHP