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.
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.
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.
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 ??
Changing mid-stream from static HTML to dynamic PHP is no small matter. Among other things, you need:
Setting up a PHP environment in Dreamweaver
Building your first dynamic website – Part 1: Setting up your site and database connection
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.