Hello, everyone! I have an acquaintance who knows that I've done some web design in the past, and wants me to rework a website for a group she's in. She is having trouble with their existing web developer not contacting them, and is planning on starting from scratch. If it was just the front-end design of the website, and some simple CMS stuff (wordpress), I'd be all good. However, her existing website has some additional features she'd like to keep (and update) that I don't have the slightest clue how to approach. Basically, it's the website is for a local sports team and it can keep track of the players, including different things like stats, and how much they've paid on things (or how much they owe). With the numbers they get, it will do simple calculations for them, and spit everything out to an exportable excel sheet (as well as show it in table form on the website itself). I've done my share of HTML, CSS, and javascript (read: front-side) but I'm not sure how to tackle this... I do have some programming experience (C+, Visual Basic, and actionscript) but it's been a while. Does anybody have any direction they can send me in, or comments or helpful advice? I'll have several months to get this project up and running (if I get it) but even if I don't, I'd like to expand my skills. What do I need to learn? Or are there any tutorials you know of that are along these lines? Thanks in advance!
You'll need PHP and (My)SQL skills, and some basic knowledge on how to manipulate Excel/CSV files. Any PHP+MySQL should get you going, and the Excel/CSV library are pretty easy to pick up. Just ask in DP if you have more questions about the building of the website - people don't bite. :-P
As far as Excel, there's a PEAR Excel library that's pretty easy to learn. It will allow you to send the user a spreadsheet generated from a database query. But as tyteen said, you'll have to learn SQL and PHP.