Showing Photo's

Anon

I am totally new at writing scripts, so please respond in plain English. We have a database with recipes. When someone searches for a recipe, we have a results page that will pull up all the ingredients. How do we set it up to also display a photo? Since we can not put the actual photo in the dB, I am a bit confused how we can call it up for display. We are using MySql and PHP 4.2
Thanks
Frank

Anon

First of all: you can put the images themselves into the database (take a look at the MySQL manual at mysql.com for more info on binary data in a table).

Secondly you could use a varchar() field to store path- and filenames of your images relative to executing script. Your table might look like this:

id|recipe_name|recipe_description|image_path

1|Cake |Blablab, something|1.jpg
2|Steak |whatever.. |2.jpg

and so forth. That way the images won't be stored in the db, but their relation to the individual recipes will be recorded.

Hmm... now I'm hungry... all this talk of cake and steak...
;-)

Anon

Thanks for your help. I was able to get the photos to show up. Now I have another question. I am putting some photo's into a gallery and I want to start by showing the thumbnails, but have an option where the visitor can click on the photo and have it open up full size.
Here is the script I am using for the thumb. What script can I add to give them the option of seeing it full size?
Thanks
Frank

while ($result = mysql_fetch_array($query)) {
$title= $result["title"];
$photo= $result["photo"];

// Using HTML "img" tags for the photos, it selects the photo by it's "id" number

echo "$title ";
echo ("<img src=\"$photo\" border=0><HR width=400 align=left>");
}

Anon

You could do either two things:

You can actually make thumbnails of your graphics, store them in the file structure, and retrieve them the say way you retrieved the other photos, or

you could use a script to dynamically resize a photo for use as a thumbnail.

The first will take time, the second will take computer resources.

The way you're doing it now wouldn't be beneficial, as you're just sending the full size images, and letting the browser resize them (not a good idea&trade😉

Anon

Hi,
Thanks for the input. Actually, what I am doing is having the thumbnails show up on the results page. What I am trying to do, is set it up so a visitor can click on the thumbnail and have it link to another page with a larger image. I use different file names for each size in my database.
So, using the script below, what do I need to add to have it hyperlink to the larger image?

$per_page = 10;

// Selects all of the data from database

$sql_text = ("SELECT * from photo ORDER BY id DESC");

// Sets page number, if no page is specified, it will create page 1

if(!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;

$query = @($sql_text);

// Sets up specified page

$page_start = ($per_page * $page) - $per_page;

$num_rows = @mysql_num_rows($query);

if($num_rows <= $per_page) {
$num_pages = 1;
}
else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
}
else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;

if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}

$sql_text = $sql_text . " LIMIT $page_start, $per_page";
$query = mysql_query($sql_text);

<title>US Legacies Old Photographs</title>
<body bgcolor="#ffffff">
<blockquote> There are currently
<?php echo "$num_rows"; ?>  photos in this photograph collection

<?php

while ($result = mysql_fetch_array($query)) {
$title= $result["title"];
$photo= $result["photo_thumb"];

// Using HTML "img" tags for the photos, it selects the photo by it's "id" number

echo "$title ";
echo ("<img src=\"$photo\" border=0><HR width=400 align=left>");
}

// This displays the "Previous" link

if ($prev_page) {
echo "<a href=\"$PHP_SELF?page=$prev_page\">< Prev</a>";
}

// This loops the Pages and displays individual links corresponding
// to the photos.

for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo " <a href=$PHP_SELF?page=$i>$i</a>";
} else {
echo " $i ";
}
}

// This displays the "Next" link.

if ($page != $num_pages) {
echo " |<a href=\"$PHP_SELF?page=$next_page\"> Next ></a>" ;
}