上传图片不工作,没有错误,只是没有显示。
问题描述:
您好,
我正在尝试将图片上传到数据库中。我可以显示图片,但由于一个原因我似乎无法上传工作。我没有错,所以我不确定我做错了什么。这是我的代码:
Hi here,
I'm trying to upload a picture into a database. I'm enable to display pictures but for one reason I can't seem to get uploading working. I get no errors so I'm not sure what I'm doing wrong. Here is my code:
$db_server = "localhost";<br />
$db_username = "root";<br />
$db_password = "";<br />
$db_database = "meubelfabriek";<br />
$conn = new PDO("mysql:host=$db_server;dbname=$db_database", $db_username, $db_password);<br />
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<br />
if (isset($_POST['submit']))<br />
{<br />
$tipe_file1 = $_FILES['image1']['type'];<br />
$tipe_file2 = $_FILES['image2']['type'];<br />
$tipe_file3 = $_FILES['image3']['type'];<br />
$tipe_file4 = $_FILES['image4']['type'];<br />
$prijs = $_POST['prijs'];<br />
$naam = $_POST['fname'];<br />
$beschrijving = $_POST['desc'];<br />
$maat1 = $_POST['maat1'];<br />
$maat2 = $_POST['maat2'];<br />
$maat3 = $_POST['maat3'];<br />
$maat4 = $_POST['maat4'];<br />
if ($tipe_file1 == "image/jpeg" || $tipe_file1 == "image/jpg"){<br />
$aMyUploads = array();<br />
foreach ($_FILES as $aFile) {<br />
if(0 === $aFile['error']){<br />
$newLocation = ''.$aFile['name'];<br />
if(0 === $aFile['error'] && (false !== move_uploaded_file($aFile['tmp_name'], $newLocation))){<br />
$aMyUploads[] = $newLocation;<br />
} else {<br />
$aMyUploads[] = '';<br />
}<br />
}<br />
}<br />
print_r($aMyUploads);<br />
$stmt = $conn->prepare("INSERT INTO `producten` (naam, beschrijving, prijs, maat1, maat2, maat3, maat4, image1, image2, image3, image4) VALUES<br />
(:naam, :beschrijving, :prijs, :maat1, :maat2, :maat3, :maat4, :image1, :image2, :image3, :image4)");<br />
$stmt->execute(array(":naam"=>$naam, ":beschrijving"=>$beschrijving, ":prijs"=>$prijs, ":maat1"=>$maat1, ":maat2"=>$maat2, ":maat3"=>$maat3, ":maat4"=>$maat4, ":image1"=>$aMyUploads[0], ":image2"=>$aMyUploads[1], ":image3"=>$aMyUploads[2], ":image4"=>$aMyUploads[3]));<br />
}else{<br />
echo "<script>alert('Failed to add data! Images must be inputed at last one and filetype JPG/JPEG')</script><br />
<script>setTimeout(\"self.history.back();\",0000);</script>";<br />
}<br />
}
我尝试过:
不同的代码,通过PHP我的管理员将图片上传到数据库。
What I have tried:
Different code, uploading pictures into the database through PHP my admin.
答
db_server =localhost;< br />
db_server = "localhost";<br />
db_username =root;< br />
db_username = "root";<br />
db_password =;< br />
db_password = "";<br />