Symfony2(doctrine2)native sql insert [英] Symfony2 (doctrine2) native sql insert
本文介绍了Symfony2(doctrine2)native sql insert的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在本机sql中插入symfony2 doctrine2中的数据?
How to insert data in symfony2 doctrine2 on native sql?
我的查询
insert into propriedades (id,name,descripcion,num_lote,cod_imovel,imovel,convenio,proprietar,cpf,area_ha,perimetro,location,centro) VALUES (nextval('propriedades_id_seq'),'?','?','?','?','?','?','?','?','?','?',ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>".$terra['coordinates']."</coordinates></LinearRing></outerBoundaryIs></Polygon>'),ST_Centroid(ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>".$terra['coordinates']."</coordinates></LinearRing></outerBoundaryIs></Polygon>')))
推荐答案
你必须使用 $ conn-> insert(' table',$ dataArray);
。请参阅文档
这篇关于Symfony2(doctrine2)native sql insert的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文