PHP绑定通配符 [英] PHP Binding a Wildcard

问题描述

希望当有人需要在变量值旁边使用多字符通配符时，有人会为我提供有关如何在mysqli中绑定参数的帮助.我发现它在创建SQL语句时对我有用，像这样:

Hope Somebody will help me about how I bind a parameter in mysqli when a multiple character wildcard needs to be next to the variable value. I found that it worked for me when creating a SQL statement, like this:

$sql = "SELECT item_title FROM item WHERE item_title LIKE '%$title%'";

但是，我试图按照相同的模式绑定变量，但发现它失败了.他们使用了以下代码:

However, I tried to bind the variable following the same pattern, and found that it failed. They used this code:

$sql = "SELECT item_title FROM item WHERE item_title LIKE '%?%'";

它引发了此错误:

警告:mysqli_stmt_bind_param()[function.mysqli-stmt-bind-param]: 变量数量与准备好的参数数量不匹配 在program_name中的语句在线上……

Warning: mysqli_stmt_bind_param() [function.mysqli-stmt-bind-param]: Number of variables doesn't match number of parameters in prepared statement in program_name on line......

有人可以告诉我如何解决此问题吗? 谢谢你.

Can anybody tell me how fix this problem? Thank you.

推荐答案

您只能绑定数据文字，而不能绑定任意查询部分.
因此，请先准备好文字

You can bind only data literals not arbitrary query parts.
So, prepare your literal first

$var = "%$var%";
$sql = "SELECT item_title FROM item WHERE item_title LIKE ?";

这篇关于PHP绑定通配符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！