Hackfut Security File Manager
Current Path:
/home/u126195517/domains/foodstamping.in/public_html/admin
home
/
u126195517
/
domains
/
foodstamping.in
/
public_html
/
admin
/
📁
..
📁
assets
📄
categories.php
(15.94 KB)
📄
get-product.php
(604 B)
📄
index.php
(7.83 KB)
📄
login.php
(4.52 KB)
📄
logout.php
(557 B)
📄
orders.php
(10.34 KB)
📄
product-action.php
(2.63 KB)
📄
product-images.php
(14.15 KB)
📄
product-save.php
(6.86 KB)
📄
product-specifications.php
(11.11 KB)
📄
products.php
(48.18 KB)
📄
reviews.php
(12.46 KB)
📄
specifications.php
(14.72 KB)
Editing: index.php
<?php session_start(); require_once '../config/database.php'; // Check if admin is logged in if(!isset($_SESSION['admin_id'])) { header("Location: login.php"); exit(); } $database = new Database(); $db = $database->getConnection(); // Get statistics $stats = []; // Total products $query = "SELECT COUNT(*) as total FROM products WHERE status = 1"; $stmt = $db->prepare($query); $stmt->execute(); $stats['products'] = $stmt->fetch(PDO::FETCH_ASSOC)['total']; // Total orders $query = "SELECT COUNT(*) as total FROM orders"; $stmt = $db->prepare($query); $stmt->execute(); $stats['orders'] = $stmt->fetch(PDO::FETCH_ASSOC)['total']; // Total revenue $query = "SELECT SUM(total_amount) as total FROM orders WHERE payment_status = 'paid'"; $stmt = $db->prepare($query); $stmt->execute(); $stats['revenue'] = $stmt->fetch(PDO::FETCH_ASSOC)['total'] ?? 0; // Recent orders $query = "SELECT * FROM orders ORDER BY created_at DESC LIMIT 5"; $stmt = $db->prepare($query); $stmt->execute(); $recent_orders = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Admin Dashboard - A-1 Common Seal</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css"> <style> .sidebar { min-height: 100vh; background: #343a40; } .sidebar .nav-link { color: #fff; padding: 15px 20px; } .sidebar .nav-link:hover { background: #495057; } .sidebar .nav-link.active { background: #007bff; } .stat-card { border-left: 4px solid; padding: 20px; margin-bottom: 20px; } </style> </head> <body> <div class="container-fluid"> <div class="row"> <!-- Sidebar --> <nav class="col-md-2 d-md-block sidebar"> <div class="position-sticky"> <h4 class="text-white p-3">Admin Panel</h4> <ul class="nav flex-column"> <li class="nav-item"> <a class="nav-link active" href="index.php"> <i class="fas fa-tachometer-alt"></i> Dashboard </a> </li> <li class="nav-item"> <a class="nav-link" href="products.php"> <i class="fas fa-box"></i> Products </a> </li> <li class="nav-item"> <a class="nav-link" href="categories.php"> <i class="fas fa-tags"></i> Categories </a> </li> <li class="nav-item"> <a class="nav-link" href="orders.php"> <i class="fas fa-shopping-cart"></i> Orders </a> </li> <li class="nav-item"> <a class="nav-link" href="logout.php"> <i class="fas fa-sign-out-alt"></i> Logout </a> </li> </ul> </div> </nav> <!-- Main Content --> <main class="col-md-10 ms-sm-auto px-md-4"> <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom"> <h1 class="h2">Dashboard</h1> <div class="btn-toolbar mb-2 mb-md-0"> <span>Welcome, <?php echo $_SESSION['admin_name']; ?></span> </div> </div> <!-- Statistics Cards --> <div class="row"> <div class="col-md-4"> <div class="card stat-card border-primary"> <div class="card-body"> <h5 class="card-title">Total Products</h5> <h2 class="text-primary"><?php echo $stats['products']; ?></h2> </div> </div> </div> <div class="col-md-4"> <div class="card stat-card border-success"> <div class="card-body"> <h5 class="card-title">Total Orders</h5> <h2 class="text-success"><?php echo $stats['orders']; ?></h2> </div> </div> </div> <div class="col-md-4"> <div class="card stat-card border-info"> <div class="card-body"> <h5 class="card-title">Total Revenue</h5> <h2 class="text-info">Rs. <?php echo number_format($stats['revenue'], 2); ?></h2> </div> </div> </div> </div> <!-- Recent Orders --> <div class="card mt-4"> <div class="card-header"> <h5>Recent Orders</h5> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>Order #</th> <th>Customer</th> <th>Amount</th> <th>Status</th> <th>Date</th> </tr> </thead> <tbody> <?php foreach($recent_orders as $order): ?> <tr> <td><?php echo $order['order_number']; ?></td> <td><?php echo $order['customer_name']; ?></td> <td>Rs. <?php echo number_format($order['total_amount'], 2); ?></td> <td> <span class="badge bg-<?php echo $order['status'] == 'delivered' ? 'success' : ($order['status'] == 'cancelled' ? 'danger' : 'warning'); ?>"> <?php echo ucfirst($order['status']); ?> </span> </td> <td><?php echo date('Y-m-d', strtotime($order['created_at'])); ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> </div> </div> </main> </div> </div> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script> </body> </html>
Upload File
Create Folder