Advertisement
Guest User

Untitled

a guest
Jul 16th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. I am facing "**number of bound variables does not match number of tokens**" exception while trying to use multiple condition in where clause using PDO.
  2.  
  3. code:
  4. $servername = "localhost";
  5. $username = "xxxx";
  6. $password = "xxxxx";
  7. $dbname = "yyyy";
  8.  
  9. $searchParam = $_POST['typeahead'];
  10. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  11. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  12. $stmt = $conn->prepare("SELECT * FROM trucks WHERE plate_number LIKE :plateNumber OR company_name LIKE: companyName");
  13. $stmt->bindValue(':plateNumber', '%'.$searchParam.'%', PDO::PARAM_INT);
  14. $stmt->bindValue(':companyName', '%'.$searchParam.'%', PDO::PARAM_INT);
  15.  
  16. Thanks for your help!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement