public function batQuery($sql, $db_config)
{
// 连接数据库
require THINK_PATH . '/Lib/Think/Db/Driver/DbMysql.class.php';
$db = new Dbmysql($db_config);
$db->query($sql);
return true;
}
public function installsql($sql, $db_config)
{
require THINK_PATH . '/Lib/Think/Db/Driver/DbMysql.class.php';
$db = new Dbmysql($db_config);
$sql = str_replace("\r\n", "\n", $sql);
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= $query[0] == '#' || $query[0] . $query[1] == '--' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($ret as $query) {
if (trim($query)) {
$db->query($query);
}
}
return true;
}