Team 21 Contact Manager

A full-stack contact management application built with a LAMP (Linux, Apache, MySQL, PHP) backend and a Javascript/HTML/CSS frontend.

Features

Backend API → Secure PHP endpoints that handles user accounts and contacts.
Frontend UI → A responsive interface where users can sign up, login, add, search, update, and delete their contacts.

Setup

1. Cloning the Repository

git clone git@github.com:levent-istifli/COP-4331-Small-Project.git

2. Database Setup

Import database schema into MySQL:

mysql -u root -p password < schema.sql

Populate database (optional):

python datagen.py
mysql -u root -p password < data.sql

3. Backend Configuration

Edit config.php with your database credentials:

define("DB_HOST", "localhost"); // or the host's ip address
define("DB_USER", "db_user");
define("DB_PASSWORD", "db_user_pwd");
define("DB_NAME", "name_of_db");

API Overview

The backend exposes REST-style enpoints under '/LAMPAPI'

Endpoint	Method	Description
/LAMPAPI/signup.php	POST	Register new user
/LAMPAPI/login.php	POST	Authenticate user
/LAMPAPI/add_contact.php	POST	Create contact
/LAMPAPI/search_contact.php	GET	Read/Search contacts
/LAMPAPI/update_contact.php	POST	Update contact
/LAMPAPI/delete_contact.php	POST	Delete contact

Example of API Interaction

Adding a user (POST /LAMPAPI/signup.php):

Request:

{
	"firstname": "John",
	"lastname": "Smith",
	"login": "jsmith",
	"password": "thisisgroup21"
}

Response:

If user already exist:

{
	"Error": "Login already exist"
}

If user does not exist:

{
	"Error": ""
}

Authors

Gradi Mbuyi → Database / API → gradimbuyi@outlook.com
Levent Istifli → API / Project Manager → tchesley.w@gmail.com
Trevor Chesley → Frontend / UI -> leventistifli@gmail.com