Untitled

<?php
	// SKRIPTA ZA RAD S BAZOM PODATAKA:
	include("db_connection.php");

	// KLASE ZA RAD S PODACIMA IZ BAZE:
	class Ispit {
		public static function Student()
		{
			$query = "SELECT imeStud, prezStud, mbrStud
						  FROM stud
						  ORDER BY prezStud ASC, imeStud ASC";

				$r = mysql_query($query);
				return $r;
		}
	}

	class Pretraga {
		public static function Ispiti($mbrs)
		{
			$query = "SELECT
						p.nazPred 'predmet',
						CONCAT(n.imeNastavnik, ' ', n.prezNastavnik) 'nastavnik',
						i.datIspit 'datumIspita',
						i.ocjena 'ocjena'
							FROM stud s
							INNER JOIN ispit i ON i.mbrStud = s.mbrStud
							INNER JOIN pred p ON p.sifPred = i.sifPred
							INNER JOIN nastavnik n ON n.sifNastavnik = i.sifNastavnik
							WHERE s.mbrStud = ".$mbrs;

				$r = mysql_query($query);
				return $r;
		}
	}

	// GLAVNA LOGIKA SKRIPTE:
	$ispiti = null;

	if(isset($_GET["mbrs"]))
	{
		$mbrs = $_GET["mbrs"];
		$ispiti = Pretraga::Ispiti($mbrs);
	}
?>

<html>
	<head>
		<meta charset="UTF-8" />
		<title>PHP Programiranje - ISPIT - Marina Mandić</title>
		<style>
			th{
				padding: 10px;
				text-align: left;
			}
			td {
				padding: 10px;
			}
		</style>
	</head>
	<body>
		<form action="index.php" method="GET">
			<label>
				<h3>Odaberi studenta:</h3>
				<select id="mbrs" name="mbrs">
					<?php
						$studenti = Ispit::Student();
						while($row = mysql_fetch_assoc($studenti))
						{
							$imePrez = $row["imeStud"] . ' ' . $row["prezStud"];
							$id = $row["mbrStud"];

							echo '<option value="'. $id .'">'. $imePrez .'</option>';
						}
					?>
				</select>&nbsp;
				<input type="submit" value="Prikaži ispite za odabranog studenta" onclick="this.value='Pretražujem...';this.readonly=true;" />
			</label>
		</form>
		<?php
			if($ispiti != null && mysql_num_rows($ispiti) > 0){
				echo '<br/><hr/><h4>Ispiti:</h4>';
				echo '<table>
					  <tr>
						<th>RBR</th><th>Predmet</th><th>Nastavnik</th><th>Datum Ispita</th><th>Ocjena</th>
					  </tr>';

				$rbr = 0;
				while($row = mysql_fetch_assoc($ispiti))
				{
					$rbr++;
					$predmet = $row["predmet"];
					$nastavnik = $row["nastavnik"];
					$datumIspita = $row["datumIspita"];
					$ocjena = $row["ocjena"];

					echo '<tr><td>'.$rbr.'</td><td>'.$predmet.'</td><td>'.$nastavnik.'</td><td>'.$datumIspita.'</td><td>'.$ocjena.'</td></tr>';
				}

				echo '</table>';
			} else {
				echo 'Nema rezultata!';
			}
		?>
	</body>
</html>