下面是使用pdo连接mysql并且创建数据库和表的一个示例try {
$pdo = new PDO(
"mysql:host=localhost;port=3306;",
'root',
'adminrootkl',
[
PDO::ATTR_CASE => PDO::CASE_NATURAL,
]
);
} catch (PDOException $e) {
echo '数据库连接失败' . $e->getMessage();
}
$newdataname = 'newtestdata';
//查询数据库是否存在
$result = $pdo->exec("CREATE DATABASE IF NOT EXISTS {$newdataname} DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
if (!$result) {
die('create database error!');
}
$pdo->exec("use {$newdataname}");
$tablestr = <<
CREATE TABLE `kl_area` (
`area_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id',
`chengxiang` int(11) DEFAULT NULL,
`area_name` varchar(50) NOT NULL DEFAULT '',
`code` varchar(10) DEFAULT NULL,
`quanpin` varchar(255) NOT NULL DEFAULT '' COMMENT '全拼',
`jianpin` varchar(255) NOT NULL DEFAULT '' COMMENT '简拼',
`archive_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '归档状态,-1删除,0禁用,1正常',
PRIMARY KEY (`area_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='区域表';
eot;
$result = $pdo->exec($tablestr);