A website to create Pizza orders. Provides the required Website files and the Sql files to setup the database.
This was created as the final project for Appalachian State University's CS 3430: Database course.
The outer frame displayed by the different webpages was taken from [Appalachian State University's Food Services](http://foodservices.appstate.edu/) page.
As such, the majority of the **/website/includes/** and **/website/images/** are Appalachian State property.
Project Members: * Austin Keener ([DV8FromTheWorld](https://github.com/DV8FromTheWorld)) * James Corsi ([WamboJambo](https://github.com/WamboJambo)) * Tamarcus Garcia * Drew Morton
Class Name: CS 3430, Database
Class Teacher: Dr. Rahman Tashakkori
Class Semester: Spring Semester, 2015
- Bootstrap.js
- Bootstrap-Validator
- BootstrapFormHelpers
- JQuery
- Version: 1.11.2
- Download: Unneeded, it is downloaded in-line.
- Website
- All dependencies
- A PHP enabled Webserver (Apache HTTPd with PHP is recommended)
- An SQL compliant database implementation (MySQL is recommended)
You need to download the project either using Git pull or download a snapshot of the Master branch of this repo.
Snapshot
After you've downloaded, place /website/ in the web folder for your PHP enabled Webserver
NOTE: Do not include the root folder, only the contents of the root folder.
- Bootstrap.js
- Install Directory: /website/bootstrap/
- Copy contents of the bootstrap-VERSION-dist folder into the Install Directory.
- Files copied should include
- /css/
- /fonts/
- /js/
- Bootstrap-Validator
- Install Directory: /website/bootstrap/bootstrap-validator/
- Copy contents of the bootstrap-validator-VERSION folder into the Install Directory.
- Files copied should include
- /dist/
- /docs/
- /js/
- All other files in this folder.
- BootstrapFormHelpers
- Install Directory: /website/bootstrap/BootstrapFormHelpers/
- Copy contents of the BootstrapFormHelpers-VERSION folder into the Install Directory.
- Files copied should include
- /dist/
- /img/
- /js/
- /less/
- bfh-PLUGIN.jquery.json
- All other files in this folder
In the /sql/ folder there are 3 shell files to pay attention to: CreateDB.sh, DropDB.sh and Sql.sh.
These all interface directly with the MySql server through the linux command line. If you wish to use these to automate creating the database, then you need to edit them and populate their user, password and database values.
If you don't want to use the shell files, aren't using MySQL or you aren't on a unix based machine you can also use the **CreateDB.sql** files to create the database.
You will need to be logged into the Sql server and have created and selected the database which you want to work with.
[How to Create and Select a Database](http://dev.mysql.com/doc/refman/5.7/en/creating-database.html)
w
After you have created and selected you database, you will need to **source** the **CreateDB.sql** file into the database.
In the /website/ folder locate the connect.php file. You will need to populate the $server, $user, $pass and $db variables with the proper information needed to connect to the database you just created.
If the SQL server is running on the same machine as the PHP enabled Webserver, then $server should be "localhost".
Hopefully the setup process the went well and it all you now have a working website!