Image Attributes in Picture Database

[Anon]

Hello!

I've created a database to store my photo gallery, but I need a better way to update everything.

Is there any code I can add to an update script that will automatically grab and store the pic heights and widths for each pic?

OR

Is there any code to add to the output script that will dynamically determine these attributes and echo them in the output (preferred method)?

I'm just trying to get the dynamic gallery pages to load as fast as possible, and I heard that defining the image heights and widths will make it faster. Is this worth the effort to add this function?

Thanks!
newskool99

[Anon]

If you have the GD library installed under your system, you can load the image and use one of the functions to return the height and width.

I'ven't used GD yet, but I'm pretty confident that it will work.

-sridhar

[Anon]

It is worth the effort, especially since it's so easy! (And if you have any kind of a layout that uses tables you'll notice a speed difference in most browsers).

What you want is the GetImageSize() function, documented at:

http://www.php.net/manual/function.getimagesize.php

I'm working with this on my own site, I store all of the data into the database (no sense in making the box work harder than it needs to, if I can store it once and it doesn't change it might as well come out of the database rather than being computed every time...)

Anyway, read the above link (they've even thoughtfully included a piece of the array that outputs the correct browser tags for you).

HTH,

-- C

[Anon]

This sounds great! I read info at the link you mentioned, does this sound right?..

Option 1 - Add GetImageSize() to existing code:

// create thumbnail gallery table
echo "<BR><TABLE WIDTH=\"500\" BORDER=\"0\">";
echo "<TR>";
$i=1;
while ($row=mysql_fetch_array($result)) {
$PIC_ID = $row["PIC_ID"];
$TN_ID = $row["TN_ID"];

$PATH1 = $row["PATH1"];
$PATH2 = $row["PATH2"];
if (is_int($i/4)) {
// get thumbnail size and print table row
$size = GetImageSize ("$PATH2$TN_ID");
echo "<TD ALIGN=\"center\" HEIGHT=\"100\"><a href=\"$PATH1$PIC_ID\"><img src=\"$PATH2$TN_ID\" border=\"0\" $size[3]></a></TD></tr><tr>";
}
else {
// get thumbnail size and print table row
$size = GetImageSize ("$PATH2$TN_ID");
echo "<TD ALIGN=\"center\" HEIGHT=\"100\"><a href=\"$PATH1$PIC_ID\"><img src=\"$PATH2$TN_ID\" border=\"0\" $size[3]></a></TD>";
}
$i++;
}
echo "</TR>";
echo "</TABLE>";

option 2 - best option:

Use GetImageSize() when adding new pics and store in database and use something like

<img src=\"$PATH2$TN_ID\" border=\"0\" height=\"$height\" width=\"$width\">

Is that it? Is option 2 faster?

Thanks a mil!
newskool99

[Anon]

Thanks sridhar! I've heard the GD is very useful.. I hope to look into it more soon.

newskool99