PHP 之Mysql增删改查操作案例

时间：2021-11-28 03:43:08

1：user表：

CREATE TABLE `user` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(32) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

2：mysqltools.php　　(mysql工具类)

<?php

    class MySqlTools{

    private $host='127.0.0.1';

    private $uname='root';

    private $pwd='mysql';

    private $dbname='test';

    private $conn;

    function __construct(){

        $this->conn=mysql_connect($this->host,$this->uname,$this->pwd)

        or die('mysql_connect error:'.mysql_error());

        mysql_select_db($this->dbname)

        or die('mysql_select_db error:'.mysql_error());

        mysql_query("set names 'utf8'");

    }    

    function exec_dql($sql){

        $result=mysql_query($sql,$this->conn);

        $arr=array();

        while($row=mysql_fetch_assoc($result)){

        $arr[]=$row;

        }

        mysql_free_result($result);

        return $arr;

    }

    function exec_dml($sql){

        return mysql_query($sql,$this->conn);

    }

    function free(){

        mysql_close($this->conn);

    }

    }

?>

3:index.php　　(首页)

PHP 之Mysql增删改查操作案例

<html>

    <head>

    <title>Index</title>

    </head>

    <body>

    <?php

        require_once 'mysqltools.php';

        $mysql=new MySqlTools();

        $sql='select id,name from user';

        $users=$mysql->exec_dql($sql);

    ?>

    <table style="width:50%;">

        <tr>

        <th>ID</th>

        <th>Name</th>

        <th>Oper</th>

        </tr>

        <?php

        foreach($users as $user){

        ?>

        <tr align="center">

        <td><?php echo $user['id'];?></td>

        <td><?php echo $user['name'];?></td>

        <td>

            <a href="show.php?id=<?php echo $user['id'];?>">详情</a>

            <a href="delete.php?id=<?php echo $user['id'];?>">删除</a>

        </td>

        </tr>

        <?php }?>

    </table>

    <hr/>

    <h2><a href="add.php">Add a new user</a></h2>

    </body>

</html>

4:add.php　　（增加新用户）

PHP 之Mysql增删改查操作案例

<html>

    <head>

    <title>Add</title>

    <meta http-equiv="content-type" content="text/html;charset=utf-8"/>

    </head>

    <body>

    <h1>Add</h1><a href="index.php">Index</a><br/>

    <?php

        if(!empty($_POST['uname'])){

        $name=$_POST['uname'];

        require_once 'mysqltools.php';

        $sql="insert into user(name) values('$name')";

        $mysql=new MySqlTools();

        if($mysql->exec_dml($sql)){

            echo '<h3>Add Success!</h3>';

        }else{

            echo '<h3>Add Error!</h3>';

        }

        }

    ?>

    <form method="post">

        Name:<input type="text" name="uname"/>

        <input type="submit" value="Add"/>

    </form>

    </body>

</html>

5:delete.php　　(删除操作)

<?php

    $id=$_GET['id'];

    if(isset($id)){

    require_once 'mysqltools.php';

    $mysql=new MySqlTools();

    $sql="delete from user where id=$id";

    $mysql->exec_dml($sql);

    }

    header('Location: index.php');

?>

6：show.php　　(显示详细信息页面)

PHP 之Mysql增删改查操作案例

<?php

    header('Conent-Type:text/html;charset=utf-8');

    $id=$_GET['id'];

    $name='';

    if(isset($id)){

    require_once 'mysqltools.php';

    $mysql=new MySqlTools();

    $sql="select name from user where id=$id limit 1";

    $arr=$mysql->exec_dql($sql);

    $name=$arr[0]['name'];

    }

    echo "ID:$id<br/>Name:$name<br/>";

    echo '<h3><a href="index.php">Index</a></h3>';

?>

相关文章