alhakimy
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by alhakimy
-
-
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 picturewhat should I do To delete the record When pressed Del
thank you
How to delete a record
in PHP
Posted
Thank you justsomeguy
Now when the deletion process
Do not delete directly when press the Delete
But after pressing Refresh the page is deleted