• 页面化操作数据库


    首先默认选择库test1,01.php中然后用show tables;查询出所有的表,然后用循环依次输出所有的表名,和操作超链接,超链接上对应有该表的信息传到02.php,02.php中,根据接收到的参数,查询到该表,然后用desc 表名,结果循环输出表字段名,再查询出所有字段循环输出对应的值,后面有操作超链接,存有该行数据的信息,传到03.php.03.php可以更改

    01.php

    <?php
    $conn=mysql_connect("localhost","root","111111");
    mysql_query("set names utf8",$conn);//设置编码
    mysql_query("use test1");//选库
    $sql="show tables";
    $rs=mysql_query($sql,$conn);
    ?>
    <!doctype html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>列出所有表</title>
    </head>
    <body>
        <table border=1 width=50%>
            <p>所有的表</p>
            <tr>
                <td>表名</td>
                <td>操作</td>
            </tr>
            <?php
                while($row=mysql_fetch_assoc($rs)){
                    echo "<tr>";
                    echo "<td>",$row["Tables_in_test1"],"</td>";
                    echo "<td>","<a href=02.php?table=".$row["Tables_in_test1"].">编辑</a></td>";
                    echo "</tr>";
                }
            ?>
        </table>
    </body>
    </html>
    

     02.php

    <?php
    $conn=mysql_connect("localhost","root","111111");
    mysql_query("set names utf8",$conn);//设置编码
    mysql_query("use test1");//选库
    $table=$_GET['table'];//接收数据
    addslashes($table);
    $sql="select * from ".$table;
    $rs=mysql_query($sql,$conn);
    $sql="desc ".$table;
    $ziduan=mysql_query($sql,$conn);
    ?>
    <!doctype html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>表中所有的数据</title>
    </head>
    <body>
    <table border=1 width="50%">
        <?php
            $i=0;//记录多少字段
            echo "<tr>";
            while($row=mysql_fetch_row($ziduan)){
                echo "<td>",$row[0],"</td>";
                $i++;
            }
            echo "<td>操作</td>";
            echo "</tr>";
            while($row=mysql_fetch_row($rs)){
                echo "<tr>";
                for($a=0;$a<$i;$a++){
                    echo "<td>",$row[$a],"</td>";
                }
                echo "<td><a href=03.php?id=".$row[0].">编辑</a></td>";
                echo "</tr>";
            }
    
        ?>
    </table>
        
    </body>
    </html>
    

     03.php

    待定

  • 相关阅读:
    Gym
    Gym
    Gym
    Gym
    Gym
    bzoj 2734: [HNOI2012]集合选数
    bzoj 1068: [SCOI2007]压缩
    HDU 2899 Strange fuction
    hihocoder #1142 : 三分·三分求极值
    HDU 2824 The Euler function
  • 原文地址:https://www.cnblogs.com/lzzhuany/p/4733145.html
Copyright © 2020-2023  润新知