connect_error){ $error_type = $connect->connect_error; echo ""; echo ''; die("failed"); } $sql = 'SELECT name, post, description, time, date, place FROM ACT_POST'; $result = mysqli_query($connect, $sql) or die( mysqli_error($connect)); // fetch the resulting rows as an array $clubs = mysqli_fetch_all($result, MYSQLI_ASSOC); // free the $result from memory (good practise) mysqli_free_result($result); // close connection mysqli_close($connect); ?> Directory - TheClubHub

Clubs Here at Cameron



"; echo "

" . htmlspecialchars($club['name']) . "

"; if (!empty($club['post']) && filter_var($club['post'], FILTER_VALIDATE_URL)) { echo "
"; echo "Club Image"; echo "
"; } else { // Fallback to placeholder image echo "
"; echo "No Image Available"; echo "
"; } echo "

Department: " . htmlspecialchars($club['description']) . "

"; echo "

Room: " . htmlspecialchars($club['time']) . "

"; echo "

Meeting Day: " . htmlspecialchars($club['date']) . "

"; echo "

Time: " . htmlspecialchars($club['place']) . "

"; echo "
"; } ?>