This is a site for a preK-12 private Christian school. Grades 7-12 have an 8 period day and change classes just like any other middle or high school. We have regular sports, football, volleyball, basketball, baseball, wrestling, soccer, softball, golf, and cheerleading.
I have already written scripts for entering sports schedules & roster. Schedules can be updated with scores after each game is played. I have a script for teachers to enter the weeks homework and the student can retrieve that information set to their individual schedule. I have a script for the lunch menu, entry and retrieval. I have a script for entering news items for a scrolling box on the home page.
So, I already have a lot of database structure already set up. I have a user table for teachers/coaches/staff which is hit on login in (userid/password), so I know what they are allowed to have access to.
Right now, I have a link to click which pops up a new page for log in and updating information. What I had in mind was that I could have the log in form on included in the header.inc or footer.inc where the user could log in on the main page. Then when they browsed to a page that they were allowed to update, a small update link would be included on that page so they could click it and go to update mode.
I have about 5-6 pages on the site that need to be updated on a regular basis. The main one will be the alumni folder which will consist of several pages that need to be updated monthly. We are coming up on 50 years and there's a real push to get the alumni page updated often and regularly.
Because of navigation issues, I want to control the pages and their names. I don't want anyone adding pages except me or my successor.
I have a 9th grader, but there's a guy on the technology committee with me who has a 2nd grader and is capable of taking over for me when I'm gone. However, my goal is to get this site as hands off as possible before I leave.
Thanks,
Alisa