Problem in uploading an image & storing the image in the database

Asked By smithjohn 230 points N/A Posted on - 05/27/2011

Hi everybody,

I need some help. I want to develop a web application that uses MySQL database in the backend. I developed the database. I have created the table name person_info that stores detailed information about different person’s information. Now I want to use it to store uploaded image in a column for a record.

So I searched for a different slob and encryption related information on forums but I didn’t get that. I also need some help related to uploading a file to server. Because of that, I am using a form to submit all my information but can catch the image in the server. So I need some help for uploading image and how to store that image in the server? Thanks in advance.

• Status: Open
• Question Views: 768
• Answer Count: 2
• Vote Up 23 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Brice

Go To Solution

Best Answer

Best Answer

Answered By Brice 0 points N/A #106886

Problem in uploading an image & storing the image in the database

Hi,

I'm Brice. You can't exactly put your images into your database, what you can do is put the directory of your image into your database and retrieve it during the process of your website. What you can do is create a folder, name it whatever you want, and put all the images you will be using in there, ideally you should put this on the root folder of your web application. Now in your database, make a column specifically for the image of the entity you are referring to, put the name of the image there and just retrieve it in your program every time you need it. You should create a variable that holds the folder name of the images for convenience in your application.

About Brice

Questions
1

Answers
14

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 06/11/2011
• Question Category: MySQL Server

Answered By LisaRoberts525 0 points N/A #106888

Problem in uploading an image & storing the image in the database

If you want to upload images into MySQL database, first you have to create the database with a field to store images. In your case you have already created the database. So use the ‘alter table' command to add a column to your database. The data type of the column must be a blob type. Depending on the size of the images you want to upload, you can add one of the blob types available in MySQL.

MySQL defines four blob types as tinyblob, blob, mediumblob and largeblob according to the maximum length of value that they can hold. Now you can use the MySQL command ‘insert into’ to upload images.

About LisaRoberts525

Questions
0

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/02/2011
• Question Category: MySQL Server