Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    1
    Member #
    33247
    I am still somewhat new to php and web design in general. So if I seem to be completely clueless about somethings its because I am.

    But here is my problem. I am creating a website for the U.S. Presidents, Vice-Presidents & First Ladies. What I want to do is to enter their information into a database and then have a html page automatically created for that particular person. I know how I want the layout to be you can view a sample of a President's page here.

    I was told that I will need php (which I obviously kind of guessed) but I have searched long and hard to figure out how to write code to make this happen. If anyone can help, I would be eternally grateful.

  2.  

  3. #2
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    PHP and a MySQL DB is the way to go with this, but the answer is not a quick or easy one.

    You'll not only need that setup, but you'll also need a way to input the information as well as edit it once the data is in there.

    There are numerous ways of doing this, but before you start, you'll need to figure out what kind of information you're going to be working with and define a format for displaying the information.

    Creating the page to display the information will probably be the easiest part of this, usually creating the management part of it is more involved than his displaying it.

    As for the automatic page creation, that's kind of a mis- statement, your more likely to create a page that connects to the DB, based on a "key" or "variable", once that key is sent to the DB, the DB will then send the data to the page that you've created to display the data, so in reality, you can have one page that is capable of displaying hundreds if not thousands of pages of information.

    On top of that, strictly for SEO purposes, you'll want to use an apache module called mod-rewrite that is tied in with all that, that you can make the browser display each page as its own page so instead of having a URL like http://presidents.com/mypage.com?who=georgewashington to something more search engine friendly like http://presidents.com/george_washington/

    Since you're apparently new to all this a good place to start for PHP is http://w3schools.com and http://PHP.net

    Try downloading some sample content systems to see how they do the DB connections, reading and writing to the DB , then you can start building your own.

    I like http://hotscripts.com , there are tons of scripts there that you can download, use, deconstruct ( to see how they do it )...

  4. #3
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,717
    Member #
    5580
    Liked
    718 times
    To me it seems like an awful lot of work to enter the biographies for all of those people.
    You can get very detailed and comprehensive biographies already ....
    Example: http://en.wikipedia.org/wiki/Barbara_Bush

    Type this much: http://en.wikipedia.org/wiki/
    ... and then enter a name: http://en.wikipedia.org/wiki/Dwight_eisenhower

    Maybe your database list could be the wiki links entered with the correct names for each?

    It all seems so redundant. Too bad there isn't a free national database using API's.



Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 09:35 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com