Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

[hardinera]

jan,

thanks for your help

silly me forgot to set the query first for the $id lol

<?php echo("<img src=\"show.php?id=$id\" />"); ?>

this code surely helped me... thanks a lot

>.> QUESTION AGAIN

what if there is no image on the selected row?

i cant print *no selected image*

do i have to use if else statement in printing?

[Jan]

I'd check if your image column is empty with: if(!empty($row['image'])) before callling Jaan's image download script. If it's empty you can show a default image.

[Orjan]

You can always, in your show.php state an id that is going to be shown if the given ID does not exist. Anything could be done.

[kadalpenguk]

tq, i'll try

[ssSuave]

Hi thanks again for the tutorial.

So my upload form is working perfectly on Safari and FF but it fails to work on IE. The image just does not get uploaded.
It is really annoying and I cannot figure it out. I have tried searching for an answer on google but couldn't find anything. I know i am not the only one since there were other people who had the same problem but I couldn't find any solutions. I read something about how instead of "enctype" there should be "encoding" for IE but i don't know how to integrate it. I would Really appreciate your help.

Thank you in advance

[phillw]

Thanks for the tutorial - between you and Jordan - exactly what I've been trawling round looking for.

Regards,

Phill.

[Jordan]

You're welcome (from me for Part I), lol.

[phillw]

He he - I [I]thought[I] this was going all too well

Refering back to part1, I had to change to medium-blob because of image size.

The output is fine, but my browser (Shiretoko - FireFox 3.5) displays the image at 67% to fit it in a non-scrolling window.

Having read through the posts I'm guessing (and it is a guess) I'm going to need something like GD ?

Now, don't get me wrong - I'm keen to learn this stuff, but..... Is there a way to force the image to display at 100% ?

Some of the images are A4 size (about US Letter), and need to be displayed at 100%.
I've asked Jordan about the best way to lower the file-size (they're 200k), possibly lowering the resolution to 92dpi for screen display - but I'd still need them to display at 100% scale.

I thought along the lines of forcing the display to x pixels by y pixels, but the images are not all the same size due to some cropping I did of the original image files.

They are currently 'hard-coded' into html, obviously I'm looking to make it dynamic.

To give you some sort of idea of where I'm headed for the ones that need to be 100%, they can be seen at M.G. Judd Ltd. - Replacement Ignition & Door Keys

I stress that that is a very much W-I-P area, where I've been learning how to put together a media CSS and a print CSS, along with non-java rolling buttons, etc , so there are not many pages that have data in them. (Home, Contact us & Starting handles....., from memory) - In my defense, it is all hand-coded !

Now, per-se, I am open to having these pages remain as static. (they don't change), and I can still use the MySQL data for making the tables with (altough, again, as you can see from the mini-table at the top - formatting it would possibly be more touble than it is worth.
Fortunately, the other pages aren't anything like these!!
But, whichever way I do it, I go back to issues of bandwidth, so am at a bit of a pondery as to a fairly 'industry-standard' way of doing it.
Is it okay to mix static & dynamic ?

Regards,

Phill.

[Vswe]

Awesome, thanks Jaan. +rep of course.

[madhaninfo]

$id = $_GET['id']; from which page this id no is getting please tell me