<?php
class Crud
{
private $servername = "localhost";
private $username = "root";
private $password = "";
private $dbname = "oops_db";
public $con;
public $employeeTable = "employee";
public function __construct()
{
try {
$this->con = new mysqli($this->servername, $this->username, $this->password, $this->dbname);
} catch (Exception $e) {
echo $e->getMessage();
}
}
public function update($userid,$first_name, $last_name,$city_name,$email,$insertdate)
{
echo $sql = "UPDATE $this->employeeTable SET first_name='$first_name',last_name='$last_name',city_name='$city_name',email='$email' where userid=$userid";
$query = $this->con->query($sql);
if ($query) {
return true;
}else{
return false;
}
}
}
?>
<?php
include_once("Crud.php");
$userid=$_GET['userid'];
$viewdata=new Crud();
$employee = $viewdata->displayRecordbyid($userid);
?>
<!DOCTYPE html>
<html>
<body>
<form method="post" action="update_process.php">
First name:<br>
<input type="text" name="first_name" value="<?php echo $employee['first_name'];?>">
<br>
Last name:<br>
<input type="text" name="last_name" value="<?php echo $employee['last_name'];?>">
<br>
City name:<br>
<input type="text" name="city_name" value="<?php echo $employee['city_name'];?>">
<br>
Email Id:<br>
<input type="email" name="email" value="<?php echo $employee['email'];?>">
<br><br>
<input type="hidden" name="userid" value="<?php echo $employee['userid'];?>">
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<?php
include_once("Crud.php");
$insertdata=new Crud();
if(isset($_POST['submit']))
{
$userid = $_POST['userid'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$city_name = $_POST['city_name'];
$email = $_POST['email'];
date_default_timezone_set("Asia/Calcutta");
$insertdate = date("Y-m-d H:i:s");
$sql=$insertdata->update($userid,$first_name, $last_name,$city_name,$email,$insertdate);
if($sql)
{
echo "Data inserted successfully !";
}
else
{
echo "Data inserted error !";
}
}
?>