$fileName = "lib/craeteFormLock.lock";
if (!file_exists($fileName)) {
createSqlFrom($dbname, $con);
fopen($fileName, 'w');
}
return $con;
//创建用户注册表
$tabName = 'la_user';
$sql = "CREATE TABLE `{$dbname}`.`{$tabName}` ( `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `username` VARCHAR(50) NOT NULL COMMENT '用户名' ,`email` VARCHAR(50) NOT NULL COMMENT '邮箱' , `password` VARCHAR(50) NOT NULL COMMENT '密码' , `create_time` INT(11) NOT NULL COMMENT '创建时间' ,`vip` INT(2) NOT NULL default -1 COMMENT '1 vip -1 not vip' , PRIMARY KEY (`id`)) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_general_ci";
if (!check_table_is_exist($con, $dbname, $tabName)) {
#echo '该表不存在';
if (!mysqli_query($con, $sql)) {
echo '用户表格创建失败';
exit;
}
}
完整代码
function mysqlinit($host = DB_HOST, $username = DB_USER, $password = DB_PWD, $dbname = DB_NAME, $dbprot = DB_PORT)
{
$con = mysqli_connect($host, $username, $password, $dbname, $dbprot);
if (!$con) {
echo mysqli_error($con);
return false;
}
$result = mysqli_query($con, 'show databases;');
While ($row = mysqli_fetch_assoc($result)) {
$data[] = $row['Database'];
}
if (!in_array(strtolower($dbname), $data)) {
#echo "数据库不存在";
if (!mysqli_query($con, "CREATE DATABASE " . $dbname)) {
echo "数据库创建失败", mysqli_error($con);
}
}
if (!mysqli_select_db($con, $dbname)) {
echo mysqli_error($con);
return false;
}
mysqli_set_charset($con, 'utf8');
$fileName = "lib/craeteFormLock.lock";
if (!file_exists($fileName)) {
createSqlFrom($dbname, $con);
fopen($fileName, 'w');
}
return $con;