- mhd.sulhan (m.shulhan@gmail.com)
*/
foreach ($data as $d) {
//{{{ delete all file
$q = "\tselect\tM.path\n\t\t\tfrom\t_media\t\t\tM\n\t\t\t,\t\t_media_table\tMT\n\t\t\twhere\tM.id\t\t= MT._media_id\n\t\t\tand\t\tMT.table_id\t= '" . $d["table_id"] . "'";
$rs = Jaring::db_execute($q);
foreach ($rs as $k => $v) {
$f = APP_PATH . $v["path"];
if (file_exists($f)) {
unlink($f);
}
}
//}}}
//{{{ delete data from _media_table
$media_id = $d["_media_id"];
$bindv = [];
$bindv[] = $d["table_id"];
$bindv[] = $media_id;
$table = "_media_table";
$fids = ["table_id", "_media_id"];
Jaring::db_prepare_delete($table, $fids);
Jaring::$_db_ps->execute($bindv);
Jaring::$_db_ps->closeCursor();
//}}}
//{{{ delete data from media
$q = " delete from _media where id = " . $media_id;
Jaring::db_execute($q);
//}}}
}
Jaring::$_out['success'] = true;
Jaring::$_out['data'] = Jaring::$MSG_SUCCESS_DESTROY;