Jump to content

alhakimy

Members
  • Content count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About alhakimy

  • Rank
    Newbie
  1. How to delete a record

    Thank you justsomeguy Now when the deletion process Do not delete directly when press the Delete But after pressing Refresh the page is deleted
  2. How to delete a record

    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
×