我正在以面向对象的编程学习PHP,并希望帮助我将图像插入数据库。我该怎么办?
通常,数据在没有图像的情况下插入,但无法使用图像输入数据。因此,请帮助解决这个问题。
protected function create()
{
$this->validate();
if (!empty($this->errors)) {
return false;
}
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO " . static::$table_name . " (";
$sql .= join(', ', array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
$result = self::$database->query($sql);
if ($result) {
$this->id = self::$database->insert_id;
}
return $result;
}
数据是在没有图像的情况下插入的,但是我试图用图像插入数据,所以请帮助我
尝试此
<html>
<body>
<?php
$msg = '';
if($_SERVER['REQUEST_METHOD']=='POST'){
$image = $_FILES['image']['tmp_name'];
$img = file_get_contents($image);
$con = mysqli_connect('localhost','root','','admin') or die('Unable To connect');
$sql = "insert into images (image) values(?)";
$stmt = mysqli_prepare($con,$sql);
mysqli_stmt_bind_param($stmt, "s",$img);
mysqli_stmt_execute($stmt);
$check = mysqli_stmt_affected_rows($stmt);
if($check==1){
$msg = 'Image Successfullly UPloaded';
}else{
$msg = 'Error uploading image';
}
mysqli_close($con);
}
?>
<form action="" method="post" enctype="multipart/form-data">
<input type="file" name="image" />
<button>Upload</button>
</form>
<?php
echo $msg;
?>
</body>
</html>