Storing/displaying image urls in a database?

[nitromaster]

Hi

Basically I have the following scenario:

User chooses picture from list. Picture info is added into the db, including url.

However I can't figure out how exactly i should be storing the url for the image.

 

What data type should i use? How to insert it/extract it (with the backlashes/etc neeeded) ? Should I store the full http://www.somesite.com/imageurl.jpg or just somesite.com/imageurl.jpg ? (as little as possible)

How do i then display it?

 

Had a quick search here...no luck finding what i'm looking for..had a look on google but ended up just finding info on the BLOB data type..which would be inserting the actual image binary data into the database i believe.

 

Any help?

 

Thanks

Martyn

[Andy-H]

just take necessary procedures to prevent sql injection (i.e. mysql_real_escape_string if your using mysql) and xss, (i.e. htmlentities ) I would store it as text...

 

[calmchess]

i do a half and half approach i store the file name with extension in the database then when i use it i'll write something like.....http://www.myrul.com/image/<?php echo $filename?> where $filename is the pic name from the database.

[nitromaster]

just take necessary procedures to prevent sql injection (i.e. mysql_real_escape_string if your using mysql) and xss, (i.e. htmlentities ) I would store it as text...

Thanks!!

 

[redarrow]

best quote today i say,,,, well said.....

 

just take necessary procedures to prevent sql injection (i.e. mysql_real_escape_string() if your using mysql) and xss, (i.e. htmlentities() ) I would store it as text...

 

50 books in one sentence.