Simple PHP Database Application With Explanation
Hi Dear students in this post am going explain complete life cycle of very simple PHP---- Project.Before going to learn this you should have basic knowledge on XAMPP installation
And PHP Execution. I have provided links bellow if you wish to learn them.
Learn Article on XAMPP installation by clicking following link xampp installation
Learn Executing PHP on XAMPP Server by clicking following link xampp execution
About This Simple Project:
This is a simple Database application, In detail MySQL database table has 3 fields which are user id,username,password.This simple project interface has two sections, One section is-- for inserting New username and Password to database table, Another section displays data from database table.
Database Specifications:
Database Name: db
Table Structure:
CREATE TABLE `users`( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `psd` varchar(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
Programs In Project:
1. Home.php
2. Insert.php
3. Update.php
4. Delete.php
5. Index.php
6. Connection.php
Programs Explanation:
1. Home.php
Home page contains three sections,First section is used to validate form input------
Fist section is for showing results form Database,Second section is for editing Data
2. Insert.php
This page contains functionality for inserting data into MySQL database.
3. Update.php
This page contains functionality for updating existing records in database.
4. Delete.php
This page contains functionality for deleting records from MySQL database.
5. Index.php
This page contains Simple code for redirect to header.
6. Connection.php
This file contains functionality which establishes connection to my sql database.
Download Project and Install: Installation Guide
1.Download Project---->unzip folder--->place project folder at c:\xampp\htdocs\
2.Open web browser type localhost\phpmyadmin
3.Create Database Name it db
4.Select created database and export sql file from project folder into database
5.Open Web browser and type localhost\projectname press enter
DOWNLOAD PROJECT
Category: PHP, Programming
0 comments