PHP : how to use mysql prepare statement inside single quote

Question

在我的 PHP 项目中，我想制作准备语句来插入点。我是休闲做的

$query = "update d_location set dl_location = GeomFromText('POINT(:lat :lon)') where dl_id = :id";
            echo $query;
            $stmt = $conn->prepare($query);
            $params = array(
                        'lat'=>$lat,
                        'lon'=>$lon,
                        'id'=>$d_id
                    );
            $stmt->execute($params);

但它显示以下错误消息

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

这里有什么问题吗？ dl_location 数据类型为 GEOMETRY

Answer 1

它的工作原理是这样的。

$location = 'POINT(' . $lat . " " . $lon . ')';
            $query = "update d_location set dl_location = GeomFromText(:location) where dl_id = :id";
            $stmt = $conn->prepare($query);
            $params = array(
                        'location'=>$location,
                        'id'=>$d_id
                    );
            $stmt->execute($params);