nitromaster Posted December 24, 2009 Share Posted December 24, 2009 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 Link to comment https://forums.phpfreaks.com/topic/186270-storingdisplaying-image-urls-in-a-database/ Share on other sites More sharing options...
Andy-H Posted December 24, 2009 Share Posted December 24, 2009 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... Link to comment https://forums.phpfreaks.com/topic/186270-storingdisplaying-image-urls-in-a-database/#findComment-983754 Share on other sites More sharing options...
calmchess Posted December 24, 2009 Share Posted December 24, 2009 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. Link to comment https://forums.phpfreaks.com/topic/186270-storingdisplaying-image-urls-in-a-database/#findComment-983757 Share on other sites More sharing options...
nitromaster Posted January 10, 2010 Author Share Posted January 10, 2010 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!! Link to comment https://forums.phpfreaks.com/topic/186270-storingdisplaying-image-urls-in-a-database/#findComment-992149 Share on other sites More sharing options...
redarrow Posted January 10, 2010 Share Posted January 10, 2010 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. Link to comment https://forums.phpfreaks.com/topic/186270-storingdisplaying-image-urls-in-a-database/#findComment-992151 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.