A tracker with admin panel to track announcements on pages (mainly targeted to parents announcements)
==================== Project is to build a database-driven CRUD app to replace the current static page at http://www.binghamton.edu/dean-of-students/deans-message.html using PHP and MySQL.
Requirements:
- Password-protected admin interface
- Each newsletter consists of a subject (title) and body, like an email
- Newsletters will be stored in a new MySQL database
- Admin users can create, update, delete newsletters
- Admin can change the current version,create drafts, publish.
- Site visitors can search newsletters and view matching search results
- The site will display the most recent newsletter, with links to archived newsletters from previous months
We will be wrapping this in the standard University stylesheet and template.
=====================
Instalation Notes:
Run the database script at /base/db.sql to create the required database/table. It also creates an initial admin entry. The admin entry must be in the format of username and MD5 hash password.
The inital entry created will contain:
- Username: root
- Password: root