In message <[EMAIL PROTECTED]>
, Grant Pollet <[EMAIL PROTECTED]> writes
>I am trying to create a website so that I can show property listings from a
>MySQL database. I want to include pictures. Has anyone every dabbled with
>this? I have 2 ideas on this: I can either save the pictures on the
>webserver and store some sort of reference to the picture in the field OR
>save the actual picture in the database.
>
>I've worked with databases before, but I've never tried this. Has anyone
>ever done something similar? What do you recommend?
>
>Thanks,
>Grant
I have a few property listing sites, and usually use a standard
reference to find the properties. So property 123 has a picture at
images/thumbnails/123_1.jpg, and one at images/thumbnails/123_2.jpg,
etc. I also have a larger copy of the picture ("click on thumbnail to
view full size") at images/view/123_1.jpg
Usually, I have a boolean field in the database to say if the image is
there, but sometimes I use file exists().
I am not sure whether this is faster than storing in a database or not,
I believe that it is, I have never tested in with large amounts of data,
but it is certainly easier to handle the graphics.
Also, I sometimes store the URL of the graphic in the database,
especially if the graphic is likely to be on another server, where there
is co-operation with other sites.
--
Pete Clark
Free advertising for your website, business, or organisation at:
http://www.hotcosta.com/resources.php
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
