Reputation: 1

How I can upload image to mysql db from my form?

How I can upload image to mysql db from my form? In my form I set and in my databse I also defined data type for this fiels as longblob but not gettin image in to db

I m just simply inserting it into database with insert query.

Plz help me guys..

Upvotes: 0

Answers (7)

Brian Hannay

Reputation: 600

Use the blob data type for your column, read the uploaded file in and stripslashes. An example is below.

//open a file
$file = fopen($_FILES['fileToUpload']['tmp_name'], "r") or die("Error");

//read the contents of file
$contents = fread($file, filesize($_FILES['fileToUpload']['tmp_name']));

//add slashes. For details refer http://php.net/manual/en/function.addslashes.php
$contents = addslashes($contents);

//fire query to insert
mysql_query("INSERT INTO content(`img`) VALUES ('$contents');") or die(mysql_error()); 

//close file
fclose($file);

Upvotes: 1

Hamid Talebi

Reputation: 1318

This is better to to save your pictures in root of your project,such as images folder.
And save your path of pictures or name of pictures in your database with nvarchar or varchar data type.

Upvotes: 0

Dino Babu

Reputation: 5809

use blob data type field in database.

  $image_url = 'http://www.technew.in/templates/dino/images/technew_head.png';
  $imageData = chunk_split(base64_encode(file_get_contents($image_url)));
  $query = "INSERT INTO db_image (image_data) VALUES('$imageData')";
  mysql_query($query) or die(mysql_error());

Upvotes: 1