index.php

<?php
session_start();
require("mainconfig.php");
$msg_type = "nothing";

if (isset($_SESSION['user'])) {
	$sess_username = $_SESSION['user']['username'];
	$check_user = mysqli_query($db, "SELECT * FROM users WHERE username = '$sess_username'");
	$data_user = mysqli_fetch_assoc($check_user);
	if (mysqli_num_rows($check_user) == 0) {
		header("Location: ".$cfg_baseurl."logout.php");
	} else if ($data_user['status'] == "Suspended") {
		header("Location: ".$cfg_baseurl."logout.php");
	}

	$check_order = mysqli_query($db, "SELECT SUM(price) AS total FROM orders WHERE user = '$sess_username'");
	$data_order = mysqli_fetch_assoc($check_order);
	$count_users = mysqli_num_rows(mysqli_query($db, "SELECT * FROM users"));
} else {
    header("Location: ".$cfg_baseurl."landing.php");
}
	if (isset($_POST['login'])) {
		$post_username = mysqli_real_escape_string($db, trim($_POST['username']));
		$post_password = mysqli_real_escape_string($db, trim($_POST['password']));
		if (empty($post_username) || empty($post_password)) {
			$msg_type = "error";
			$msg_content = "<b>Gagal:</b> Mohon mengisi semua input.";
		} else {
			$check_user = mysqli_query($db, "SELECT * FROM users WHERE username = '$post_username'");
			if (mysqli_num_rows($check_user) == 0) {
				$msg_type = "error";
				$msg_content = "<b>Gagal:</b> Username atau password salah.";
			} else {
				$data_user = mysqli_fetch_assoc($check_user);
				if ($post_password <> $data_user['password']) {
					$msg_type = "error";
					$msg_content = "<b>Gagal:</b> Username atau password salah.";
				} else if ($data_user['status'] == "Suspended") {
					$msg_type = "error";
					$msg_content = "<b>Gagal:</b> Akun nonaktif.";
				} else {
					$_SESSION['user'] = $data_user;
					header("Location: ".$cfg_baseurl);
				}
			}
		}
	}

include("lib/header.php");
if (isset($_SESSION['user'])) {
?>

            <div class="row">
							    <div class="col-md-12">
                                    <div class="panel panel-default">
										<div class="panel-heading">
											<h3 class="panel-title"><i class="fa fa-line-chart"></i> Pesanan 7 Hari Terakhir</h3>
										</div>
										<div class="box-body">
										    <div class="box-body chart-responsive">
                                                <div class="chart" id="line-chart" style="height: 300px;"></div>
                                              </div>
                                            </div>
									</div>
                                </div>
                            </div>
				<div class="row">
					<div class="col-md-12">
						<div class="callout callout-info">
							<h4><i class="fa fa-bullhorn"></i> Selamat datang <?php echo $sess_username; ?> :)</h4>
							<p>Selamat berbelanja !</p>
						</div>
					</div>
				</div>
						          <div class="row">
						              <div class="col-md-6 col-sm-6 col-xs-12">
						              <div class="small-box bg-aqua">
			<div class="inner">
				<h3>Rp <?php echo number_format($data_order['total'],0,',','.'); ?></h3>
				<p>Total pesanan</p>
			</div>
			<div class="icon">
				<i class="fa fa-shopping-cart"></i>
			</div>
		</div>
		</div>
		<div class="col-md-6 col-sm-6 col-xs-12">
						              <div class="small-box bg-aqua">
			<div class="inner">
				<h3>Rp <?php echo number_format($data_user['balance'],0,',','.'); ?></h3>
				<p>Sisa saldo</p>
			</div>
			<div class="icon">
				<i class="fa fa-money"></i>
			</div>
		</div>
		</div>

            </div>
            <div class="clearfix visible-sm-block"></div>






							<div class="row">
								<div class="col-md-12">
									<div class="panel panel-default">
										<div class="panel-heading">
											<h3 class="panel-title"><i class="fa fa-info-circle"></i> Informasi</h3>
										</div>
										<div class="panel-body">
											<div class="table-responsive">
												<table class="table table-striped table-bordered table-hover m-0">
													<thead>

													<tr>
														<th>#</th>
														<th>Tanggal</th>
														<th>Isi</th>
													</tr>
												</thead>
												<tbody>
													<?php
													$check_news = mysqli_query($db, "SELECT * FROM news ORDER BY id DESC LIMIT 5");
													$no = 1;
													while ($data_news = mysqli_fetch_assoc($check_news)) {
													?>
													<tr>
														<th scope="row"><?php echo $no; ?></th>
														<td><?php echo $data_news['date']; ?></td>
														<td><?php echo $data_news['content']; ?></td>
													</tr>
													<?php
													$no++;
													}
													?>
												</tbody>
											</table>
										</div>
									</div>
								</div>
							</div>
						</div>

						<!--end row -->
<?php
}
include("lib/footer.php");
?>