database

<title>Students Data</title> <style> table { width: 100%; border-collapse: collapse; } th, td { border: 1px solid black; padding: 8px; text-align: left; } th { background-color: #f2f2f2; } form { display: inline; } </style>

Students Data

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT first_name, last_name, email, date_of_birth, gender, major, enrollment_year FROM students"; $stmt = $pdo->query($sql); if ($stmt->rowCount() > 0) { echo ""; echo ""; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo ""; echo ""; } echo "

First Name	Last Name	Email	Date of Birth	Gender	Major	Enrollment Year	Actions
".$row['first_name']."	".$row['last_name']."	".$row['email']."	".$row['date_of_birth']."	".$row['gender']."	".$row['major']."	".$row['enrollment_year']."	"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; } else { echo "No results found."; } $pdo = null; } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?>