I'll create a comprehensive admin panel with all the requested features. Here's the complete solution: pdo = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME, DB_USER, DB_PASS); $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { die("Database connection failed: " . $e->getMessage()); } } public function query($sql, $params = []) { $stmt = $this->pdo->prepare($sql); $stmt->execute($params); return $stmt; } public function fetchAll($sql, $params = []) { $stmt = $this->query($sql, $params); return $stmt->fetchAll(PDO::FETCH_ASSOC); } public function fetch($sql, $params = []) { $stmt = $this->query($sql, $params); return $stmt->fetch(PDO::FETCH_ASSOC); } public function lastInsertId() { return $this->pdo->lastInsertId(); } } function isLoggedIn() { return isset($_SESSION['admin_id']); } function redirect($url) { header("Location: $url"); exit(); } function sanitize($data) { return htmlspecialchars(trim($data), ENT_QUOTES, 'UTF-8'); } function getSetting($name) { $db = new Database(); $result = $db->fetch("SELECT * FROM settings WHERE id = 1"); return $result[$name] ?? null; } function getAdmin($id) { $db = new Database(); return $db->fetch("SELECT * FROM admins WHERE admin_id = ?", [$id]); } function getAllTables() { $db = new Database(); return $db->fetchAll("SHOW TABLES"); } function getTableColumns($table) { $db = new Database(); return $db->fetchAll("SHOW COLUMNS FROM $table"); } fetch("SELECT * FROM admins WHERE username = ?", [$username]); if ($admin && password_verify($password, $admin['password'])) { $_SESSION['admin_id'] = $admin['admin_id']; $_SESSION['admin_type'] = $admin['admin_type']; redirect('index.php'); } else { $error = "Invalid username or password"; } } ?> Admin Login

Admin Login

Admin Dashboard

Dashboard

Total Clients

fetch("SELECT COUNT(*) as count FROM clients")['count']; ?>

Total Orders

fetch("SELECT COUNT(*) as count FROM orders")['count']; ?>

Total Payments

fetch("SELECT SUM(payment_amount) as total FROM payments")['total']; ?>

$

Recent Orders

fetchAll("SELECT o.order_id, c.name, o.order_status, o.order_charge FROM orders o JOIN clients c ON o.client_id = c.client_id ORDER BY o.order_create DESC LIMIT 5"); foreach ($recentOrders as $order): ?>

ID	Client	Status	Amount
			$

Recent Payments

fetchAll("SELECT p.payment_id, c.name, p.payment_amount, p.payment_status FROM payments p JOIN clients c ON p.client_id = c.client_id ORDER BY p.payment_create_date DESC LIMIT 5"); foreach ($recentPayments as $payment): ?>

ID	Client	Amount	Status
		$

query("DELETE FROM clients WHERE client_id = ?", [$id]); $_SESSION['message'] = "Client deleted successfully"; redirect('clients.php'); break; case 'edit': $client = $db->fetch("SELECT * FROM clients WHERE client_id = ?", [$id]); break; } } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $data = [ 'name' => sanitize($_POST['name']), 'email' => sanitize($_POST['email']), 'username' => sanitize($_POST['username']), 'telephone' => sanitize($_POST['telephone']), 'balance' => (float)$_POST['balance'], 'spent' => (float)$_POST['spent'], 'client_type' => sanitize($_POST['client_type']), 'status' => sanitize($_POST['status']) ]; if (isset($_POST['client_id'])) { // Update existing client $id = (int)$_POST['client_id']; $db->query("UPDATE clients SET name = :name, email = :email, username = :username, telephone = :telephone, balance = :balance, spent = :spent, client_type = :client_type, status = :status WHERE client_id = $id", $data); $_SESSION['message'] = "Client updated successfully"; } else { // Add new client $data['password'] = password_hash($_POST['password'], PASSWORD_DEFAULT); $data['register_date'] = date('Y-m-d H:i:s'); $db->query("INSERT INTO clients (name, email, username, password, telephone, balance, spent, client_type, status, register_date) VALUES (:name, :email, :username, :password, :telephone, :balance, :spent, :client_type, :status, :register_date)", $data); $_SESSION['message'] = "Client added successfully"; } redirect('clients.php'); } // Get all clients $clients = $db->fetchAll("SELECT * FROM clients ORDER BY client_id DESC"); ?> Manage Clients

Manage Clients

ID	Name	Email	Username	Balance	Spent	Status	Actions
				$	$

query("DELETE FROM orders WHERE order_id = ?", [$id]); $_SESSION['message'] = "Order deleted successfully"; redirect('orders.php'); break; case 'edit': $order = $db->fetch("SELECT * FROM orders WHERE order_id = ?", [$id]); break; case 'refund': $order = $db->fetch("SELECT * FROM orders WHERE order_id = ?", [$id]); if ($order && !$order['refunded']) { $refundAmount = $order['order_charge'] * 0.8; // 80% refund $db->query("UPDATE orders SET refunded = 1, refunded_amount = ? WHERE order_id = ?", [$refundAmount, $id]); $db->query("UPDATE clients SET balance = balance + ? WHERE client_id = ?", [$refundAmount, $order['client_id']]); $_SESSION['message'] = "Order refunded successfully"; } redirect('orders.php'); break; } } // Get all orders with client and service info $orders = $db->fetchAll("SELECT o.*, c.name as client_name, s.service_name FROM orders o JOIN clients c ON o.client_id = c.client_id JOIN services s ON o.service_id = s.service_id ORDER BY o.order_create DESC"); ?> Manage Orders

Manage Orders

ID	Client	Service	Charge	Status	Date	Refunded	Actions
			$				Refund

query("DELETE FROM payments WHERE payment_id = ?", [$id]); $_SESSION['message'] = "Payment deleted successfully"; redirect('payments.php'); break; case 'edit': $payment = $db->fetch("SELECT * FROM payments WHERE payment_id = ?", [$id]); break; case 'approve': $payment = $db->fetch("SELECT * FROM payments WHERE payment_id = ?", [$id]); if ($payment && $payment['payment_status'] == '1') { $db->query("UPDATE payments SET payment_status = '2' WHERE payment_id = ?", [$id]); $db->query("UPDATE clients SET balance = balance + ? WHERE client_id = ?", [$payment['payment_amount'], $payment['client_id']]); $_SESSION['message'] = "Payment approved successfully"; } redirect('payments.php'); break; } } // Get all payments with client info $payments = $db->fetchAll("SELECT p.*, c.name as client_name FROM payments p JOIN clients c ON p.client_id = c.client_id ORDER BY p.payment_create_date DESC"); ?> Manage Payments

Manage Payments

ID	Client	Amount	Method	Status	Date	Actions
		$		'Pending', '2' => 'Approved', '3' => 'Rejected' ]; echo $statusText[$payment['payment_status']] ?? 'Unknown'; ?>		Approve

query("DELETE FROM services WHERE service_id = ?", [$id]); $_SESSION['message'] = "Service deleted successfully"; redirect('services.php'); break; case 'edit': $service = $db->fetch("SELECT * FROM services WHERE service_id = ?", [$id]); break; } } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $data = [ 'service_name' => sanitize($_POST['service_name']), 'service_description' => sanitize($_POST['service_description']), 'service_price' => sanitize($_POST['service_price']), 'service_min' => (int)$_POST['service_min'], 'service_max' => (int)$_POST['service_max'], 'category_id' => (int)$_POST['category_id'], 'service_type' => sanitize($_POST['service_type']), 'status' => sanitize($_POST['status']) ]; if (isset($_POST['service_id'])) { // Update existing service $id = (int)$_POST['service_id']; $db->query("UPDATE services SET service_name = :service_name, service_description = :service_description, service_price = :service_price, service_min = :service_min, service_max = :service_max, category_id = :category_id, service_type = :service_type, status = :status WHERE service_id = $id", $data); $_SESSION['message'] = "Service updated successfully"; } else { // Add new service $db->query("INSERT INTO services (service_name, service_description, service_price, service_min, service_max, category_id, service_type, status) VALUES (:service_name, :service_description, :service_price, :service_min, :service_max, :category_id, :service_type, :status)", $data); $_SESSION['message'] = "Service added successfully"; } redirect('services.php'); } // Get all services with category info $services = $db->fetchAll("SELECT s.*, c.category_name FROM services s JOIN categories c ON s.category_id = c.category_id ORDER BY s.service_id DESC"); // Get all categories for dropdown $categories = $db->fetchAll("SELECT * FROM categories ORDER BY category_name"); ?> Manage Services

Manage Services

ID	Name	Description	Price	Category	Min	Max	Status	Actions
		...	$

query("DELETE FROM categories WHERE category_id = ?", [$id]); $_SESSION['message'] = "Category deleted successfully"; redirect('categories.php'); break; case 'edit': $category = $db->fetch("SELECT * FROM categories WHERE category_id = ?", [$id]); break; } } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $data = [ 'category_name' => sanitize($_POST['category_name']), 'category_type' => sanitize($_POST['category_type']), 'status' => sanitize($_POST['status']) ]; if (isset($_POST['category_id'])) { // Update existing category $id = (int)$_POST['category_id']; $db->query("UPDATE categories SET category_name = :category_name, category_type = :category_type, status = :status WHERE category_id = $id", $data); $_SESSION['message'] = "Category updated successfully"; } else { // Add new category $data['category_line'] = 1; $db->query("INSERT INTO categories (category_name, category_line, category_type, status) VALUES (:category_name, :category_line, :category_type, :status)", $data); $_SESSION['message'] = "Category added successfully"; } redirect('categories.php'); } // Get all categories $categories = $db->fetchAll("SELECT * FROM categories ORDER BY category_id DESC"); ?> Manage Categories

Manage Categories

ID	Name	Type	Status	Actions