php 原生pdo操作sql

1、新建db.

<?php
//sql
class db{
    public $localhost = '127.0.0.1';
    public $db_name = 'easyswoole_orm';
    public $user_name = 'easyswoole_orm';
    public $pass_word = 'iaPrA78EmEx6kAEC';
    function dadequery($sql){
        $db = new PDO("mysql:host={$this->localhost};dbname={$this->db_name}", $this->user_name, $this->pass_word,array(PDO::MYSQL_ATTR_INIT_COMMAND=>"set names utf8"));
        $sth = $db->query($sql);
        $data = $sth->fetchAll(PDO::FETCH_ASSOC);
        $db = null;
        $sth = null;
        return $data;
    }
    function update($sql){
        $db = new PDO("mysql:host={$this->localhost};dbname={$this->db_name}", $this->user_name, $this->pass_word,array(PDO::MYSQL_ATTR_INIT_COMMAND=>"set names utf8"));
        $date = $db->exec($sql);
        $db = null;
        return $date;
    }
}

2、引入使用

<?php

require_once 'db.php';

$db=new db();
//$dade = $db->dadequery("select * from dade_user");

$dade = $db->update("UPDATE dade_user SET shop_id = 100 WHERE `id`=100");

print_r(json_encode($dade));die;