File manager - Edit - /home/autoph/public_html/connectv1/app/company_dealer/search_dealer.php
Back
<?php include_once("../../cfg/db.php"); $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT id, name, code FROM source_dealer WHERE (code LIKE '%$search_item%' OR name LIKE '%$search_item%') AND id != 0 AND status = 1 ORDER BY name ASC"; //echo $search_query; return; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo '<option value="'.$row['id'].'">'.$row["code"].' - '.$row["name"].'</option>'; } // if($check_if_okay > 0){ // $remove_query = "UPDATE source_company_dealer SET status = 0 WHERE dealer_id='$dealer_id' AND company_id='$company_id'"; // $db->sql_query($remove_query); // $arr_status['status'] = 1; //done removing // echo json_encode($arr_status); // } else { // $arr_status['status'] = 0; //record not found // echo json_encode($arr_status); // } // while($row = $company_info->fetch_assoc()) { // echo '<option value="'.$row['id'].'">'.$row["code"].' - '.$row["name"].'</option>'; // } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings