Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $c = mysqli_connect("localhost", "root", "", "komis");
- ?>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Wynajmujemy samochody</title>
- <link rel="stylesheet" type="text/css" href="auto.css">
- </head>
- <body>
- <div id="banner">
- <h1>Wynajem Samochodów</h1>
- </div>
- <div id="panel-lewy">
- <h2></h2>
- <?php
- $zap1 = mysqli_query($c, "SELECT `id`,`marka`,`model` FROM `samochody`");
- while($r = mysqli_fetch_assoc($zap1)){
- echo $r['id'].' '.$r['model'].' '.$r['marka'].'<br>';
- }
- ?>
- <h2>ZAMÓWIENIA</h2>
- <?php
- $zap2 = mysqli_query($c, "SELECT `Samochody_id`,`Klient` FROM `zamowienia`");
- while($r = mysqli_fetch_assoc($zap2)){
- echo $r['Samochody_id'].' '.$r['Klient'].'<br>';
- }
- ?>
- </div>
- <div id="panel-prawy">
- <h2>PEŁNE DANE FIAT</h2>
- <?php
- $zap3 = mysqli_query($c, 'SELECT * FROM `samochody` WHERE `marka` = "Fiat"');
- while($r = mysqli_fetch_assoc($zap3)){
- echo $r['id'].' / '.$r['marka'].' / '.$r['model'].' / '.$r['rocznik'].' / '.$r['kolor'].' / '.$r['stan'].'<br>';
- }
- ?>
- </div>
- <div id="stopka">
- <table>
- <tr>
- <td><a href="kwerendy.txt">Kwerendy</a></td>
- <td>Autor: MÓJ NUMER PESEL</td>
- <td><img src="auto.png" alt="komis samochodowy"></td>
- </tr>
- </div>
- </body>
- </html>
- <?php
- mysqli_close($c);
- ?>
- html, body {
- margin: 0;
- padding: 0;
- }
- .baner {
- background-color: #0B873D;
- color: white;
- font-size: 150%;
- text-align: center;
- width: 100%;
- }
- .lewy {
- background-color: #8CE1AE;
- width: 40%;
- height: 600px;
- display: block;
- float: left;
- }
- .srodkowy {
- background-color: #5CCB89;
- width: 40%;
- height: 600px;
- display: block;
- float: left;
- }
- .prawy {
- background-color: #1DA956;
- width: 20%;
- height: 600px;
- display: block;
- float: left;
- }
- a {
- color: brown;
- }
- a:visited {
- color: red;
- }
- ul {
- margin: 20px;
- list-style-image: url('auto.png');
- }
Advertisement
Add Comment
Please, Sign In to add comment