The Perfume Store is a simple store which sells perfumes. The purpose of this project was to demonstrate a shopping cart system. The store works by allowing a visitor to the site to create an account and then once they have created an account to log in and add the items they want to purchase to their shopping cart. The database stores the items that are in a persons shopping cart for as long as they want. The user can update the items in their cart if they want more or they can remove them if they decide they do not want them anymore. When the shopper is ready to "check-out" they simply click the check-out link at the top and all the items current in their shopping cart are placed into an order. The final step is to fill in the shipping and billing addresses (if they are different from the default address information supplied when the user created their account). A user can check on their previously completed orders at any time. Since this is just a simple demonstration nothing actually happens when an order is finalized, and there is no way (except directly editing the database) to change the items in inventory.
Contains definitions for global database object used in other scripts for connecting to database and executing queries.
Contains basic functions used by all scripts for things like creating a new HTML page.
This is my personal web site. The web site is run using PHP scripts with a MySQL database acting as the backend. I can add new entires to the main page of my web site by going to the admin.php script. From this page I can add, remove, and edit log entires. These are the files used:
This script handles logging in. The password is hard coded into the script and when a user logs in it will display to them three options. It also handles logging out. When the user is logged in a cookie is set on their computer to keep track of the fact that they are logged in. The "Show Side Bars" option is not functional yet.
This script shows an overview of all the log data contained in the database by default. It also will show the full details of individual log entries.
This script is used to enter new log entries.
This script is used to edit log entries.
This script is used to delete log entries.
This script is not yet complete. Currently it only shows an over view of all the various "groups" of side bars. When completed it will allow you to create new groups, rearrange them, delete groups, and edit the individual items in each group.
This is the main page that shows when someone goes to the webpage. It pulls all data neccessary for the page from the MySQL database.
This script is a set of common functions used in all the other scripts.
This script contains functions related to database connectivity.
This is a script I wrote to keep track of my database designs. It does not actually create a database, rather it just stores the logical design information for the database. I am currently working on making it so that it can generate a 2-D image showing all the tables and the relationships in any given database that it is storing logical design information about. One thing that I like about this script is that I have made it so that I can store notes about virtually any part of the database, which is helpfull in fully documenting how a logical database design is suppose to work. You are allowed to enter notes for any given database, talbe, or individual field.
This is like the index for the directory. It shows the viewer a list of all the databases in the system along with their creation date and the date they were last modified. From this screen the user can view, edit, or delete one of the databases in the system. They can also create a new database from screen and access the field type setup (type_setup.php) menu. If the user selects to view the details of any of the databases then this script will handle that request also by showing a list of all the tables in the selected database.
This is where the user can specify the field types that are valid in the database documentation system. Common entries would be things like "int" for an integer field, "char" for a character field, etc... The list that the user creates here is the same list that user selects from when choosing the field type for a newly created field.
This allows the user to change the name of a database or update the notes about that database.
This allows the user to delete an entire database from the documentation system.
This allows the user to create a new database in the database documentation system
This allows the user to view the details of an individual table within a database. It will show them the list of fields on that table along with the field type and other important information such as if the field is part of a primary key.
This allows the user to change the name of a table and to update the comments associated with the table.
This allows the user to delete a table definition from the database schema documentation system
This allows the user to create a new table definition in the database schema documentation system
This shows a list of all the fields in a given table along with other important information about those fields such as their data type, if they are part of a primary key, and whether or not the field allows null values.
This function is not yet complete, but its purpose is to show all the details of an individual column (field) including any notes associated with that column.
This allows a user to change any aspect of an individual column definition.
This allows a user to remove a column definition from the database documentation system
This allows a user to add a new column to the currently selected database and table.
This is a set of functions commonly used in the other scripts in this project.
This script contains functions related to database connectivity.
This is a sample image created to test the possiblity of have the database documentation system automatically create database entity relationship diagrams.