1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : dashboard.php
back
<?php include("includes/header.php"); ?>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
  <!-- Navbar -->
  <?php include("includes/top_nav.php");?>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <?php include("includes/side_nav.php");?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Dashboard</h1>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <?php
        $get_menu_course="SELECT * FROM menu_course";
        $run_menu_course=query($get_menu_course);
        $total_menu_course=row_count($run_menu_course);
        $get_menu_show_course="SELECT * FROM menu_course WHERE menu_course_status='1'";
        $run_menu_show_course=query($get_menu_show_course);
        $total_menu_show_course=row_count($run_menu_show_course);
        $get_menu_hide_course="SELECT * FROM menu_course WHERE menu_course_status='0'";
        $run_menu_hide_course=query($get_menu_hide_course);
        $total_menu_hide_course=row_count($run_menu_hide_course);

        $get_all_course="SELECT * FROM courses";
        $run_all_course=query($get_all_course);
        $total_course=row_count($run_all_course);
        $get_show_course="SELECT * FROM courses WHERE status='1'";
        $run_show_course=query($get_show_course);
        $total_show_course=row_count($run_show_course);
        $get_hide_course="SELECT * FROM courses WHERE status='0'";
        $run_hide_course=query($get_hide_course);
        $total_hide_course=row_count($run_hide_course);
        ?>
	<!-- Main content -->
  <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        <div class="row">
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3><?php  echo $total_menu_course; ?></h3>

                <p>Menu Course</p>
              </div>
              
              <a href="view_all_menu.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3><?php  echo $total_menu_show_course; ?></h3>

                <p>Menu Show Course</p>
              </div>
              
              <a href="view_all_menu.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3><?php  echo $total_menu_hide_course; ?></h3>

                <p>Menu Hide Course</p>
              </div>
              
              <a href="view_all_menu.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-secondary">
              <div class="inner">
                <h3><?php  echo $total_course; ?></h3>

                <p>Sub Menu Course</p>
              </div>
              
              <a href="view_posts.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
                <!-- small box -->
                <div class="small-box bg-secondary">
                  <div class="inner">
                    <h3><?php echo $total_show_course; ?></h3>

                    <p>Sub Menu Show Courses</p>
                  </div>
                  
                  <a href="view_posts.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
              </div>
          <div class="col-lg-3 col-6">
                <!-- small box -->
                <div class="small-box bg-secondary">
                  <div class="inner">
                    <h3><?php echo $total_hide_course;  ?></h3>

                    <p>Sub Menu Hide Courses</p>
                  </div>
                  
                  <a href="view_posts.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
              </div>
          <div class="col-lg-3 col-6">
                <!-- small box -->
                <div class="small-box bg-secondary">
                  <div class="inner">
                    <h3>Coming Soon</h3>

                    <p>Blog</p>
                  </div>
                  
                  <a href="#" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                </div>
              </div>
        </div>
      </div>
    </section>
   
    <!-- /.content -->
	
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <?php include("includes/footer.php");?>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<?php include("includes/scripts.php"); ?>
</body>
</html>