Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_GET['term'])){
- $return_arr = array();
- try {
- $conn = new PDO("mysql:host=".DB_SERVER.";dbname=".DB_NAME, DB_USER, DB_PASSWORD);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $terms = ($_GET['term']);
- function isUTF8($terms) {
- return (utf8_encode(utf8_decode($terms)) == $terms);
- }
- $searchTerms = explode(' ',$terms);
- $searchTermBits = array();
- foreach ($searchTerms as $term) {
- $term = trim($term);
- if (!empty($term)) {
- $searchTermBits[] = "docType RLIKE '.$term.' OR docTitle RLIKE '.$term.'";
- }
- }
- $stmt = $conn->prepare('SELECT * FROM openDocs WHERE '.implode(' AND ', $searchTermBits).' LIMIT 50');
- $stmt->execute(array('term' => '%'.$_GET['term'].'%'));
- while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
- $return_arr[] = $row;
- }
- } catch(PDOException $e) {
- echo 'ERROR: ' . $e->getMessage();
- }
- echo json_encode($return_arr);}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement