Guest User

Untitled

a guest
Oct 1st, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. <?php
  2.  
  3. $c = mysqli_connect("localhost", "root", "", "komis");
  4.  
  5. ?>
  6. <html>
  7. <head>
  8. <meta charset="utf-8">
  9. <title>Wynajmujemy samochody</title>
  10. <link rel="stylesheet" type="text/css" href="auto.css">
  11. </head>
  12. <body>
  13. <div id="banner">
  14. <h1>Wynajem Samochodów</h1>
  15. </div>
  16. <div id="panel-lewy">
  17. <h2></h2>
  18. <?php
  19.  
  20. $zap1 = mysqli_query($c, "SELECT `id`,`marka`,`model` FROM `samochody`");
  21. while($r = mysqli_fetch_assoc($zap1)){
  22. echo $r['id'].' '.$r['model'].' '.$r['marka'].'<br>';
  23. }
  24.  
  25. ?>
  26. <h2>ZAMÓWIENIA</h2>
  27. <?php
  28.  
  29. $zap2 = mysqli_query($c, "SELECT `Samochody_id`,`Klient` FROM `zamowienia`");
  30. while($r = mysqli_fetch_assoc($zap2)){
  31. echo $r['Samochody_id'].' '.$r['Klient'].'<br>';
  32. }
  33.  
  34. ?>
  35. </div>
  36. <div id="panel-prawy">
  37. <h2>PEŁNE DANE FIAT</h2>
  38. <?php
  39.  
  40. $zap3 = mysqli_query($c, 'SELECT * FROM `samochody` WHERE `marka` = "Fiat"');
  41. while($r = mysqli_fetch_assoc($zap3)){
  42. echo $r['id'].' / '.$r['marka'].' / '.$r['model'].' / '.$r['rocznik'].' / '.$r['kolor'].' / '.$r['stan'].'<br>';
  43. }
  44.  
  45. ?>
  46. </div>
  47. <div id="stopka">
  48. <table>
  49. <tr>
  50. <td><a href="kwerendy.txt">Kwerendy</a></td>
  51. <td>Autor: MÓJ NUMER PESEL</td>
  52. <td><img src="auto.png" alt="komis samochodowy"></td>
  53. </tr>
  54. </div>
  55. </body>
  56. </html>
  57. <?php
  58.  
  59. mysqli_close($c);
  60.  
  61. ?>
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.  
  77.  
  78. html, body {
  79. margin: 0;
  80. padding: 0;
  81. }
  82.  
  83.  
  84. .baner {
  85. background-color: #0B873D;
  86. color: white;
  87. font-size: 150%;
  88. text-align: center;
  89. width: 100%;
  90. }
  91.  
  92. .lewy {
  93. background-color: #8CE1AE;
  94. width: 40%;
  95. height: 600px;
  96. display: block;
  97. float: left;
  98. }
  99.  
  100. .srodkowy {
  101. background-color: #5CCB89;
  102. width: 40%;
  103. height: 600px;
  104. display: block;
  105. float: left;
  106. }
  107.  
  108. .prawy {
  109. background-color: #1DA956;
  110. width: 20%;
  111. height: 600px;
  112. display: block;
  113. float: left;
  114. }
  115.  
  116. a {
  117. color: brown;
  118. }
  119.  
  120. a:visited {
  121. color: red;
  122. }
  123.  
  124. ul {
  125. margin: 20px;
  126. list-style-image: url('auto.png');
  127. }
Advertisement
Add Comment
Please, Sign In to add comment