HTMLify
Delete-The-Record.php
Views: 629 | Author: djdj
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | <?php // Connecting to the Db $servername = "localhost"; $username = "root"; $password = ""; $database = "form"; //create connection $conn = mysqli_connect($servername, $username, $password, $database); if(!$conn){ die('Connection fail!!'.mysqli_connect_error()); } else{ echo "Connection was successfull<br>"; } $sql = "DELETE FROM `details` WHERE `name` = 'ram' "; $result = mysqli_query($conn, $sql); $aff = mysqli_affected_rows($conn); echo $aff; if($result){ echo " Recods Deleted sucessfully"; } else{ $err = mysqli_error($conn); echo " Recods not deleted because this error $err"; } //using limit to delete to recordes $sql = "DELETE FROM `details` WHERE `email` = 'ram@gmail.com' limit 10"; $result = mysqli_query($conn, $sql); $aff = mysqli_affected_rows($conn); echo $aff; if($result){ echo " Recods Deleted sucessfully"; } else{ $err = mysqli_error($conn); echo " Recods not deleted because this error $err"; } ?> |