Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connect=mysqli_connect('localhost', 'root', '', 'ogloszenia');
- ?>
- <!DOCTYPE html>
- <html lang="pl">
- <head>
- <meta charset="UTF-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta author="Artur Łomozik">
- <title>Ogłoszenia</title>
- </head>
- <body>
- <form>
- <select id="kat" name="kat">
- <option value="1">książki</option>
- <option value="2">muzyka</option>
- <option value="3">filmy</option>
- </select>
- <br>
- <br>
- <input type="submit" value="Wybierz">
- </form>
- <br>
- <?php
- if(isset($_GET['kat']))
- {
- //echo "<table> <th> ID</th> <th>tytul</th><th>tresc</th><th></th>";
- $ID=$_GET['kat'];
- $sql="SELECT *, `ogloszenie`.`id` from `ogloszenie` inner join `uzytkownik` on `ogloszenie`.`uzytkownik_id`=`uzytkownik`.`id` where `kategoria`=$ID";
- $result=mysqli_query($connect, $sql);
- while($row=mysqli_fetch_array($result))
- {
- echo <<<COS
- <div id="ogloszenie">
- <h1>$row[id] $row[tytul]</h1>
- $row[tresc]
- <h5>$row[telefon]</h5>
- </div>
- <hr>
- COS;
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement