//插入
public function query1()
{
// $bool=DB::table('test')->insert([
// ['name'=>'james','age'=>'32'],
// ['name'=>'wade','age'=>'34']
// ]);
// var_dump($bool);
$test = Test::create(
['name' => 'antony', 'age' => '33']
);
dd($test);
}
//删除
public function query2()
{
// $test = DB::table('test')->where('id','1004')->delete();
// $test = Test::find(1006)->delete();
$row = Test::where('name','antony')->delete();
var_dump($row);
}
//修改
public function query3(){
// $test = DB::table('test')->where('id','1003')->update(['age'=>'30']);
$test = Test::where('id','1003')->update(['age'=>'31']);
var_dump($test);
}
//查
public function query4(){
// $test = DB::table('test')->get();
// $test = DB::table('test')->where('id','>','1001')->first();
// $test = DB::table('test')->where('id','>','1001')->value('name');
// $test = Test::all();
// $test = Test::where('id','>','1001')->first();
$test = Test::where('id','>','1002')->value('name');
dd($test);
}
