update.php

<?php
$empno=$_GET['id'];
//database connect
$db=mysqli_connect("localhost","root","","mycompanyhr");
// database connection
if ($db==false) {
echo "Connect failed: ". mysqli_connect_error($db);
exit();
}
else {
echo "Connection successful";
}
$sql1="select * from employee where EMPNO='$empno' ";
$rs1=mysqli_query($db,$sql1);
//fetch all data
$record=mysqli_fetch_array($rs1);
$fname=$record['FIRSTNAME'];
$lname=$record['LASTNAME'];
$dept=$record['WORKDEPT'];
$phone=$record['PHONENO'];
?>
Update record
<form name='forminsert' method='get' action=''>
Employee no
<input name='txtempno' type='text' maxlength=6
value='<?php echo $empno;?>' > <br>
Firstname
<input name='txtfname' type='text'
value='<?php echo $fname;?>' > <br>
Lastname
<input name='txtlname' type='text'
value='<?php echo $lname;?>' > <br>
Department
<input name='txtdept' type='text'
value='<?php echo $dept;?>' > <br>
Extension
<input name='txtphone' type='text'
value='<?php echo $phone;?>' > <br>

<input name='submit' type='submit' value='Save'> <br>

</form>

<?php
//extract all info from the form
$empno=$_GET['txtempno'];
$fname=$_GET['txtfname'];
$lname=$_GET['txtlname'];
$dept=$_GET['txtdept'];
$phone=$_GET['txtphone'];

//develop the SQL command
if($empno!=''){
$sql="update employee
set FIRSTNAME='$fname', LASTNAME='$lname',
WORKDEPT='$dept', PHONENO='$phone'
where EMPNO='$empno' ";


//execute the SQL command
$rs=mysqli_query($db,$sql);

//check the execution status
if($rs==false){
echo "Record cannot be saved!<br>";
echo "SQL Error : ".mysqli_error($db);
}
else{
echo "<br>Record for $fname update!<br>";
echo "<a href='listing-edit.php'>
List records</a><br>";
}
}//end NULL
?>

Popular Posts

WorldConferences.net