Save the binary content of an image in the database

Question

How do I get the bytecode of an image at upload time to be able to store it in the mysql blob field without the need to save the image to ftp?

Answer 1

If what you want is to simply save an image in BD, follow suggestion of how to do:

Listing 1: Table creation script in the database

CREATE TABLE PESSOA (  
    PES_ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,  
    PES_IMG BLOB  
);

Listing 2: Upload form

<form action="gravar.php" method="POST" enctype="multipart/form-data"> 
    <label for="imagem">Imagem:</label> 
    <input type="file" name="imagem"/> <br/> 
    <input type="submit" value="Enviar"/> 
</form>

Listing 3: Script saving the image in the database

<?php 
$imagem = $_FILES["imagem"]; 
$host = "localhost"; 
$username = "root"; 
$password = ""; 
$db = "test"; 

$acesso = 'mysql:host=' . $host . ';db=' . $db; 

// Recebeu a imagem
if($imagem != NULL):
    $nomeFinal = time().'.jpg'; 

    // Tenta gravar o arquivo no servidor
    if (move_uploaded_file($imagem['tmp_name'], $nomeFinal)): 

        // Pega a imagem
        $tamanhoImg = filesize($nomeFinal); 
        $mysqlImg = addslashes(fread(fopen($nomeFinal, "r"), $tamanhoImg)); 

        // Conecta-se ao BD e tenta gravar
        try{
            $pdoConecta = new PDO( $acesso, $username, $password ) ;
            $pdoConecta->query("INSERT INTO PESSOA (PES_IMG) VALUES ('$mysqlImg')");
        } catch( PDOException $e ) {
            echo $e->getMessage();
        }

        // Apaga o arquivo
        unlink($nomeFinal); 
    endif;

else:
    echo"Você não realizou o upload de forma satisfatória."; 
endif;
?>

Source: http://www.devmedia.com.br/upload-de-imagens-em-php-e-mysql/10041

Answer 2

Well, if what you want is the byte array to save in the bank here is how to do:

$filename = "myFile.sav"; 
$handle = fopen($filename, "rb"); 
$fsize = filesize($filename); 
$contents = fread($handle, $fsize); 
$byteArray = unpack("N*",$contents); 
print_r($byteArray); 
for($n = 0; $n < 16; $n++)
{ 
    echo $byteArray [$n].'<br/>'; 
}

But remember how php is synchronous large files can take a long time to be processed.

See more in at the source

Answer 3

What you’re looking for is not binary, it’s Base64.

With this function you can transform the image into a format that you can save in the database and use in HTML easily. However Base64 takes up 1/3 more space, that is, you will take up more disk space on your server and, more importantly, your page will take longer to load.

Utilizing:

$imgEmBase64 = base64_encode($_FILES['nomeDoCampo']['tmp_name']);
$sql = "insert into banco (imagem) values( '" . mysql_real_escape($imgEmBase64). "')";
mysql_query($sql);

You can also turn this data into image files and save on the server, but then it would be easier to accept image upload same.

Answer 4

After the POST is done, Voce takes the upload variable and saves the file any temporary folder, so you can read the file and save the content in the variable $image php to then save to the database (Mysql BLOB type field).

<?php
           $path = "images/arquivo_temporario";
           if (move_uploaded_file($_FILES['imagem'][['tmp_name'], $path))
            {
                $handle = fopen($path, "r");
                $content = fread($handle, $size);
                $imagem = base64_encode($content);
                fclose($handle);
            }
?>

Notice that the base64_encode function instead of addslashes (much used in internet examples), as it will facilitate later the display of the image in HTML, besides not changing the contents of the file.

Note that when using addslashes, function that returns a string with backslashes before characters that need to be escaped to be escaped in query the database, Voce will be changing the contents of the file.

Once saved in the database, Voce can read the saved image and store it in the variable $image php to display it with the following HTML code with PHP:

<img src="data:image/jpeg;base64,<?php echo $imagem;?>"

Answer 5

"How do I get the bytecode of an image at upload time to store it in the blob field of the mysql without the need to save the image in ftp?"

There are many things in the question. Uploading images to the server can be done using FTP software (Fetch, Cyber Duck...) or using the "upload" system (input type file, example here: http://php.net/manual/en/features.file-upload.post-method.php).

In the case of FTP vc puts the image (the document), where you want it. Then vc must indicate to PHP where the image is, to do the treatment.

In the case of "upload", the server places the image in a "tmp" folder. Using the PHP Moveupload file function (http://php.net/manual/en/function.move-uploaded-file.php) you should put the image in another folder.

The treatment: if the goal is only to solve a problem type "curiosity", I think better to send in FTP (but easy). Then read the image using fopen(), put the data into a "string" and insert into a BLOB.

If the goal is to "use", it is different. A BLOB is not "inside" the table, but is a "document" outside the table, it means that SQL should open this document (and slow). Also, if you have a table with BLOB for images, when you will try to do SELECT *, you will certainly use but memory of what has SQL. And the result will also be slow.

What we do, we usually put only the "path" to fetch the image. For example "my_pict.jpg" in a Varchar.

Easier, but we can get in front of another problem: how to put my image, but prevent the use of this image from another server? (another web site that wants to use my image without authorization for example). Op 1: put an htaccess that prevents reading Op 2: place in a "inaccessible" folder. This depends on the hosting you have, more on the hosting I have, I land put data "before" folder "www". Documents are invisible from the Web, but I can read them from PHP.

My opinion: well think the "why" before seeking the "how".