深入了解PHPcms單頁資料儲存表

CREATE TABLE pages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content TEXT NOT NULL,
    update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

$title = "Sample Page";
$content = "This is a sample page content.";
$insert_query = "INSERT INTO pages (title, content) VALUES ('$title', '$content')";
$result = $db->query($insert_query);
if ($result) {
    echo "Page data inserted successfully.";
} else {
    echo "Failed to insert page data.";
}

$id = 1;
$title = "Updated Page";
$content = "This is the updated page content.";
$update_query = "UPDATE pages SET title='$title', content='$content' WHERE id=$id";
$result = $db->query($update_query);
if ($result) {
    echo "Page data updated successfully.";
} else {
    echo "Failed to update page data.";
}

$id = 1;
$delete_query = "DELETE FROM pages WHERE id=$id";
$result = $db->query($delete_query);
if ($result) {
    echo "Page data deleted successfully.";
} else {
    echo "Failed to delete page data.";
}

$select_query = "SELECT * FROM pages";
$result = $db->query($select_query);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Title: " . $row['title'] . "<br>";
        echo "Content: " . $row['content'] . "<br>";
        echo "Update Time: " . $row['update_time'] . "<br><br>";
    }
} else {
    echo "No page data found.";
}