Image retrieval form mysql database

Question

1.00/5 (1 vote)

See more:

I have retrieved the image from the database using php.When i retrieve and display the pic,certain pics and only half in size.The image is not display its entire size and width.http://postimg.org/image/hhgffma09/[^]

Please help me out .thank you

Posted 22-Feb-14 13:28pm

abisheak Balaji

Add a Solution

Comments

Garth J Lancaster 22-Feb-14 20:04pm

given you don't show any code, how can we help you ?

I suggest you update your question with the code, both for saving and fetching an image, and, the table definition for the MySQL table (hint, use 'describe <tablename>' - from a recent exercise, if you're not saving an image correctly in the appropriate sized 'blob', you cant expect to get it back

EZW 22-Feb-14 21:29pm

Does your IMG tag (<img src="... ) have any styling to it defining width or height? This looks like an HTML/CSS problem rather then PHP... but can't tell without any code

abisheak Balaji 22-Feb-14 21:45pm

no,I haven't specificed any width and height attribute in IMG src element.
I used MySQL workbench to insert
the data into the database.
I'll update the table definition once I
login to my system.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

abisheak Balaji · Accepted Answer · 2014-02-23T00:16:00

Solution 2

Thanks guys, Solved it myself.Had to change Blob to LongBlob though i put too much weight on database.Uploaded the pics again and works great.

Posted 23-Feb-14 0:16am

abisheak Balaji