创建配置文件盒初始化文件
config.php
<?php
header("Content-type:text/html;charset=utf-8");
define('HOST', '127.0.0.1');
define('USERNAME', 'root');
define('PASSWORD', '');
?>
connect.php
<?php
require('config.php');
//连库
if (!($con = mysql_connect(HOST, USERNAME, PASSWORD))) {
echo mysql_error();
}
//选库
if (!(mysql_selectdb('info'))) {
echo mysql_error();
}
//字符集
if (!(mysql_query('set names utf8'))) {
echo mysql_error();
}
?>
mysql
CREATE TABLE article(
id int(11) unsigned PRIMARY KEY AUTO_INCREMENT,
title char(100) NOT NULL,
author char(50) NOT NULL,
description VARCHAR(255) NOT NULL,
content TEXT NOT NULL,
dateline INT(11) NOT NULL DEFAULT 0
)ENGINE=InnoDB DEFAULT CHARSET=utf8;