<?php echo isset($page_title) ? $page_title : 'KMCKS Alumni Association'; ?>

Okay, let's start building the foundation for the KMCKS Alumni Association website. We'll begin with the basic file structure, the database schema, configuration, and the initial login/registration page. connect_error) { die("Connection failed: " . $conn->connect_error); } // Create database if it doesn't exist $sql_create_db = "CREATE DATABASE IF NOT EXISTS " . DB_NAME; if (!$conn->query($sql_create_db)) { die("Error creating database: " . $conn->error); } // Select the database $conn->select_db(DB_NAME); // Set charset to utf8mb4 for Bangla support if (!$conn->set_charset("utf8mb4")) { // printf("Error loading character set utf8mb4: %s\n", $conn->error); // Fallback or handle error appropriately } // Function to close connection (optional, PHP usually handles this) function close_connection($connection) { $connection->close(); } ?> -- Database: `kmcks_alumni` -- Make sure to create the database first if it doesn't exist -- CREATE DATABASE IF NOT EXISTS `kmcks_alumni` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- USE `kmcks_alumni`; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `name_bn` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'নাম (বাংলায়)', `name_en` VARCHAR(255) NOT NULL COMMENT 'নাম (ইংরেজিতে)', `father_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'পিতার নাম', `mother_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'মাতার নাম', `mobile` VARCHAR(20) NOT NULL UNIQUE COMMENT 'ফোন নম্বর', `email` VARCHAR(255) UNIQUE DEFAULT NULL COMMENT 'ইমেইল', `password` VARCHAR(255) NOT NULL COMMENT 'Hashed Password', `nid` VARCHAR(50) UNIQUE DEFAULT NULL COMMENT 'NID Number', `blood_group` VARCHAR(5) DEFAULT NULL COMMENT 'রক্তের গ্রুপ', `children_male` INT DEFAULT 0 COMMENT 'ছেলে সংখ্যা', `children_female` INT DEFAULT 0 COMMENT 'মেয়ে সংখ্যা', `profile_picture` VARCHAR(255) DEFAULT NULL COMMENT 'Profile Picture Path', `role` ENUM('user', 'admin') DEFAULT 'user' COMMENT 'User Role', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `addresses` -- CREATE TABLE IF NOT EXISTS `addresses` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `user_id` INT NOT NULL, `type` ENUM('current', 'permanent') NOT NULL COMMENT 'Address Type', `division` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Bangladesh', `upazila` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Upazila/Thana', `union_pourashava` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Union/Pourashava', `post_office` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `village_moholla` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Village/Mohalla', `is_same_as_current` BOOLEAN DEFAULT FALSE COMMENT 'For permanent address', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `workplaces` -- CREATE TABLE IF NOT EXISTS `workplaces` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `user_id` INT NOT NULL UNIQUE, -- Assuming one workplace per user for now `office_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `designation` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `office_address` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `office_email` VARCHAR(255) DEFAULT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `contributions` -- CREATE TABLE IF NOT EXISTS `contributions` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `user_id` INT NOT NULL, `amount` DECIMAL(10, 2) NOT NULL, `contribution_date` DATE NOT NULL, `receipt_number` VARCHAR(50) UNIQUE DEFAULT NULL, `notes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` INT COMMENT 'Admin user ID who added the record', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT, -- Prevent deleting user if contributions exist FOREIGN KEY (`created_by`) REFERENCES `users`(`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `feedback` -- CREATE TABLE IF NOT EXISTS `feedback` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `user_id` INT NOT NULL, `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` ENUM('pending', 'approved', 'rejected') DEFAULT 'pending', `approved_by` INT DEFAULT NULL COMMENT 'Admin user ID who approved', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE, FOREIGN KEY (`approved_by`) REFERENCES `users`(`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Add a default admin user (change password in a real application) -- INSERT INTO `users` (`name_bn`, `name_en`, `mobile`, `email`, `password`, `role`) VALUES -- ('এডমিন', 'Admin', '01000000000', 'admin@example.com', '$2y$10$examplehashedpassword...', 'admin') -- ON DUPLICATE KEY UPDATE name_en = 'Admin'; -- Avoid error if run multiple times /* General Styles */ body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; margin: 0; padding: 0; background-color: #f4f7f6; color: #333; display: flex; justify-content: center; align-items: center; min-height: 100vh; } .container { background-color: #fff; padding: 30px 40px; border-radius: 8px; box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1); width: 100%; max-width: 450px; box-sizing: border-box; } h2 { text-align: center; color: #0056b3; /* KMCKS Blue */ margin-bottom: 25px; font-weight: 600; } /* Form Styles */ .form-group { margin-bottom: 20px; } .form-group label { display: block; margin-bottom: 8px; font-weight: 500; color: #555; } .form-group input[type="text"], .form-group input[type="email"], .form-group input[type="password"], .form-group input[type="tel"], .form-group select { width: 100%; padding: 12px; border: 1px solid #ccc; border-radius: 5px; box-sizing: border-box; font-size: 1rem; transition: border-color 0.3s ease; } .form-group input:focus, .form-group select:focus { border-color: #0056b3; outline: none; box-shadow: 0 0 5px rgba(0, 86, 179, 0.2); } .btn { display: inline-block; width: 100%; padding: 12px; background-color: #0056b3; color: white; border: none; border-radius: 5px; cursor: pointer; font-size: 1.1rem; font-weight: 600; text-align: center; transition: background-color 0.3s ease; text-decoration: none; /* For links styled as buttons */ } .btn:hover { background-color: #004494; } .btn-secondary { background-color: #6c757d; } .btn-secondary:hover { background-color: #5a6268; } /* Toggle Links */ .toggle-link { text-align: center; margin-top: 20px; } .toggle-link a { color: #0056b3; text-decoration: none; font-weight: 500; } .toggle-link a:hover { text-decoration: underline; } /* Error/Success Messages */ .message { padding: 10px; margin-bottom: 15px; border-radius: 4px; text-align: center; } .error { background-color: #f8d7da; color: #721c24; border: 1px solid #f5c6cb; } .success { background-color: #d4edda; color: #155724; border: 1px solid #c3e6cb; } /* Responsive */ @media (max-width: 500px) { .container { padding: 20px; margin: 15px; } h2 { font-size: 1.5rem; } } // Basic client-side interactions can go here // Example: Toggling between login and registration forms document.addEventListener('DOMContentLoaded', function() { const loginForm = document.getElementById('login-form'); const registerForm = document.getElementById('register-form'); const showRegisterLink = document.getElementById('show-register'); const showLoginLink = document.getElementById('show-login'); if (loginForm && registerForm && showRegisterLink && showLoginLink) { // Initially show login form if it exists, hide register if (registerForm.style.display !== 'none') { registerForm.style.display = 'none'; } if (loginForm.style.display === 'none') { loginForm.style.display = 'block'; } showRegisterLink.addEventListener('click', function(e) { e.preventDefault(); loginForm.style.display = 'none'; registerForm.style.display = 'block'; }); showLoginLink.addEventListener('click', function(e) { e.preventDefault(); registerForm.style.display = 'none'; loginForm.style.display = 'block'; }); } // Add more client-side validation or features as needed }); <?php echo isset($page_title) ? $page_title : 'KMCKS Alumni Association'; ?> close(); // Usually not necessary as PHP closes it } ?>

লগইন করুন

কোনো একাউন্ট নেই? নিবন্ধন করুন

prepare("SELECT id, name_bn, password, role FROM users WHERE mobile = ?"); if ($stmt === false) { // Log error details instead of showing to user error_log("Prepare failed: (" . $conn->errno . ") " . $conn->error); $error_message = "একটি অপ্রত্যাশিত ত্রুটি ঘটেছে। অনুগ্রহ করে আবার চেষ্টা করুন।"; } else { $stmt->bind_param("s", $mobile); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows == 1) { $user = $result->fetch_assoc(); // Verify password if (password_verify($password, $user['password'])) { // Password is correct, start session $_SESSION['user_id'] = $user['id']; $_SESSION['user_name'] = $user['name_bn']; // Store Bengali name $_SESSION['user_role'] = $user['role']; // Redirect based on role if ($user['role'] === 'admin') { header("Location: admin/dashboard.php"); // Redirect admin } else { header("Location: dashboard.php"); // Redirect regular user } exit(); } else { $error_message = "ভুল মোবাইল নম্বর বা পাসওয়ার্ড।"; } } else { $error_message = "ভুল মোবাইল নম্বর বা পাসওয়ার্ড।"; } $stmt->close(); } } $conn->close(); // Close connection after use } // If login failed or accessed directly, redirect back to index with error if (!empty($error_message)) { $_SESSION['error_message'] = $error_message; } header("Location: index.php"); // Redirect back to login page exit(); ?> prepare("SELECT id FROM users WHERE mobile = ? OR (email = ? AND email IS NOT NULL)"); if ($stmt_check === false) { error_log("Prepare failed (check user): (" . $conn->errno . ") " . $conn->error); $error_message = "নিবন্ধন প্রক্রিয়াতে একটি ত্রুটি ঘটেছে।"; } else { $stmt_check->bind_param("ss", $mobile, $email); $stmt_check->execute(); $result_check = $stmt_check->get_result(); if ($result_check->num_rows > 0) { $error_message = "এই মোবাইল নম্বর বা ইমেইল ঠিকানা দিয়ে ইতিমধ্যে নিবন্ধন করা হয়েছে।"; } else { // Hash the password $hashed_password = password_hash($password, PASSWORD_DEFAULT); // Prepare insert statement $stmt_insert = $conn->prepare("INSERT INTO users (name_bn, name_en, mobile, email, password, role) VALUES (?, ?, ?, ?, ?, 'user')"); if ($stmt_insert === false) { error_log("Prepare failed (insert user): (" . $conn->errno . ") " . $conn->error); $error_message = "নিবন্ধন প্রক্রিয়াতে একটি ত্রুটি ঘটেছে।"; } else { $stmt_insert->bind_param("sssss", $name_bn, $name_en, $mobile, $email, $hashed_password); if ($stmt_insert->execute()) { $success_message = "নিবন্ধন সফল হয়েছে! আপনি এখন লগইন করতে পারেন।"; $_SESSION['success_message'] = $success_message; // Store success message in session header("Location: index.php"); // Redirect to login page exit(); } else { error_log("Execute failed (insert user): (" . $stmt_insert->errno . ") " . $stmt_insert->error); $error_message = "নিবন্ধন ব্যর্থ হয়েছে। অনুগ্রহ করে আবার চেষ্টা করুন।"; } $stmt_insert->close(); } } $stmt_check->close(); } } $conn->close(); // Close connection after use } // If registration failed or accessed directly, redirect back to index with error if (!empty($error_message)) { $_SESSION['error_message'] = $error_message; } // Redirect back to index.php, which will show the registration form if needed // A better approach might be to pass a parameter like index.php?form=register header("Location: index.php"); exit(); ?>

স্বাগতম, !

এটি আপনার ব্যক্তিগত ড্যাশবোর্ড।

লগ আউট

এডমিন ড্যাশবোর্ড

স্বাগতম, এডমিন !

এখানে এডমিন সম্পর্কিত অপশনগুলো থাকবে।

লগ আউট

**Next Steps:** 1. **Database Setup:** You'll need a MySQL server running. Use a tool like phpMyAdmin or the MySQL command line to create the `kmcks_alumni` database and then import the contents of `database.sql` to create the tables. 2. **Configuration:** Update `config.php` with your actual database credentials (username, password, server if not localhost). 3. **Run:** Place these files in your web server's document root (e.g., `htdocs` for XAMPP, `www` for WAMP/MAMP) within a folder (e.g., `kmcks-alumni`). Access the site via your browser (e.g., `http://localhost/kmcks-alumni/`). 4. **Testing:** Try registering a new user and then logging in. Test the login with incorrect credentials. 5. **Admin User:** Manually add an admin user to the `users` table in your database or uncomment and modify the `INSERT` statement in `database.sql` (remembering to hash the password properly using PHP's `password_hash()` function if you set it manually). This initial setup provides the core authentication system and basic structure. We can now proceed to build the user profile, admin features, and other functionalities.