Example of Final Project

Introduction to Database Systems (2018 Spring)

This is a sample code of the final project. For those who have no idea about the tasks in the beginning, we provide a example here. Of course, you are allowed to modify the structure or anything you want.

Folder Structure

/example
    /auth
        (Backend files relative to "Auth")
    /css
        (Css files)
    /database
        (Main files of db operations)
    home.php
        (Files of the view)

The sample structure we provided for you is:

/example
    /auth
        login.php
    /css
        announce.css
        event.css
        home.css
        login.css
    /database
        auth.php
        database.php
    anncs.php
    events.php
    home.php
    login.php
    signup.php

For example, if you want to manage the control of anncs.php, you may do the following changes by adding files (remark *):

/example
    /anncs *
        add.php *
        delete.php *
        edit.php *
    /auth
        login.php
    /css
        announce.css
        event.css
        home.css
        login.css
    /database
        anncs.php *
        auth.php
        database.php
    anncs.php
    events.php
    home.php
    login.php
    signup.php

Diagram

Form post

There are several methods such as GET, POST , PUT, etc, for the web applications to transfer data between the websites. In /example/login.php, you can learn how to use the mothod POST there. Hint: You may also need to use method GET in your project.

Reference