MySQL Image Database

ophidianthug

Howdy. Im setting up a webcomic, and want to organize the images into a databse to save space on my server and cut down on the number of extra pages.

My question is, what would I have to do to be able to store the location of the images on a database and call that information to the index.php file so that the strips can be viewed when the page loads? Ive dug through other webcomic sites and found that their strips are organized in a 'site.php?strip_id="xxxx"' format, but I am unsure how to tell the index to look to a database for the strip.

Any help would be much appreciated.

lazzerous

you would most likely set up an admin script for adding new comics

You'd select the comic image file off your hard drive, and give it a title along with whatever relevant information you feel is necessary

Once submitted, you would add the image to your server (move_uploaded_file()), and then take the info on that file and add it into a table

comics:
id int(6) unique auto_increment
title varchar(50)
description text
date_added datestamp
image_location varchar(75)

thus, you would have entry #7 with the image_location set to '/comics/deathToFurby.jpg' or whatever

your script for viewing comics would be ste up to recognize a variable, such as $comic_id

when you want to see the comic from entry #7, you would go to view_comic.php?comic_id=7

then your script would have a mysql query something like this:
select * from comics where id='$comic_id';

make sense?

ophidianthug

Ok, I understand that script, but Im not sure where each piece goes. At the moment, I have a table with a comic strip in the first row, and ZNews set up in the next row. The html for the strip is

So, if I wanted to grab the comic from a database rather than straight from the 'comic' folder would I change it to

And where would the "select * from comics where id='$comic_id';" query go, into a new document named 'view_comic.php' ?

ophidianthug

Still fumbling with this...

Ok, I have a "comics" database with a "comics" table with three fields:

id - 3 number id for each comic, set to auto_increment
date - date of publication
image_location - the URL for the strip

I have a page on the toplevel folder named "comic.php" with the script:

<?
include ("comic_include.php");
$comic_id = mysql_query (select * from comics where id='$strip_id'")
?>

The "comic_include.php" contains the database access info:

<?
$db_name="Comics";
$db_user="xxxx";
$db_password="xxxx";
$db_host="localhost";
$connection=mysql_connect("$db_host","$db_user","$db_password") or die ("error connection to sql");
$db=mysql_select_db($db_name ,$connection) or die ("error connection to Comics database");
?>

I changed the user/pass to x's for posting purposes of course. And in the index page where I'm trying to display the comic strips, I have a table with the HTML:

<?
<img src="comic.php?comic_id=4">
?>

Obviously this doesnt work, as Im sure there are a great number of mistakes im making, I just dont know what to change to what. I notice I have no code to tell the query to bring out the location of a strip...

(This is only my second day doing anything with PHP or MySQL, I was going to post this under the NewB section but Database seemed more appropriate.)