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