How do I upload and download multiple type of files in PHP from MySQL database?

In thisyou can upload any file which you want with change the file extention. Here is example for image. <formaction="upload.php"method="post"enctype="multipart/form-data"> Select image to upload:<inputtype="file"name="fileToUpload"id="fileToUpload"><inputtype="submit"value="Upload Image"name="submit"></form> <?php$target_dir ="uploads/";$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);$uploadOk =1;$imageFileType =strtolower(pathinfo($target_file,PATHINFO_EXTENSION));// Check if image file is a actual image or fake imageif(isset($_POST["submit"])) { $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);if($check !== false) {echo"File is an image - ". $check["mime"] ."."; $uploadOk =1; }else{echo"File is not an image."; $uploadOk =0; }}// Check if file already existsif(file_exists($target_file)) {echo"Sorry, file already exists."; $uploadOk =0;}// Check file sizeif($_FILES["fileToUpload"]["size"] >500000) {echo"Sorry, your file is too large."; $uploadOk =0;}// Allow certain file formatsif($imageFileType !="jpg"&& $imageFileType !="png"&& $imageFileType !="jpeg"&& $imageFileType !="gif") {echo"Sorry, only JPG, JPEG, PNG & GIF files are allowed."; $uploadOk =0;}// Check if $uploadOk is set to 0 by an errorif($uploadOk ==0) {echo"Sorry, your file was not uploaded.";// if everything is ok, try to upload file}else{if(move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {echo"The file ". basename($_FILES["fileToUpload"]["name"])." has been uploaded."; }else{echo"Sorry, there was an error uploading your file."; }}?> read less

For upload <html lang="en"> <head> <meta charset="UTF-8" /> <title>Multiple File Ppload with PHP</title> </head> <body> <form action="" method="post" enctype="multipart/form-data"> <input type="file" id="file" name="files[]" multiple="multiple" accept="image/*" /> <input type="submit" value="Upload!" /> </form> </body> </html> PHP CODE $valid_formats = array("jpg", "png", "gif", "zip", "bmp"); $max_file_size = 1024*100; //100 kb $path = "uploads/"; // Upload directory $count = 0; if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST"){ // Loop $_FILES to exeicute all files foreach ($_FILES['files']['name'] as $f => $name) { if ($_FILES['files']['error'][$f] == 4) { continue; // Skip file if any error found } if ($_FILES['files']['error'][$f] == 0) { if ($_FILES['files']['size'][$f] > $max_file_size) { $message[] = "$name is too large!."; continue; // Skip large files } elseif( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats) ){ $message[] = "$name is not a valid format"; continue; // Skip invalid file formats } else{ // No error found! Move uploaded files if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $path.$name)) $count++; // Number of successfully uploaded file } } } } Download FIle <?php function zipFilesAndDownload($file_names,$archive_file_name,$file_path) { $zip = new ZipArchive(); if ($zip->open($archive_file_name, ZIPARCHIVE::CREATE )!==TRUE) { exit("cannot open <$archive_file_name>\n"); } foreach($file_names as $files) { $zip->addFile($file_path.$files,$files); //echo $file_path.$files,$files."<br />"; } $zip->close(); header("Content-type: application/zip"); header("Content-Disposition: attachment; filename=$archive_file_name"); header("Pragma: no-cache"); header("Expires: 0"); readfile("$archive_file_name"); exit; } require_once("config.php"); $cqurfetch=mysql_query("SELECT * FROM albums where user_id='$user_id' and accept='1'"); while($row = mysql_fetch_array($cqurfetch)) { $file_names[] = $row['user_album_images']; } $archive_file_name=time().'.gallery.zip'; $file_path="/uploads/"; zipFilesAndDownload($file_names,$archive_file_name,$file_path); ?> read less