* 一次采集全部歌手 */ if (!defined('APP_PATH')) { exit("Access is denied."); } require_once APP_PATH . 'util/db.php'; require_once APP_PATH . 'util/Collect.class.php'; $con = get_con(); $collect = new Collect(); //$artistAreaCodeArr = array('cn', 'western', 'kr', 'jp'); $artistAreaCodeArr = array('cn'); //$artistTypeArr = array('male', 'female', 'group'); $artistTypeArr = array('male'); //$indexLetterArr = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'other'); $indexLetterArr = array('A'); $artistArr = $collect->artistList($artistAreaCodeArr, $artistTypeArr, $indexLetterArr); if (!empty($artistArr)) { foreach ($artistArr as $artist) { $data['id'] = $artist['id']; $data['index_letter'] = $artist['index_letter']; $data['area_code'] = $artist['area_code']; $data['type'] = $artist['type']; $result = mysql_query("select id from " . DBPREFIX . "artist where id={$data['id']}", $con); if (!($row = mysql_fetch_array($result))) { // 数据库不存在该歌手 -> insert $sql = "insert into\n " . DBPREFIX . "artist\n (id,\n index_letter,\n area_code,\n type)\n values\n ({$data['id']},\n '{$data['index_letter']}',\n '{$data['area_code']}',\n '{$data['type']}')"; } else { // 数据库已存在该歌手 -> update $sql = "update\n " . DBPREFIX . "artist\n set\n index_letter = '{$data['index_letter']}',\n area_code = '{$data['area_code']}',\n type = '{$data['type']}'\n where\n id = {$data['id']}"; } mysql_query($sql, $con);