5. C

Třídní učitelka: [insert_php]
require_once( $_SERVER[‘DOCUMENT_ROOT’] . ‘/wp-config.php’ );
require_once( $_SERVER[‘DOCUMENT_ROOT’] . ‘/wp-includes/wp-db.php’ );
if (!$wpdb) {
$wpdb = new wpdb( DB_USER, DB_PASSWORD, DB_NAME, DB_HOST);
} else {
global $wpdb;
}
foreach( $wpdb->get_results(“SELECT * FROM ucitele WHERE trida=’5. C'”) as $key => $row) {
// each column in your row will be accessible like this
$zastupujici=$row->zastupujici;
$titul=$row->titul;
$jmeno=$row->jmeno;
$prijmeni=$row->prijmeni;
$cele_jmeno=$titul.” “.$jmeno.” “.$prijmeni;
$url=$row->url;
if($url<>“”) $vloz_url=”$cele_jmeno“; else $vloz_url=”$cele_jmeno”;
echo $vloz_url;
}
echo “

V případě nepřítomnosti zastupuje: “;
foreach( $wpdb->get_results(“SELECT * FROM ucitele WHERE id=’$zastupujici'”) as $key => $row) {
// each column in your row will be accessible like this
$titul=$row->titul;
$jmeno=$row->jmeno;
$prijmeni=$row->prijmeni;
$cele_jmeno=$titul.” “.$jmeno.” “.$prijmeni;
$url=$row->url;
if($url<>“”) $vloz_url=”$cele_jmeno“; else $vloz_url=”$cele_jmeno”;
echo $vloz_url;
}
[/insert_php]