get the BLOB value of an image and insert it to database in php

Question

I have this code:

$filename = $_FILES['file']['name'];
$blob_value = [CODE TO CONVERT FILENAME TO BINARY];

$query = "INSERT INTO uploads VALUES('$blob_value');";
mysql_query($query);

I want to convert the image file to its equivalent blob_value and insert it to database. how am i suppose to do that. thank you for your response!

don't, store the file in the file system and any details you need in the db. — , Apr 02 '12 at 06:23
but our professor said to compare if the image exist using blob. but how am i suppose to do that in database? — John Micah Fernandez Miguel, Apr 02 '12 at 06:27

score 0 · Answer 1 · answered Apr 02 '12 at 06:33

0

Maybe something like this is what you need

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp      = fopen( $tmpName, 'r' );

$content = fread( $fp, filesize( $tmpName ) );

fclose( $fp );

$query = "INSERT INTO upload ( name, size, type, content ) ".
"VALUES ( '$fileName', '$fileSize', '$fileType', '$content' )";

mysql_query( $query ) or die( 'Error, query failed' );

Theres probably lots of different ways to do this though, i haven't tried this code...

answered Apr 02 '12 at 06:33

Patrick

104
1
12

if i base the validation on the image file size will it be better than getting its BLOB value? – John Micah Fernandez Miguel Apr 02 '12 at 06:55
No why would you do that, then the chance of getting the same hash if more than one image has the same size. I think it's better to do it on the file itself. – Patrick Apr 13 '12 at 08:11

deceze · Answer 2 · 2012-04-02T06:46:33.473

0

First of all, you're looking for $_FILES['file']['tmp_name'], which is the file holding the file data. Just the file name itself isn't of much use.

Secondly, the "BLOB value" of a file is just the binary data of the file, i.e. the file contents. So all you need to do to get the file "BLOB" data is:

$blob = file_get_contents($_FILES['file']['tmp_name']);

Third, storing large files is not really what a database was designed for. You should store the file in the file system and only information about the file in the database. If you want to check whether you already have the exact same file, store a hash of the file in the database, which you can easily search for.

edited Apr 02 '12 at 06:46

answered Apr 02 '12 at 06:35

deceze

510,633
85
743
889

thanks! but what if the user uploaded images with different FILENAME but the same image. i want to detect that even the FILENAME is different but the IMAGE itself is the same . the image still exists. – John Micah Fernandez Miguel Apr 02 '12 at 06:40
do i need to put addslashes()? – John Micah Fernandez Miguel Apr 02 '12 at 06:48
See http://stackoverflow.com/questions/7052655/insert-blobs-in-mysql-databases-with-php – deceze Apr 02 '12 at 06:52
if i base the validation on the image file size will it be better than getting its BLOB value? – John Micah Fernandez Miguel Apr 02 '12 at 06:55
Again, **use a hash**. Seeing that you're still learning this may be an advanced topic, but it's the best solution. Generate a hash from the file's content, store that in the database, check for each new file if its hash is already known. – deceze Apr 02 '12 at 07:06
im sorry for being noob. but what particular field am i going to hash?? the [name] or [size] or [tmp_name]?? – John Micah Fernandez Miguel Apr 02 '12 at 07:07
The whole file, i.e. `file_get_contents($_FILES['file']['tmp_name'])`. – deceze Apr 02 '12 at 07:10

get the BLOB value of an image and insert it to database in php

2 Answers2