我试图根据它得到的信息创建一个动态查询。
当$query2为例如:'type' => 'PvP', 'online' => 'Premium'
和$query是:SELECT * FROM disserveur WHERE type =:type And online =:online
正在工作,
$req = $bdd->prepare("$query");
$req->execute(array('type' => 'PvP', 'online' => 'Premium'));
但是当我在执行中使用$query2变量时,它不起作用。
$req = $bdd->prepare("$query"); //C
$req->execute(array($query2));
每次都得到相同的错误。
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
这是代码
unset($sql);
unset($sql2);
if (isset($type2) AND $type2 != "all") {
$sql[] = " type = :type ";
$sql2[] = " 'type' => '$type2'";
}
if (isset($online2) AND $online2 != "all") {
$sql[] = " online = :online ";
$sql2[] = " 'online' => '$online2'";
}
if (isset($version2) AND $version2 != "all") {
$sql[] = " version LIKE :version ";
$sql2[] = " 'version' => %$version2%";
}
$query = "SELECT * FROM dispserveur";
if (!empty($sql)) {
$query .= ' WHERE ' . implode(' AND ', $sql);
}
if (!empty($sql2)) {
$query2 = implode(', ', $sql2);
}
echo $query;
echo "<br />";
echo $query2;
$req = $bdd->prepare("$query"); //C
$req->execute(array($query2));
while ($red = $req->fetch())
{echo "$red[ip]<br />";}
感谢您的帮助
execute()
的参数必须是一个键与:paramName
匹配的关联数组。相反,你使用的$query2
只是一个字符串。这就是为什么你的代码不能工作。
改变:
$sql2[] = " 'type' => '$type2'";
$sql2[] = " 'online' => '$online2'";
$sql2[] = " 'version' => %$version2%";
:
$sql2['type']=$type2;
$sql2['online']=>$online2;
$sql2['version']=>"%$version2%";
之后,修改
$req->execute(array($query2));
$req->execute($sql2);
甜菜汁的方法是正确的,但它不是
美元申请→执行(数组(query2美元));
美元申请→执行(数组(sql2美元));
,
$req->execute(array($query2));
to
$req->execute($sql2);
谢谢你的快速回答:)