Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
03-19-2010, 11:47 AM #1
- Join Date
- Mar 2010
- Thanked 0 Times in 0 Posts
Going nuts: Comic Navigation site
here's what I want to do:
I want to make a webpage that does a few things...
I want it to have an ID navigation, like .php%Id=1 or however that looks.
I want to ID to display a page that also has a comic page (image) with the same ID and some information with it related to that comic.
I imagine there would be some SQL stuff involved. It'd be great to be able to make a page where I can select a image off my computer, type in some text information, and submit it.
In my original idea, doing so would generate a new webpage on my server (another .php with a new ID, like page 10 when the last is page 9) and then the PHP just references it.
I heard SQL can store information. It works in tables, and has like an ID for each row and information in that row. I can understand maybe getting the submitted information (from the textfield in the upload) but how do I get it to reference an image? If I had it uploaded to the server in a folder, can I have the SQL table contain a link?
Is there a way I can have it so it says /images/comic*.jpg where * is equal to the ID?
I also want a next and previous button which basically say "Go to this ID+1 or go to this ID-1"
Then I want the main page to show the comic (image) equal to the ID, and the information with the ID as well.
My problem is I don't understand how to have a webpage generate this information and show it. I don't see how an SQL database can link and image, and I don't understand uploading an image into the database.
I'm a moron entirely at coding. I don't know PHP syntax and I don't know SQL scripting. I can understand it if people define what code lines do though.
Can ANYONE help me? I need this done today.
My ideal page would work like this:
img src href="images/image(#= Page ID).jpg"
information based on SQL database =page ID
Previous (ID -1, not less than 1) Next (ID+1, not more than total amount)
Last edited by AngryRobot; 03-19-2010 at 12:06 PM.
03-19-2010, 01:32 PM #2
- Join Date
- Jun 2003
- Cottage Grove, Minnesota
- Thanked 1,094 Times in 1,085 Posts
Have you considered using WordPress for your site?
WordPress doesn't just have to be for blogs. You can customize it
to be a CMS-based system for your website ... and you can make
your own templates and graphics for it.