Skip to content

A registrar app built to work with "many to many" mySQL database

Notifications You must be signed in to change notification settings

CharlesAMoss/epic_Registrar

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

University Registrar

A registrar app built to work with "many to many" mySQL database, 8/25/2015

By Charles Moss & Tyler Deem

Description

An input field accepts a student's info of "name" and "date of enrollment". Another input field accepts course info of "name" and a "course number" (ex. HIST100). The user can enroll students into course and then view the enrolled students by course.

Setup

When installing from source you may notice that once you have cloned this repo, that this project makes use of a PHP Dependency Manager: Composer. Once you have Composer installed you can acquire any project dependencies via your shell by entering:

$ composer install

setting up mySQL database for this project

You then only need to start up a local PHP server from within the "web" directory within the project's folder and point your browser to whatever local host server you have created.

Database Setup

-> CREATE DATABASE registrar;

-> USE registrar;

-> CREATE TABLE students (id serial PRIMARY KEY, student_name varchar (255), enroll_date date);

-> CREATE TABLE courses (id serial PRIMARY KEY, course_name varchar (255), course_number varchar (255));

-> CREATE TABLE courses_students (id serial PRIMARY KEY, course_id int, student_id int);

An export of our database can be found in the db folder

Technologies Used

This project makes use of PHP, mySQL, the testing framework PHPUnit, the micro-framework Silex, and uses Twig templates.

Legal

Copyright (c) 2015 Charles A Moss & Tyler Deem

This software is licensed under the MIT license.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

About

A registrar app built to work with "many to many" mySQL database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages