创建一系列与结果同样的查询,但有不同的id[重复]

0

的问题

我下面阵列:

$ids = (1,2,3,4,5);

我需要做的下查询

SELECT name, last_name, age FROM users WHERE id_user = $id

在"在那里",我需要提供阵列中的id去咨询一个接一个,如果存在该信息创建一系列的结果表

$ users = ([1 =>
                "name" => "xxxx",
                "last_name =>" yyyy ",
                "age" => 20
           ],
           [2 =>
                "name" => "xxxx",
                "last_name =>" yyyy ",
                 "age" => 25
           ]
etc etc....

数id可以改变

我怎么可能创建这一系列的查询结果取决于id?

对不起,我的英语,谢谢你们都非常多。

arrays php sql
2021-11-24 02:26:19
1

最好的答案

-1

如果我得到了你的问题是否正确,我认为你需要的是在阵查询。

SELECT name, last_name, age FROM users WHERE id IN $ids;

2021-11-24 02:33:17

...在(第1、2、3、4)
sukalogika

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................