如何将项数组转换为其核心条件id数组 - How to convert an array of items to their coressponding array of id

How to convert an array of items to their coressponding array of id

本文关键字：数组核心条件 id 转换 | 更新日期: 2023-09-27

我的MySQL数据库中有一个表，其中包含以下成分：

id ingredient
1   egg
2   peanut
3  treenut
4   oil

现在我有一个数组作为配料=[花生，油，鸡蛋]

我必须将此数组转换为id的相应数组，如下所示：

成分=[2,4,1]有人能帮忙吗？？

提前感谢。。。

$ingridents = array("peanut", "oil", "eg");
$newArray = array();
$result = mysqli_query($link, "SELECT id, ingrident FROM ingridents WHERE ingrident IN (".implode(",", $ingridents).")");
while($row = mysqli_fetch_assoc($result) {
    $newArray[$row['ingrident']] = $row['id'];
}
echo $newArray['peanut']; // would echo out the ID of peanut

试试这个。。。

$ingredients = array("peanut", "oil", "egg");
$ingredients = "'".implode("','", $ingredients)."'";
$query = mysqli_query($link, "SELECT id, ingredient FROM table WHERE ingredient IN ($ingredients)");
while($row = mysqli_fetch_assoc($query) {
    $ingredient_ids[] = $row['id'];
}