實(shí)現(xiàn)更新，刪除，插入操作的鏈?zhǔn)秸{(diào)用

data方法

    public function Data($Data){
         $str = '';
        if (count($Data) > 0) {
            foreach ($Data as $k => $v) {
                $str .= ' , ' . $k . '= "' . $v.'"';
            }
            $str = substr($str, 2);
        }
        $this->opts['Data'] = " $str";
         return $this;
    }

更新

   public function update()
    {
        $sql = 'UPDATE ' .$this->table .' SET ';
        $sql .= $this->opts['Data']??null;
        $sql .= $this->opts['where']??die('禁止無條件刪除');
        $stmt = $this->db->prepare($sql);
        $res = $stmt->execute();
        return $stmt->rowCount();
    }

刪除

    public function delete()
    {
        $sql = 'DELETE FROM '.$this->table;
        $sql .= $this->opts['where']??die('禁止無條件刪除');
        $stmt = $this->db->prepare($sql);
        $stmt->execute();
       return $stmt->rowCount();
    }

插入

    public function insert()
    {
        $sql = 'INSERT '.$this->table.' SET ';
        $sql .= $this->opts['Data'];
        $stmt = $this->db->prepare($sql);
        $stmt->execute();
       return $stmt->rowCount();
    }

客戶端調(diào)用代碼

echo Db::table('T_product')
    ->where(['id'=>1])
    ->Data(['proname'=>'空調(diào)','description'=>'格力空調(diào)'])
    ->update();
echo Db::table('T_product')
    ->where(['id'=>10])
    ->delete();
echo Db::table('T_product')
    ->Data(['proid'=>'120058','proname'=>'平板','price'=>9988,'description'=>'平板2'])
    ->insert();

批改老師：PHPz

批改狀態(tài)：合格

老師批語：