Local Offices Contact Directory Site using PHP and SQLite Free Source Code

Introduction

This is a PHP Project entitled Local Offices Contact Directories Site. This is a simple PHP and SQLite mini-project that serves as an online contact directory of offices for a state or city. The main goal of this web application is to provide information to the public about the local offices including their contact details. The application has only a minimum scope but enough to learn with for those who are learning and beginners in PHP Language.

I developed this project using the following:

• XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
• PHP Language
• SQLite Database
• HTML
• CSS
• JavaScript
• jQuery
• Ajax
• Bootstrap
• Summernote
• and more...

About the Local Offices Contact Directories Site

This simple website project has 3 modules which are the Public Side, Office Manager, and Admin Side. The Admin Side has simple features and functionalities which include managing the office master list and site information. The Public and Office Manager Side has the same user interface but the difference is that public visitor is only allowed to search office and view information while the office manager required to login in the site so they can manage their office details and add/manage their office's announcements. Each office registered in the system has only 1 system access credential.

Project Features

Admin Panel

• Secure Login/Logout
• Home Page
• Add Office
• List Offices
• Update Office Details
• Delete Office
• View Office Details
• View Office Announcements
• Manage (edit/delete) Office Announcements
• Manage System Users
• Update About Site Content
• Manage Account Credentials

Office System Manager Side

• Secure Login and register office details and credentials
• Home Page
• Displays List of Local Offices
• Can Search Office
• Can View Office Details
• List All Announcements
• Manage/Update Office Details and Credentials
• Post an Announcement
• Manage Posted Announcement
• Displays the Site's About Content

Public Side

• Home Page
• Displays List of Local Offices
• Visitors can search Office
• Visitors can View Office Details
• List All Announcements
• Displays the Site's About Content

Some of the System Snapshots

Public Home Page

Office Contact Details & Announcement View (Public)

Office System Manager Profile Page

Announcements Page

Admin Panel

Admin Side (Office Details)

The project source code is free to download on this website. Feel Free to download and modify the source code the way you wanter. Follow the instruction below to run this project.

How to Run

Requirements

• Download and Install any local web server such as XAMPP/WAMP.
• Download the provided source code zip file. (download button is located below)

Installation/Setup

1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and gd extension. Then, save the file.
2. Open your XAMPP/WAMP's Control Panel and start Apache.
3. Extract the downloaded source code zip file.
4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
5. Browse the Local Offices Contact Directories Site in a browser. i.e. http://localhost/contacts/.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Local Offices Contact Directories Site project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP Projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)