Advertisement
Guest User

Untitled

a guest
Feb 17th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. <html>
  2. <body>
  3. <h2>Usuwanie Rekordu</h2>
  4. <form action="usuw2.php" method="post">
  5. <table>
  6. <tr>
  7. <td>ID:</td>
  8. <td><input type="text" name="ID" id="ID" ></td>
  9. </tr>
  10. <tr>
  11. <td>Nacja:</td>
  12. <td><input type="text" name="Nacja" id="Nacja" ></td>
  13. </tr>
  14. <tr>
  15. <td>LiczbaPkt:</td>
  16. <td><input type ="text" name="LiczbaPkt" id="LiczbaPkt"></td>
  17. </tr>
  18. <tr>
  19. <td><input name="delete" type="submit" id="dodaj"
  20. value="Usun Rekord"></td>
  21. </tr>
  22. </table>
  23. </form>
  24.  
  25. </body>
  26. </html>
  27.  
  28. <?php
  29.  
  30. // php code to Delete data from mysql database
  31.  
  32. if(isset($_POST['delete']))
  33. {
  34. $hostname = "localhost";
  35. $username = "root";
  36. $password = "";
  37. $databaseName = "kluby ranking";
  38.  
  39. // get id to delete
  40. $ID=$_POST["ID"];
  41. $Nacja=$_POST["Nacja"];
  42. $LiczbaPkt=$_POST["LiczbaPkt"];
  43.  
  44. // connect to mysql
  45. $connect = mysqli_connect($hostname, $username, $password, $databaseName);
  46.  
  47. // mysql delete query
  48. $query = "DELETE FROM `europa` WHERE `ID ,Nacja, LiczbaPkt` = $ID,$Nacja,$LiczbaPkt";
  49.  
  50. $result = mysqli_query($connect, $query);
  51.  
  52. if($result)
  53. {
  54. echo 'Data Deleted';
  55. }else{
  56. echo 'Data Not Deleted';
  57. }
  58. mysqli_close($connect);
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement