<?php echo $pageTitle; ?> - P2P Donation Platform

I'll create the admin pages for your peer-to-peer donation platform. Here's the comprehensive solution:

Admin Dashboard

Total Users

Active Donations

Pending Withdrawals

Pending Approvals

Manage Users

ID	Full Name	Email	Phone	Status	Role	Actions
						Edit Delete

Manage Withdrawals

ID	User	Amount	Bank Details	Status	Date	Actions
						Approve Reject

Manage Donations

ID	Donor	Receiver	Amount	Status	Date	Actions
						Approve View

Manage Help Requests

ID	User	Amount	Status	Date	Actions
					Match View

System Settings

Admin Profile

' . $_SESSION['password_change_error'] . ''; unset($_SESSION['password_change_error']); } if (isset($_SESSION['password_change_success'])) { echo '

' . $_SESSION['password_change_success'] . '

'; unset($_SESSION['password_change_success']); } ?>

Change Password

query($sql); $row = $result->fetch_assoc(); return $row['total']; } function getActiveDonations() { global $conn; $sql = "SELECT COUNT(*) as total FROM donations WHERE status = 'completed'"; $result = $conn->query($sql); $row = $result->fetch_assoc(); return $row['total']; } function getPendingWithdrawals() { global $conn; $sql = "SELECT COUNT(*) as total FROM withdrawals WHERE status = 'pending'"; $result = $conn->query($sql); $row = $result->fetch_assoc(); return $row['total']; } function getPendingApprovals() { global $conn; $sql = "SELECT COUNT(*) as total FROM donations WHERE status = 'pending_approval'"; $result = $conn->query($sql); $row = $result->fetch_assoc(); return $row['total']; } function getAllUsers() { global $conn; $sql = "SELECT * FROM users ORDER BY created_at DESC"; $result = $conn->query($sql); $users = []; while ($row = $result->fetch_assoc()) { $users[] = $row; } return $users; } function getUserName($userId) { global $conn; $sql = "SELECT fullname FROM users WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $userId); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); return $row['fullname']; } function getUserRole($role) { $roles = [ 'user' => 'Regular User', 'editor' => 'Editor', 'admin' => 'Admin' ]; return $roles[$role] ?? $role; } function getWithdrawals() { global $conn; $sql = "SELECT * FROM withdrawals ORDER BY created_at DESC"; $result = $conn->query($sql); $withdrawals = []; while ($row = $result->fetch_assoc()) { $withdrawals[] = $row; } return $withdrawals; } function getBankDetails($userId) { global $conn; $sql = "SELECT bank_name, account_number FROM bank_details WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $userId); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); return $row ? $row['bank_name'] . ' - ' . $row['account_number'] : 'N/A'; } function getWithdrawalStatus($status) { $statuses = [ 'pending' => 'Pending', 'approved' => 'Approved', 'rejected' => 'Rejected', 'completed' => 'Completed' ]; return $statuses[$status] ?? $status; } function getDonations() { global $conn; $sql = "SELECT * FROM donations ORDER BY created_at DESC"; $result = $conn->query($sql); $donations = []; while ($row = $result->fetch_assoc()) { $donations[] = $row; } return $donations; } function getDonationStatus($status) { $statuses = [ 'pending' => 'Pending', 'pending_approval' => 'Pending Approval', 'approved' => 'Approved', 'completed' => 'Completed', 'cancelled' => 'Cancelled' ]; return $statuses[$status] ?? $status; } function getHelpRequests() { global $conn; $sql = "SELECT * FROM help_requests ORDER BY created_at DESC"; $result = $conn->query($sql); $requests = []; while ($row = $result->fetch_assoc()) { $requests[] = $row; } return $requests; } function getHelpRequestStatus($status) { $statuses = [ 'pending' => 'Pending', 'matched' => 'Matched', 'completed' => 'Completed', 'cancelled' => 'Cancelled' ]; return $statuses[$status] ?? $status; } function getSystemSettings() { global $conn; $sql = "SELECT * FROM system_settings LIMIT 1"; $result = $conn->query($sql); return $result->fetch_assoc(); } function getAdminProfile($adminId) { global $conn; $sql = "SELECT * FROM users WHERE id = ? AND role = 'admin'"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $adminId); $stmt->execute(); $result = $stmt->get_result(); return $result->fetch_assoc(); } function formatCurrency($amount) { return '₦' . number_format($amount, 2); } function formatDate($date) { return date('M d, Y H:i', strtotime($date)); } prepare($sql); $stmt->bind_param("s", $email); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 1) { $user = $result->fetch_assoc(); if (password_verify($password, $user['password'])) { $_SESSION['admin_id'] = $user['id']; return true; } } return false; } function adminLogout() { unset($_SESSION['admin_id']); session_destroy(); } <?php echo $pageTitle; ?> - P2P Donation Platform

connect_error) { die("Connection failed: " . $conn->connect_error); } // Set timezone date_default_timezone_set('Africa/Lagos'); // Error reporting error_reporting(E_ALL); ini_set('display_errors', 1); // Session configuration ini_set('session.cookie_httponly', 1); ini_set('session.cookie_secure', 1); ini_set('session.use_strict_mode', 1); -- Database schema for P2P Donation Platform CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fullname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(20) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('user','editor','admin') NOT NULL DEFAULT 'user', `is_active` tinyint(1) NOT NULL DEFAULT 1, `referral_code` varchar(20) DEFAULT NULL, `referred_by` int(11) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), UNIQUE KEY `phone` (`phone`), UNIQUE KEY `referral_code` (`referral_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `bank_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `bank_name` varchar(100) NOT NULL, `account_name` varchar(255) NOT NULL, `account_number` varchar(20) NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), CONSTRAINT `bank_details_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `donations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `donor_id` int(11) NOT NULL, `receiver_id` int(11) NOT NULL, `amount` decimal(12,2) NOT NULL, `receipt_path` varchar(255) DEFAULT NULL, `status` enum('pending','pending_approval','approved','completed','cancelled') NOT NULL DEFAULT 'pending', `donation_date` datetime NOT NULL DEFAULT current_timestamp(), `approval_date` datetime DEFAULT NULL, `completion_date` datetime DEFAULT NULL, `maturity_date` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `donor_id` (`donor_id`), KEY `receiver_id` (`receiver_id`), CONSTRAINT `donations_ibfk_1` FOREIGN KEY (`donor_id`) REFERENCES `users` (`id`), CONSTRAINT `donations_ibfk_2` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `help_requests` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `amount` decimal(12,2) NOT NULL, `status` enum('pending','matched','completed','cancelled') NOT NULL DEFAULT 'pending', `matched_donation_id` int(11) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `matched_donation_id` (`matched_donation_id`), CONSTRAINT `help_requests_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), CONSTRAINT `help_requests_ibfk_2` FOREIGN KEY (`matched_donation_id`) REFERENCES `donations` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `withdrawals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `amount` decimal(12,2) NOT NULL, `status` enum('pending','approved','rejected','completed') NOT NULL DEFAULT 'pending', `approved_by` int(11) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `approved_by` (`approved_by`), CONSTRAINT `withdrawals_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), CONSTRAINT `withdrawals_ibfk_2` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `referrals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `referrer_id` int(11) NOT NULL, `referred_id` int(11) NOT NULL, `level` int(11) NOT NULL, `commission_amount` decimal(12,2) NOT NULL, `status` enum('pending','approved','paid') NOT NULL DEFAULT 'pending', `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `referred_id` (`referred_id`), KEY `referrer_id` (`referrer_id`), CONSTRAINT `referrals_ibfk_1` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`), CONSTRAINT `referrals_ibfk_2` FOREIGN KEY (`referred_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `system_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `min_withdrawal` decimal(12,2) NOT NULL DEFAULT 5000.00, `donation_duration` int(11) NOT NULL DEFAULT 7, `interest_rate` decimal(5,2) NOT NULL DEFAULT 50.00, `email_notification` tinyint(1) NOT NULL DEFAULT 1, `recommitment_option` tinyint(1) NOT NULL DEFAULT 1, `auto_matching` tinyint(1) NOT NULL DEFAULT 1, `referral_levels` int(11) NOT NULL DEFAULT 3, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `message` text NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Insert initial system settings INSERT INTO `system_settings` (`min_withdrawal`, `donation_duration`, `interest_rate`, `email_notification`, `recommitment_option`, `auto_matching`, `referral_levels`) VALUES (5000.00, 7, 50.00, 1, 1, 1, 3); -- Create admin user (password: admin123) INSERT INTO `users` (`fullname`, `email`, `phone`, `password`, `role`, `is_active`) VALUES ('Admin User', 'admin@example.com', '08012345678', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', 1);