Simple Insert, Delete, Update and Show data in PHP

Insert data in PHP
<?php
$con=mysqli_connect("localhost", "root", "", "mydatabase");
$sql = "INSERT INTO registration (UserId,UserName,State,City,PhoneNo,Pin,Gender)
VALUES('P012','John','UP','MBD',9876543210,244001,'Male')";
$result = mysqli_query($con, $sql);
//while($contact = mysql_fetch_assoc($result))
if($result===true) 
{
    echo "New record created successfully";
} 
else 
{
    echo "Error: " .$sql. "<br/>" .$con->error;
}
mysqli_close($con);
?>

Delete data in PHP
<?php
$con=mysqli_connect("localhost", "root", "", "mydatabase");
$sql = "Delete from registration where UserId='P010'";
$result = mysqli_query($con, $sql);
//while($contact = mysql_fetch_assoc($result))
if($result===true) 
{
    echo "Record deleted";
} 
else 
{
    echo "Error: " .$sql. "<br>" .$con->error;
}
mysqli_close($con);
?>

Update data in PHP
<?php
$con=mysqli_connect("localhost", "root", "", "mydatabase");
$sql = "Update registration set PhoneNo=1234567890 where UserId='P007'";
$result = mysqli_query($con, $sql);
//while($contact = mysql_fetch_assoc($result))
if($result==true) 
{
    echo "Record Updated successfully";
} 
else
{
    echo "Error: " .$sql. "<br>" .$con->error;
}
mysqli_close($con);
?>

Show data in PHP
<?php
$con=mysqli_connect("localhost", "root", "", "mydatabase");
$sql = "SELECT * from registration";
$result = mysqli_query($con, $sql);
echo "<table border='2'>";
echo "<tr><th>UderId</th><th>Name</th><th>State</th><th>City</th><th>Phone No</th><th>Pin</th><th>Gender</th></tr>";
while($contact = mysqli_fetch_array($result)) 
{ 
echo "<tr><td>";
echo $contact['UserId'];
echo "</td><td>";
echo $contact['UserName'];
echo "</td><td>";
echo $contact['State'];
echo "</td><td>";
echo $contact['City'];
echo "</td><td>";
echo $contact['PhoneNo'];
echo "</td><td>";
echo $contact['Pin'];
echo "</td><td>";
echo $contact['Gender'];
echo "</td></tr>";
} 
echo "</table>";
?>

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos