Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- </head>
- <body>
- <?php
- $mysqli = mysqli_connect("localhost", "root", "", "faks"); // spajanje na server i bazu
- if(!mysqli_connect_errno($mysqli)) { // provjera da li je bila greska
- $sql = "SELECT * FROM stud, mjesto WHERE stud.pbr_preb = mjesto.pbr";
- // print($sql);
- $result = mysqli_query($mysqli, $sql); // izvršavanje upita
- if($result==True) {
- print("<table border='1' >");
- print(" <td> BR </td><td> MBR </td> <td> Ime </td> <td> Prezime </td> <td> PBR </td> <td> Naziv mjesta </td>");
- $i=0;
- while($row = mysqli_fetch_assoc($result)) { // dohvat svakog retka iz $result
- print("<tr>");
- $i++;
- if ($i%2!=0){
- print(" <td><b> $i.</b></td>");}
- else {print(" <td>$i.</td>");}
- print(" <td>{$row['mbr_stud']}</td> ");
- print(" <td>{$row['ime_stud']}</td> ");
- print(" <td>{$row['prez_stud']}</td> ");
- print(" <td>{$row['pbr_preb']}</td>");
- print(" <td>{$row['naz_mjesta']}</td>");
- print("</tr>"); // ispis svakog retka
- }
- print("</table>");
- mysqli_free_result($result); // oslobađanje memorije
- } else {
- print(" Upit je neuspješno izvršen! ");
- }
- } else {
- print(" Greška kod spajanja na bazu! " . mysqli_connect_error());
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement