function db_delete_files($ids)
{
global $link;
mysqli_set_charset($link, "utf8");
$stm = $link->stmt_init();
$stm->prepare('DELETE FROM FILES WHERE ID=?');
foreach ($ids as $id) {
logmsg("del file " . $id);
$stm->bind_param('i', $id);
$stm->execute();
db_append_to_log('FILES', $id, 'remove', 'file removed', $id);
}
$stm->close();
if (count($ids) > 0) {
recycle_files($ids);
}
}
function upload_file($tab, $cnt, $idrecord)
{
global $ERA;
if (!isset($_POST['upload' . $cnt])) {
return;
}
$target_dir = $ERA . 'uploads/';
$original_filename = basename($_FILES['filename' . $cnt]['name']);
$target_file = $target_dir . $original_filename;
$tmp_filename = $_FILES['filename' . $cnt]['tmp_name'];
logmsg('original_filename=' . $original_filename);
logmsg('target_file=' . $target_file);
logmsg('tmp_filename=' . $tmp_filename);
// Check if file already exists
if (file_exists($target_file)) {
unlink($target_file);
}
if (move_uploaded_file($tmp_filename, $target_file)) {
$description = $_POST['desc' . $cnt];
$fileid = db_insert_uploaded_file($tab, $idrecord, $original_filename, $description);
rename($target_file, $ERA . 'files/' . $fileid);
infomsg('The file ' . $original_filename . ' has been uploaded.');
db_append_to_log('FILES', $fileid, 'add', $description, $original_filename);
} else {
infomsg('Sorry, there was an error uploading your file.');
}
}
