";
for ($i = 0; $i < $data_items ; $i++)
{
//Calculate Width of bar for this Caption
$width = round(($percent[$i]*$table_width)/$highest_percent);
echo "| ".
"$caption[$i] | ".
"".
"![](\"../uni-umfrage/dot_blu.gif\") ".
" $percent[$i]% | ";
$graph=$graph."&data[".$caption[$i]."]=".$val[$i];
}
echo " ".
"Gesamt: $total";
if ($mittel!='0') echo "
Durchschnitt: ".round($mittel,2);
echo " |  ";
}
function menge($feld,$name,$ID){
include("../../etc/connecti.php");
if($name=="") $name=$feld;
do {
@$vysledek=MySQLi_Query($spojeni,"SELECT AVG(".$feld.") as schnitt FROM uni_umfrage WHERE uni_id=".$ID);
$prumer=MySQLi_Fetch_Array($vysledek);
@$vysledek=MySQLi_Query($spojeni,"SELECT distinct ".$feld." FROM uni_umfrage WHERE uni_id=".$ID." order by ".$feld);
while($zaznam=MySQLi_Fetch_Array($vysledek)) {
@$vysledek2=MySQLi_Query($spojeni,"SELECT count(*) FROM uni_umfrage where ".$feld."='".$zaznam[$feld]."' AND uni_id=".$ID);
$zaznam2=MySQLi_Fetch_Array($vysledek2);
if($zaznam[$feld]!="" and $zaznam[$feld]!='0') $text=$text.$zaznam[$feld].":".$zaznam2['0']."*";
}
}while(false);
print_graph(substr($text,0,-1),$name,$prumer['0'],100,15);
}
function schnitt_alle($feld){
include("../../etc/connecti.php");
do {
@$vysledek=MySQLi_Query($spojeni,"SELECT AVG(".$feld.") as schnitt FROM uni_umfrage");
$prumer=MySQLi_Fetch_Array($vysledek);
echo "Durchschnitt aller Universitäten: ".round($prumer["schnitt"],2)." ";
}while(false);
}
function spitzenreiter($feld){
include("../../etc/connecti.php");
$bester_schnitt=6;
do {
@$vysledek=MySQLi_Query($spojeni,"SELECT uni_id,count(*) as anzahl FROM uni_umfrage group by uni_id having anzahl>5");
while($zaznam=MySQLi_Fetch_Array($vysledek)) {
@$vysledek2=MySQLi_Query($spojeni,"SELECT AVG($feld) FROM uni_umfrage where uni_id='".$zaznam['uni_id']."'");
$schnitt=MySQLi_Fetch_Array($vysledek2);
if ($schnitt['0']<$bester_schnitt) {
$bester_schnitt=$schnitt['0'];
$uni_id=$zaznam['uni_id'];
}
}
@$vysledek=MySQLi_Query($spojeni,"SELECT Name, Ort FROM university where ID=$uni_id");
$name=MySQLi_Fetch_Array($vysledek);
echo "Spitzenreiter: ".round($bester_schnitt,2)." (".$name['Ort'].":".$name['0'].") |