you can store images using the blob data type but as mentioned before, don't store the image in the database because it takes up too much space. just store it in a folder and store the link in the database.

Spoono has a tutorial on what you might be looking for: Image Databasing

Hi, I have a problem.

I'm uploading an image to a database but I want it to send error message that I have already uploaded a file for the specific record. What should I do?

-kamiya_ayanami

Hi can you show me the code of inserting pics into a MySQL database.
Can You Add Images Into A Mysql Database?

Replying to Avalon

Much better if the procedure is included. Am a novice programmer and very much willing to learn more about web developopment.
Hope you can help me.

Thanks,
Tin

inserting/retrieving pics in MySQL dbase/ PHP
Can You Add Images Into A Mysql Database?

Replying to sxyloverboy
Hi there, I tried inserting pic in MySQL using BLOB as the data type.
But it only converts the link to binary characters.
When I retrieved it, it only display the binary character to my web browser.
I observed that the data type (BLOB) is in binary.
I was thinking of changing it into something else but I don't know how.
Hope you could help me.

Thanks.

php displaying an image out of mysql
Can You Add Images Into A Mysql Database?

HI I done a Google search and found this forum and I have been having trouble displaying images in a html form.

Ok I have a working upload script I made which I tested it and it works it stores the username and the link to where the images is . I know how to display one image but I have a max limit to the user of 12 pictures and I don't fully know how I can display all 12 for the user.

I have the user to have his own page where only the images he uploaded he can look at.

I so far made the script making an array and using a while loop but didn't succeed on doing this.

So right now I have the username and the link of the image in the database and now trying to display those images in a html table.


Thanks.

-reply by aaron

OK, there is in fact way to store images however I do not know who would like to use it since it is not that simple to use. Currently the simplest way has been already provided here and it is saving links in the mysql database.

However there is also another thing person could do since there are some readers of files and so on integrated in the php you can find one adn use it to read the binary source code of the image and then effectively save binaries in the database however then again when you want to provide your users images then you would have to generate image back. Though this can be really useful if you are making some security integration in your script this could provide you with the ability to generate new images from randomly generated strings. Or somewhere else I cannot remember now the thing is that this can be ussuful however the problem is it is a bit complicated.

O yes I have remembered one more use case. When let's say you do not have rights to write files on the server however you have rights to write in the database you would use database and it woudl solve your problems

view image from database at single page
Can You Add Images Into A Mysql Database?

How to view all stored image from mysql database
I wan to store and display

Title:
Comment:
Description:
File:

These are the fields I have.

-question by satheesh

If u store image on mysql db, your mysql is very big. Is not good. Please store address / path u image on table is more effesien than store image on db