huntrguy102 Posted February 17, 2010 Share Posted February 17, 2010 I have books in a database and I have all the pictures that I want to use. Is there a way to have these pictures in a database to pull and put on a page using php? Link to comment https://forums.phpfreaks.com/topic/192393-images-in-a-mysql-database/ Share on other sites More sharing options...
mapleleaf Posted February 17, 2010 Share Posted February 17, 2010 It will be better to store the image name(and path if needed) in the database and store the images in a directory. Link to comment https://forums.phpfreaks.com/topic/192393-images-in-a-mysql-database/#findComment-1013764 Share on other sites More sharing options...
huntrguy102 Posted February 17, 2010 Author Share Posted February 17, 2010 ok thanks. Link to comment https://forums.phpfreaks.com/topic/192393-images-in-a-mysql-database/#findComment-1013991 Share on other sites More sharing options...
huntrguy102 Posted February 17, 2010 Author Share Posted February 17, 2010 ok so I put them in a directory. But I'm still not sure on how to fetch the data from the database and post it. Link to comment https://forums.phpfreaks.com/topic/192393-images-in-a-mysql-database/#findComment-1014016 Share on other sites More sharing options...
mapleleaf Posted February 17, 2010 Share Posted February 17, 2010 so each image is associated with a book so you need the path to the image in the database in a field with the book entry Then you for example: ///$site_url is the full path of your domain $sql = "SELECT url WHERE book_id = '$book_id'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo $site_url.'/images/'.$row['url']; something like that Link to comment https://forums.phpfreaks.com/topic/192393-images-in-a-mysql-database/#findComment-1014020 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.