Radionica programiranje 44. Računi 1. dio

SQL upit: Lista polaznika

===========================

SELECT DISTINCT ime, prezime, id_polaznika

FROM polaznici_tecaja

Forma padajući izbornik bez gumba submit. Opcije su imena i prezimena polaznika iz Liste polaznika
==============================================================
<form action='o.php' method='get'>

    <select id="polaznici" 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))

{

    print "<option value=" . $row["id_polaznika"] . ">"

    . $row["ime"] . " " . $row["prezime"] . "</option>";

}

?>

    </select>

</form>

Odabrano ime i prezime polaznika ostaje u fokusu nakon što smo odabrali polaznika
==============================================================
<form action='o.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>