getMessage();
}
$id = $name = $stage = $age = "";
if (isset($_POST['show'])) {
$id = $_POST['id'];
$stmt = $pdo->prepare("SELECT * FROM students WHERE id = ?");
$stmt->execute([$id]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if ($row) {
$name = $row['full_name']; $stage = $row['stage']; $age = $row['age'];
}
}
if (isset($_POST['save'])) {
$id = $_POST['id']; $name = $_POST['full_name']; $stage = $_POST['stage']; $age = $_POST['age'];
try {
$stmt = $pdo->prepare("INSERT INTO students VALUES (?, ?, ?, ?)");
$stmt->execute([$id, $name, $stage, $age]);
} catch (PDOException $e) {
echo "";
}
}
if (isset($_POST['update'])) {
$id = $_POST['id']; $name = $_POST['full_name']; $stage = $_POST['stage']; $age = $_POST['age'];
$stmt = $pdo->prepare("UPDATE students SET full_name=?, stage=?, age=? WHERE id=?");
$stmt->execute([$name, $stage, $age, $id]);
}
if (isset($_POST['delete'])) {
$id = $_POST['id'];
$stmt = $pdo->prepare("DELETE FROM students WHERE id = ?");
$stmt->execute([$id]);
$id = $name = $stage = $age = "";
}
?>
Student Details
Student Details
| ID | Full Name | Stage | Age |
|---|
query("SELECT * FROM students");
while($row = $all->fetch(PDO::FETCH_ASSOC)) {
echo "| {$row['id']} | {$row['full_name']} | {$row['stage']} | {$row['age']} |
";
}
?>