How to Create Employee Manager in PHP MySQL

Hi, in this article we are going to create How to Create Employee Manager in PHP MySQL. This project Employee manager System has been developed in PHP and MySQL. The main objective of developing this project is to manage many types of work-related employees. It can help for the employer to contain all the records of employee details features. this project based on CRUD system. Creating CRUD is a very common task in web development CRUD stand For Create, Read, Update and Delete. The main purpose of a CRUD system is that enables users to create, read, update, and delete data. Normally data stored in MySQL Database. PHP is the server-side scripting language that manipulates MySQL Database tables to give Front-end users power to perform CRUD action.

How to Create Employee Manager in PHP MySQL

1-Creating Database

Open Phpmyadmin in your Browser
Click on Database Tab Display on Top side
Give the Database name “employee”.
After Creating Database Open it.
Click on SQL Tab on Top area
Copy the Below Source Code and paste it.
Then Click on Go.

-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 27, 2018 at 09:32 PM
-- Server version: 10.1.26-MariaDB
-- PHP Version: 7.1.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `employee`
--

-- --------------------------------------------------------

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `emp_id` int(5) NOT NULL,
  `emp_email` varchar(30) NOT NULL,
  `emp_name` varchar(30) NOT NULL,
  `emp_phone` bigint(12) NOT NULL,
  `emp_dob` date NOT NULL,
  `emp_address` varchar(100) NOT NULL,
  `emp_dept` varchar(30) NOT NULL,
  `emp_status` varchar(20) NOT NULL,
  `emp_password` varchar(16) NOT NULL,
  `emp_joindate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`emp_id`, `emp_email`, `emp_name`, `emp_phone`, `emp_dob`, `emp_address`, `emp_dept`, `emp_status`, `emp_password`, `emp_joindate`) VALUES
(8, 'deepak.suhawal@gmail.com', 'DeepakRaj', 7525929273, '2018-01-17', 'Gomati Nagar\r\n79', 'Leader', 'Office', '00124578', '2018-01-27'),
(9, 'Example@mail.com', 'Abhi', 124578983, '2018-01-09', 'India ', 'Leader', 'Contract', '12345', '2018-01-28'),
(10, 'example@email.com', 'Alku', 2145789876, '2018-01-03', 'America', 'Supervisor', 'Contract', '2112', '2018-01-28'),
(11, 'mail@mail.com', 'Babu', 7865342567, '2018-01-16', 'Pakistan', 'Operator', 'Outsourcing', '1234', '2018-01-29'),
(12, 'admin@admin.com', 'admin', 2356789833, '2018-01-09', 'India', 'Supervisor', 'Office', '1234', '2018-01-28'),
(13, 'achika.hyren@gmail.com', 'Achika', 9876787678, '2018-01-02', 'Lucknow', 'Supervisor', 'Office', '1234', '2018-01-28'),
(14, 'user@user.com', 'User', 8787987654, '2018-01-14', 'India', 'Supervisor', 'Contract', '12345', '2018-01-17');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`emp_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `emp_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

-- phpMyAdmin SQL Dump

-- version 4.7.0

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: Jan 27, 2018 at 09:32 PM

-- Server version: 10.1.26-MariaDB

-- PHP Version: 7.1.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;

/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;

/*!40101 SET @[email protected]@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `employee`

-- --------------------------------------------------------

-- Table structure for table `employee`

CREATE TABLE `employee` (

`emp_id` int(5) NOT NULL,

`emp_email` varchar(30) NOT NULL,

`emp_name` varchar(30) NOT NULL,

`emp_phone` bigint(12) NOT NULL,

`emp_dob` date NOT NULL,

`emp_address` varchar(100) NOT NULL,

`emp_dept` varchar(30) NOT NULL,

`emp_status` varchar(20) NOT NULL,

`emp_password` varchar(16) NOT NULL,

`emp_joindate` date NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `employee`

INSERT INTO `employee` (`emp_id`, `emp_email`, `emp_name`, `emp_phone`, `emp_dob`, `emp_address`, `emp_dept`, `emp_status`, `emp_password`, `emp_joindate`) VALUES

(8, '[email protected]om', 'DeepakRaj', 7525929273, '2018-01-17', 'Gomati Nagar\r\n79', 'Leader', 'Office', '00124578', '2018-01-27'),

(9, '[email protected]', 'Abhi', 124578983, '2018-01-09', 'India ', 'Leader', 'Contract', '12345', '2018-01-28'),

(10, '[email protected]', 'Alku', 2145789876, '2018-01-03', 'America', 'Supervisor', 'Contract', '2112', '2018-01-28'),

(11, '[email protected]', 'Babu', 7865342567, '2018-01-16', 'Pakistan', 'Operator', 'Outsourcing', '1234', '2018-01-29'),

(12, '[email protected]', 'admin', 2356789833, '2018-01-09', 'India', 'Supervisor', 'Office', '1234', '2018-01-28'),

(13, '[email protected]', 'Achika', 9876787678, '2018-01-02', 'Lucknow', 'Supervisor', 'Office', '1234', '2018-01-28'),

(14, '[email protected]', 'User', 8787987654, '2018-01-14', 'India', 'Supervisor', 'Contract', '12345', '2018-01-17');

-- Indexes for dumped tables

-- Indexes for table `employee`

ALTER TABLE `employee`

ADD PRIMARY KEY (`emp_id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `employee`

ALTER TABLE `employee`

MODIFY `emp_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;COMMIT;

/*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;

/*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;

/*!40101 SET [email protected]_COLLATION_CONNECTION */;

OR Import DB File

After Downloading the source code extract it in your root folder where found db folder to access db file.

Open Phpmyadmin in your Browser
Click on Database Tab Display on Top side
Give the Database name “employee“.
After Creating Database Open it.
Click on Import Tab on Top area
You can Find Db file in Downloaded source code Select it.
Then Click on Go.

2- Creating Database Connection

After import Database File then next step is creating database connection using php copy the below code and save it is as “connection.php”.

<?php
$db_host = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "employee";

$con = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (!$con) {
    die("Connection failed: " . mysqli_connect_error());
}
?>

<?php

$db_host = "localhost";

$db_user = "root";

$db_pass = "";

$db_name = "employee";

$con = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (!$con) {

die("Connection failed: " . mysqli_connect_error());

}

3 – Creating Index Page

This step we create a page named index.php where show all employee and manage all employee.

<?php
include("connection.php");
error_reporting(1);
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>How to Create Employee Manager in PHP MySQL</title>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
	

	<style>
		.content {
			margin-top: 80px;
		}
	</style>

</head>
<body>
	<nav class="navbar navbar-inverse navbar-fixed-top">
		<div class="container">
			<div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
			
			</div>
			<div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li class="active"><a href="index.php">All Employee</a></li>
					<li><a href="add.php">Add Employee</a></li>
				</ul>
			</div><!--/.nav-collapse -->
		</div>
	</nav>
	<div class="container">
		<div class="content">
			<h2>All Employee List</h2>
			<hr />

			<?php
			if(isset($_GET['emp_id']) == 'delete'){
				$del = $_GET['emp_id'];
				$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$del'");
				if(mysqli_num_rows($sql) == 0){
					echo '<div class="alert alert-info alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button> Data not found.</div>';
				}else{
					$delete = mysqli_query($con, "DELETE FROM employee WHERE emp_id='$del'");
					if($delete){
						echo '<div class="alert alert-primary alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Data successfully deleted.</div>';
					}else{
						echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button> Data failed deleted.</div>';
					}
				}
			}
			?>

			<form class="form-inline pull-right" method="get">
				<div class="form-group">
					<select name="filter" class="form-control" onChange="form.submit()">
						<option value="0">Filter Employee</option>
						<?php $filter = (isset($_GET['filter']) ? strtolower($_GET['filter']) : NULL);  ?>
						<option value="Contract" <?php if($filter == 'Contract'){ echo 'selected'; } ?>>Contract</option>
						<option value="Office" <?php if($filter == 'Office'){ echo 'selected'; } ?>>Office</option>
                        <option value="Outsourcing" <?php if($filter == 'Outsourcing'){ echo 'selected'; } ?>>Outsourcing</option>
					</select>
				</div>
			</form>
			<br />
			<br />
			<div class="table-responsive">
			<table class="table table-striped table-hover">
				<tr>
                    <th>No.</th>
					<th>ID</th>
					<th>Name</th>
                    <th>Address</th>
                    <th>Dob</th>
					<th>Phone</th>
					<th>Department</th>
					<th>Status</th>
                    <th>Tools</th>
				</tr>
				<?php
				if($filter){
					$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_status='$filter' ORDER BY emp_id ASC");
				}else{
					$sql = mysqli_query($con, "SELECT * FROM employee ORDER BY emp_id ASC");
				}
				if(mysqli_num_rows($sql) == 0){
					echo '<tr><td colspan="8">Data not found.</td></tr>';
				}else{
					$no = 1;
					while($row = mysqli_fetch_assoc($sql)){
						echo '
						<tr>
							<td>'.$no.'</td>
							<td>'.$row['emp_id'].'</td>
							<td><a href="profile.php?emp_id='.$row['emp_id'].'"> '.$row['emp_name'].'</a></td>
                            <td>'.$row['emp_address'].'</td>
                            <td>'.$row['emp_dob'].'</td>
							<td>'.$row['emp_phone'].'</td>
                            <td>'.$row['emp_dept'].'</td>
							<td>';
							if($row['emp_status'] == 'Contract'){
								echo '<span class="label label-success">Contract</span>';
							}
                            else if ($row['emp_status'] == 'Office' ){
								echo '<span class="label label-info">Office</span>';
							}
                            else if ($row['emp_status'] == 'Outsourcing' ){
								echo '<span class="label label-warning">Outsourcing</span>';
							}
						echo '
							</td>
							<td>

								<a href="edit.php?emp_id='.$row['emp_id'].'" title="Edit Data" class="btn btn-primary btn-sm"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span></a>
								
								<a href="password.php?emp_id='.$row['emp_id'].'" title="Change Password" data-placement="bottom" data-toggle="tooltip" class="btn btn-warning btn-sm"><span class="glyphicon glyphicon-refresh" aria-hidden="true"></span></a>
								
								<a href="index.php?emp_id='.$row['emp_id'].'" title="Delete Record" onclick="return confirm(\'You are sure will erase data. '.$row['emp_name'].'?\')" class="btn btn-danger btn-sm"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a>
							</td>
						</tr>
						';
						$no++;
					}
				}
				?>
			</table>
			</div>
		</div>
	</div><center>
	<p>&copy; <a href="http://sourcecodessite.com" target="_blank" title="Source Code Site - Download Source Code Free ">Sourcecodesite</a></p
		></center>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

<?php

include("connection.php");

error_reporting(1);

<!DOCTYPE html>

<head>

<title>How to Create Employee Manager in PHP MySQL</title>

<style>

.content {

margin-top: 80px;

}

</style>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

</div>

<li class="active"><a href="index.php">All Employee</a></li>

<li><a href="add.php">Add Employee</a></li>

</ul>

</div>

</div>

</nav>

<h2>All Employee List</h2>

<hr />

<?php

if(isset($_GET['emp_id']) == 'delete'){

$del = $_GET['emp_id'];

$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$del'");

if(mysqli_num_rows($sql) == 0){

echo '<div class="alert alert-info alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> Data not found.</div>';

}else{

$delete = mysqli_query($con, "DELETE FROM employee WHERE emp_id='$del'");

if($delete){

echo '<div class="alert alert-primary alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data successfully deleted.</div>';

}else{

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button> Data failed deleted.</div>';

}

<option value="0">Filter Employee</option>

<?php $filter = (isset($_GET['filter']) ? strtolower($_GET['filter']) : NULL); ?>

<option value="Contract" <?php if($filter == 'Contract'){ echo 'selected'; } ?>>Contract</option>

<option value="Office" <?php if($filter == 'Office'){ echo 'selected'; } ?>>Office</option>

<option value="Outsourcing" <?php if($filter == 'Outsourcing'){ echo 'selected'; } ?>>Outsourcing</option>

</select>

</div>

</form>

<br />

<tr>

<th>Address</th>

<th>Phone</th>

<th>Department</th>

<th>Status</th>

<th>Tools</th>

</tr>

<?php

if($filter){

$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_status='$filter' ORDER BY emp_id ASC");

}else{

$sql = mysqli_query($con, "SELECT * FROM employee ORDER BY emp_id ASC");

}

if(mysqli_num_rows($sql) == 0){

echo '<tr><td colspan="8">Data not found.</td></tr>';

}else{

$no = 1;

while($row = mysqli_fetch_assoc($sql)){

echo '

<tr>

<td>'.$row['emp_address'].'</td>

<td>'.$row['emp_phone'].'</td>

<td>';

if($row['emp_status'] == 'Contract'){

echo '<span class="label label-success">Contract</span>';

}

else if ($row['emp_status'] == 'Office' ){

echo '<span class="label label-info">Office</span>';

}

else if ($row['emp_status'] == 'Outsourcing' ){

echo '<span class="label label-warning">Outsourcing</span>';

}

echo '

</td>

<td>

</td>

</tr>

$no++;

}

</table>

</div>

</div><center>

<p>© <a href="http://sourcecodessite.com" target="_blank" title="Source Code Site - Download Source Code Free ">Sourcecodesite</a></p

></center>

</body>

</html>

4 – Creating Add Employee Page

This step create add employee form and validate using php.

<?php
include('connection.php');
extract($_POST);

if(isset($reg))
{

	//check user exists or not
	$que=mysqli_query($con,"select * from employee where emp_email='$eid'");
	if(mysqli_num_rows($que))
	{
	$m= "<p style='color:red'>This user already exists</p>";
	}
	else
	{
	//$pass=md5($p);
		
		
		
		$query="insert into employee values('','$eid','$name','$phone','$date','$address','$dept','$status','$p','$dob')";
		if(mysqli_query($con,$query))
		{
		$m= "Data saved successfully";
		}
		else
		{
		$m= "some error";
		}
	}
	}
?>

<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

<script>function checkPass()
{
    //Store the password field objects into variables ...
    var pass1 = document.getElementById('pass1');
    var pass2 = document.getElementById('pass2');
    //Store the Confimation Message Object ...
    var message = document.getElementById('confirmMessage');
    //Set the colors we will be using ...
    var goodColor = "#66cc66";
    var badColor = "#ff6666";
    //Compare the values in the password field 
    //and the confirmation field
    if(pass1.value == pass2.value){
        //The passwords match. 
        //Set the color to the good color and inform
        //the user that they have entered the correct password 
        pass2.style.backgroundColor = goodColor;
        message.style.color = goodColor;
        message.innerHTML = "Passwords Match"
    }else{
        //The passwords do not match.
        //Set the color to the bad color and
        //notify the user.
        pass2.style.backgroundColor = badColor;
        message.style.color = badColor;
        message.innerHTML = "Passwords Do Not Match!"
    }
} 
function validatephone(phone) 
{
    var maintainplus = '';
    var numval = phone.value
    if ( numval.charAt(0)=='+' )
    {
        var maintainplus = '';
    }
    curphonevar = numval.replace(/[\\A-Za-z!"£$%^&\,*+_={};:'@#~,.Š\/<>?|`¬\]\[]/g,'');
    phone.value = maintainplus + curphonevar;
    var maintainplus = '';
    phone.focus;
}
// validates text only
function Validate(txt) {
    txt.value = txt.value.replace(/[^a-zA-Z-'\n\r.]+/g, '');
}
// validate email
function email_validate(email)
{
var regMail = /^([_a-zA-Z0-9-]+)(\.[_a-zA-Z0-9-]+)*@([a-zA-Z0-9-]+\.)+([a-zA-Z]{2,3})$/;

    if(regMail.test(email) == false)
    {
    document.getElementById("status").innerHTML    = "<span class='warning'>Email address is not valid yet.</span>";
    }
    else
    {
    document.getElementById("status").innerHTML	= "<span class='valid'>Thanks, you have entered a valid Email address!</span>";	
    }
}
// validate date of birth
function dob_validate(dob)
{
var regDOB = /^(\d{1,2})[-\/](\d{1,2})[-\/](\d{4})$/;

    if(regDOB.test(dob) == false)
    {
    document.getElementById("statusDOB").innerHTML	= "<span class='warning'>DOB is only used to verify your age.</span>";
    }
    else
    {
    document.getElementById("statusDOB").innerHTML	= "<span class='valid'>Thanks, you have entered a valid DOB!</span>";	
    }
}
// validate address
function add_validate(address)
{
var regAdd = /^(?=.*\d)[a-zA-Z\s\d\/]+$/;
  
    if(regAdd.test(address) == false)
    {
    document.getElementById("statusAdd").innerHTML	= "<span class='warning'>Address is not valid yet.</span>";
    }
    else
    {
    document.getElementById("statusAdd").innerHTML	= "<span class='valid'>Thanks, Address looks valid!</span>";	
    }
}

</script>
   
 <style>body {
    padding-top:50px;
}
fieldset {
    border: thin solid #ccc; 
    border-radius: 4px;
    padding: 20px;
    padding-left: 40px;
    background: #fbfbfb;
}
legend {
   color: #678;
}
.form-control {
    width: 95%;
}
label small {
    color: #678 !important;
}
span.req {
    color:maroon;
    font-size: 112%;
}
</style>     

	
	
</head>
<body>
 <nav class="navbar navbar-inverse navbar-fixed-top">
		<div class="container">
			<div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
				
			</div>
			<div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li><a href="index.php">Employee List</a></li>
					<li class="active"><a href="add.php">Add Employee</a></li>
				</ul>
			</div><!--/.nav-collapse -->
		</div>
	</nav>   
	<br>
<div class="container">
	<div class="row">
        <div class="col-md-6">
            <form action="" method="post" id="fileForm" role="form">
            <fieldset><legend class="text-center"><span style="color:#000">Add New Employee </span></legend>
			
			
						<div class="form-group">
              		  <label for="email"><span class="req">* </span> Email Address: </label> 
                    	<input class="form-control" required type="text" name="eid" id = "email"  onchange="email_validate(this.value);" placeholder="Enter email"/>   
                        <div class="status" id="status"></div>
            </div>

			
			<div class="form-group"> 	 
                <label for="firstname"><span class="req">* </span> Employee Name: </label>
                    <input class="form-control" type="text" name="name" id = "txt" onkeyup = "Validate(this)" placeholder="Enter name" required /> 
                        <div id="errFirst"></div>    
            </div>

            <div class="form-group">
            <label for="phonenumber"><span class="req">* </span> Phone Number: </label>
                    <input required type="text" name="phone" id="phone" class="form-control phone" maxlength="28" onKeyUp="validatephone(this);" placeholder="Enter mobile no."/> 
            </div>

			<div class="form-group">
						<label for="phonenumber"><span class="req">* </span> Date Of Birth: </label>
								<input required type="date" name="date" class="form-control" placeholder="0000-00-00"/> 
						</div>
						
						<div class="form-group"> 	 
                <label for="address"><span class="req">* </span> Address: </label>
					<textarea name="address" class="form-control" placeholder="Enter address"></textarea>
                    
                        <div id="errFirst"></div>    
            </div>

			<div class="form-group">
					<label for="department"><span class="req">* </span> Depatment: </label>
					
						<select name="dept" class="form-control" required>
							<option value=""> ----- </option>
							<option value="Operator">Operator</option>
							<option value="Leader">Leader</option>
                            <option value="Supervisor">Supervisor</option>
							<option value="Manager">Manager</option>
						</select>
					
				</div>
				
				<div class="form-group">
					<label for="status"><span class="req">* </span> Status: </label>
					
						<select name="status" class="form-control">
							<option value=""> ----- </option>
                            <option value="Outsourcing">Outsourcing</option>
							<option value="Contract">Contract</option>
							<option value="Office">Office</option>
						</select>
					</div>
           

          <div class="form-group">
                <label for="password"><span class="req">* </span> Password: </label>
                    <input required name="p" type="password" class="form-control inputpass" minlength="4" maxlength="16"  id="pass1" placeholder="Enter password"/> </p>
					</div>
			<div class="form-group">
                <label for="password"><span class="req">* </span> Password Confirm: </label>
                    <input required name="password" type="password" class="form-control inputpass" minlength="4" maxlength="16" placeholder="Enter again password to validate"  id="pass2" onKeyUp="checkPass(); return false;" />
                        <span id="confirmMessage" class="confirmMessage"></span>
            </div>
	
						<div class="form-group">
						<label for="join_date"><span class="req">* </span> Join Date: </label>
								<input required type="date" name="dob" class="form-control" placeholder="0000-00-00"/> 
						</div>
            
               
                <hr>
<div>
                <input type="checkbox" required name="terms" onChange="this.setCustomValidity(validity.valueMissing ? 'Please indicate that you accept the Terms and Conditions' : '');" id="field_terms">  <label for="terms">I agree with the <a href="#" title="You may read our terms and conditions by clicking on this link">terms and conditions</a> for Registration.</label><span class="req">* </span>
            </div>

            <div class="form-group">
                <input class="btn btn-success" type="submit" name="reg" value="Register">
            </div>
                      

            </fieldset>
            </form><!-- ends register form -->

<script type="text/javascript">
  document.getElementById("field_terms").setCustomValidity("Please indicate that you accept the Terms and Conditions");
</script>
        </div><!-- ends col-6 -->
   
            <div class="col-md-6">
                
				<?php 
 if(isset($m))
 {
 ?>
 <h3 style="background-color:#000; color:#fff; padding:10px; margin:5px; border-radius:5px;"><?php echo $m; ?></h3>

 </tr>
 <?php
  }
 ?>
				
				
                
            </div>

	</div>
</div>

</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

<?php

include('connection.php');

extract($_POST);

if(isset($reg))

{

//check user exists or not

$que=mysqli_query($con,"select * from employee where emp_email='$eid'");

if(mysqli_num_rows($que))

{

$m= "<p style='color:red'>This user already exists</p>";

}

else

{

//$pass=md5($p);

$query="insert into employee values('','$eid','$name','$phone','$date','$address','$dept','$status','$p','$dob')";

if(mysqli_query($con,$query))

{

$m= "Data saved successfully";

}

else

{

$m= "some error";

}

<!DOCTYPE html>

<html>

<head>

{

//Store the password field objects into variables ...

var pass1 = document.getElementById('pass1');

var pass2 = document.getElementById('pass2');

//Store the Confimation Message Object ...

var message = document.getElementById('confirmMessage');

//Set the colors we will be using ...

var goodColor = "#66cc66";

var badColor = "#ff6666";

//Compare the values in the password field

//and the confirmation field

if(pass1.value == pass2.value){

//The passwords match.

//Set the color to the good color and inform

//the user that they have entered the correct password

pass2.style.backgroundColor = goodColor;

message.style.color = goodColor;

message.innerHTML = "Passwords Match"

}else{

//The passwords do not match.

//Set the color to the bad color and

//notify the user.

pass2.style.backgroundColor = badColor;

message.style.color = badColor;

message.innerHTML = "Passwords Do Not Match!"

}

function validatephone(phone)

{

var maintainplus = '';

var numval = phone.value

if ( numval.charAt(0)=='+' )

{

var maintainplus = '';

}

curphonevar = numval.replace(/[\\A-Za-z!"£$%^&\,*+_={};:'@#~,.Š\/<>?|`¬\]\[]/g,'');

phone.value = maintainplus + curphonevar;

var maintainplus = '';

phone.focus;

}

// validates text only

function Validate(txt) {

txt.value = txt.value.replace(/[^a-zA-Z-'\n\r.]+/g, '');

}

// validate email

function email_validate(email)

{

var regMail = /^([_a-zA-Z0-9-]+)(\.[_a-zA-Z0-9-]+)*@([a-zA-Z0-9-]+\.)+([a-zA-Z]{2,3})$/;

if(regMail.test(email) == false)

{

document.getElementById("status").innerHTML = "<span class='warning'>Email address is not valid yet.</span>";

}

else

{

document.getElementById("status").innerHTML = "<span class='valid'>Thanks, you have entered a valid Email address!</span>";

}

// validate date of birth

function dob_validate(dob)

{

var regDOB = /^(\d{1,2})[-\/](\d{1,2})[-\/](\d{4})$/;

if(regDOB.test(dob) == false)

{

document.getElementById("statusDOB").innerHTML = "<span class='warning'>DOB is only used to verify your age.</span>";

}

else

{

document.getElementById("statusDOB").innerHTML = "<span class='valid'>Thanks, you have entered a valid DOB!</span>";

}

// validate address

function add_validate(address)

{

var regAdd = /^(?=.*\d)[a-zA-Z\s\d\/]+$/;

if(regAdd.test(address) == false)

{

document.getElementById("statusAdd").innerHTML = "<span class='warning'>Address is not valid yet.</span>";

}

else

{

document.getElementById("statusAdd").innerHTML = "<span class='valid'>Thanks, Address looks valid!</span>";

}

</script>

<style>body {

padding-top:50px;

}

fieldset {

border: thin solid #ccc;

border-radius: 4px;

padding: 20px;

padding-left: 40px;

background: #fbfbfb;

}

legend {

color: #678;

}

.form-control {

width: 95%;

}

label small {

color: #678 !important;

}

span.req {

color:maroon;

font-size: 112%;

}

</style>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

</div>

<li><a href="index.php">Employee List</a></li>

<li class="active"><a href="add.php">Add Employee</a></li>

</ul>

</div>

</div>

</nav>

<br>

<fieldset><legend class="text-center"><span style="color:#000">Add New Employee </span></legend>

<label for="email"><span class="req">* </span> Email Address: </label>

</div>

<label for="firstname"><span class="req">* </span> Employee Name: </label>

</div>

<label for="phonenumber"><span class="req">* </span> Phone Number: </label>

</div>

<label for="phonenumber"><span class="req">* </span> Date Of Birth: </label>

</div>

<label for="address"><span class="req">* </span> Address: </label>

</div>

<label for="department"><span class="req">* </span> Depatment: </label>

<option value="Operator">Operator</option>

<option value="Leader">Leader</option>

<option value="Supervisor">Supervisor</option>

<option value="Manager">Manager</option>

</select>

</div>

<label for="status"><span class="req">* </span> Status: </label>

<option value="Outsourcing">Outsourcing</option>

<option value="Contract">Contract</option>

<option value="Office">Office</option>

</select>

</div>

<label for="password"><span class="req">* </span> Password: </label>

</div>

<label for="password"><span class="req">* </span> Password Confirm: </label>

</div>

</div>

<hr>

<div>

<input type="checkbox" required name="terms" onChange="this.setCustomValidity(validity.valueMissing ? 'Please indicate that you accept the Terms and Conditions' : '');" id="field_terms"> <label for="terms">I agree with the <a href="#" title="You may read our terms and conditions by clicking on this link">terms and conditions</a> for Registration.</label><span class="req">* </span>

</div>

</div>

</fieldset>

</form>

document.getElementById("field_terms").setCustomValidity("Please indicate that you accept the Terms and Conditions");

</script>

</div>

<?php

if(isset($m))

{

</tr>

<?php

}

</div>

</body>

</html>

5 – Create Profile Page for every employee

This step we are creating a profile page for every employee where show employee details and manage employee like edit and delete.

<?php
include("connection.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>

	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Profile</title>

	<!-- Bootstrap -->
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  		<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
	<style>
		.content {
			margin-top: 80px;
		}
	</style>
	
	
</head>
<body>
	<nav class="navbar navbar-inverse navbar-fixed-top">
		<div class="container">
			<div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
				
			</div>
			<div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li><a href="index.php">Employee List</a></li>
					<li><a href="add.php">Add Employee</a></li>
				</ul>
			</div><!--/.nav-collapse -->
		</div>
	</nav>
	<div class="container">
		<div class="content">
			<h2>Employee Profile</h2>
			<hr />
			
			<?php
			$id = $_GET['emp_id'];
			
			
			$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$id'");
			if(mysqli_num_rows($sql) == 0){
				header("Location: index.php");
			}else{
				$row = mysqli_fetch_assoc($sql);
			}
			
			if(isset($_GET['del']) == 'delete'){
			    $s  = $_GET['del'];
				$delete = mysqli_query($con, "DELETE FROM employee WHERE emp_id='$s'");
				if($delete){
					echo '<div class="alert alert-danger alert-dismissable">><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Data successfully deleted.</div>';
				}else{
					echo '<div class="alert alert-info alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Data failed deleted.</div>';
				}
			}
			?>
			
			<table class="table table-striped table-condensed">
				<tr>
					<th width="20%">Emp_id</th>
					<td><?php echo $row['emp_id']; ?></td>
				</tr>
				<tr>
					<th>Name</th>
					<td><?php echo $row['emp_name']; ?></td>
				</tr>
				<tr>
					<th>Dob</th>
					<td><?php echo $row['emp_id']; ?></td>
				</tr>
				<tr>
					<th>Address</th>
					<td><?php echo $row['emp_address']; ?></td>
				</tr>
				<tr>
					<th>Phone</th>
					<td><?php echo $row['emp_phone']; ?></td>
				</tr>
				<tr>
					<th>Department</th>
					<td><?php echo $row['emp_dept']; ?></td>
				</tr>
				<tr>
					<th>Status</th>
					<td><?php echo $row['emp_status']; ?></td>
				</tr>
				<tr>
					<th>Email</th>
					<td><?php echo $row['emp_email']; ?></td>
				</tr>
				<tr>
					<th>Password</th>
					<td><?php echo $row['emp_password']; ?></td>
				</tr>
			</table>
			<a href="index.php" class="btn btn-sm btn-info"><span class="glyphicon glyphicon-refresh" aria-hidden="true"></span> Back To Home </a>
			<a href="edit.php?emp_id=<?php echo $row['emp_id']; ?>" class="btn btn-sm btn-success"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit Data</a>
			<a href="profile.php?del=<?php echo $row['emp_id']; ?>" class="btn btn-sm btn-danger" onClick="return confirm('You sure are delete data <?php echo $row['emp_name']; ?>')"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span> Delete Data</a>
			
		</div>
	</div>

	
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

<?php

include("connection.php");

<!DOCTYPE html>

<head>

<title>Profile</title>

<style>

.content {

margin-top: 80px;

}

</style>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

</div>

<li><a href="index.php">Employee List</a></li>

<li><a href="add.php">Add Employee</a></li>

</ul>

</div>

</div>

</nav>

<h2>Employee Profile</h2>

<hr />

<?php

$id = $_GET['emp_id'];

$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$id'");

if(mysqli_num_rows($sql) == 0){

header("Location: index.php");

}else{

$row = mysqli_fetch_assoc($sql);

}

if(isset($_GET['del']) == 'delete'){

$s = $_GET['del'];

$delete = mysqli_query($con, "DELETE FROM employee WHERE emp_id='$s'");

if($delete){

echo '<div class="alert alert-danger alert-dismissable">><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data successfully deleted.</div>';

}else{

echo '<div class="alert alert-info alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data failed deleted.</div>';

}

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<th>Address</th>

</tr>

<tr>

<th>Phone</th>

</tr>

<tr>

<th>Department</th>

</tr>

<tr>

<th>Status</th>

</tr>

<tr>

<th>Email</th>

</tr>

<tr>

<th>Password</th>

</tr>

</table>

<a href="edit.php?emp_id=<?php echo $row['emp_id']; ?>" class="btn btn-sm btn-success"><span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit Data</a>

<a href="profile.php?del=<?php echo $row['emp_id']; ?>" class="btn btn-sm btn-danger" onClick="return confirm('You sure are delete data <?php echo $row['emp_name']; ?>')"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span> Delete Data</a>

</div>

</body>

</html>

6 – Update Employee Detail

this step we are add script in php to update employee details.

<?php
include("connection.php");
//error_reporting(1);
?>
<!DOCTYPE html>
<html lang="en">
<head>

	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Edit Data</title>

	<!-- Bootstrap -->
		<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  		<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
	
	<script>
	$('.date').datepicker({
		format: 'yyyy-mm-dd',
	})
	</script>
	
	<style>
		.content {
			margin-top: 80px;
		}
	</style>
	
	
</head>
<body>
	<nav class="navbar navbar-inverse navbar-fixed-top">
		<div class="container">
			<div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
				
			</div>
			<div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li><a href="index.php">Employee List</a></li>
					<li><a href="add.php">Add Employee</a></li>
				</ul>
			</div><!--/.nav-collapse -->
		</div>
	</nav>
	<div class="container">
		<div class="content">
			<h2>Employee &raquo; Edit Data</h2>
			<hr />
			
			<?php
			$emp_id = $_GET['emp_id'];
			$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$emp_id'");
			if(mysqli_num_rows($sql) == 0){
				header("Location: index.php");
			}else{
				$row = mysqli_fetch_assoc($sql);
			}
			if(isset($_POST['save'])){
				$email			 = $_POST['email'];
				$name		     = $_POST['name'];
				$address	 	 = $_POST['address'];
				$dob	         = $_POST['dob'];
				$phone		     = $_POST['phone'];
				$dept	         = $_POST['dept'];
				$status			 = $_POST['status'];
				
				$update = mysqli_query($con, "UPDATE employee SET emp_name='$name', emp_email='$email', emp_address='$address', emp_dob='$dob', emp_phone='$phone', emp_dept='$dept', emp_status='$status'  WHERE emp_id='$emp_id'") or die(mysqli_error());
				if($update){
					header("Location: edit.php?emp_id=".$emp_id."&message=success");
				}else{
					echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Data failed, try again.</div>';
				}
			}
			
			if(isset($_GET['message']) == 'success'){
				echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Data successfully saved.</div>';
			}
			?>
			<form class="form-horizontal" action="" method="post">
				<div class="form-group">
					<label class="col-sm-3 control-label">Emp_id</label>
					<div class="col-sm-3">
						<input type="text" name="emp_id" value="<?php echo $row ['emp_id']; ?>" class="form-control" placeholder="Emp_id" required>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">Email</label>
					<div class="col-sm-3">
						<input type="email" name="email" value="<?php echo $row ['emp_email']; ?>" class="form-control" placeholder="Email" required>
					</div>
				</div>
				
				<div class="form-group">
					<label class="col-sm-3 control-label">Name</label>
					<div class="col-sm-3">
						<input type="text" name="name" value="<?php echo $row ['emp_name']; ?>" class="form-control" placeholder="Name" required>
					</div>
				</div>
				
					<div class="form-group">
					<label class="col-sm-3 control-label">Address</label>
					<div class="col-sm-3">
						<textarea name="address" class="form-control" placeholder="Department"><?php echo $row ['emp_address']; ?></textarea>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">Dob</label>
					<div class="col-sm-3">
						<input type="date" name="dob" value="<?php echo $row ['emp_dob']; ?>" class="input-group date form-control" date="" data-date-format="yyyy-mm-dd" placeholder="0000-00-00" required>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">Phone</label>
					<div class="col-sm-3">
						<input type="number" name="phone" value="<?php echo $row ['emp_phone']; ?>" class="form-control" placeholder="Phone" required>
					</div>
				</div>
				
				
				<div class="form-group">
					<label class="col-sm-3 control-label">Department</label>
					<div class="col-sm-3">
						<select name="dept" class="form-control" required>
							<option value=""> - Lattest Department - </option>
							<option value="Operator">Operator</option>
							<option value="Leader">Leader</option>
                            <option value="Supervisor">Supervisor</option>
							<option value="Manager">Manager</option>
						</select>
					</div>
                    <div class="col-sm-3">
                    <b>Department is :</b> <span class="label label-success"><?php echo $row['emp_dept']; ?></span>
				    </div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">Status</label>
					<div class="col-sm-3">
						<select name="status" class="form-control" required>
							<option value="">- Lattest Status -</option>
                            <option value="Outsourcing">Outsourcing</option>
							<option value="Contract">Contract</option>
							<option value="Office">Offfice</option>
						</select> 
					</div>
                    <div class="col-sm-3">
                    <b>Status is :</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class="label label-info"><?php echo $row['emp_status']; ?></span>
				    </div>
                </div>
				
				<div class="form-group">
					<label class="col-sm-3 control-label">&nbsp;</label>
					<div class="col-sm-6">
						<input type="submit" name="save" class="btn btn-sm btn-primary" value="Update">
						<a href="index.php" class="btn btn-sm btn-danger">Cancel</a>
					</div>
				</div>
			</form>
		</div>
	</div>

	
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

<?php

include("connection.php");

//error_reporting(1);

<!DOCTYPE html>

<head>

$('.date').datepicker({

format: 'yyyy-mm-dd',

})

</script>

<style>

.content {

margin-top: 80px;

}

</style>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

</div>

<li><a href="index.php">Employee List</a></li>

<li><a href="add.php">Add Employee</a></li>

</ul>

</div>

</div>

</nav>

<h2>Employee » Edit Data</h2>

<hr />

<?php

$emp_id = $_GET['emp_id'];

$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$emp_id'");

if(mysqli_num_rows($sql) == 0){

header("Location: index.php");

}else{

$row = mysqli_fetch_assoc($sql);

}

if(isset($_POST['save'])){

$email = $_POST['email'];

$name = $_POST['name'];

$address = $_POST['address'];

$dob = $_POST['dob'];

$phone = $_POST['phone'];

$dept = $_POST['dept'];

$status = $_POST['status'];

$update = mysqli_query($con, "UPDATE employee SET emp_name='$name', emp_email='$email', emp_address='$address', emp_dob='$dob', emp_phone='$phone', emp_dept='$dept', emp_status='$status' WHERE emp_id='$emp_id'") or die(mysqli_error());

if($update){

header("Location: edit.php?emp_id=".$emp_id."&message=success");

}else{

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data failed, try again.</div>';

}

if(isset($_GET['message']) == 'success'){

echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data successfully saved.</div>';

}

<input type="text" name="emp_id" value="<?php echo $row ['emp_id']; ?>" class="form-control" placeholder="Emp_id" required>

</div>

<label class="col-sm-3 control-label">Email</label>

<input type="email" name="email" value="<?php echo $row ['emp_email']; ?>" class="form-control" placeholder="Email" required>

</div>

<input type="text" name="name" value="<?php echo $row ['emp_name']; ?>" class="form-control" placeholder="Name" required>

</div>

<label class="col-sm-3 control-label">Address</label>

</div>

<input type="date" name="dob" value="<?php echo $row ['emp_dob']; ?>" class="input-group date form-control" date="" data-date-format="yyyy-mm-dd" placeholder="0000-00-00" required>

</div>

<label class="col-sm-3 control-label">Phone</label>

<input type="number" name="phone" value="<?php echo $row ['emp_phone']; ?>" class="form-control" placeholder="Phone" required>

</div>

<label class="col-sm-3 control-label">Department</label>

<option value=""> - Lattest Department - </option>

<option value="Operator">Operator</option>

<option value="Leader">Leader</option>

<option value="Supervisor">Supervisor</option>

<option value="Manager">Manager</option>

</select>

</div>

<b>Department is :</b> <span class="label label-success"><?php echo $row['emp_dept']; ?></span>

</div>

<label class="col-sm-3 control-label">Status</label>

<option value="">- Lattest Status -</option>

<option value="Outsourcing">Outsourcing</option>

<option value="Contract">Contract</option>

<option value="Office">Offfice</option>

</select>

</div>

<b>Status is :</b>          <span class="label label-info"><?php echo $row['emp_status']; ?></span>

</div>

<a href="index.php" class="btn btn-sm btn-danger">Cancel</a>

</div>

</form>

</div>

</body>

</html>

7 – Create Change Password Page

This step we are creating a change password script in php.

<?php
include("connection.php");
?>
<!DOCTYPE html>
<html lang="en">
<head>

	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Password Update</title>

	<!-- Bootstrap -->
	    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  		<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

	<style>
		.content {
			margin-top: 80px;
		}
	</style>


</head>
<body>
	<nav class="navbar navbar-inverse navbar-fixed-top">
		<div class="container">
			<div class="navbar-header">
				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
			</div>
			<div id="navbar" class="navbar-collapse collapse">
				<ul class="nav navbar-nav">
					<li><a href="index.php">Employee List</a></li>
					<li><a href="add.php">Add Employee</a></li>
				</ul>
			</div><!--/.nav-collapse -->
		</div>
	</nav>
	<div class="container">
		<div class="content">
		
		
		
			<h2>Employee Data &raquo; Change Password</h2>
			<hr />

			<p>Change password Employee with Id <?php echo '<b>'.$_GET['emp_id'].'</b>'; ?></p>
			<?php
			$s= $_GET['emp_id'];
			//echo $s;
			?>
			<?php
			if(isset($_POST['Change'])){
			
				//$emp_id 	= $_POST['emp_id'];
				$password 	= ($_POST['password']);
				$password1 	= $_POST['password1'];
				$password2 	= $_POST['password2'];

				$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$s' AND emp_password='$password'");
					//$sql = mysqli_query($con, "select emp_password from employee where emp_id='$s'");
				if(mysqli_num_rows($sql) == 0){
				
				//echo '<div class="alert alert-danger" role="alert">
//  <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>
 // <span class="sr-only">Error:</span>
 // Wrong password entry password is incorrect.
//</div>';
				
					echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Wrong password entry password is correct</div>';
				}else{
					if($password1 == $password2){
						if(strlen($password1) >= 6){
							//$pass = $password1;
							$update = mysqli_query($con, "UPDATE employee SET emp_password='$password1' WHERE emp_id='$s'");
							if($update){
								echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Password successfully change.</div>';
							}else{
								echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>The password failed to change.</div>';
							}
						}else{
							echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Long character Password at least 6 characters.</div>';
						}
					}else{
						echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Pasword is not the same.</div>';
					}
				}
			}
			?>

			<form class="form-horizontal" action="" method="post">
				<div class="form-group">
					<label class="col-sm-3 control-label">Old Password</label>
					<div class="col-sm-3">
						<input type="password" name="password" class="form-control" placeholder="Old Password" required>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">New Password</label>
					<div class="col-sm-3">
						<input type="password" name="password1" class="form-control" placeholder="New Password" required>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">Re-enter New Password</label>
					<div class="col-sm-3">
						<input type="password" name="password2" class="form-control" placeholder="Re-enter New Password" required>
					</div>
				</div>
				<div class="form-group">
					<label class="col-sm-3 control-label">&nbsp;</label>
					<div class="col-sm-6">
						<input type="submit" name="Change" class="btn btn-sm btn-info" value="Change">
						<a href="index.php" class="btn btn-sm btn-danger"><b>Cancel</b></a>
					</div>
				</div>
			</form>
		</div>
	</div>

	
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

<?php

include("connection.php");

<!DOCTYPE html>

<head>

<title>Password Update</title>

<style>

.content {

margin-top: 80px;

}

</style>

</head>

<body>

<span class="sr-only">Toggle navigation</span>

</button>

</div>

<li><a href="index.php">Employee List</a></li>

<li><a href="add.php">Add Employee</a></li>

</ul>

</div>

</div>

</nav>

<h2>Employee Data » Change Password</h2>

<hr />

<p>Change password Employee with Id <?php echo '<b>'.$_GET['emp_id'].'</b>'; ?></p>

<?php

$s= $_GET['emp_id'];

//echo $s;

<?php

if(isset($_POST['Change'])){

//$emp_id = $_POST['emp_id'];

$password = ($_POST['password']);

$password1 = $_POST['password1'];

$password2 = $_POST['password2'];

$sql = mysqli_query($con, "SELECT * FROM employee WHERE emp_id='$s' AND emp_password='$password'");

//$sql = mysqli_query($con, "select emp_password from employee where emp_id='$s'");

if(mysqli_num_rows($sql) == 0){

//echo '<div class="alert alert-danger" role="alert">

// <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>

// <span class="sr-only">Error:</span>

// Wrong password entry password is incorrect.

//</div>';

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Wrong password entry password is correct</div>';

}else{

if($password1 == $password2){

if(strlen($password1) >= 6){

//$pass = $password1;

$update = mysqli_query($con, "UPDATE employee SET emp_password='$password1' WHERE emp_id='$s'");

if($update){

echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Password successfully change.</div>';

}else{

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>The password failed to change.</div>';

}

}else{

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Long character Password at least 6 characters.</div>';

}

}else{

echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Pasword is not the same.</div>';

}

<label class="col-sm-3 control-label">Old Password</label>

</div>

<label class="col-sm-3 control-label">New Password</label>

</div>

<label class="col-sm-3 control-label">Re-enter New Password</label>

</div>

<a href="index.php" class="btn btn-sm btn-danger"><b>Cancel</b></a>

</div>

</form>

</div>

</body>

</html>

If you facing any type of problem with this source code then you can Download the Complete source code in zip Formate by clicking the below button Download Now otherwise you can send Comment.

Download Now