<?php
// 杭电2018届学生专业信息爬取

// Database
$con = mysql_connect("localhost","root","root");
mysql_select_db("HDU", $con);

$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://college.studentpay.cn/alipay/h5/my_bill.htm');
curl_setopt($curl, CURLOPT_HEADER, 1);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_POST, 1);

//格式 2018 [01-40] 11 [0-150]

for($i = 1;$i <= 40;$i++){
for($j = 1;$j <= 150;$j++){
$num = '2018' . sprintf("%02d", $i) . '11' . sprintf("%03d", $j);
$num = (int)$num;
$post_data = array(
"tipsShow" => 1,
"schNo" => 10336,
"stuNo" => $num
);

curl_setopt($curl, CURLOPT_POSTFIELDS, $post_data);
$data = curl_exec($curl);
//curl_close($curl);

//姓名
preg_match("|\"item-title label\">(.*)</div>|isU",$data,$match);
$stuName = $match[1];
$stuName = preg_replace("/(\s|\&nbsp\;|　|\xc2\xa0)/",'',$stuName); // 去除空格

//专业
preg_match("|\"item-input\">(.*)</div>|isU",$data,$match);
$stuClass = $match[1];
$stuClass = preg_replace("/(\s|\&nbsp\;|　|\xc2\xa0)/",'',$stuClass); // 去除空格
$stuClass = str_replace('无班','',$stuClass); // 去除“无班”

if($stuName != null){
insertData($stuName, $stuClass, $num);
}
sleep(0.5);
}
}

echo('DONE! ENJOY IT!');

function insertData($Name, $Class, $No){
mysql_query("INSERT INTO HDU (stu_Name, stu_Class, stu_No) VALUES ('$Name', '$Class','$No')");
}