Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function User_Ajax()
- {
- global $DBH;
- if (isset($_GET['q'])) {
- //$data = array('req' => $_GET['q']);
- $RESULT = $DBH->prepare("SELECT * FROM " . DB_PREFIX . "user WHERE `l_name` like '%" . $_GET['q'] . "%' OR `f_name` like '%" . $_GET['q'] . "%'");
- $RESULT->execute();
- $RESULT->setFetchMode(PDO::FETCH_ASSOC);
- while ($row = $RESULT->fetch())
- $a[] = $row['f_name'] . ' ' . $row['l_name'];
- }
- echo json_encode($a);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement