<?php
if(isset($_POST['submit'])){
$hostname = 'localhost';
$username = 'root';
$password = '';
$dbname= 'my_db';

$id = $_POST['id'];
$connect = mysqli_connect('localhost','root','','my_db');

$query="DELETE FROM myguests WHERE id='.$id.'";
$result = mysqli_query($connect, $query);
if(result)
{
echo 'data deleted';
}else{
echo 'data not delete';
}
mysqli_close($connect);
?>
<form action="Delete.php" method="POST">
ID TO DELETE:&nbsp;<input type="text" name="id" required><br><br>
<input type="submit" name="delete" value="clear data">
</form>