File manager - Edit - /home/autoph/public_html/connect/home/ajax_autocomplete_party.php
Back
<?php //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //include 'core/database/connect.php'; $dbhost = 'localhost'; $dbuser = 'autoph_arnel'; $dbpass = 'Hke@2001'; $db = 'autoph_connect'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass , $db) or die($conn); function get_city($conn , $term){ $query = "SELECT * FROM vts_customers WHERE cust_fname LIKE '%".$term."%' || cust_lname LIKE '%".$term."%' ORDER BY cust_lname ASC LIMIT 15"; $result = mysqli_query($conn, $query); $data = mysqli_fetch_all($result,MYSQLI_ASSOC); return $data; } if (isset($_GET['term'])) { $getCity = get_city($conn, $_GET['term']); $cityList = array(); foreach($getCity as $city){ $cityList[] = $city['cust_lname'] . ", ".$city['cust_fname']; } echo json_encode($cityList); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings