Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php function search($criteria) { $sql = "SELECT * FROM my_table WHERE column_1 like :criteria1, OR column_2 like :criteria2, OR column_3 like :criteria3 "; $criteria = "%$criteria%"; $stmt = $this->db->prepare($sql); $stmt->bindParam(':criteria1', $criteria); $stmt->bindParam(':criteria2', $criteria); $stmt->bindParam(':criteria3', $criteria); $stmt->execute(); return($stmt->fetchAll(PDO::FETCH_ASSOC)); }
Copy Clear