<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>