I use google for translation
I have this code
<?php
//step one connect with database
$connect = new mysqli ("localhost","root","0220","test");
?>
<?php
// insert step
$id=$_POST['id'];
$name=$_POST['name'];
$pass=$_POST['pass'];
$sql = "INSERT INTO users (id, name, pass)VALUES ('$id', '$name', '$pass')";
if($_POST['enter']) {
// not null text
if(empty($id)||empty($name)||empty($pass)){
echo "You did not enter the required fields.";
die;
}
if ($connect->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $connect->error;
}}
?>
<?php
//step 2 the select query
$qur = "select * from users";
$result = mysqli_query($connect, $qur);
If ( ! $result ){
Die ("error in query"); }
?>
<?php
//step 3 show the data
echo "<table border='1'>";
While ($row= mysqli_fetch_assoc($result)){
Echo "<tr><td>".$row["id"]."</td><td>".$row["name"]."</td><td>".$row["pass"]."</td><td><a href='delete?id=".$row["id"]."'>del</a></td></tr>";}
echo "</table>"
?>
Makes like the attached picture
what should I do To delete the record When pressed Del
thank you
