Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- http://egzamin-e14.blogspot.com/2018/05/arkusz-e14-01-1801.html
- PHP:
- <?php
- $root = "localhost";
- $username = "root";
- $pass = "";
- $db = "ogloszenia";
- $conn = mysqli_connect($root,$username,$pass,$db);
- $zapytanie1 = "select id,tytul,tresc from ogloszenie where kategoria=1;";
- $zapytanie2 = "select telefon from uzytkownik inner join ogloszenie on uzytkownik.id=ogloszenie.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]."</h3>";
- echo "<p>".$row[2]."</p>";
- echo "<p>Telefon kontaktowy: ".$row2[0]."</p>";
- }
- mysqli_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement