MySQL简单增删改查


前台页面例如


<form action="sql.php?action=insert" method="post">
  <input type="text" name="name" />
  <input type="text" name="pwd" />
  <input type="submit" value="Submit" />
</form>

后台操作


$action = $_GET['action']; //操作
switch = ('action'){
    case "select":
        $mysql = new pass();
        $mysqli=$mysql->db();
        $res = array();
        $hasList = false;
        $sql_select = "select id,name from user";
        if($result = $mysqli -> query($sql_select )){
            while($row = $result -> fetch_assoc()){
                $res[] = $row;
            }
            $result -> close();
        }
        if(!empty($res)){
            $hasList = true;
        }
        $arr = array(
                'code' => 1,
                'hasList' => $hasList,
                'count' => "5",
                'data' => $res,
            );
        echo json_encode($arr);
    break;

    case "insert":
        $mysql = new pass();
        $mysqli=$mysql->db();
        $res = array();
        $hasList = false;
        $sql_insert = "insert into user (name , pwd) values ('aidis' , '123')";
        if($mysqli -> query($sql_insert ) === true){
            echo = 1;
        }else{
            echo = 0;
        }
        $result -> close();
    break;

    case "update":
        $mysql = new pass();
        $mysqli=$mysql->db();
        $arr = $_POST;
        $id = $arr['id'];
        $name = $arr['name'];
        $pwd = $arr['pwd'];
        $sql_update = "update user set name = '$name' , pwd = '$pwd' where id = $id";
        if($mysqli -> query($sql_update ) === true){
            echo = 1;
        }else{
            echo = 0;
        }
        $result -> close();
    break;

    case "delete":
        $mysql = new pass();
        $mysqli=$mysql->db();
        $id = $_GET['id'];
        $sql_delete = "delete from user where id = $id";
        if($mysqli -> query($sql_delete ) === true){
            echo = 1;
        }else{
            echo = 0;
        }
        $result -> close();
    break;

}
class pass{
    function dbset(){
        $host='localhost';
        $user='root';
        $pass='password';
        $dbname='dbname';
        $mysqli=new mysqli($host,$user,$pass,$dbname);
        $mysqli->query('set names utf8');
        if ($mysqli->connect_errno) {
            printf("Connect failed: %s\n", $mysqli->connect_error);
            exit();
        }
        return $mysqli;
    }
    function db(){
        $mysqli=$this->dbset();
        return $mysqli;
    }
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值