Blog Program with PHP and MySQL- 2

In the previous chapter, I showed structured view of all files for a blog program. Let's start to making a blog program.

First we should have to do for making a blog program is create database table. Of course, we should analyze requirements and design system first. However, This article just focus on programing skills about PHP and MySQL, so we are going to move on implementing part directly. If I have a time later, I promise I will post other articles about software development processes, such as requirements, design, testing, maintenance and so on.

Anyway, Let's start to make blog program by crating database.

We are going to make 7 tables in a database. List of data base tables we should create are shown as below. Keep in mind that "member id" in the last two lows means each members ID. e.g, Each member will have bg_"member_id"_t and bg_"member_id"_ct. For example, There are two members. One of IDs is "hyeon" and another is "cheol". "hyeon" will have both tables, "bg_hyeon_t" and "bg_hyeon_ct". Also, "cheol" will have both tables, "bg_cheol_t", and bg_cheol_ct".