<div class="span6">
<h1>Explore the Dictionary</h1>
<h3>Most Viewed Items</h3>
<ul>
<?php
//open DB
include dirname(__FILE__) . '/include/dbconnopen.php';
$most_viewed_results = mysqli_query($cnnCDD, "Call Main_Most_Viewed()");
//close DB
include dirname(__FILE__) . '/include/dbconnclose.php';
?>
<?php
while ($result_element = mysqli_fetch_assoc($most_viewed_results)) {
//if element is a database
if ($result_element['Element_Type'] == 'Database') {
$database = Database::get_database_info($result_element['Element_ID']);
?>
<li><a href="database_info.php?database_id=<?php
echo $database['Database_ID'];
?>
"><i class="icon-th-large"></i> <?php
echo $database['Database_Name'];
?>
</a> (database)</li>
<?php
} else {
if ($result_element['Element_Type'] == 'Table') {
$table = Table::get_table_info($result_element['Element_ID']);
?>
<li><a href="table_info.php?table_id=<?php
echo $table['Table_ID'];
<?php
include 'classes/database.php';
include 'classes/business_function.php';
include 'classes/keyword.php';
$database_info = Database::get_database_info($_GET['database_id']);
//if the user is not logged in and the item isn't public
if (!isset($_COOKIE['user_id']) && $database_info['Public'] == '0') {
header("Location: " . $_SERVER['HTTP_REFERER']);
}
Database::add_view($_GET['database_id']);
//recently viewed link
$recently_viewed_link = '<li><a href="database_info.php?database_id=' . $database_info['Database_ID'] . '"><i class="icon-th-large"></i> ' . $database_info['Database_Name'] . '</a> (database)</li>';
if (stripslashes($_COOKIE['recently_viewed'][0]) != $recently_viewed_link) {
//add item to recently viewed
setcookie("recently_viewed[4]", stripslashes($_COOKIE['recently_viewed'][3]));
setcookie("recently_viewed[3]", stripslashes($_COOKIE['recently_viewed'][2]));
setcookie("recently_viewed[2]", stripslashes($_COOKIE['recently_viewed'][1]));
setcookie("recently_viewed[1]", stripslashes($_COOKIE['recently_viewed'][0]));
setcookie("recently_viewed[0]", $recently_viewed_link);
}
include 'include/header.php';
?>
<br />
<div style="font-weight: bold; font-size: 20px; font-family: arial;">
Database Detail
</div>
<br />
<div id="database_info_static">
<table class="table table-striped table-bordered">
<tr>
