php把接收的参数循环输出拼接成mysql查询条件语句
2024-05-10 Umming PHP学习 评论(0) 浏览(1530)
<?php
function buildSqlCondition($params) {
$condition = "";
foreach ($params as $key => $value) {
if (is_array($value)) {
foreach ($value as $item) {
$condition.= " $key = '$item' OR";
}
} else {
$condition.= " $key = '$value' AND";
}
}
// 去掉最后多余的 "OR" 或 "AND"
$condition = rtrim($condition, " OR");
$condition = rtrim($condition, " AND");
return $condition;
}
// 示例用法
$parameters = [
'special' => ["FRD", "G3"],
'vthMax' => ["3.9", "4.5"],
'vthMin' => ["2.0", "2.9", "3.0"]
];
echo buildSqlCondition($parameters);
?> 标签: php
本文链接:https://www.umming.com/php/325.html
声明:本站信息由网友自行发布或来源于网络,真实性、合法性由发布人负责,请仔细甄别!本站只为传递信息,我们不做任何双方证明,也不承担任何法律责任。文章内容若侵犯你的权益,请联系本站删除!
也许你还会对下面的内容感兴趣:
发表评论: