Personal Contact Manager – LAMP Stack Web Application

📌 Project Overview

This project is a full-stack, API-driven personal contact manager developed as part of a small group software engineering project. The application allows users to register, log in, and securely manage their own contacts, including creating, viewing, searching, updating, and deleting contact records.

The application is deployed on a remote server, accessed via a custom domain, and demonstrated live during a team presentation.

✨ Features

User Accounts

• User registration (sign up)
• User login with credentials
• Users can only access their own data

Contact Management (CRUD)

Logged-in users can:

• Create new contacts
• View all of their contacts
• Update existing contacts
• Delete contacts (with confirmation)

Contact Fields

Each contact includes:

• First Name
• Last Name
• Email
• Phone Number
• Date Created
• Associated User ID

Search

• Server-side search using MySQL queries
• Partial match support (e.g., Jo → John, Jones)
• Case-insensitive
• No client-side caching of contact lists

🗄️ Database Schema

Users Table

Field	Type
ID	INT (PK)
FirstName	VARCHAR(50)
LastName	VARCHAR(50)
Login	VARCHAR(50)
Password	VARCHAR(50)

Contacts Table

Field	Type
ID	INT (PK)
FirstName	VARCHAR(50)
LastName	VARCHAR(50)
Phone	VARCHAR(50)
Email	VARCHAR(50)
UserID	INT (FK)

🚀 Deployment & Setup Guide (LAMP)

1️⃣ Create a LAMP Server

1. Create a DigitalOcean LAMP Droplet

   • Ubuntu
   • Basic Plan ($7/month)

2. Set and save your root password

3. SSH into the server:

   ssh root@your_domain_or_ip

Apache, MySQL, and PHP are preinstalled.

2️⃣ Configure Web Root

cd /var/www/html

Directory structure:

/var/www/html
│── index.html
│── css/
│── js/
│── images/
│── LAMPAPI/

3️⃣ Database Setup

Login to MySQL:

mysql -u root -p

Create database:

CREATE DATABASE COP4331;
USE COP4331;

Create tables:

CREATE TABLE Users (
  ID INT AUTO_INCREMENT PRIMARY KEY,
  FirstName VARCHAR(50),
  LastName VARCHAR(50),
  Login VARCHAR(50),
  Password VARCHAR(50)
);

CREATE TABLE Contacts (
  ID INT AUTO_INCREMENT PRIMARY KEY,
  FirstName VARCHAR(50),
  LastName VARCHAR(50),
  Phone VARCHAR(50),
  Email VARCHAR(50),
  UserID INT
);

Create database user:

CREATE USER 'TheBeast' IDENTIFIED BY 'WeLoveCOP4331';
GRANT ALL PRIVILEGES ON COP4331.* TO 'TheBeast'@'%';

4️⃣ API Configuration

All API endpoints live in:

/var/www/html/LAMPAPI

Each PHP file must include:

$conn = new mysqli("localhost", "TheBeast", "WeLoveCOP4331", "COP4331");

5️⃣ Frontend Deployment

Upload:

• index.html
• contacts.html
• /css
• /js
• /images

Use FileZilla or SFTP for uploads.

🔌 API Usage

Example: Login

POST /LAMPAPI/Login.php

{
  "login": "username",
  "password": "password"
}

Example: Search Contacts

POST /LAMPAPI/SearchContacts.php

{
  "userId": 1,
  "search": "Jo"
}

Responses are returned as JSON objects or arrays.

⚠️ Important Notes

• No localhost demos – application must be live
• No Python frameworks used
• Search is server-side only
• Users can only access their own data
• All communication uses JSON
• Repository is public as required

📎 Links

• Live Application: (add domain here)
• SwaggerHub API: (add link here)