且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在数据库中的一行中插入多个文件

更新时间:2023-11-22 14:12:52

media_tittle =


_POST ['media_tittle'];


extension = array(jpeg,jpg,png);
//计算总文件数


I have created multiple file form. But when i insert files in database it inserted separated file each row.So i want to insert multiple file in one row.

What I have tried:

$media_tittle=$_POST['media_tittle'];	
	
	$extension = array("jpeg","jpg","png");	
	// Count total files
	$countfiles = count($_FILES['media_images']['name']);
	
	for($i=0;$i<$countfiles;$i++){
		$filename = $_FILES['media_images']['name'][$i];
		$tmp_dir = $_FILES['media_images']['tmp_name'][$i];
		$imgSize = $_FILES['media_images']['size'][$i];		
	
		$namefile = pathinfo($filename, PATHINFO_FILENAME);
		$ext = pathinfo($filename, PATHINFO_EXTENSION);		
		
		$counter = 0;
		
		if(empty($media_tittle)){
			$errMSG = true;	
			echo "Please Enter Title.";
		}
		elseif(empty($filename)){
			$errMSG = true;	
			echo "Please Upload Images.";
		}
		elseif(in_array($ext, $extension) == false){
			$errMSG = true;	
			echo "Please Upload .jpeg, .jpg, .png formatted file.";
		}
		elseif($imgSize >= 500000){
			$errMSG = true;	
			echo "File too large. File must be less than 500 Kilobytes.";
		}
		if(!isset($errMSG)){
			list($b_width, $b_height) = getimagesize($tmp_dir);
			if($b_width != 730 || $b_height != 500){
				$errMSG = true;	
				echo "Please check the Witdh and height of Image.";
			}
			if(!isset($errMSG)){				
				while(file_exists("../media_corner/$filename")){
					$filename = $namefile. $counter.'.'.$ext;
					$counter++;
				}
				move_uploaded_file($tmp_dir, "../media_corner/$filename");				
				//$filename = $_FILES['media_images']['name'];
				$result = mysqli_query($conn, "INSERT INTO `media_corner`(`title`, `images`, `status`) VALUES ('$media_tittle','$filename','N')")or die("Could not retrieve image: " . mysqli_error($conn));
			}		
		}		
	}

media_tittle=


_POST['media_tittle'];


extension = array("jpeg","jpg","png"); // Count total files