Skip navigation
jdhughen
jdhughen
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

303 Views   4 Replies   Latest reply: jdhughen, Dec 11, 2012 12:49 PM
 
Replies
  • Nancy O.
    Currently Being Moderated
    1. Nancy O.,
    Dec 10, 2012 5:01 PM   in reply to jdhughen
    Report

    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:
  • jdhughen
    Currently Being Moderated
    2. jdhughen,
    Dec 10, 2012 7:01 PM   in reply to Nancy O.
    Report

    Thanks, I've already created the site using dreamweaver so I would prefer to continue working there since I know that. I never messed with wordpress. The site is complete. I have the "player profiles" already. I guess what I basicaly want to do is to change them from being static content to dynamic content and allow each player to "update" their own profile online which would update either a MySQL db or a XML file depending on which way I went. I've used dnamicaly loaded text from an XML file in flash, but thought that using MySQL might be more flexable going forward ??

     

    thanks

     

    Joel

     
    |
    Mark as:
  • Nancy O.
    Currently Being Moderated
    3. Nancy O.,
    Dec 11, 2012 11:05 AM   in reply to jdhughen
    Report

    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:
  • jdhughen
    Currently Being Moderated
    4. jdhughen,
    Dec 11, 2012 12:49 PM   in reply to Nancy O.
    Report

    Nancy,

     

    Thanks. I installed WAMP last night , set dreamweaver and did a couple of the std tuts. I will eventualy go that route but it's going to take longer to get it like I want it than I have time right now. I need to get this online for now so I decided to collect/update data via online pdf, then manually update a XML file with the XML I get from the PDF's. create a template for the displayed player profiles and populate via the master XML dynamicaly in a pop-up, Ie click on a players image and see their profile. Once I get it up I can back track and figure out the PHP/MySQL offline. And the data I collect from the PDFs will still be useable.

     

    Thanks

     

    Joel.

     
    |
    Mark as:
Actions

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