Blob

[Arsench]

Hello world,

Can you please help me.I have a blob field and want to insert and read image, but don't know how to do that.I want to insert data with images into mysql db and then read that in php.


Thank a lot

[nrglift]

I would recommend not using the BLOB to store the image in. It can dramatically increase the size of your database and FAST! I would recommend uploading the images to the server and only storing the path to the image in the database.

[Arsench]

I would recommend not using the BLOB to store the image in. It can dramatically increase the size of your database and FAST! I would recommend uploading the images to the server and only storing the path to the image in the database.

thank your advise friend, but I dont know how to upload with the other text data and then display the current image for the current data.example.

ID = 1001
Name = Valencia
Image = Val.jpg


thanks again

[thetestingsite]

Here's a good tutorial for what you want to do using PHP/MySQL.

http://www.php-mysql-tutorial.com/image-gallery/
http://www.php-mysql-tutorial.com/upload-to-file-server.php

Hope this helps.