$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); } }