Výklad pojmů

'; //poradnik poc. pismen pojmu $out.='
'; foreach($chars as $k=>$v) { $out.=''.$v.' '; } $out.='
'; //TOP pojmy $top_c=GetTopConception(); $out.='
'; foreach($top_c as $k=>$v) { $url='/informace/vyklad-pojmu/'.$v['urlid'].'/'; $out.=''.$v['s_pojem'].'
'; } $out.='
'; //END top Pojmy foreach($chars as $k=>$v) { $pojmy=GetConceptionsForChar($v); if(!$pojmy) continue; $out.='
'; foreach($pojmy as $k=>$v) { $url='/informace/vyklad-pojmu/'.$v['urlid'].'/'; $out.=''.$v['s_pojem'].'
'; } $out.='
'; } $out.=''; return $out; } function renderSlovnikLeftMenu() { global $db; $chars=GetChars(); $out=''; //poradnik poc. pismen pojmu $out.='
'; foreach($chars as $k=>$v) { $out.=''.$v.' '; } $out.='
'; //TOP pojmy $top_c=GetTopConception(); $out.='
'; foreach($top_c as $k=>$v) { $url='/informace/vyklad-pojmu/'.$v['urlid'].'/'; $out.=''.$v['s_pojem'].'
'; } $out.='
'; //END top Pojmy foreach($chars as $k=>$v) { $pojmy=GetConceptionsForChar($v); if(!$pojmy) continue; $out.='
'; foreach($pojmy as $k=>$v) { $url='/informace/vyklad-pojmu/'.$v['urlid'].'/'; $out.=''.$v['s_pojem'].'
'; } $out.='
'; } return $out; } function GetChars() { global $db; $dbSQL = "SELECT DISTINCT(char_id) FROM contentSystem.slovnik WHERE b_deleted=0"; $dbRes = mysqli_query($db, $dbSQL); while($row = @mysqli_fetch_array($dbRes)) { $ret[]=$row['char_id']; } return $ret; } /* * Vrati TOP pojmy zo slovnika */ function GetTopConception() { global $db; $dbSQL = "SELECT * FROM contentSystem.slovnik WHERE b_top=1 AND b_deleted=0"; $dbRes = mysqli_query($db, $dbSQL); while($row = @mysqli_fetch_array($dbRes)) { $ret[$row['id']]=$row; } return $ret; } /* * Vrati TOP pojmy zo slovnika */ function GetConceptionsForChar($char) { global $db; $dbSQL = "SELECT * FROM contentSystem.slovnik WHERE char_id='".$char."' AND b_deleted=0"; $dbRes = mysqli_query($db, $dbSQL); while($row = @mysqli_fetch_array($dbRes)) { $ret[$row['id']]=$row; } return $ret; } /* * Vrati pojem na zaklade urlid */ function GetConception($urlid) { global $db; $dbSQL = "SELECT * FROM contentSystem.slovnik WHERE urlid='".$urlid."' AND b_deleted=0"; $dbRes = mysqli_query($db, $dbSQL); $row = @mysqli_fetch_array($dbRes); return $row; } function RenderConception($urlid) { $row=GetConception($urlid); if(!$row) return ''; $out='
'; $out.='

'.$row['s_pojem'].'

'; $out.=$row['s_vyklad']; $out.='
'; return $out; } /* * vysklada zoznam boxuk pre hlavni pojmy */ function RenderTopConceptionsBox() { $top_pojmy=GetTopConception(); if(!$top_pojmy) return ''; $out=''; foreach($top_pojmy as $k=>$v) { $out.='
'; $out.='

'.$v['s_pojem'].'

'; $out.=$v['s_vyklad']; $out.='
'; } return $out; } /* * Vysklada seznam boxu pro dane pocatecni pismeno */ function RenderConceptionBox($char_id,$not_urlid=null) { $top_pojmy=GetConceptionsForChar($char_id); if(!$top_pojmy) return ''; $out=''; foreach($top_pojmy as $k=>$v) { if(!is_null($not_urlid) && $v['urlid']==$not_urlid) continue; //pokial chceme nejaky pojem preskocit $out.='
'; $out.='

'.$v['s_pojem'].'

'; $out.=$v['s_vyklad']; $out.='
'; } return $out; } ?>