{source}
<?php
$jinput = JFactory::getApplication('site')->input;
$prof = $jinput->get('prof', null, null);
?>
<?php
// Create a new query object. ------------------------ USAVRSAVANJE ------------------------
$query = $db->getQuery(true);
$query->select($db->quoteName('usavr'));
$query->from($db->quoteName('#__usavr'));
$query->where($db->quoteName('prof') . "=". $db->quote($prof));
$query->order($db->quoteName('godina') . ' DESC');
$db->setQuery($query);
$usa = $db->loadObjectList();
?>
<?php
// Create a new query object. ------------------------ TITULA ------------------------
$query = $db->getQuery(true);
$query->select($db->quoteName('titula'));
$query->from($db->quoteName('#__nastavnici'));
$query->where($db->quoteName('prof') . "=". $db->quote($prof));
$db->setQuery($query);
$titula = $db->loadResult();
?>
<?php
// Create a new query object. ------------------------ IME I PREZIME ------------------------
$query = $db->getQuery(true);
$query->select($db->quoteName('ime_prezime'));
$query->from($db->quoteName('#__nastavnici'));
$query->where($db->quoteName('prof') . "=". $db->quote($prof));
$db->setQuery($query);
$imeprezime = $db->loadResult();
?>
<h3>
<?php
echo $titula . " " . $imeprezime;
?>
</h3>
<br />
<div class="container-fluid">
<div class="row">
<div class="col-xs-12 col-sm-12 col-md-12">
<?php
echo "<ol>";
foreach ($usa as $item) {
echo "<li>$item->usavr</li>";
}
echo "</ol>";
?>
</div>
</div>
</div>
{/source}















