query($sql) as $puke)
$ziedi[] = $puke["puku_nosaukums"];
$ziedi = array_unique($ziedi);
foreach($ziedi as $zieds) {
echo $zieds.'
';
}
# Izvelkam kategorijas
$kategorija = array();
foreach ($conn->query($sql) as $ziedu_kategorija)
$kategorija[] = $ziedu_kategorija["nosaukums"];
$kategorija = array_unique($kategorija);
foreach($kategorija as $val) {
echo $val.'
';
}
*/
$categories = $conn->query("SELECT zid, nosaukums FROM ziedu_kategorijas ORDER BY nosaukums ASC");
$flowers = [];
foreach ($categories as $category)
{
$cat = $category['zid'];
$flowers[$category['zid']] = "SELECT puku_nosaukums FROM ziedi WHERE ziedu_id = $cat ORDER BY puku_nosaukums ASC, $category[zid]"; // prepared statement, OBLIGĀTI (http://php.net/manual/en/mysqli.prepare.php)
}
// alternatīvi, ekonomējot SQL pieprasījumus:
$tmp = $conn->query("SELECT ziedu_id, puku_nosaukums FROM ziedi ORDER BY puku_nosaukums ASC");
$flowers = [];
foreach ($tmp as $flower)
{
$flowers[$flower['ziedu_id']][] = $flower['puku_nosaukums'];
}
// izvade:
foreach ($categories as $category)
{
echo $category['nosaukums'].'
';
foreach ($flowers[$category['ziedu_id']] as $flower)
{
if(empty($flower['puku_nosaukums'])) {
echo 'Ziedu nav!';
} else {
echo $flower['puku_nosaukums'];
}
}
}
?>