Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2019
339
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4. <link rel="stylesheet" type="text/css" href="style.css">
  5. </head>
  6.  
  7. <body>
  8. <div id="naglowek">
  9.  
  10. </div>
  11.  
  12. <div id="menu">
  13. <input type="button" value="Strona glowna" onclick="location.href='index.php';"> <br />
  14. <input type="button" value="Rejestracja" onclick="location.href='rejestracja.php';"> <br />
  15. <input type="button" value="Przegladaj" onclick="location.href='przegladaj.php';"> <br />
  16. <input type="button" value="Kasowanie" onclick="location.href='kasowanie.php';">
  17. </div>
  18. <div id="tresc">
  19. <form method="post">
  20. <input type="submit" name="submit" value="Usun" > <br />
  21. <input type="text" name="usuwanie" placeholder="wpisz liczbę"> <br>
  22. <?php
  23.  
  24.  
  25.  
  26.  
  27.  
  28. $wyn = $_POST['usuwanie'];
  29. require_once "db_config.php";
  30. $polaczenie = @mysqli_connect($db_host,$db_user,$db_pass,$db_name);
  31.  
  32.  
  33. if (mysqli_connect_errno()){
  34.  
  35.  
  36.  
  37.  
  38. }
  39. else{
  40.  
  41. $kwerenda1="SELECT * FROM komis";
  42. $kwerenda2="DELETE FROM komis WHERE id = '$wyn'";
  43.  
  44. if($wynik=$polaczenie->query($kwerenda1)){
  45.  
  46. $tablica=array();
  47. if($wynik->num_rows){
  48.  
  49.  
  50. while ($wiersz= mysqli_fetch_assoc($wynik)){
  51. $tablica[] = $wiersz;
  52.  
  53.  
  54.  
  55. }
  56. echo "<table border='1'><tr><td>Id</td><td>Marka</td><td>Model</td><td>Rocznik</td><td>Przebieg</td><td>Paliwo</td><td>Kolor</td><td>Moc </td></tr>";
  57. for($i=0;$i<sizeof($tablica);$i++){
  58. echo "<tr>";
  59. echo "<td>".$tablica[$i]['id']."</td>";
  60. echo "<td>".$tablica[$i]['marka']."</td>";
  61. echo "<td>".$tablica[$i]['model']."</td>";
  62. echo "<td>".$tablica[$i]['rok_prod']."</td>";
  63. echo "<td>".$tablica[$i]['przebieg']."</td>";
  64. echo "<td>".$tablica[$i]['paliwo']."</td>";
  65. echo "<td>".$tablica[$i]['kolor']."</td>";
  66. echo "<td>".$tablica[$i]['moc']."</td>";
  67. echo "</tr>";
  68.  
  69.  
  70.  
  71. }
  72. echo "</table>";
  73. }
  74.  
  75. }
  76.  
  77. else{
  78.  
  79.  
  80.  
  81. };
  82.  
  83.  
  84.  
  85.  
  86.  
  87.  
  88. if(isset($_POST['submit'])) {
  89.  
  90. $wyn = $_POST['usuwanie'];
  91.  
  92. if($wynik=$polaczenie->query($kwerenda2)){
  93.  
  94.  
  95. $tablica=array();
  96. if($wynik->num_rows){
  97. echo " ok <br />";
  98.  
  99. while ($wiersz= mysqli_fetch_assoc($wynik)){
  100. $tablica[] = $wiersz;
  101.  
  102.  
  103.  
  104. }
  105.  
  106. }
  107. }
  108.  
  109. }
  110.  
  111. $polaczenie->close();
  112. }
  113. ?>
  114. </form>
  115. </div>
  116. <div id="stopka"><p> Strona by Patryk Kwinczak &trade; </p></div>
  117. &reg
  118. </body>
  119.  
  120. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement