php显示TABLE数据

最新推荐文章于 2024-01-07 16:02:23 发布

judyge

最新推荐文章于 2024-01-07 16:02:23 发布

阅读量1.7k

点赞数

分类专栏： js与前端

js与前端专栏收录该内容

863 篇文章 6 订阅

订阅专栏

 
        //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#