abstract：<?phpnamespace app\index\controller;use think\Db;use PDO;class Index{    //查詢    public function index()    {    $res = Db::table('class')->field

<?php

namespace app\index\controller;

use think\Db;

use PDO;

class Index

{

    //查詢

    public function index()

    {

    $res = Db::table('class')->field('r_id,r_name,r_fen')->where('p_id','=',2)->order('r_fen','desc')->limit(3)->select();

    // ->where('r_fen','<',90)

    var_dump($res);

    }

    //添加

    public function insert()

    {

    $data = [

    ['r_name'=>'aaaa',

    'r_city'=>'1111a',

    'r_fen'=>'78',

    'p_id'=>2],

    ['r_name'=>'aaaa',

    'r_city'=>'1111a',

    'r_fen'=>'78',

    'p_id'=>2],

    ['r_name'=>'aaaa',

    'r_city'=>'1111a',

    'r_fen'=>'78',

    'p_id'=>2]

    ];

    dump($data);

    $res = Db::table('class')->data($data)->insertAll();

    // $id = Db::getLastInsID();

    return "添加".$res;

    }

    //刪除

    public function dle()

    {

    $id = 14;

    Db::table('class')->delete($id);

    }

    //修改

    public function upl()

    {

    Db::table('class')->where('r_id',1)->data(['r_name'=>'楊俊杰','r_fen'=>100])->update();

    }

}

Correcting teacher：西門大官人Correction time：2019-05-05 10:32:32
Teacher's summary：insert()和insertAll()方法的區(qū)別是什么？