query("SELECT * FROM tb_memo WHERE type = 'tutorial' ");
$i=0;
$cat = "";
$response = array();
$data;
while($row=$sql->fetch_array()) {
$response[$i][]= ''.$row['memo_name'].'';
$response[$i][]= date_format(date_create($row['date_added']), "m/d/Y h:i A");
$response[$i][]= $row['department'];
if(!empty($row['video_url'])){
$response[$i][]= '
Watch
';
}else{
$response[$i][]= ' ';
}
$i=$i+1;
}
echo $json_string = json_encode($response);
?>