File manager - Edit - /home/autoph/public_html/connectv1/app/nature_of_business/reload_nature.php
Back
<?php include_once("../../cfg/db.php"); $type = $_POST['type']; if($type == 1){ $query = "SELECT `id`, `name` FROM `source_nature_of_business` WHERE id != 0 ORDER BY name ASC"; $nature = $db -> return_result($query); //echo $query; return; foreach($nature as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } } else if($type == 2){ $arr = array(); if(isset($_POST['nature_id'])){ $nature_id = $_POST['nature_id']; $query = "SELECT snb.id, snb.name, snb.category_id, snb.add_source, concat(e.first_name, ' ', e.last_name) AS creator, DATE_FORMAT(snb.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, concat(e1.first_name, ' ', e1.last_name) AS last_modifier, snb.status FROM `source_nature_of_business` snb INNER JOIN employee e ON e.id = snb.added_by INNER JOIN employee e1 ON e1.id = snb.last_modified_by WHERE snb.id != 0 AND snb.id = '$nature_id'"; // echo $query; return; $nature_details = $db -> return_result($query); foreach($nature_details AS $data){ $add_source = $data['add_source']; $arr['name'] = $data['name']; $arr['category'] = $data['category_id']; $arr['date_added'] = $data['date_added']; $arr['creator'] = $data['creator']; $arr['last_modifier'] = $data['last_modifier']; if($add_source == 0){ $add_source = "(By import)"; } else if($add_source == 1){ $add_source = "(Manual add)"; } else { $add_source = "(Not monitored)"; } $arr['add_source'] = $add_source; $arr['status'] = (intval($data['status']) <> 0) ? true : false ; } echo json_encode($arr); } } else if($type == 3){ $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT id, name FROM source_nature_of_business WHERE (name LIKE '%$search_item%') AND id != 0 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["name"].'</option>'; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings