添加 OR 参数时"Call to a member function bind_param() on a non-object"

Question

下面是我试图通过php运行的功能，如果我删除了" h = y或？"部分。而只是将其运行为" H =？"它运行得很好。任何帮助弄清楚为什么这不起作用的帮助。

function getInfo($Z)
{
   global $mysqli;
   $stmt = $mysqli->prepare("SELECT A,B,C,D,E,F,G,I,J FROM DB WHERE H=Y OR ?");
   $stmt->bind_param("s", $Z);
   $stmt->execute();
   $stmt->bind_result($A,$B,$C,$D,$E,$F,$G,$I,$J);
   while ($stmt->fetch())
   {
      echo "$A,$B,$C,$D,$E,$F,$G,$I,$Jn";
   }
   $stmt->close();
}

Answer 1

您的意思是它是h = y还是h =？这样：

... FROM DB WHERE (H=Y) OR (H=?)