File "dashboard_menu.php"

Full Path: /home/refref/public_html/wp-admin/public/dashboard_menu.php
File size: 2.2 KB
MIME-type: text/x-php
Charset: utf-8

<?php
	include_once('includes/connect_database.php'); 
	include_once('functions.php'); 
?>

<?php

	//Total category count
	$sql_category = "SELECT COUNT(*) as num FROM tbl_news_category";
	$total_category = mysqli_query($connect, $sql_category);
	$total_category = mysqli_fetch_array($total_category);
	$total_category = $total_category['num'];

	//Total news count
	// $news_query = "SELECT COUNT(*) as num FROM tbl_news";
	// $total_news = mysqli_fetch_array(mysqli_query($news_query));
	// $total_news = $total_news['num'];
	$sql_news = "SELECT COUNT(*) as num FROM tbl_news";
	$total_news = mysqli_query($connect, $sql_news);
	$total_news = mysqli_fetch_array($total_news);
	$total_news = $total_news['num'];

?>
<div id="content" class="container col-md-12">

<div class="col-md-12">
		<h1>Dashboard</h1>
		<hr/>
	</div>

 		<a href="category.php">
			<div class="col-sm-6 col-md-2">
	            <div class="thumbnail">    
	              <div class="caption">
	              <center>
	              <img src="images/ic_category.png" width="100" height="100">
	                <h3><?php echo $total_category;?></h3>
	                <p class="detail">News Category</p>  
	                </center>
	              </div>
	            </div>
	         </div>
	    </a>

		<a href="news.php">
          <div class="col-sm-6 col-md-2">
            <div class="thumbnail">    
              <div class="caption">
              <center>
              <img src="images/ic_news.png" width="100" height="100">
                <h3><?php echo $total_news;?></h3>
                <p class="detail">News List</p>  
                </center>
              </div>
            </div>
          </div>
        </a>

        <a href="admin.php">
          <div class="col-sm-6 col-md-2">
            <div class="thumbnail"> 
              <div class="caption">
              <center>
              <img src="images/ic_setting.png" width="100" height="100">
                <h3><br></h3>
                <p class="detail">Setting</p>     
                </center>
              </div>
            </div>
          </div>
        </a>
</div>

<?php include_once('includes/close_database.php'); ?>