我有我的数据库中的所有城市列表,我想我的用户选择他们的城市时,注册的列表很长,页面加载也
在我的FormType上,我有这个:
->add('city', EntityType::class, [
'class' => City::class,
])下面是get the City as JsonResponse:
/**
* @Route("/citySearch/{_query?}", name="handle_search", methods={"POST", "GET"})
*/
public function handleSearchRequest(Request $request, $_query)
{
$em = $this->getDoctrine()->getManager();
if ($_query)
{
$data = $em->getRepository(City::class)->findByCiTy($_query);
}
$resultlist = [];
foreach ($data as $d){
array_push($resultlist, $d->getNom());
}
$resultlist = [];
foreach ($data as $d){
array_push($resultlist, $d->getNom());
}
$list[] = [
'options' => $resultlist,
];
return new JsonResponse($list);
}请问用户选择城市的最优化和最快捷的方式是什么?
发布于 2021-02-16 09:44:19
您可以使用分页库进行小批量退货示例链接:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.8/tutorials/pagination.html
或者,您可以在数据库中使用视图
https://stackoverflow.com/questions/66212968
复制相似问题