It is a simple Web-based phonebook application which stores and displays ID, Name, Contact No, and Address of a person. It is also capable of updating/editing and deleting phonebook entries.
CREATE TABLE `phonebook` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL,
`phone_no` VARCHAR(15) NOT NULL,
`address` VARCHAR(50) NOT NULL,
`date_created DATETIME` NOT NULL DEFAULT ‘0000-00-00 00:00:00’,