This is a web-based system coded in PHP and MySQL that allows end-users to input personal fund raising data (such as the names, addresses, phone, money raised, etc.). The data from each user is compiled into one main MySQL database. The raw data is stored for each individual sale in one table and totals are computed and stored into a separate table. Administrators can export the compiled data into .csv files which can be read by Microsoft Excel, OpenOffice.org, or even a simple text editor. The system authentication consists of a user name and password for each end-user. The password is securely relayed to the server by means of a one-way hash function using a randomly generated ten digit key.
|Released||September 24, 2007|
|Current Version||May 15, 2008|
|Copyright||All Rights Reserved, 2008|
|Scripts||HTML, CSS, PHP, MySQL|
Tip: to search for a word or phrase press CTRL + F
This is the basic file structure within the "americanFund" directory. To read the explanation for each file please follow its link.
This section contains an explanation or summery of what each file does and it's significance in the operation of the fundraising system.
This file processes the information sent through a POST request coming from
the newSale.php html form. All the information recieved from the form is processed and inserted into the MySQL database.
This file is imported to the top of every page that needs to read/write to/from the MySQL database. It opens a connection to the database using the username and password the administrator has setup when the database was originally created.
Deletes all the sales of each and every user from the system. This will not delete any users.
Erases all data. Erases/clears the entire system of users and sales. This is used when you want to start entirely over at the start of a new fundraiser or year.
Imported to the top of each page in the /admin directory and contians:
This is the homepage for the /admin directory which is the control panel page.
Opens and reads the names of new users from studentRoster.txt, converts the list to HTML code, and then writes theconverted file to studentRosterHTML.txt. If there are any new names in the studentRoster.txt file they are inserted into the database as new users.
Lists all the usernames and passwords of all the users, including the administrator.
Exports all the usernames and passwords into a .csv file and makes it available for download. This file can be opened with common applacations such as Microsoft Excel, OpenOffice.org, or any simple text editor.
Enables the administrator to create new sales under the name of any end-user in the system.
Displays all the information about any individual sale.
Exports all the sales currently entered into the database and their information to a .csv file and makes it available for download. This file can be opened with common applacations such as Microsoft Excel, OpenOffice.org, or any simple text editor.
Displays all the sales of any individual user in a scrolling list style layout.
Exports all the information from salesIndividual.php. This includes date of sale, customer, fruit sold, nuts sold, total items sold, donations, and total money raised by that user.
Displays all sales currently in the database in a scrolling list style layout.
Exports all the information from salesSummary.php.
Add one or multiple names to this file in order to add them to the system as a new user. Follow the steps outlined here: add a new user to the system.
Displays all the information for any individual user enrolled in the system.
Contains the style information for this page. See the definition of Cascading Style Sheets.
This is the page you are currently looking at. The documentation page.
Validates the end-user by checking whether or not they have logged in. This file is imported to the header of every page that must be secure. Checks if the user is already logged in by using PHP Sessions. Wikipedia.org can explain what a basic session is in computer science. Here is the documentation on how to use sessions in PHP.
Contains common functions that are used from several places in the file structure.
Here is a brief explanation of the code:
Contains the MD5 (Message-Digest algorithm 5) encryption algorithm.
Displays any error message sent to it via a GET request.
Contains the style information for all the pages in the system. See the definition of Cascading Style Sheets.