当我通过api检索数据时,我得到了2147483647,尽管我已经以字符串列类型创建了该列。在表中,它成功地存储了989547***。
迁移:
$table->string('source_number',10)->unique();
控制器:
public function getSourceNumberSmsTemplate(Request $request){
$detail=$request->all();
if(empty($detail['source_number']) || !array_key_exists('source_number',$detail)){
return Response::json([
'message' => "Missing Parameters. Please recheck submitted data"], 422);
}
$template= smstemplate::find($detail['source_number']);
return Response::json([
$detail['source_number']=>$template], 200);
}
Api结果:
{
"id": 1,
"user_id": 1,
"source_number": 2147483647,
}
尝试查询生成器:
use IlluminateSupportFacadesDB;
$template = DB::table('sms_templates')
->where('source_number', '=' , $request->source_number)
->get();
尝试将其转换为模型中的bigint或字符串,默认情况下它是一个整数'
//像低于
protected $keyType = 'bigint';