Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
- code:
- $servername = "localhost";
- $username = "xxxx";
- $password = "xxxxx";
- $dbname = "yyyy";
- $searchParam = $_POST['typeahead'];
- $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $stmt = $conn->prepare("SELECT * FROM trucks WHERE plate_number LIKE :plateNumber OR company_name LIKE: companyName");
- $stmt->bindValue(':plateNumber', '%'.$searchParam.'%', PDO::PARAM_INT);
- $stmt->bindValue(':companyName', '%'.$searchParam.'%', PDO::PARAM_INT);
- Thanks for your help!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement