Storing Image into database

devil_vin

Hi..guys.How can I achieve to storing image into database?Is it necessary to create another table or able to mix with a table which store plain data?Thanks..

NogDog

Probably the most common practice is to store the actual image file in a directory on the disk, and only store related information (including the file name) in the database. But if you really feel a need to store the image itself in the DB, then you want to use a BLOB type field for it.

swatisonee

i'm puzzled - how would the path be defined in the INSERT query pl ?

$sql = "INSERT INTO TABLE X ("Imagelocation") VALUES ( '$????' )" ;

What would $???? be ?

thanks.

Stanley90

The problem of uploading files to a database is not that difficult. You have to use, on the server, a certain data type when creating the table. This data type has to be capable of storing large amounts of binary data. When using Microsoft SQL Server, this data type is called image. For more information see Binary Large OBject (BLO😎 for a short definition and Books Online for a complete reference.

NogDog

swatisonee wrote:
i'm puzzled - how would the path be defined in the INSERT query pl ?
$sql = "INSERT INTO TABLE X ("Imagelocation") VALUES ( '$????' )" ;
What would $???? be ?

thanks.

Well, if you're processing a file upload of some sort, it might be something like:

$uploadDir = $_SERVER['DOCUMENT_ROOT'].'/uploads/';
$fileName = basename($_FILES['file']['tmp_name']);
if(move_uploaded_file($_FILES['file']['tmp_name'], $uploadDir.$fileName))
{
   $sql = "INSERT INTO TABLE X (`ImageDirectory`, `ImageFileName`) VALUES ('$uploadDir', '$fileName')";
   // perform insert query and any other processing...
}
else
{
   // throw exception or raise error
}