提问人:FSO 提问时间:3/21/2021 更新时间:3/21/2021 访问量:127
图像未插入数据库
images is not inserting into database
问:
我在PHP中创建了一个图像上传页面。图像存储在根文件夹中,但没有插入数据库,我不知道我做错了什么................
这是我的代码
[html]
form action="" method="post" enctype="multipart/form-data" >
<input type="file" name="file">
<input type="submit" value="upload" name='submit'>
</form>
PHP的
$con=........
if(isset($_POST['submit'])){
$file=$_FILES['file'];
$filename= $_FILES['file']['name'];
$size=$_FILES['file']['size'];
$temp=$_FILES['file']['tmp_name'];
$error=$_FILES['file']['error'];
$ext=explode('.', $filename);
$actual=strtolower(end($ext));
$allowed=array('jpg','png','jpeg');
if (in_array($actual,$allowed)) {
if ($error ===0) {
if ($size <5000000) {
$desti= 'uploads/'.$filename;
move_uploaded_file($temp,$desti);
}else{
echo"limit is 50 mb";
}
}else{
echo"network error";
}
}else{
echo"wrong file type";
}
$res=mysqli_query($con, "insert into images('image') values('$desti')");
答:
0赞
Professor Abronsius
3/21/2021
#1
假设上面显示的代码是实际代码,并且您的 sql 在列名周围有单引号,然后将 sql 从
$res=mysqli_query($con, "insert into images('image') values('$desti')");
自
$sql='insert into `images` (`image`) values (?)';
$stmt=$con->prepare($sql);
$stmt->bind_param('s',$desti);
$stmt->execute();
评论
prepared statement