php多文件路径存入数据库,php – 上传多个图像并将其路径存储在数据库中

我正在制作一个表单,用户可以通过该表单上传多个图像.当用户上传图像时,它们会存储在服务器的文件夹中.一切正常,直到这里,但是当我试图保存数据库中的图像路径而不是路径时,两个图像的名称只存储在一行中.我希望每个图像的路径应该存储在不同的行中.

Upload Image:

admin_insert_property_images.php

$con=mysqli_connect("abc.com","abc","ab","abc");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

if(isset($_POST['submit']))

{

extract($_POST);

if(isset($_FILES['support_images']['name']))

{

$file_name_all="";

for($i=0; $i

{

$tmpFilePath = $_FILES['support_images']['tmp_name'][$i];

if ($tmpFilePath != "")

{

$path = "propertyimages/"; // create folder

$name = $_FILES['support_images']['name'][$i];

$size = $_FILES['support_images']['size'][$i];

list($txt, $ext) = explode(".", $name);

$file= time().substr(str_replace(" ", "_", $txt), 0);

$info = pathinfo($file);

$filename = $file.".".$ext;

if(move_uploaded_file($_FILES['support_images']['tmp_name'][$i], $path.$filename))

{

$file_name_all.=$filename."*";

}

}

}

$filepath = rtrim($file_name_all, '*');

$query=mysqli_query($con,"INSERT into propertyimages (`propertyimage`) VALUES('".addslashes($filepath)."'); ");

}

else

{

$filepath="";

}

if($query)

{

header("Location: admin_profile.php");

}

}

?>