include ("../db.php");
?>
Statistiky
zpět na galerii
/*
if ($_GET["level"]):
echo "";
else:
echo "";
endif;
echo "první úroveň";
if ($_GET["level"]):
echo "";
else:
echo "";
endif;
if ($_GET["level"]):
echo "";
else:
echo "";
endif;
echo "vše";
if ($_GET["level"]):
echo "";
else:
echo "";
endif;*/
?>
Přehled fotografií podle použitého ohniska v galerii
$_GET["level"]=1;
if ($_GET["level"]):
$result1 = mysqli_query($link, "SELECT COUNT(focal) AS pocet, focal FROM files WHERE level=1 GROUP BY focal");
else:
$result1 = mysqli_query($link, "SELECT COUNT(focal) AS pocet, focal FROM files GROUP BY focal");
endif;
while ($zaznam1 = mysqli_fetch_assoc($result1)):
$focal[SubStr($zaznam1["focal"], 0, StrPos($zaznam1["focal"], "mm")-1)] = $zaznam1["pocet"];
endwhile;
ksort ($focal);
/*echo "";
while (list ($key, $val) = each ($focal)):
$h = 200/max($focal)*$val;
echo "".$key." | ".$val." |
";
endwhile;
echo "
";*/
echo "";
while (list ($key, $val) = each ($focal)):
$h = 200/max($focal)*$val;
echo "".$val."
 | ";
endwhile;
reset($focal);
echo "
";
while (list ($key, $val) = each ($focal)):
echo "$key | ";
endwhile;
echo "
použité ohnisko (mm)";
?>
Přehled fotografií podle použité clony v galerii
if ($_GET["level"]):
$result1 = mysqli_query($link, "SELECT COUNT(apert) AS pocet, apert FROM files WHERE level=1 GROUP BY apert");
else:
$result1 = mysqli_query($link, "SELECT COUNT(apert) AS pocet, apert FROM files GROUP BY apert");
endif;
while ($zaznam1 = mysqli_fetch_assoc($result1)):
$apert[Substr($zaznam1["apert"], 2)] = $zaznam1["pocet"];
endwhile;
ksort ($apert);
echo "";
while (list ($key, $val) = each ($apert)):
$h = 200/max($apert)*$val;
echo "".$val."
 | ";
endwhile;
reset($apert);
echo "
";
while (list ($key, $val) = each ($apert)):
echo "$key | ";
endwhile;
echo "
použitá clona (f/)";
?>
Přehled fotografií podle použitého času v galerii
if ($_GET["level"]):
$result1 = mysqli_query($link, "SELECT COUNT(exp) AS pocet, exp FROM files WHERE level=1 GROUP BY exp");
else:
$result1 = mysqli_query($link, "SELECT COUNT(exp) AS pocet, exp FROM files GROUP BY exp");
endif;
while ($zaznam1 = mysqli_fetch_assoc($result1)):
$time = Substr($zaznam1["exp"], 0, StrPos($zaznam1["exp"], "&"));
if (StrPos($time, "/")>0):
$jm = Substr($time, 0, StrPos($time, "/"));
$cit = Substr($time, StrPos($time, "/")+1);
$time = $jm/$cit;
endif;
settype($time, double);
$exp[Substr($zaznam1["exp"], 0, StrPos($zaznam1["exp"], "&"))] = Array($time, $zaznam1["pocet"]);
endwhile;
asort($exp);
echo "";
while (list ($key, $val) = each ($exp)):
if ($val[1]>$max):
$max = $val[1];
endif;
endwhile;
reset($exp);
while (list ($key, $val) = each ($exp)):
$h = 200/$max*$val[1];
echo "".$val[1]."
![\"".$key."\" \"".$val[1]."\"](\"exp.gif\") | ";
endwhile;
reset($exp);
echo "
";
while (list ($key, $val) = each ($exp)):
echo "$key | ";
endwhile;
echo "
použitý čas (s) ";
?>