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']; ?> "><i class="icon-th"></i> <?php echo $table['Table_Name']; ?> </a> (table)</li> <?php } else { if ($result_element['Element_Type'] == 'Variable') { $variable = Variable::get_variable_info($result_element['Element_ID']); ?> <li><a href="variable_info.php?variable_id=<?php echo $variable['Variable_ID'];
<?php include 'classes/database.php'; include 'classes/table.php'; include 'classes/keyword.php'; $table_info = Table::get_table_info($_GET['table_id']); //if the user is not logged in and the item isn't public if (!isset($_COOKIE['user_id']) && $table_info['Public'] == '0') { header("Location: " . $_SERVER['HTTP_REFERER']); } Table::add_view($_GET['table_id']); //recently viewed link $recently_viewed_link = '<li><a href="table_info.php?table_id=' . $table_info['Table_ID'] . '"><i class="icon-th"></i> ' . $table_info['Table_Name'] . '</a> (table)</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;"> Table Detail </div> <br /> <div id="table_info_static"> <table class="table table-striped table-bordered"> <tr>