Laravel 5.1 无法获取刚存入数据库的数据
object表:
CREATE TABLE IF NOT EXISTS `bigdata_db`.`objects` (
`object_id` CHAR(34) NOT NULL,
`object_lt_x` FLOAT NOT NULL,
`object_lt_y` FLOAT NOT NULL,
`object_width` FLOAT NOT NULL,
`object_height` FLOAT NOT NULL,
`image_id` CHAR(34) NOT NULL,
`type_id` CHAR(34) NOT NULL,
PRIMARY KEY (`object_id`),
INDEX `fk_objects_images1_idx` (`image_id` ASC),
INDEX `fk_objects_types1_idx` (`type_id` ASC),
CONSTRAINT `fk_objects_images1`
FOREIGN KEY (`image_id`)
REFERENCES `bigdata_db`.`images` (`image_id`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_objects_types1`
FOREIGN KEY (`type_id`)
REFERENCES `bigdata_db`.`types` (`type_id`)
ON DELETE CASCADE
ON UPDATE CASCADE);
把数据存入数据库的代码:
$obj = new Object;
$obj->object_id = $objectId;
$obj->object_lt_x = $objX;
$obj->object_lt_y = $objY;
$obj->object_width = $objWidth;
$obj->object_height = $objHeight;
$obj->image_id = $imageId;
$obj->type_id = $typeId;
if ($obj->save()) {
$obj_id = $obj->object_id;
$object = DB::table('objects')->where('object_id',$objectId)->get();
$success = array('status' => 1,'message' => $type_name.'标记成功!','obj_id' => $obj_id,'object' => $object);
return response()->json($success);
} else {
$error = array('status' => 0,'message' => $type_name.'标记失败!');
return response()->json($error);
}
在返回的json中发现无法获取到刚刚存进数据库的数据
Object {status: 1, message: "脚标记成功!", obj_id: "A04293C0-6B90-AFF0-1C43-28224E3C29D0", object: Array[0]}
推荐文章: