Manage Projects

connect_error) { die("Connection failed: " . $conn->connect_error); } // 2. Prepare the SQL query // We assume the table is named 'project_list' (change this to your actual table name) $sql = "SELECT * FROM project_list WHERE username = ? ORDER BY project_name ASC"; if ($stmt = $conn->prepare($sql)) { // Bind the session username to the '?' in the query $stmt->bind_param("s", $_SESSION['username']); // Execute the query $stmt->execute(); // Get the results $result = $stmt->get_result(); // 3. Display the projects if ($result->num_rows > 0) { echo '

'; while ($row = $result->fetch_assoc()) { // Use htmlspecialchars to prevent XSS attacks echo '
• ' . htmlspecialchars($row['project_name']) . '
'; } echo '

'; } else { echo '

No projects found. Start one below!

'; } $stmt->close(); } else { echo "Error preparing statement: " . $conn->error; } $conn->close(); ?>

---