SQL upit: Upit za obrazac Računi
============================================
<html>
<head>
<title>Report Responsive Web Design</title>
<meta charset="UTF-8">
<link rel="stylesheet" href="stil_izvjesce.css" type="text/css">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<div class="container">
<form action='z.php' method='get'>
<select name="polaznici" onchange="this.form.submit();">
<?php
$link = mysqli_connect("localhost", "root", "", "mariva");
$sql = "SELECT DISTINCT ime, prezime, id_polaznika
FROM polaznici_tecaja";
$result = mysqli_query($link, $sql);
While ($row = mysqli_fetch_assoc($result))
{
if ($row["id_polaznika"] == $_GET["polaznici"]) {
print "<option value=" . $row["id_polaznika"] . " selected>"
. $row["ime"] . " " . $row["prezime"] . "</option>";
}
else {
print "<option value=" . $row["id_polaznika"] . ">"
. $row["ime"] . " " . $row["prezime"] . "</option>";
}
}
?>
</select>
</form>
<table>
<tr>
<td>Id računa</td>
<td>Id polaznika</td>
<td>Ime primatelja</td>
<td>Prezime primatelja</td>
<td>Ulica i broj</td>
<td>Grad</td>
<td>Poštanski broj</td>
<td>Id način plaćanja</td>
<td>datum plaćanja</td>
<td>Rok plaćanja</td>
<td>Knjige</td>
<td>Iznos računa</td>
</tr>
<?php
$link = mysqli_connect("localhost", "root", "", "mariva");
$sql = "SELECT DISTINCT id_racuna, racuni.id_polaznika AS racuni_id_polaznika, polaznici_tecaja.ime AS polaznici_tecaja_ime, polaznici_tecaja.prezime AS polaznici_tecaja_prezime, polaznici_tecaja.ulicaibroj AS polaznici_tecaja_ulicaibroj, polaznici_tecaja.grad AS polaznici_tecaja_grad, polaznici_tecaja.postanski_broj AS polaznici_tecaja_postanski_broj, racuni.ime_primatelja AS racuni_ime_primatelja, racuni.prezime_primatelja AS racuni_prezime_primatelja, racuni.ulica_i_broj AS racuni_ulica_i_broj, racuni.grad AS racuni_grad, racuni.postanski_broj AS racuni_postanski_broj, racuni.id_nacin_placanja AS racuni_id_nacin_placanja, racuni.datum_placanja AS racuni_datum_placanja, racuni.rok_placanja AS racuni_rok_placanja, racuni.knjige AS racuni_knjige, racuni.iznos_racuna AS racuni_iznos_racuna
FROM polaznici_tecaja
INNER JOIN racuni
ON polaznici_tecaja.id_polaznika
= racuni.id_polaznika
ORDER BY id_racuna DESC LIMIT 1";
$result = mysqli_query($link, $sql);
While ($row = mysqli_fetch_assoc($result))
{
print "<tr>";
print "<td>" . $row['id_racuna'] . "</td>";
print "<td>" . $row['racuni_id_polaznika'] . "</td>";
print "<td>" . $row['racuni_ime_primatelja'] . "</td>";
print "<td>" . $row['racuni_prezime_primatelja'] . "</td>";
print "<td>" . $row['racuni_ulica_i_broj'] . "</td>";
print "<td>" . $row['racuni_grad'] . "</td>";
print "<td>" . $row['racuni_postanski_broj'] . "</td>";
print "<td>" . $row['racuni_id_nacin_placanja'] . "</td>";
print "<td>" . $row['racuni_datum_placanja'] . "</td>";
print "<td>" . $row['racuni_rok_placanja'] . "</td>";
print "<td>" . $row['racuni_knjige'] . "</td>";
print "<td>" . $row['racuni_iznos_racuna'] . "</td>";
print "</tr>";
}
?>
</table>
</div>
</body>
</html>
Primjedbe
Objavi komentar