"; $url = $_SERVER['REQUEST_URI']; $path = explode("/", $url); // var_dump($path[1]); if ($path[1] == "bcu") $db = "logisys3_bcu"; else if ($path[1] == "bnu") $db = "logisys3_bnu"; else if ($path[1] == "dud") $db = "logisys3_dud"; else if ($path[1] == "rcub") $db = "logisys3_rcu"; else if ($path[1] == "ru") $db = "logisys3_rur"; $Query = "select fboardcode, fboardname, funivcode, funivname, date_format(now(), '%d/%m/%Y %r') as fdate FROM {$db}.masboard, {$db}.control c order by fboardcode"; $result = mysqli_query($conn, $Query); $row = mysqli_fetch_assoc($result); $Query2 = "select distinct fdegree, fdescpn from {$db}.entdeg;"; $result2 = mysqli_query($conn, $Query2); $row2 = mysqli_fetch_assoc($result2); ?>
Course wise statistics
Select Degree
All
{$row2['fdegree']}-{$row2['fdescpn']}"; while ($row = mysqli_fetch_assoc($result2)) { echo "
{$row['fdegree']}-{$row['fdescpn']}
"; } ?>