Banner Add

PHP

Edit/Update data in radio button , Multiple checkbox , select box in database Mysql using PHP – HTML Tutorial makcode.in

June 03, 2023
admin

Create edit.php for updating a data with method POST AND Action = “edit-process.php”

First retrieve a database crud and table name cruddetails and fetch rows – id,name,address,gender,edu,year

retrieve.php

<?php
$conn= mysqli_connect('localhost','root','','crud');
if (!$conn){
  die('could not connect mysql:' .msql_error());
}
$result = mysqli_query($conn,"SELECT * FROM cruddetails");
?>
<!DOCTYPE html>
<html>
 <head>
 <title> Retrive data</title>
 </head>
<body>
  <h4><a href="insert.html">Insert Data</a></h4>
<?php
if (mysqli_num_rows($result) > 0) {
?>
  <table>
  
  <tr>
    <td>Name</td>
    <td>Address</td>
    <td>Gender</td>
    <td>Education</td>
    <td>Year</td>
    <td>Action</td>
  </tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
    <td><?php echo $row["name"]; ?></td>
    <td><?php echo $row["address"]; ?></td>
    <td><?php echo $row["gender"]; ?></td>
    <td><?php echo $row["edu"]; ?></td>
    <td><?php echo $row["year"]; ?></td>
    <td><a href="edit.php?id=<?php echo $row["id"]; ?>">Update</a></td>
</tr>
<?php
$i++;
}
?>
</table>
 <?php
}
else{
    echo "No result found";
}
?>
 </body>
</html>

After creating retrieve.php then create edit file for fetching and updating records having two files

edit.php

<?php
$conn= mysqli_connect('localhost','root','','crud');
if (!$conn){
  die('could not connect mysql:' .msql_error());
}
$id = $_GET ['id'];
$query = "SELECT * FROM cruddetails WHERE id ='".$id."'";
$result = mysqli_query($conn,$query) or die (mysqli_error());
$row = mysqli_fetch_assoc($result);
$data = explode(',',$row['edu']);
$datagender = explode(',',$row['gender']);                 
// print_r($datagender);die;
?>
<h1><a href="records.php">All Records</a></h1>
<form action="edit-process.php" method="POST">
	<input type="hidden" name="id" value="<?php echo $row['id']?>"><br>
NAME: <input type="text" name="name" value="<?php echo $row['name']?>"><br>
Address: <textarea name="address" cols="20" rows="5"><?php echo $row['address']?></textarea><br>
Gender: <input type="radio" name="gender" value="Male" 
<?php
if (in_array("Male", $datagender))
  {
   ?> checked = checked;
   <?php
  }
?>>Male
<input type="radio" name="gender" value="Male" 
<?php
if (in_array("Female", $datagender))
  {
   ?> checked = checked;
   <?php
  }
?>>Female<br>
Education: <input type="checkbox" name="edu[]" value="BE"
<?php
if (in_array("BE", $data))
  {
   ?> checked = checked;
   <?php
  }
?>
>BE
<input type="checkbox" name="edu[]" value="DE"
<?php
if (in_array("DE", $data))
  {
   ?> checked = checked;
   <?php
  }
?>
>DE
<input type="checkbox" name="edu[]" value="MCA"
<?php
if (in_array("MCA", $data))
  {
   ?> checked = checked;
   <?php
  }
?>
>MCA
Year: <select name="year">
	
	<option <?php if($row['year']=='2018'){ echo "selected";}?>>2018</option>
	<option <?php if($row['year']=='2019'){ echo "selected";}?>>2019</option>
	<option <?php if($row['year']=='2020'){ echo "selected";}?>>2020</option>
</select><br>
<input type="submit" name="save" value="save">		
</form>

edit-process.php

<?php 
$conn= mysqli_connect('localhost','root','','crud');
if (!$conn){
  die('could not connect mysql:' .msql_error());
}
if (isset($_POST['save'])) {
	$id = $_POST['id'];
	$name = $_POST['name'];
	$address = $_POST['address'];
	$gender = $_POST['gender'];
	$edu = implode(",",$_POST['edu']);
	$year = $_POST['year'];
$sql = "UPDATE cruddetails SET name='$name',address='$address',gender='$gender',edu='$edu',year='$year' WHERE id=".$id;
// var_dump($sql);
// die;
 $result = $conn->query($sql);
 echo "<script>alert('UPDATE successfully');</script>";
          echo "<script>window.location.href='records.php'</script>";
}
 ?>