Skip to content

Instantly share code, notes, and snippets.

@j67678

j67678/function.php

Created November 2, 2013 09:51
Show Gist options
  • Save j67678/7277309 to your computer and use it in GitHub Desktop.
Save j67678/7277309 to your computer and use it in GitHub Desktop.
Download ZIP
抓取正方课表
Raw
function.php
<?php
function str_extract($string,$before,$after){
if(!strpos($string, $before))return false;
$start = strpos($string, $before) + strlen($before);
$string = substr($string, $start);
$end = strpos($string, $after);
return substr($string, 0, $end);
}
function strip_breaks($str){
$str = str_replace('
','',$str);
$str = str_replace(' ','',$str);
$str = str_replace(' ','',$str);
return $str;
}
$weeks = array('周一','周二','周三','周四','周五','周六','周日');
$times = array('第1,2节','第3,4节','第5,6节','第7,8节','第9,10,11节','第9,10,11节','第9,10,11节');
function find_index($str, $arr){
for($i = 0;$i < count($arr);$i++){
if($str==$arr[$i])return $i;
}
}
function parse_table($str){
global $weeks,$times;
$str = str_replace('&nbsp;',' ',$str);
$str = str_replace('</th><th','#TAG<',$str);
$str = str_replace('</td><td','#TAG<',$str);
$str = str_replace('</tr><tr','#BR<',$str);
//$str = strip_tags($str);
$str = explode('#BR',$str);
$result = array();
foreach($str as $line){
//special
$time = str_extract($line,'<title="','">');
$line = strip_tags($line);
$column = explode('#TAG',$line);
if($time!=false){
$column[7] = $time;
}
if(strpos($time, ';')){
$place = $column[8];
$timearr = explode(';', $time);
$placearr = explode(';', $place);
for($i = 0; $i < count($timearr); $i++){
if(empty($timearr[$i]))$timearr[$i] = $timearr[0];
$column[7] = $timearr[$i];
if(empty($placearr[$i]))$placearr[$i] = $placearr[0];
$column[8] = $placearr[$i];
$column[9] = substr($timearr[$i], 0, 6);
$column[10] = substr($timearr[$i], 6, strpos($timearr[$i], '{') - 6);
$column[11] = find_index($column[9],$weeks);
$column[12] = find_index($column[10],$times);
$duration = substr($column[7],strpos($column[7], '{'));
$column[13] = str_extract($duration, '第', '-');
$column[14] = str_extract($duration, '-', '周');
if(strpos($column[7], '1,2,3,4')){
$column[12] = 0;
array_push($result,$column);
$column[12] = 1;
array_push($result,$column);
}else if(strpos($column[7], '5,6,7,8')){
$column[12] = 2;
array_push($result,$column);
$column[12] = 3;
array_push($result,$column);
}else{
array_push($result,$column);
}
}
}else{
$column[9] = substr($column[7], 0, 6);
$column[10] = substr($column[7], 6, strpos($column[7], '{') - 6);
$column[11] = find_index($column[9],$weeks);
$column[12] = find_index($column[10],$times);
$duration = substr($column[7],strpos($column[7], '{'));
$column[13] = str_extract($duration, '第', '-');
$column[14] = str_extract($duration, '-', '周');
if(strpos($column[7], '1,2,3,4')){
$column[12] = 0;
array_push($result,$column);
$column[12] = 1;
array_push($result,$column);
}else if(strpos($column[7], '5,6,7,8')){
$column[12] = 2;
array_push($result,$column);
$column[12] = 3;
array_push($result,$column);
}else{
array_push($result,$column);
}
}
}
return $result;
}
function postURL($data_string, $sessionid){
$URL = 'http://211.70.149.135:88/xsxkqk.aspx?zgh=2718&xm=%DB%A2%CE%B0%C5%F4&gnmkdm=N123108';
$result = '';
$URL_Info=parse_url($URL);
$request = "POST /xsxkqk.aspx?zgh=2718&xm=%DB%A2%CE%B0%C5%F4&gnmkdm=N123108 HTTP/1.1\n";
$host = $URL_Info["host"].':'.$URL_Info["port"];
$request.="Host: $host\n";
$request.="User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0\n";
$request.="Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\n";
$request.="Accept-Language: zh-cn,zh;q=0.8,en-us;q=0.5,en;q=0.3\n";
$request.="Accept-Encoding: gzip, deflate\n";
$request.="Referer: $URL\n";
$request.="Cookie: ASP.NET_SessionId=$sessionid\n";
$request.="Content-type: application/x-www-form-urlencoded\n";
$request.="Content-length: ".strlen($data_string)."\n";
$request.="Connection: close\n";
$request.="\n";
$request.=$data_string."\n";
$fp = fsockopen($URL_Info["host"],$URL_Info["port"]);
fputs($fp, $request);
while(!feof($fp)){
$result .= fgets($fp, 128);
}
fclose($fp);
return $result;
}
?>
Raw
index.php
<?php
include('function.php');
include('conn.php');
set_time_limit(0);
$sessionid = 'q1wwrkzd4akgb4rwykdyufy2';
$viewstate = <<<EOD
dDw3MDAyNzk2NjU7dDw7bDxpPDE%2BOz47bDx0PDtsPGk8MT47aTwzPjtpPDc%2BO2k8OD47aTwxMz47PjtsPHQ8dDxwPHA8bDxEYXRhVGV4dEZpZWxkOz47bDxYTjs%2BPjs%2BO3Q8aTwxMT47QDwyMDAzLTIwMDQ7MjAwNC0yMDA1OzIwMDUtMjAwNjsyMDA2LTIwMDc7MjAwNy0yMDA4OzIwMDgtMjAwOTsyMDA5LTIwMTA7MjAxMC0yMDExOzIwMTEtMjAxMjsyMDEyLTIwMTM7MjAxMy0yMDE0Oz47QDwyMDAzLTIwMDQ7MjAwNC0yMDA1OzIwMDUtMjAwNjsyMDA2LTIwMDc7MjAwNy0yMDA4OzIwMDgtMjAwOTsyMDA5LTIwMTA7MjAxMC0yMDExOzIwMTEtMjAxMjsyMDEyLTIwMTM7MjAxMy0yMDE0Oz4%2BO2w8aTwxMD47Pj47Oz47dDx0PDs7bDxpPDA%2BOz4%2BOzs%2BO3Q8cDxwPGw8VGV4dDtWaXNpYmxlOz47bDzlp5PlkI3vvJo7bzx0Pjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8546L5pyL6aOeOz4%2BOz47Oz47dDxAMDxwPHA8bDxQYWdlQ291bnQ7XyFJdGVtQ291bnQ7XyFEYXRhU291cmNlSXRlbUNvdW50O0RhdGFLZXlzOz47bDxpPDE%2BO2k8OT47aTw5PjtsPD47Pj47Pjs7Ozs7Ozs7Ozs%2BO2w8aTwwPjs%2BO2w8dDw7bDxpPDE%2BO2k8Mj47aTwzPjtpPDQ%2BO2k8NT47aTw2PjtpPDc%2BO2k8OD47aTw5Pjs%2BO2w8dDw7bDxpPDA%2BO2k8MT47aTwyPjtpPDM%2BO2k8ND47aTw1PjtpPDY%2BO2k8Nz47aTw4PjtpPDk%2BO2k8MTA%2BO2k8MTE%2BO2k8MTI%2BO2k8MTM%2BO2k8MTQ%2BO2k8MTU%2BO2k8MTY%2BO2k8MTg%2BO2k8MTk%2BOz47bDx0PHA8cDxsPFRleHQ7PjtsPCgyMDEzLTIwMTQtMSktMDcwMTQwMDEtMDMzMC0xOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2tjeHguYXNweD9rY2RtPTA3MDE0MDAxJnhoPTI3MTgnLCdrY3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTQ5MCxoZWlnaHQ9NTAwLGxlZnQ9MjAwLHRvcD01MCcpIlw%2BQ%2BivreiogOeoi%2BW6j%2BiuvuiuoTFcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOaYrzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XDxhIGhyZWY9JyMnIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdqc3h4LmFzcHg%2FanN6Z2g9MDMzMCZ4a2toPSgyMDEzLTIwMTQtMSktMDcwMTQwMDEtMDMzMC0xJnhoPTI3MTgnLCdqc3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTgwMCxoZWlnaHQ9NjAwLGxlZnQ9MTIwLHRvcD02MCcpIlw%2B56iL5rO95YevXDwvYVw%2BOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwwMzMwOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwyLjU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDQuMC0wLjA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7VG9vbFRpcDs%2BO2w85ZGo5LqM56ysNSw26IqCe%2BesrDgtMTjlkah9XDvlkajlm5vnrKw3O%2BWRqOS6jOesrDUsNuiKgnvnrKw4LTE45ZGofVw75ZGo5Zub56ysNyw46IqCe%2BesrDgtMTjlkah9Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzpgLjlpKvmpbw0MTFcO%2BmAuOWkq%2BalvDQxMTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MDcwMTQwMDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFxlOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmnKrkuIrkvKA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjs%2BPjt0PDtsPGk8MD47aTwxPjtpPDI%2BO2k8Mz47aTw0PjtpPDU%2BO2k8Nj47aTw3PjtpPDg%2BO2k8OT47aTwxMD47aTwxMT47aTwxMj47aTwxMz47aTwxND47aTwxNT47aTwxNj47aTwxOD47aTwxOT47PjtsPHQ8cDxwPGw8VGV4dDs%2BO2w8KDIwMTMtMjAxNC0xKS0wNzA1NDAwMS0yNzk4LTE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3Blbigna2N4eC5hc3B4P2tjZG09MDcwNTQwMDEmeGg9MjcxOCcsJ2tjeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9NDkwLGhlaWdodD01MDAsbGVmdD0yMDAsdG9wPTUwJykiXD7lpKflraborqHnrpfmnLrln7rnoYBBXDwvYVw%2BOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmmK87Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3BlbignanN4eC5hc3B4P2pzemdoPTI3OTgmeGtraD0oMjAxMy0yMDE0LTEpLTA3MDU0MDAxLTI3OTgtMSZ4aD0yNzE4JywnanN4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD04MDAsaGVpZ2h0PTYwMCxsZWZ0PTEyMCx0b3A9NjAnKSJcPueOi%2BWWnOWHpFw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Mjc5ODs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Mi41Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwyLjAtMS4wOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzlkajkupTnrKw1LDboioJ756ysNC0xOeWRqH07Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOS4nOaVmeS4gOWNlzIwMjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MDcwNTQwMDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFxlOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmnKrkuIrkvKA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjs%2BPjt0PDtsPGk8MD47aTwxPjtpPDI%2BO2k8Mz47aTw0PjtpPDU%2BO2k8Nj47aTw3PjtpPDg%2BO2k8OT47aTwxMD47aTwxMT47aTwxMj47aTwxMz47aTwxND47aTwxNT47aTwxNj47aTwxOD47aTwxOT47PjtsPHQ8cDxwPGw8VGV4dDs%2BO2w8KDIwMTMtMjAxNC0xKS0wODAyNDAwMS0yODEzLTE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3Blbigna2N4eC5hc3B4P2tjZG09MDgwMjQwMDEmeGg9MjcxOCcsJ2tjeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9NDkwLGhlaWdodD01MDAsbGVmdD0yMDAsdG9wPTUwJykiXD7pq5jnrYnmlbDlraZBMVw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pivOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2pzeHguYXNweD9qc3pnaD0yODEzJnhra2g9KDIwMTMtMjAxNC0xKS0wODAyNDAwMS0yODEzLTEmeGg9MjcxOCcsJ2pzeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9ODAwLGhlaWdodD02MDAsbGVmdD0xMjAsdG9wPTYwJykiXD7pl6vlv5fojrJcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDI4MTM7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDYuMC0wLjA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7VG9vbFRpcDs%2BO2w85ZGo5LiA56ysMSwy6IqCe%2BesrDQtMTnlkah9XDvlkajkuoznrKwzO%2BWRqOS4gOesrDEsMuiKgnvnrKw0LTE55ZGofVw75ZGo5LqM56ysMyw06IqCe%2BesrDQtMTnlkah9XDvlkajlm5vnrKwxLDLoioJ756ysNC0xOeWRqH07Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOS4nOaVmeS4gOWMlzMwN1w75Lic5pWZ5LiA5YyXMzA3XDvkuJzmlZnkuIDljJczMDc7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDA4MDI0MDAxOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcZTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pyq5LiK5LygOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47Pj47dDw7bDxpPDA%2BO2k8MT47aTwyPjtpPDM%2BO2k8ND47aTw1PjtpPDY%2BO2k8Nz47aTw4PjtpPDk%2BO2k8MTA%2BO2k8MTE%2BO2k8MTI%2BO2k8MTM%2BO2k8MTQ%2BO2k8MTU%2BO2k8MTY%2BO2k8MTg%2BO2k8MTk%2BOz47bDx0PHA8cDxsPFRleHQ7PjtsPCgyMDEzLTIwMTQtMSktMTIwMDEwMDYtMzIxMi0xOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2tjeHguYXNweD9rY2RtPTEyMDAxMDA2JnhoPTI3MTgnLCdrY3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTQ5MCxoZWlnaHQ9NTAwLGxlZnQ9MjAwLHRvcD01MCcpIlw%2B5aSn5a2m6K%2Bt5paHXDwvYVw%2BOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmmK87Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3BlbignanN4eC5hc3B4P2pzemdoPTMyMTImeGtraD0oMjAxMy0yMDE0LTEpLTEyMDAxMDA2LTMyMTItMSZ4aD0yNzE4JywnanN4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD04MDAsaGVpZ2h0PTYwMCxsZWZ0PTEyMCx0b3A9NjAnKSJcPuW6nuS4nOmcnlw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MzIxMjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MS41Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwzLjAtMC4wOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzlkajkuInnrKw5LDEwLDEx6IqCe%2BesrDQtMTPlkah9Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzkuJzmlZnkuIDljZc0MDg7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDEyMDAxMDA2Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcZTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pyq5LiK5LygOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47Pj47dDw7bDxpPDA%2BO2k8MT47aTwyPjtpPDM%2BO2k8ND47aTw1PjtpPDY%2BO2k8Nz47aTw4PjtpPDk%2BO2k8MTA%2BO2k8MTE%2BO2k8MTI%2BO2k8MTM%2BO2k8MTQ%2BO2k8MTU%2BO2k8MTY%2BO2k8MTg%2BO2k8MTk%2BOz47bDx0PHA8cDxsPFRleHQ7PjtsPCgyMDEzLTIwMTQtMSktMjEwMTQwMDEtMDQwOC0xOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2tjeHguYXNweD9rY2RtPTIxMDE0MDAxJnhoPTI3MTgnLCdrY3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTQ5MCxoZWlnaHQ9NTAwLGxlZnQ9MjAwLHRvcD01MCcpIlw%2B5Yab5LqL55CG6K66XDwvYVw%2BOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmmK87Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3BlbignanN4eC5hc3B4P2pzemdoPTA0MDgmeGtraD0oMjAxMy0yMDE0LTEpLTIxMDE0MDAxLTA0MDgtMSZ4aD0yNzE4JywnanN4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD04MDAsaGVpZ2h0PTYwMCxsZWZ0PTEyMCx0b3A9NjAnKSJcPuWwmueOiea1t1w8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8MDQwODs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Mjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Mi4wLTAuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85ZGo5LiJ56ysNyw46IqCe%2BesrDQtMTnlkah9Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzkuJzmlZnkuIDpmLYxMDU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDIxMDE0MDAxOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcZTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pyq5LiK5LygOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47Pj47dDw7bDxpPDA%2BO2k8MT47aTwyPjtpPDM%2BO2k8ND47aTw1PjtpPDY%2BO2k8Nz47aTw4PjtpPDk%2BO2k8MTA%2BO2k8MTE%2BO2k8MTI%2BO2k8MTM%2BO2k8MTQ%2BO2k8MTU%2BO2k8MTY%2BO2k8MTg%2BO2k8MTk%2BOz47bDx0PHA8cDxsPFRleHQ7PjtsPCgyMDEzLTIwMTQtMSktMTMwNDQwMDItMjk2MC0yOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2tjeHguYXNweD9rY2RtPTEzMDQ0MDAyJnhoPTI3MTgnLCdrY3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTQ5MCxoZWlnaHQ9NTAwLGxlZnQ9MjAwLHRvcD01MCcpIlw%2B5aSn5a2m6Iux6K%2BtMlw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pivOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2pzeHguYXNweD9qc3pnaD0yOTYwJnhra2g9KDIwMTMtMjAxNC0xKS0xMzA0NDAwMi0yOTYwLTImeGg9MjcxOCcsJ2pzeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9ODAwLGhlaWdodD02MDAsbGVmdD0xMjAsdG9wPTYwJykiXD7lvKDoibNcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDI5NjA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDQuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8NC4wLTAuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDtUb29sVGlwOz47bDzlkajkuoznrKwxLDLoioJ756ysNC0xOeWRqH1cO%2BWRqOS6lOesrDE75ZGo5LqM56ysMSwy6IqCe%2BesrDQtMTnlkah9XDvlkajkupTnrKwxLDLoioJ756ysNC0xOeWRqH07Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOS4nOaVmUQxMDdcO%2BS4nOaVmUQ0MDM7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDEzMDQ0MDAyOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcZTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pyq5LiK5LygOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47Pj47dDw7bDxpPDA%2BO2k8MT47aTwyPjtpPDM%2BO2k8ND47aTw1PjtpPDY%2BO2k8Nz47aTw4PjtpPDk%2BO2k8MTA%2BO2k8MTE%2BO2k8MTI%2BO2k8MTM%2BO2k8MTQ%2BO2k8MTU%2BO2k8MTY%2BO2k8MTg%2BO2k8MTk%2BOz47bDx0PHA8cDxsPFRleHQ7PjtsPCgyMDEzLTIwMTQtMSktMTYwMTQ1MDYtMDQyMC0xOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2tjeHguYXNweD9rY2RtPTE2MDE0NTA2JnhoPTI3MTgnLCdrY3h4JywndG9vbGJhcj0wLGxvY2F0aW9uPTAsZGlyZWN0b3JpZXM9MCxzdGF0dXM9MCxtZW51YmFyPTAsc2Nyb2xsYmFycz0xLHJlc2l6YWJsZT0wLHdpZHRoPTQ5MCxoZWlnaHQ9NTAwLGxlZnQ9MjAwLHRvcD01MCcpIlw%2B5LmS5LmT55CD5Yid57qnXDwvYVw%2BOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwmbmJzcFw7Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDzmmK87Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPFw8YSBocmVmPScjJyBvbmNsaWNrPSJ3aW5kb3cub3BlbignanN4eC5hc3B4P2pzemdoPTA0MjAmeGtraD0oMjAxMy0yMDE0LTEpLTE2MDE0NTA2LTA0MjAtMSZ4aD0yNzE4JywnanN4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD04MDAsaGVpZ2h0PTYwMCxsZWZ0PTEyMCx0b3A9NjAnKSJcPuWImOS6rjFcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDA0MjA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDE7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDIuMC0wLjA7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOWRqOWbm%2BesrDMsNOiKgnvnrKw0LTE45ZGofTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85Lic5Yy65L2T6IKy5Zy6Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxNjAxNDUwNjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XGU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOacquS4iuS8oDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BOz4%2BO3Q8O2w8aTwwPjtpPDE%2BO2k8Mj47aTwzPjtpPDQ%2BO2k8NT47aTw2PjtpPDc%2BO2k8OD47aTw5PjtpPDEwPjtpPDExPjtpPDEyPjtpPDEzPjtpPDE0PjtpPDE1PjtpPDE2PjtpPDE4PjtpPDE5Pjs%2BO2w8dDxwPHA8bDxUZXh0Oz47bDwoMjAxMy0yMDE0LTEpLTE4MDE0MDAxLTI4NzYtMTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XDxhIGhyZWY9JyMnIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdrY3h4LmFzcHg%2Fa2NkbT0xODAxNDAwMSZ4aD0yNzE4Jywna2N4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD00OTAsaGVpZ2h0PTUwMCxsZWZ0PTIwMCx0b3A9NTAnKSJcPuaAneaDs%2BmBk%2BW%2Bt%2BS%2FruWFu%2BS4juazleW%2Bi%2BWfuuehgFw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pivOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2pzeHguYXNweD9qc3pnaD0yODc2Jnhra2g9KDIwMTMtMjAxNC0xKS0xODAxNDAwMS0yODc2LTEmeGg9MjcxOCcsJ2pzeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9ODAwLGhlaWdodD02MDAsbGVmdD0xMjAsdG9wPTYwJykiXD7lrqvmmZPnuqJcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDI4NzY7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDIuNTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8NC4wLTAuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDtUb29sVGlwOz47bDzlkajkuInnrKw1LDboioJ756ysNC0xNOWRqH1cO%2BWRqOS6lOesrDc75ZGo5LiJ56ysNSw26IqCe%2BesrDQtMTTlkah9XDvlkajkupTnrKw3LDjoioJ756ysNC0xNOWRqH07Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOS4nOaVmeS4gOWMlzIwOVw75Lic5pWZ5LiA5YyXMjA5Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxODAxNDAwMTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XGU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOacquS4iuS8oDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BOz4%2BO3Q8O2w8aTwwPjtpPDE%2BO2k8Mj47aTwzPjtpPDQ%2BO2k8NT47aTw2PjtpPDc%2BO2k8OD47aTw5PjtpPDEwPjtpPDExPjtpPDEyPjtpPDEzPjtpPDE0PjtpPDE1PjtpPDE2PjtpPDE4PjtpPDE5Pjs%2BO2w8dDxwPHA8bDxUZXh0Oz47bDwoMjAxMy0yMDE0LTEpLTEyMDAxMDU3LTEyMTUtMTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XDxhIGhyZWY9JyMnIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdrY3h4LmFzcHg%2Fa2NkbT0xMjAwMTA1NyZ4aD0yNzE4Jywna2N4eCcsJ3Rvb2xiYXI9MCxsb2NhdGlvbj0wLGRpcmVjdG9yaWVzPTAsc3RhdHVzPTAsbWVudWJhcj0wLHNjcm9sbGJhcnM9MSxyZXNpemFibGU9MCx3aWR0aD00OTAsaGVpZ2h0PTUwMCxsZWZ0PTIwMCx0b3A9NTAnKSJcPuS4reWbveWPpOS7o%2BenkeaKgOaWh%2BWMluWSjOeOsOS7o%2BWMllw8L2FcPjs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85pivOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDxcPGEgaHJlZj0nIycgb25jbGljaz0id2luZG93Lm9wZW4oJ2pzeHguYXNweD9qc3pnaD0xMjE1Jnhra2g9KDIwMTMtMjAxNC0xKS0xMjAwMTA1Ny0xMjE1LTEmeGg9MjcxOCcsJ2pzeHgnLCd0b29sYmFyPTAsbG9jYXRpb249MCxkaXJlY3Rvcmllcz0wLHN0YXR1cz0wLG1lbnViYXI9MCxzY3JvbGxiYXJzPTEscmVzaXphYmxlPTAsd2lkdGg9ODAwLGhlaWdodD02MDAsbGVmdD0xMjAsdG9wPTYwJykiXD7mnajmmKVcPC9hXD47Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDEyMTU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPDEuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8My4wLTAuMDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85ZGo5LqU56ysOSwxMCwxMeiKgnvnrKw0LTEx5ZGofTs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w85Lic5pWZ5LiA6Zi2MTA0Oz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxOz4%2BOz47Oz47dDxwPHA8bDxUZXh0Oz47bDwxMjAwMTA1Nzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8XGU7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPCZuYnNwXDs7Pj47Pjs7Pjt0PHA8cDxsPFRleHQ7PjtsPOacquS4iuS8oDs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BO3Q8cDxwPGw8VGV4dDs%2BO2w8Jm5ic3BcOzs%2BPjs%2BOzs%2BOz4%2BOz4%2BOz4%2BOz4%2BOz4%2BOz7yR%2FQ6oWwvZ%2FjgH3VYwxPxM9dBdQ%3D%3D
EOD;
$xn = '2013-2014';
$xq = '1';
$table = 'lesson2013_1_raw';
$sql = "SELECT * FROM `ahut_profile` WHERE `xh` ORDER BY `rx` DESC, `xh`";
$result = mysql_query($sql);
while(($row = mysql_fetch_array($result)) !== false){
echo $row['xh'];
$str = postURL('__EVENTTARGET=&__EVENTARGUMENT=&__VIEWSTATE='.$viewstate.'&ddlXN='.$xn.'&ddlXQ='.$xq.'&TextBox1='.$row['xh'].'&btnFiler=+%B2%E9+%D1%AF+',$sessionid);
$str = @iconv('gb2312', 'utf-8//IGNORE', $str);
$str = strip_breaks($str);
$str = str_extract($str, '</td><td>授课计划下载</td></tr>', '</tr></table>');
$str = parse_table($str);
if(empty($str)){
echo "Empty!\n";
continue;
}
foreach($str as $r){
$lessonid = substr($r[0],14,8);
$teacherid = substr($r[0],23,4);
$sql = "INSERT INTO `$table` VALUES ('{$row['xh']}', '{$row['xm']}', '{$row['bj']}', '$lessonid', '$teacherid', '{$r[1]}', '', '{$r[4]}','{$r[5]}', '{$r[9]}', '{$r[10]}', '{$r[11]}', '{$r[12]}', '{$r[13]}', '{$r[14]}', '{$r[8]}')";
mysql_query($sql);
}
echo "\n";
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment