File manager - Edit - /home/autoph/public_html/connectv1/app/sales_consultant/load_sc_members.php
Back
<?php include_once("../../cfg/db.php"); $type = $_POST['type']; if($type == 1){ $gsm_id = $db->escape(trim($_POST['gsm_id'])); $query = " SELECT sc.id, sc.first_name, sc.last_name FROM sales_group sg INNER JOIN sales_consultant sc ON sc.id = sg.sc_id WHERE gm_id = '$gsm_id' AND sg.status != 0"; //echo $query; return; $sc_members = $db -> return_result($query); foreach($sc_members AS $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } else if($type == 2){ //search $search_item = $db->escape(trim($_POST['search_item'])); $gsm_id = $db->escape(trim($_POST['gm_id'])); $query = " SELECT sc.id, sc.first_name, sc.last_name FROM sales_group sg INNER JOIN sales_consultant sc ON sc.id = sg.sc_id WHERE gm_id = '$gsm_id' AND sg.status != 0 AND ((sc.first_name LIKE '%$search_item%') OR (sc.last_name LIKE '%$search_item%') OR (sc.employee_id LIKE '%$search_item%'))"; //echo $query; return; $sc_members = $db -> return_result($query); foreach($sc_members AS $data){ echo "<option value='{$data['id']}'>" . $data['first_name']. " " . $data['last_name'] ."</option>"; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings