Create database php code and use PHP to write your own BLOG system_PHP tutorial

//date_default_timezone_set("Asia/ Shanghai");
/*
function create_siteinfo
DONE: Website information table
Author: www.5dkx.com
DATE:2010-3-30
Table structure:
title website name
keyword website keyword
description website description
*/
function create_siteinfo()
{
global $conn;
$sql = "create table siteinfo (
title varchar(100) not null,
keyword varchar(200) not null,
description varchar(200) not null
)";
$dropsql = "drop table if exists siteinfo";
mysql_query($dropsql,$conn)or die("Failed to delete table siteinfo!");
mysql_query($sql,$conn)or die("Failed to create table siteinfo!");
}
/*
function:create_article()
DONE: mysql creates article table sql statement
Author: www.5dkx.com
Table structure:
id article ID
cid category ID
abstract article abstract
title article title
posttime release time
aurhor author
comefrom article source
comeurl source URL
content text content
keyword keyword
rank article rank
views views
*/
function create_article()
{
global $conn,$table_article;
$sql ="create table $table_article(
id int(11) auto_increment not null,
cid int(5) not null,
abstract varchar(300) not null,
title varchar(50) not null,
posttime datetime not null,
author varchar(30) not null,
comefrom varchar(50) not null,
comeurl varchar(50) not null,
content TEXT not null,
keyword varchar(20) not null,
rank int(2) not null,
views int(5) not null,
PRIMARY KEY(id)
)";
$dropsql = "drop table if exists $table_article";
mysql_query($dropsql,$conn)or die("Failed to delete database!");
mysql_query($sql,$conn)or die("Failed to create database!" ");
}
/*
function:create_member()
DONE: mysql creates member table sql statement
Author:www.5dkx.com
uid member ID
u_name member name
u_passwd password
rank member level
*/
function create_member()
{
global $conn,$table_member;
$sql = "create table $ table_member(
uid int(5) auto_increment not null,
u_name varchar(20) not null UNIQUE,
u_passwd varchar(100) not null,
rank int(2) not null,
PRIMARY KEY(uid)
)";
$dropsql = "drop table if exists $table_member";
mysql_query($dropsql,$conn)or die("Failed to delete database!");
mysql_query($sql,$conn)or die("Failed to create database!");
}
/*
function:create_class
DONE:sql creates a classified sql statement
Author :www.5dkx.com
Table structure:
cid class category ID
cname class name
*/
function create_class()
{
global $conn,$table_class ;
$sql = "create table $table_class(
cid int(5) auto_increment not null,
cname varchar(50) not null UNIQUE,
PRIMARY KEY(cid)
)" ;
$dropsql = "drop table if exists $table_class";
mysql_query($dropsql,$conn)or die("Delete".$table_class."Failed!");
mysql_query($sql ,$conn)or die("Create table".$table_class."Failed");
}
/*
function:create_guest
DONE:sql Create message board sql statement
Author :www.5dkx.com
Table structure:
gid message ID
g_name message user name
g_site user personal homepage
g_mail user email
g_cid message location (which article or Message board)
*/
function create_guest()
{
global $conn,$table_guest;
$sql = "create table $table_guest(
gid int(11) auto_increment not null,
g_name varchar(50) not null,
g_site varchar(50) not null,
g_mail varchar(50) not null,
g_cid int(5) not null,
PRIMARY KEY(gid)
)";
$dropsql = "drop table if exists $table_guest";
mysql_query($dropsql,$conn)or die("delete table".$table_guest." failed ");
mysql_query($sql,$conn)or die("Create table".$table_guest."Failed");
}
function create_sql()
{
global $ table_article,$table_member,$table_class,$table_guest,$conn;
echo "Create siteinfo table r...";
create_siteinfo();
echo "Complete
";
echo "Create".$table_article."Table r...";
create_article();
echo "Complete
";
echo "Create".$table_member."Table r..." ;
create_member();
echo "Complete
";
echo "Create".$table_class."Table r...";
create_class();
echo " Complete
";
echo "Create".$table_guest."Table r...";
create_guest();
echo "Complete
";
mysql_close($ conn);
}
?>