Skip navigation
Currently Being Moderated

Best approach to a form/data problem

Dec 10, 2012 3:59 PM

I'm working with CS5.5. I have a website for a softball organization, 4 teams. 2 of the upper level teams (16u and 18u) have a "player profile" page for each player which contains info and stats for prospective colleges and recruiters. Each profile page also has a couple of still images and a video file. Currently these individual pages are updated and maintained by hand.  What I would like to do is create a page that a "player or parent" can login to and have their unique profile (just the text, not the pictures or video) displayed in a "form" that they can edit/update/save and have those changes reflected in their profile page on the website. Currently I keep all this info in table form in an excel file. There are only between 12-16 player profiles per team. What what I need to be able to do is - first display the text info in the player profile page dynamicaly. Then to edit/update the info - Populate a "form" with the current profile data - allow the user to change that data - save the changes to the data.

So.....

1st question is would it be better to use data in an XML file or a MySQL database ?  I have some experience dealing with XML but am new to MySQL.

 

2nd given the answer to the above, can you point me to some tuts that could get me started in the right direction.

 

thanks

Joel

 
Replies
  • Currently Being Moderated
    Dec 10, 2012 5:01 PM   in reply to jdhughen

    Ideally, you need a content management system (CMS) that is MySql & PHP driven.

     

    There are loads of open source frameworks you could use for this.  My first recommendation would be to look at WordPress Themes & Plugins for Sport Teams. 

     

     

     

    Nancy O.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 11, 2012 11:05 AM   in reply to jdhughen

    Changing mid-stream from static HTML to dynamic PHP is no small matter.  Among other things, you need:

    • good PHP coding skills,
    • familiarity with setting-up a MySql database,
    • and a local testing server such as WAMP, XAMPP or MAMP to test your work locally.

     

    Setting up a PHP environment in Dreamweaver

    http://www.adobe.com/devnet/dreamweaver/articles/setup_php.html

     

    Building your first dynamic website – Part 1: Setting up your site and database connection

    http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt 1.html

     

     

    Nancy O.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points