[V0_FILE]php:file="login.php" type="code" isEdit="true" getConnection(); // Query based on role $table = ''; switch($role) { case 'property_manager': $table = 'property_managers'; break; case 'landlord': $table = 'landlords'; break; case 'tenant': $table = 'tenants'; break; default: $error = 'Invalid role selected'; } if (!$error) { $query = "SELECT * FROM " . $table . " WHERE email = :email"; $stmt = $db->prepare($query); $stmt->bindParam(':email', $email); $stmt->execute(); if ($stmt->rowCount() > 0) { $user = $stmt->fetch(PDO::FETCH_ASSOC); if (password_verify($password, $user['password'])) { // Set session variables $_SESSION['user_id'] = $user['id']; $_SESSION['user_type'] = $role; $_SESSION['user_name'] = $user['first_name'] . ' ' . $user['last_name']; $_SESSION['user_email'] = $user['email']; // Redirect based on role switch($role) { case 'property_manager': header('Location: admin/dashboard.php'); break; case 'landlord': header('Location: landlord/dashboard.php'); break; case 'tenant': header('Location: tenant/dashboard.php'); break; } exit(); } else { $error = 'Invalid email or password'; } } else { $error = 'Invalid email or password'; } } } catch(PDOException $e) { $error = 'Database connection failed'; } } } ?> Login - PropertyHub

Welcome Back

Don't have an account? Create one here

Demo Credentials

Manager: admin@propertyhub.com

Landlord: landlord@propertyhub.com

Tenant: tenant@propertyhub.com

Password for all: password

[V0_FILE]php:file="config/database.php" type="code" conn = null; try { $this->conn = new PDO( "mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password ); $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $exception) { echo "Connection error: " . $exception->getMessage(); } return $this->conn; } } ?>