$tmpName) {
$fileName = $files['name'][$index];
$fileType = $files['type'][$index];
$fileSize = $files['size'][$index];
$fileError = $files['error'][$index];
if ($fileError === UPLOAD_ERR_OK) {
$destination = './uploads/' . $fileName; // Set the destination path
move_uploaded_file($tmpName, $destination); // Move the uploaded file to the destination
// Insert file details into the database
$id = generateRandomString();
if ($fileName != "") {
$stmt = $con->prepare("INSERT INTO " . $g_projectSlug . "_files set id='$id', file='$destination', file_size='$fileSize', folder='$parentFolder', timeAdded='$timeAdded', userId='$session_id'");
if (!$stmt) {
echo "err: $query";
}
if (!$stmt->execute()) {
echo "err: $query";
}
}
}
}
header("Location:./file-manager.php?folderId=$parentFolder&m=File Has Been Uploaded successfully!");
}
if (isset($_POST['updatefile'])) {
$alternative_text = $_POST['file_alternative_text'];
$title = $_POST['file_title'];
$file_caption = $_POST['file_caption'];
$file_description = $_POST['file_description'];
$url = $_POST['file_url'];
$actionId = $_POST['file_actionId'];
$stmt = $con->prepare("UPDATE " . $g_projectSlug . "_files SET alternative_text='$alternative_text', title='$title', caption='$file_caption', description='$file_description', url='$url' WHERE id='$actionId'");
if (!$stmt) {
echo "err: $query";
}
if (!$stmt->execute()) {
echo "err: $query";
}
header("Location:./file-manager.php?folderId=$parentFolder&m=File Has Been Updated successfully!");
}
$all_file_category = getRow($con, "SELECT
SUM(CASE WHEN RIGHT(`file`, 4) IN ('.jpg', 'jpeg', '.png', '.gif', '.bmp') THEN file_size ELSE 0 END) AS pic_size,
SUM(CASE WHEN RIGHT(`file`, 4) IN ('.mp4', '.flv', '.avi', '.mov', '.wmv') THEN file_size ELSE 0 END) AS video_size,
SUM(CASE WHEN RIGHT(`file`, 4) IN ('.mp3', '.wav', '.aac', '.ogg', '.wma') THEN file_size ELSE 0 END) AS audio_size,
SUM(CASE WHEN RIGHT(`file`, 4) NOT IN ('.jpg', 'jpeg', '.png', '.gif', '.bmp', '.mp4', '.flv', '.avi', '.mov', '.wmv', '.mp3', '.wav', '.aac', '.ogg', '.wma') THEN file_size ELSE 0 END) AS doc_size,
SUM(file_size) as all_files_size
FROM
" . $g_projectSlug . "_files WHERE userId='$session_id';");
?>