CREATE TABLE `address` (
`id` int(11) NOT NULL,
`name` varchar(250) NOT NULL,
`zuibiao` point NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `address`(`id`, `name`, `zuibiao`) VALUES (null,'测试',ST_GeomFromText('POINT(1.0 2.0)'))
yii2中model的写法不知要怎样写?
$model = new Address();
if ($model->load(Yii::$app->request->post()) ) {
$long=1.0;
$lat=1.2;
$model->zuibiao=new Expression("ST_GeomFromText('POINT($long $lat)')");
}
$model->save();
这样写程序不报错,但是数据表里没数据。