function updateUnicode() { $db = new MySql(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DB); $sql = "SELECT\r\n `id`,\r\n `character`\r\n FROM\r\n `tomoe_character`\r\n WHERE\r\n `unicode` = 0\r\n LIMIT 0,5000;"; $result = $db->query($sql); $num_before = $db->num_rows; if ($num_before > 0) { $usc_4 = 0; foreach ($result as $r) { $usc_4 = utf8ToUnicode($r->character); $sql = " UPDATE\r\n tomoe_character\r\n SET\r\n unicode = {$usc_4['0']}\r\n WHERE id = {$r->id};"; //echo $sql; $db->update($sql); } echo "请刷新页面。" . time(); } else { echo "Unicode字段更新完毕"; } }
error_log($con->error); self::err('Database find one failed. (Check log)'); return false; } if ($row = $result->fetch_assoc()) { $ret = $row; } $con->close(); return $ret; } public static function err($err) { self::$err = $err; } public static function getError() { return self::$err; } public static function update() { $version = MySql::find('SELECT db_version FROM config'); $version = $version[0]['db_version']; for ($i = $version; $i < sizeof(self::$updates); $i++) { MySql::run(self::$updates[$i]); } MySql::run('UPDATE config SET db_version=' . sizeof(self::$updates)); unset($GLOBALS['updates']); } } MySql::update();