for me this condition is not working . query is working when iam passing single id ,if i pass multiple id’s the data is getting only first id i selected
if (($ProjectId) && $KeyStatusId==’’ && $IssuedTo==’’ && $from==’’ && $to==’’){
$stmt = $this->conn->prepare(“SELECT KeyId
, Name
, KeyTypeId
, KeyType
, ProjectId
, Project
, KeyStatusId
, KeyStatus
, IssuedTo
, IssuedToId
, IssueDate
, ReturnedTo
, ReturnedToId
, Returndate
, Logdate
, PurposeId
, Purpose
, Description
, UserId
, User
, HookNo
, Key1
, Key2
, Key3
, Key4
, Key5
, Key6
, Key7
, Key8
, Key9
, Key10
, Key11
, Key12
, LogTime
, LogUserId
, Loguser
, SetNo
, Property
, KeysNO
, Active
, status
, CallId
, update_time
FROM keymaster
WHERE ProjectId
IN (?)”) or trigger_error($stmt->error, E_USER_ERROR);
$stmt->bind_param(“s”,($ProjectId)) or trigger_error($stmt->error, E_USER_ERROR);
$stmt->execute();
}
Try with bindValue.
$stmt->bindValue(‘?’, $ProjectId);
http://php.net/manual/en/pdostatement.bindvalue.php
You are binding to “s” something that is into round brackets, this will never work.