<html>
<body><form action="" method="post" enctype="multipart/form-data">
<center><h1 style="background-color:green; color:white;">FORM</h1>
<table border="2"><tr><th>Id</th><th>
<input type="text" name="id" placeholder="ID"></th></tr><tr><th>Name</th><th>
<input type="text" name="na" placeholder="Name"></th></tr><tr><th>Mobile number</th><th>
<input type="text" name="mn" placeholder="mobilenumber"></th></tr><tr><th>Insert your record </th><th>
<input type="submit" name="sub4" value="insert"></th></tr><tr><th>Display record </th><th><input type="submit" name="sub5" value="Display all records"></th></tr><tr><th rowspan="3"><input type="text" name="n" placeholder="name"><br><input type="text" name="m" placeholder="mobilenumber"></th><th rowspan="3"><input type="submit" name="submi3" value="update 1st record"><br><input type="submit" name="submi2" value="update 2nd record"><br><input type="submit" name="submi" value="update 3rd record"></th></tr>
<tr><th rowspan="3">
delete records</th><th rowspan="3">
<input type="submit" name="sub"value="delete 1st record"><br>
<input type="submit" name="sub2"value="delete 2nd record"><br>
<input type="submit" name="sub3"value="delete 3rd record"></th></tr></form></table>
<?php
if(isset($_POST["sub"])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// sql to delete a record
$sql = "DELETE FROM deletefinal2 WHERE id=1";

if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}

$conn->close();
}
if(isset($_POST["sub2"])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// sql to delete a record
$sql = "DELETE FROM deletefinal2 WHERE id=2";

if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}

$conn->close();
}
if(isset($_POST["sub3"])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// sql to delete a record
$sql = "DELETE FROM deletefinal2 WHERE id=3";

if ($conn->query($sql) === TRUE) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}

$conn->close();
}
if(isset($_POST["sub4"])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
$na=$_POST['na'];
$mn=$_POST['mn'];
$id=$_POST['id'];

$sql = "INSERT INTO deletefinal2(id,name,mobilenumber) VALUES('$id','$na','$mn')";

if ($conn->query($sql) === TRUE) {
echo "Record inserted successfully";
} else {
echo "Error deleting record: " . $conn->error;
}

$conn->close();
}
if(isset($_POST["sub5"])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
$n=$_POST['n'];
$mn=$_POST['mn'];
$id=$_POST['id'];

echo $n.$mn.$id;
$sql = "SELECT * FROM deletefinal2";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
echo '<table><tr><th>id</th><th>Name</th><th>mobilenumber</th></tr>';
while($row = $result->fetch_assoc()) {
   echo'<tr><th>'.$row["id"];
   echo '</th><th>'.$row["name"];
echo '</th><th>'.$row["mobilenumber"].'</th><th>';
}


} else {
echo "0 results";
}
$conn->close();
}?>
<?php if(isset($_POST['submi'])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}$n=$_POST['n'];
$m=$_POST['m'];

$sql = "UPDATE deletefinal2 SET name='$n' where id='3' ";
$sql2 = "UPDATE deletefinal2 SET mobilenumber='$m' where id='3'";

if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}if ($conn->query($sql2) === TRUE) {
echo "";
} else {
echo "Error updating record: " . $conn->error;
}
if ($conn->query($sql2) === TRUE) {
echo "";
} else {
echo "Error updating record: " . $conn->error;
}

$conn->close();}
if(isset($_POST['submi2'])){
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "fileupnew";

$sql = "UPDATE deletefinal2 SET name='$n' where id='2' ";
$sql2 = "UPDATE deletefinal2 SET mobilenumber='$m' where id='2'";

$sql = "UPDATE deletefinal2 SET name='$n' where id='1' ";
$sql2 = "UPDATE deletefinal2 SET mobilenumber='$m' where id='1'";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}if ($conn->query($sql2) === TRUE) {
echo "";
} else {
echo "Error updating record: " . $conn->error;
}
if ($conn->query($sql2) === TRUE) {
echo "";
} else {
echo "Error updating record: " . $conn->error;
}
$conn->close();}
?>