Lodius2000 Posted May 27, 2008 Share Posted May 27, 2008 also posted in the MySQL help forum:: how do you store images/video in a table field, how do you get them there, what field type do you use, how do you translate them from their storage type back into an image/video, because i gather that they do not stay in their original form if this is a huge involved answer feel free to post a link to a tutorial, I cant seem to find any that are written in plain english though Thanks in advance Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/ Share on other sites More sharing options...
haku Posted May 27, 2008 Share Posted May 27, 2008 also posted in the MySQL help forum:: Then don't post it here. It's bad form. Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-550529 Share on other sites More sharing options...
Lodius2000 Posted May 27, 2008 Author Share Posted May 27, 2008 Then don't post it here. It's bad form. wouldnt have but decided here was the place where I would get an answer sooner and cant figure out how to delete from other forum Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-550535 Share on other sites More sharing options...
Smackie Posted May 27, 2008 Share Posted May 27, 2008 also posted in the MySQL help forum:: how do you store images/video in a table field, how do you get them there, what field type do you use, how do you translate them from their storage type back into an image/video, because i gather that they do not stay in their original form if this is a huge involved answer feel free to post a link to a tutorial, I cant seem to find any that are written in plain english though Thanks in advance first off let me say putting images and/or videos into mysql is a waste of mysql space. why not put the images or your videos on your server, create a database that holds all the urls of the images and videos and create a query that will call upon them and output them or even links? like say you want to call up an image <?php $sql = "SELECT images FROM database ORDER BY id"; $result = mysql_query($sql); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo '<img src="images/'.image.'">'; } ?> btw i threw this together so not sure if it will work right but.. as you can see it will call out all the images by id.. but it will give you an idea of what im talking about. Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-550545 Share on other sites More sharing options...
Lodius2000 Posted May 28, 2008 Author Share Posted May 28, 2008 that helps , hadn't thought about it that way, thanks Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-552179 Share on other sites More sharing options...
.josh Posted May 28, 2008 Share Posted May 28, 2008 also posted in the MySQL help forum:: thread closed. Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-552180 Share on other sites More sharing options...
.josh Posted May 28, 2008 Share Posted May 28, 2008 p.s.- wouldnt have but decided here was the place where I would get an answer sooner and cant figure out how to delete from other forum You should be posting in the forum it relates to, not the place you think will get a faster response. Link to comment https://forums.phpfreaks.com/topic/107384-solved-mysql-newb-question-concerning-multimedia-storage/#findComment-552182 Share on other sites More sharing options...
Recommended Posts