Mgr. Dana Pánková

[insert_php]
$id=9;$rozvrh=”pankova”;
$sql = mysql_query(“SELECT * FROM ucitele WHERE id=$id ORDER BY prijmeni, jmeno”);
while($row = mysql_fetch_array($sql)){foreach( $row AS $key => $val ){$key = stripslashes( $val );}
$kategorie=$row[‘kategorie’];
if($kategorie==1) $pozice=”učitel 1. stupně”;
if($kategorie==2) $pozice=”učitel 2. stupně”;
$trida=$row[‘trida’];
if($trida<>“—-“){
$trida_url= strtolower(iconv(‘UTF-8’, ‘ASCII//TRANSLIT’, $trida));
$trida_url= str_replace(‘ ‘, ‘-‘, trim($trida_url));
$trida_url= str_replace(‘.’, ”, trim($trida_url));
$trida_url=”$trida“;
}
else $trida_url=$trida;
$prijmeni=$row[‘prijmeni’];
$zastupujici=$row[‘zastupujici’];
$funkce=$row[‘funkce’];
$telefon=$row[‘telefon’];
$skype=$row[‘skype’];
if($skype<>“”) {
$telefon_skype=”telefon / skype”;
$url=”http://mystatus.skype.com/$skype.num”;
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
$skype_status=curl_exec($ch);
curl_close($ch);
if($skype_status==”2″) $skype_link=”“;
if($skype_status==”3″) $skype_link=”“;
if($skype_status==”5”) $skype_link=’‘;
if($skype_status==”1″) $skype_link=’‘;
}
else $telefon_skype=”telefon”;
$konzultace=$row[‘konzultace’];
$mail=$row[‘mail’];
$patro=$row[‘kabinet_patro’];
$dvere=$row[‘kabinet_dvere’];
if($patro==0) $kabinet=”přízemí”;
if($patro>0) $kabinet=”$patro. patro”;
if($dvere>0) $kabinet=$kabinet.”, č. dv. $dvere”;
}
if($zastupujici>0) {
$sql = mysql_query(“SELECT * FROM ucitele WHERE id=’$zastupujici'”);
while($row = mysql_fetch_array($sql)){foreach( $row AS $key => $val ){$key = stripslashes( $val );}
$titulz=$row[‘titul’];
$jmenoz=$row[‘jmeno’];
$prijmeniz=$row[‘prijmeni’];
$cele_jmenoz=$titulz.” “.$jmenoz.” “.$prijmeniz;
$urlz=$row[‘url’];
if($urlz<>“”) $vloz_urlz=”$cele_jmenoz“; else $vloz_urlz=”$cele_jmenoz”;
}
}
if($vloz_urlz==””) $vloz_urlz=”—-“;
[/insert_php]