Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_REQUEST['query'])) {
- $query = $_REQUEST['query'];
- $sql = mysqli_query ($db, "SELECT a, b FROM table WHERE a LIKE '%{$query}%' OR b LIKE '%{$query}%'");
- $array = array();
- while ($row = mysqli_fetch_assoc($sql)) {
- $array[] = array (
- 'label' => $row['a'].', '.$row['b'],
- 'value' => $row['a'],
- );
- }
- //RETURN JSON ARRAY
- echo json_encode ($array);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement