how to insert a image into Db as blob in ZendFramework.

Question

I want to insert a image in blob format to db. how to write a program in zend framework. a simple form just choose one image and insert into db.

Answer 1

Read it in as a string using file_get_contents and store that.

That said, it is seldom a good idea to store the actual image data in the database. It is better practice to generate a unique filename and store that in the DB instead.

Answer 2

In your Zend form create a file element:

$element = new Zend_Form_Element_File('fileElement');

Then you can insert the uploaded image to your DB in BLOB format like this:

$conn = new PDO("mysql:host='host';dbname='database'", 'userName', 'password'); 

$imagePath = $zendForm->fileElement->getFileName(); 
$image = file_get_contents('$imagePath'); 

$sql = "INSERT INTO images (data) values(?)"; 

$q = $conn->prepare($sql); 
$q->bindParam(1, $image, PDO::PARAM_LOB); 
$q->execute();