return_result($query); //echo $query; return;
foreach($dms as $data){
echo "";
}
}
else if($type == 2){
if(isset($_POST['dms_id'])){
$dms_id = $_POST['dms_id'];
$query = "
SELECT sd.id, sd.name, concat(e.first_name, ' ', e.last_name) AS creator, DATE_FORMAT(sd.date_added, '%M %d, %Y / %h:%i:%s %p') AS date_added, sd.status
FROM `source_dms` sd
INNER JOIN employee e ON e.id = sd.added_by
WHERE sd.id != 0 AND sd.id = '$dms_id'"; //echo $query; return;
$dms_details = $db -> return_result($query);
foreach($dms_details AS $data){
$arr['name'] = $data['name'];
$arr['date_added'] = $data['date_added'];
$arr['creator'] = $data['creator'];
$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_dms 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 '';
}
}
?>