[UPHPU] Some Database setup help

Ashley Oviatt ashovi at qwest.net
Thu May 20 11:39:19 MDT 2004


We have considered it, but it's easier for our designers to edit images 
if they can just know where the file is and edit it without having to go 
to the db to do it.

Ash

District Webmaster wrote:

> Have you considered storing the image in the database? This helps with
> data portability and some security issues. You would want a blob field
> to store an image.
> 
> Dave
> 
> 
>>>>"Ashley Oviatt" <ashovi at qwest.net> 05/20/04 11:15 AM >>>
> 
> I'm setting up a MySQL database to store file locations (of images) that
> 
> will be used in a pdflib application.
> 
> The php page will have to look into the database for the file location 
> (all on the local server, this is an internal process at this point) and
> 
> then tell the location to pdflib according to what month it is/which 
> image it is supposed to use/which logo it is supposed to use/ etc.
> 
> My question is what is the best way to set up the database to do that? 
> As in what types of fields should I use? Mediumtext? int? varchar?
> 
> And what fields should I include besides just id and maybe timestamp? I 
> need some of the images to link to another user table (ie. a picture of 
> a person and their logo needs to be linked to the person's contact data 
> in another table in the same db.)
> 
> Thanks,
> 
> Ashley
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: list-unsubscribe at uphpu.org
> For additional commands, e-mail: list-help at uphpu.org
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: list-unsubscribe at uphpu.org
> For additional commands, e-mail: list-help at uphpu.org
> 
> 
> 
> 




More information about the UPHPU mailing list