Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <!--
- To change this license header, choose License Headers in Project Properties.
- To change this template file, choose Tools | Templates
- and open the template in the editor.
- -->
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <?php
- echo '<a href="index.php">'.'Natrag'.'</a>'.'<br>';
- require 'konekcija.php';
- if(isset($_GET['mbr']))
- {
- $mbr=$_GET['mbr'];
- $prosjek=$_GET['prosjek'];
- $query="select mbrStud,imeStud,prezStud
- from ucenici where mbrStud=$mbr";
- $result= mysqli_query($link, $query);
- $fetch= mysqli_fetch_assoc($result);
- echo '<table>';
- echo '<tr><td>'.'Ime:'.'<td>'.$fetch['imeStud'].'<tr>';
- echo '<tr><td>'.'Prezime:'.'<td>'.$fetch['prezStud'].'<tr>';
- echo '<tr><td>'.'Prosjek'.'<td>'.$prosjek.'<tr>';
- echo '</table>';
- $query2="select p.nazPred,o.ocjena
- from ocjene o
- left outer join pred p
- on o.sifPred=p.sifPred
- where o.mbrStud=$mbr";
- $result2= mysqli_query($link, $query2);
- if($result2==TRUE)
- {
- echo '<table border="2">';
- echo '<tr><th>'.' '.'<th>'.'Predavanje'.'<th>'.'Ocjena'.'<tr>';
- $x=0;
- while($row= mysqli_fetch_assoc($result2))
- {
- $x=$x+1;
- echo '<tr><td>'.$x.'<td>'.
- $row['nazPred'].'<td>'.
- $row['ocjena'].'<tr>';
- }
- echo '</table>';
- }
- else
- {
- echo 'Došlo je do pogreške'.'<br>';
- }
- }
- else
- {
- header('location:index.php');
- }
- ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment