laravel框架增删改查基础

model层

protected $table="score";
public $timestamps = false;//要放这个，不然报错Column not found: 1054 Unknown column 'updated_at' in 'field list'

public static function alllist(){
    return self::get();
}
public static function add($arr){
    return self::insert($arr);
}
public static function delete1($id){
    return self::where('id',$id)->delete();
}
public static function update1($id,$arr){
    return self::where('id',$id)->update($arr);
}
controller层

public function alllist(){
    $data=\App\score::alllist();
    return ["code"=>0,"msg"=>"sdadad","data"=>$data];
}
public function add(Request $request){
    $arr['cid']=$request['cid'];
    $arr['sid']=$request['sid'];
    $arr['score']=$request['score'];
    $res=\App\score::add($arr);
    if($res){
        return "添加成功";
    }else{
        return "失败";
    }
}
public function delete1(Request $request){
    $id=$request['id'];
    $res=\App\score::delete1($id);
    if($res){
        return "删除成功";
    }else{
        return "失败";
    }
}
public function update1(Request $request){
    $arr['cid']=$request['cid'];
    $arr['sid']=$request['sid'];
    $arr['score']=$request['score'];
    $id=$request['id'];
    $res=\App\score::update1($id,$arr);
    if($res){
        return "更新成功";
    }else{
        return "失败";
    }
}
web.php

Route::get("list","score@alllist");
Route::post('add','score@add');
Route::get('delete','score@delete1');
Route::get('update','score@update1');