First, let's build the SQL of our posts. The database table should contain at the very least the post title, post content, post date, and modified and published dates.
This is what the SQL should look like:
CREATE TABLE posts( id INT(11) PRIMARY KEY AUTO INCREMENT, post_title TEXT, post_content TEXT, post_date DATETIME, modified DATETIME, published DATETIME );
Now let's create a function to read the data. A typical blog site has comments and some additional metadata for SEO related to the blog post. But in this chapter, we won't be creating this part. Anyway, it should be fairly trivial to add a table relating to comments data and to have data about SEO metadata about each post in another table.
Let's start by creating the admin system. We need to log in, so we'll have to create a simple login-logout script:
//admin.php <form action="admin.php" method="post"> Username: <input type="text" name...