delete update in php using mysql

PHP Introduction

Working with Forms

PHP with MySQl

Advanced PHP

Object Oriented PHP

delete update mysql using php

Delete update queries may also be fired using php on sql table as shown in the followig examples

Delete records using php mysql

Student Form with Delete/Update Button

<html>
<body bgcolor="gray">
<center>
<form name="deleteupdateform" action="delete-update-student.php"  >
Name<input type="text" name="sname"><br>
RollNo<input type="text" name="roll"><br>
Course<input type="text" name="course"><br>
<input type="submit" name="btn" value="delete">
<input type="submit" name="btn" value="update">
</form>
</center>
</body>
</html>

PHP page to delete or update the records based on the button clicked

<html>
 <?php
  $host="localhost";
  $dbuser = "root";
  $password = ""; // change password as per your database.
  $dbname=     "sharp_tutorial";
  $conn = mysqli_connect($host, $dbuser, $password,$dbname);
  $sname=$_GET["sname"];
  $rollNo=$_GET["roll"]; 
  $course=$_GET["course"];
  $action=$_GET["btn"];
  if($action=="delete")
  {
    $sql="delete from student where rollNo='$rollNo'";
    $msg="Record Deleteded or not exists";
  }
  if($action=="update")
  {
  $sql="update student set name='$sname',course='$course' where rollNo='$rollNo'";
    $msg="Record updaed  or not exists";
  }
  mysqli_query($conn,$sql);
  echo"$msg"; //msg based on query fired.
  ?> </html>

Above program delete the records if delete button is clicked and record exists in the table as shown below.

Above program update the records if update button is clicked and record exists in the table as shown below.

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

delete update mysql using php

Delete records using php mysql

Student Form with Delete/Update Button

PHP page to delete or update the records based on the button clicked

Video/ C Introduction