Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2010
    Posts
    1
    Thanks
    0
    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:

    http://www.website.com/page%id=1

    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 11:06 AM.

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •