Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- http://egzamin-e14.blogspot.com/2018/05/arkusz-e14-02-1801.html
- PHP:
- <?php
- $root = "localhost";
- $username = "root";
- $pass = "";
- $db = "ogloszenia";
- $conn = mysqli_connect($root,$username,$pass,$db);
- $zapytanie1 = "select id,imie,nazwisko,email from uzytkownik where id<4;";
- $zapytanie2 = "select tytul from ogloszenie inner join uzytkownik on uzytkownik.id=ogloszenie.uzytkownik_id group by uzytkownik.id;";
- $z1 = mysqli_query($conn, $zapytanie1);
- $z2 = mysqli_query($conn, $zapytanie2);
- while(($row=mysqli_fetch_row($z1)) && ($row2=mysqli_fetch_row($z2))){
- echo "<h3>".$row[0].". ".$row[1].", ".$row[2]."</h3>";
- echo "<p>".$row[3]."</p>";
- echo "<p>Ogloszenie: ".$row2[0]."</p>";
- }
- mysqli_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement