prepare('UPDATE users SET name = ?, email = ? WHERE id = ?');
$stmt->execute([$name, $email, $id]);
$message = 'User updated successfully!';
} else {
// Insert new user
$stmt = $pdo->prepare('INSERT INTO users (name, email) VALUES (?, ?)');
$stmt->execute([$name, $email]);
$message = 'User added successfully!';
}
} catch (PDOException $e) {
if ($e->errorInfo[1] == 1062) { // Duplicate entry for email
$error = 'Email address already exists.';
} else {
$error = 'Database error: ' . $e->getMessage();
}
}
}
}
// Handle deleting a user
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
try {
$stmt = $pdo->prepare('DELETE FROM users WHERE id = ?');
$stmt->execute([$id]);
$message = 'User deleted successfully!';
} catch (PDOException $e) {
$error = 'Error deleting user. They might be associated with expenses.';
}
}
// Handle fetching a user for editing
if (isset($_GET['edit'])) {
$id = $_GET['edit'];
$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([$id]);
$edit_user = $stmt->fetch();
}
// Fetch all users to display
$stmt = $pdo->query('SELECT * FROM users ORDER BY name');
$users = $stmt->fetchAll();
?>
Manage Users