$db->connect($dbHost, $dbUser, $dbPwd, $dbName, 'utf8');
//获取正确的数据
if ($DemoDb == 1 && file_exists($DbDataSql)) {
$dbSqlFile = $DbDataSql;
//含表结构和演示数据
} else {
$dbSqlFile = $DbSql;
//含表结构和系统数据
}
//创建表结构和初始化系统数据
$dbSql = file_get_contents($dbSqlFile);
$sqlList = sql_split($dbSql);
foreach ($sqlList as $query) {
$query = trim($query);
if ($query) {
$b = @$db->query($query);
//DROP TABLE 不提示
if (preg_match('/CREATE\\s*TABLE\\s* `([a-zA-Z0-9_\\n]+)`/', $query, $matches)) {
showmessage($matches[1] . "表创建", $b);
} else {
if (preg_match('/INSERT\\s*INTO\\s* `([a-zA-Z0-9_\\n]+)`/', $query, $matches)) {
showmessage("初始化" . $matches[1] . "表数据", $b);
}
}
}
}
showmessage("安装数据完成！");
//写入管理员数据======================================================================
$sql = "Update youdian_admin Set AdminName='{$AdminName}', AdminPassword='******' Where AdminID=1";
$b = @$db->query($sql);
$sql = "Update youdian_member Set MemberName='{$AdminName}', MemberPassword='******' Where MemberID=1";
$sql = str_replace("\r\n", "\n", $sql);
$sql = str_replace("\r", "\n", str_replace("`" . ORIG_TABLEPRE, "`" . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
show_install();
if ($setupdbtype) {
$db->query($setupcreatsql);
}
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (preg_match('/CREATE\\s*TABLE\\s*IF\\s*NOT\\s*EXISTS/', $query)) {
$name = preg_replace("/CREATE\\s*TABLE\\s*IF\\s*NOT\\s*EXISTS\\s*`([a-zA-Z0-9_\n]+)`.*/is", "\\1", $query);
$message = "{$name} 数据结构安装成功";
} else {
$name = preg_replace("/INSERT\\s*INTO\\s*`([a-zA-Z0-9_\n]+)`.*/is", "\\1", $query);
$message = "{$name} 数据结构安装成功";
}
echo '<script type="text/javascript">showmessage(\'' . addslashes($message) . ' \');</script>' . "\r\n";
$db->query($query);
}
}
$sql = str_replace("\r\n", "\n", $sql);
$sql = str_replace("\r", "\n", str_replace("`" . ORIG_TABLEPRE, "`" . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
show_install();
if ($setupdbtype) {
$db->query($setupcreatsql);
}
foreach ($ret as $query) {
$query = trim($query);
if ($query) {
if (preg_match('/CREATE\\s*TABLE\\s*IF\\s*NOT\\s*EXISTS/', $query)) {
$name = preg_replace("/CREATE\\s*TABLE\\s*IF\\s*NOT\\s*EXISTS\\s*`([a-zA-Z0-9_\n]+)`.*/is", "\\1", $query);
$message = "{$name} 数据结构安装成功";
} else {
$name = preg_replace("/INSERT\\s*INTO\\s*`([a-zA-Z0-9_\n]+)`.*/is", "\\1", $query);
$message = "{$name} 数据结构安装成功";
}
echo '<script type="text/javascript">showmessage(\'' . addslashes($message) . ' \');</script>' . "\r\n";
$db->query($query);
}
}
