Advertisement
farezowskyy

qwerty

Oct 19th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. <?php
  2. $polaczenie=mysqli_connect('localhost','klasa4tibgr2','qwerty');
  3. if(!$polaczenie)
  4. {
  5. echo "blad";
  6. exit();
  7. }
  8. if(!mysqli_select_db($polaczenie,'baza4tibgr2'))
  9. {
  10. echo "blad";
  11. exit();
  12. }
  13.  
  14. $zapytanie1 = mysqli_query($polaczenie,"SELECT DISTINCT * FROM users");
  15. $wybor=mysqli_fetch_array($zapytanie1)
  16.  
  17. ?>
  18. <!DOCTYPE HTML>
  19. <html>
  20. <head>
  21. <meta charset="utf-8">
  22. </head>
  23. <body>
  24. <form action="qwerty.php" method="post">
  25. <input type="text" name="login" value="">login<br>
  26. <input type="password" name="haslo" value="">haslo<br>
  27. <input type="submit" value="wyslij">
  28. </form>
  29. </hr>
  30. <?php
  31. echo "<form action='qwerty.php' method='post'>";
  32.  
  33. echo "<select name='log'>";
  34. $log = $_POST['log'];
  35. while ($wybor=mysqli_fetch_array($zapytanie1))
  36.  
  37. echo "<option>".$wybor['login']."</option>";
  38. echo "</select>";
  39. echo "<input type='submit' value='usun'>";
  40. echo "</form>";
  41.  
  42. if(isSet($log))
  43. {
  44. $aha = mysqli_query($polaczenie,"SELECT DISTINCT * FROM users WHERE login='$log'");
  45. if(!$aha)
  46. {
  47. echo "blad32";
  48. }
  49. else
  50. {
  51. $usun = mysqli_query("DELETE FROM users WHERE login='$log'");
  52. if(!$usun)
  53. {
  54. echo "blad";
  55. }
  56. {
  57. echo "usunieto";
  58. }
  59. }
  60. }
  61. ?>
  62.  
  63.  
  64. <br><br>
  65.  
  66. // <?php
  67.  
  68. // if(isSet($_POST['login']) && isSet($_POST['haslo']))
  69. // {
  70. // $login=$_POST['login'];
  71. // $haslo=$_POST['haslo'];
  72. // $dodaj=mysqli_query($polaczenie,"INSERT INTO users (`login` , `haslo`) VALUES('$login' , '$haslo')");
  73. // if(!$dodaj)
  74. // {
  75. // echo "blad1";
  76. // }
  77. // else
  78. // {
  79. // echo "dodany poprawnie";
  80. // }
  81.  
  82.  
  83. // }
  84. // ?>
  85. </body>
  86. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement