Insert image.jpg in the database

Question

Good morning!
I intend to insert an image into the database in the format . jpg, but when it is inserted it appears like this in the database: ???? JFIF
Here is my code for the image:

<form action="" method="POST" enctype="multipart/form-data">
   <input type="file" name="imagem" placeholder="Insira a imagem do produto" required/>
</form>
<?php
    $imagem_produto=addslashes(file_get_contents($_FILES['imagem']['tmp_name']));
    $inserir_produto=mysqli_query($link,"INSERT INTO produtos (imagem) VALUES('{$imagem_produto}')");
?>

What he wanted was for the name and extension of the image to appear in the database, for example "image.jpg" only this!

Answer 1

If you just want the name, why don’t you use it like this?

$nome_img = $_FILES['imagem']['name'];
if(move_uploaded_file($_FILES['imagem']['tmp_name'], "images/".$nome_img)){
   $inserir=mysqli_query($db, "INSERT INTO coluna(nome) VALUES ('$nome_img')");
}else{
   echo "Erro!";
}

With this you will insert the image in the database.

I suppose you have a code for the upload but I leave it here anyway.

I point out that I usually use varchar(255) in the database.

Answer 2

The table field where your image will end up must be blob or mediumblob depending on the size you need! Then just show the Row on the side you need and it will appear!

Code to insert image

Make a button and make it Ubmit with name=""

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


 $name = $_FILES['imagem']['name'];
 $target_file = basename($_FILES["imagem"]["name"]);

 // Select file type
 $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

 // Se quiseres só jpg deixa só jpg
  $extensions_arr = array("jpg","jpeg","png","gif");

 // Check extension
 if( in_array($imageFileType,$extensions_arr) ){

 // Convert to base64 
 $image_base64 = 
 base64_encode(file_get_contents($_FILES['imagem'] 
['tmp_name']) );
 $image = 'data:image/'.$imageFileType.';base64,'.$image_base64;


$query="INSERT INTO produtos(imagem) VALUES ('".$image."')";
$query_run = mysqli_query($conn,$query);