php 显示数据表记录

rorely

浏览: 119768 次
性别:
来自: 北京

最近访客更多访客>>

fft1987

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

PHP MySQL HTML

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#

分享到：

sql 建立数据库 | php 删除数据库表中的记录

2009-07-01 15:51
浏览 794
评论(0)
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论