Insert image into database

Question

What type of variable do I use to store an image in the database? And is there a specific command for this? or just enter as any record?

I have a product table with the fields:

code, name, price, image, in the image I intend to store a product photo.

Answer 1

as already mentioned, one can use BLOB and LONGBLOB, but DON’T DO THIS.

There are several and diverse temptations whether to store images in databases, such as:

TEMPTATIONS - backup facility - single and uniform access between multiple nodes - sql image listing and accounting

however, we have the true heels of Quiles:

REALITY - backup becomes bulky beyond normal - Database server memory load is overloaded with non-related data - Bank server network traffic volume increases substantially

I suggest scheming an intelligent way of organizing data in an intuitive data structure, for example: /version/year/id-product/photos

If you want to perform data centralization and single point access, try distributed or replicated filesystems, there are thousands of alternatives (GFS,GPFS,AFS,DFS mogileFS, extremfs)

And there are also the document bases, where today many have distorted and become NOSQL (S3, couchdb, mongoDB, etc..)

Answer 2

It is difficult to help you without knowing which DBMS and which language you are using.
However, for example, I will use Mysql+PHP.

Answering your question: Mysql uses a LONGBLOB field.

Now, I believe is not a good practice. Change your application and do not do this.
Whether you’re in DBMS or not, your image will be on disk.
This will only make your database more "swollen"
Record in DBMS only the path to the image, will get lighter.

To upload images and save only the path to the database. You can read the php documentation on the subject here (link).

First you need a form to select the image:

<form enctype="multipart/form-data" action="salvar.php" method="post">
    Imagem: <input name="userfile" type="file" />
    <input type="submit" value="Enviar" />
</form>

Note that the "action" of the form points to "save.php". See how it turned out:

<?php
$uploaddir = '/upload/imagens/'; //directório onde será gravado a imagem

if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploaddir . $_FILES['userfile']['name'])) {
    $uploadfile = $uploaddir . $_FILES['userfile']['name'];
    //grava na base de dados, no campo imagem, somente o nome da imagem que ficou gravado na variável $uploadfile que criamos acima.
} else {
    //não foi possível concluir o upload da imagem.
}
?>

Answer 3

You can save the image path, where it is in your ftp for example:

foto_do_produto(varchar 100) - seu campo

/images/produtos/prod50156.png - o valor do campo

For more references and examples of other languages although you haven’t mentioned any in the question I leave it in php as an example here