问题遇到的现象和发生背景
数据库CRUD接口测试报错,不知道报错原因,使用的是PHP Laravell框架书写的api接口
用代码块功能插入代码,请勿粘贴截图
model层代码
namespace App\model;
use Illuminate\Database\Eloquent\Model;
class crud extends Model
{
protected $table="count";
protected $primaryKey="id";
public $timestamps = true;
protected $guarded = [];
public static function Find($id)
{
try{
$res =self::select('*')->where('id', $id)->get();
return $res;
}catch (\Exception $exception){
echo $exception->getMessage();
return false;
}
}
public static function Insert($name,$id)
{
try{
$res =self::create([
'name' =>$name,
'id' =>$id
]
);
return $res;
}catch (\Exception $exception){
echo $exception->getMessage();
return false;
}
}
public static function remove($id)
{
try{
$res =self::where('id', $id)->delete();
return $res;
}catch (\Exception $exception){
echo $exception->getMessage();
return false;
}
}
public static function upda($name,$id)
{
try{
$res =self::where('id', $id)->update(
[
'name'=>$name,
'id'=>$id
]
);
return $res;
}catch (\Exception $exception){
echo $exception->getMessage();
return false;
}
}
}
URL
Route::get("check", "TestController@Check");
Route::get("insert", "TestController@ins");
Route::get("delete", "TestController@dele");
Route::get("update", "TestController@updat");
Controller
namespace App\Http\Controllers;
use App\crud;
use Illuminate\Http\Request;
class TestController extends Controller
{
/**
* 查询数据库
*/
public function Check(Request $request){
$id = $request['id']; //获取表单数据id
$res=crud::Find($id);
return $res?
response()-> json(array('msg'=>'成功','data'=>$res),200):
response()-> json(array('msg'=>'失败','data'=>null),100);
}
public function ins(Request $request){
$name = $request['name'];
$id = $request['id'];
$res=crud::Insert($name,$id);
return $res?
response()-> json(array('msg'=>'成功','data'=>$res),200):
response()-> json(array('msg'=>'失败','data'=>null),100);
}
public function dele(Request $request){
$id = $request['id'];
$res=crud::remove($id);
return $res?
response()-> json(array('msg'=>'成功','data'=>$res),200):
response()-> json(array('msg'=>'失败','data'=>null),100);
}
public function updat(Request $request){
$name = $request['name'];
$id = $request['id'];
$res=crud::upda($name,$id);
return $res?
response()-> json(array('msg'=>'成功','data'=>$res),200):
response()-> json(array('msg'=>'失败','data'=>null),100);
}
}
运行结果及报错内容
**
apifox中报错内容**