問題描述
我正在制作一個表格,用戶可以通過它上傳多張圖片.當用戶上傳圖像時,它們會存儲在服務器的文件夾中.直到這里一切正常,但是當我嘗試將圖像的路徑保存在數(shù)據(jù)庫中時,而不是路徑,兩個圖像的名稱僅存儲在一行中.我希望每個圖像的路徑應該存儲在不同的行中.
我正在制作一個表格,用戶可以通過它上傳多張圖片.當用戶上傳圖像時,它們會存儲在服務器的文件夾中.直到這里一切正常,但是當我嘗試將圖像的路徑保存在數(shù)據(jù)庫中時,而不是路徑,兩個圖像的名稱僅存儲在一行中.我希望每個圖像的路徑應該存儲在不同的行中.
<div class="form-group"><label class="col-md-3 control-label"></label><div class="提交"><input class="btn btn-primary" value="保存" type="submit" name="submit">
</表單>
admin_insert_property_images.php
你的 $filepath
變量和你的 query
必須在你的循環(huán)中.
您還使用了與 mysqli_
函數(shù)不兼容的 mysql_query
.
這兩個 API 不能混合在一起.使用 mysqli_query
同時將數(shù)據(jù)庫連接傳遞給它.
I am making a form through which user can upload multiple images. When the user uploads the images they get stored in the server's folder. Everything works fine till here but when I am trying to save the path of the images in the database then instead of the path, the name of both the images gets stored in one row only. I want that the path of each image should get stored in different row.
<form action="admin_insert_property_images.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="col-md-3 control-label">Upload Image:</label>
<div class="col-md-8">
<input type="file" id="file" name="support_images[]" multiple accept="image/*" />
</div>
</div>
<div class="form-group">
<label class="col-md-3 control-label"></label>
<div class="submit">
<input class="btn btn-primary" value="Save " type="submit" name="submit">
</div>
</div>
</form>
admin_insert_property_images.php
<?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<count($_FILES['support_images']['name']); $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");
}
}
?>
Your $filepath
variable and your query
has to be in your loop.
You are also using mysql_query
which is not compatible with mysqli_
functions.
Those two APIs do not mix together. Use mysqli_query
while passing DB connection to it.
<?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<count($_FILES['support_images']['name']); $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, '*').$path;
$query=mysqli_query($con,"INSERT into propertyimages (`propertyimage`) VALUES('".addslashes($filepath)."'); ");
}
}
else
{
$filepath="";
}
if($query)
{
header("Location: admin_profile.php");
}
}
這篇關(guān)于上傳多張圖片并將其路徑存儲在數(shù)據(jù)庫中的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網(wǎng)!