File manager - Edit - /home/autoph/public_html/voc/home/search_customers.php
Back
<?php include 'core/database/connect.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); //error_reporting(1); $tDate = date_create() ->format("Y/m/d"); $tTime =Explode(":", date('H:i:s')); $svtTime = $tTime[0].":".$tTime[1].":".$tTime[1]; function get_names($conn , $term){ $query = "SELECT * FROM vts_customers WHERE cust_fname LIKE '%".$term."%' ORDER BY cust_lname ASC"; $result = mysqli_query($conn, $query); $data = mysqli_fetch_all($result,MYSQLI_ASSOC); return $data; } if (isset($_GET['term'])) { $fname = get_names($conn, $_GET['term']); $nameList = array(); foreach($getName as $name){ $nameFList[] = $name['cust_fname']; $nameLList[] = $name['cust_lname']; } echo json_encode($nameList); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings