Visitor Management System - PHP

VMS or Visitor Management System is an utility for the receptionists who have to maintain a bulky and a very-hard-to-maintain record books for all the visitors that visit the company for their various reasons.

VMS has 4 sub- sections, Front Page (Home), check in Visitor (for adding new visitors), View Data (for getting the visitor details - all fields) and a Check out Visitor page that shows Logged out visitor data for the present day!

DataBase Connects :

The project uses MySQLi as of now, to integrate the connections use the following 'keys';

DataBase Name = db_vms

(stores visitor details and user details)

Table = info_visitor

N A M E	T Y P E	E X T R A
Serial	int(11)	AUTO_INCREMENT
Name	char(50)
Contact	bigint(10)
Purpose	varchar(100)
meetingTo	varchar(100)
day	varchar(50)
month	int(2)
year	int(4)
Date	date
TimeIN	time
ReceiptID	int(6)
Status	varchar(100)
Comment	varchar(100)
TimeOUT	time
registeredBy	varchar(30)
loggedOutBy	varchar(30)
imagePath	varchar(100)
StudentName	varchar(40)
courseYear	int(1)
Hostel	varchar(80)

Table Name = login_info

N A M E	T Y P E	E X T R A
SnoPrimary	int(11)	AUTO_INCREAMENT
userName	varchar(30)	latin1_general_cs
pass	varchar(30)	latin1_general_cs

Project Development FINISHED SUCCESSFULLY

BY ~ Abayo Akinyi