TechGuru

php写的cet成绩批量查询

Posted in javascript, php on 08/24/2009 11:32 上午 by tunpishuang

一直都关注cnbeta的动态，没想到20号的时候登录尽然有这条新闻：‘“2009年6月CET6成绩于今天2009年8月20号早上9点公布” ，cnbeta现在是嘛新闻都出啊。于是乎就拿出了俺的“证件夹”，掏出了准考证开始查成绩，我对这个网上cet查分的网站的认识和评价基本上和此文一样，这次6级得到437分，感觉还是差不多了，因为还重来没有认认真真的停下来背单词、作题，除了考四级的时候作了一张模拟卷。

这个查询网站通过ajax来查询，需要等待15秒的时间，每次限查询一人成绩，听说08年的时候还要安装activex控件才能查询，对于linux用户就恼火了。通过分析一下http://cet.99sushe.com/这个页面发现没有表单(form)，而是这样一句：

<input id="btn" type="button" name="" value="查询" onclick="submit_search();" /></p>

调用了一个js函数submit_search(); 网页引用了一个js文件：http://cet.99sushe.com/res/js/cet0908.js ：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180

——————————————-

总结起来就是向getscore.html post一个数据”id=”+xxxxxxxxxxxx

可以通过curl向指定的服务器发送数据包，具体方法此文 “斗智斗勇续四六级查分技巧 ” 有介绍，需要注意的一点是查询的服务器有referer验证，referer验证一般用来防盗链，防止数据从非本站的提交上去，不过自定义referer并不是什么好难的事情，此为的作者还做了一个c#的gui前端，基本上就是把cmd的输出放在gui界面上，没有多大的意义。这个 “CET在线连续查分程序” 是别人用c#弄的一个在线查询，可以指定准考证号的起始号码和结束号码，就可以连续查询了。

然后我受到这样的启发，做了一个php版本的，演示地址：http://tunpishuang.iamspace.com/cet.php ，和c#那个略有不同的是并不是指定起始和结束地址，而是直接输入前6位，最多输出6000人的成绩，我贴一下源代码：

cet.php —————————————————

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>2009年上半年CET院校成绩批量查询 by tunpishuang</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
#description{
border:solid 4px 4px 10px 4px #828282;
color:#8B0000;
width:420px;
}
#form{
border:solid 4px #828282;
color:#8B0000;
width:520px;
}
</style>
</head>
<body>
<h1>2009年上半年CET院校成绩批量查询 by tunpishuang</h1>
<div id="description">
A.前6位是地区号.(可以问与你同一城市报名的任何一人)<br />
B.然后是071 (表示07年的第1次,即07年6月份的)<br />
C.然后是1或2 (1代表四级,2代表6级)<br />
D.然后的三位是你的考场号,多为0**或1**<br />
E.最后两位是你的座位<br />
</div>
<form method="post" action="cet_query.php">
<div id="form">
单人成绩查询(输入准考证号)<input type="text" name="tid" id="tid" size="15" maxlength="15" /><input type="submit" value="查一查，更健康" /><p></p>
院校成绩查询(输入准考证号前六位)<input type="text" name="cid" id="cid" size="8" maxlength="6" /><input type="submit" value="查一查，更健康" />
</div>
</form>
<div>
<h1>这个查询程序草草完工，有待完善的地方，但是我不想弄了，弄老一天，人都矿鸟<p></p>
有空到我博客来耍哈，<a href="http://techguru.cn">http://techguru.cn</a></h1>
</div>
</body>
</html>

cet_query.php—————————————————-

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130

<?php
echo "
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<title>查询结果</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />
<style type=\"text/css\">
table,td,tr,th{
border:solid 1px #1E90FF;
text-align:center;
}
</style>
</head>
<body>
<table cellpadding=\"15\" cellspacing=\"0\" >
<tr>
<th>听力</th>
<th>阅读</th>
<th>综合</th>
<th>写作</th>
<th>总分</th>
<th>学校</th>
<th>姓名</th>
</tr>
";

$data_fmt=array();
function query($id){
$curl = curl_init();
$curlpost='id='.$id;
curl_setopt($curl, CURLOPT_URL, 'http://cet.99sushe.com/getscore.html');
curl_setopt($curl, CURLOPT_REFERER, 'http://cet.99sushe.com');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_POST,1);
curl_setopt($curl, CURLOPT_POSTFIELDS,$curlpost);
curl_setopt($curl, CURLOPT_CONNECTTIMEOUT,0);
$data = curl_exec($curl);
global $data_fmt;
$data_fmt=explode(",",$data);
echo "
<tr>
<td>$data_fmt[0]</td>
<td>$data_fmt[1]</td>
<td>$data_fmt[2]</td>
<td>$data_fmt[3]</td>
<td>$data_fmt[4]</td>
<td>$data_fmt[5]</td>
<td>$data_fmt[6]</td>
</tr>"
;
curl_close($curl);
}

function person_query($tid){
query($tid);

}
function college_query($cid)
{ $cid=$_POST['cid'];
$cid=sprintf("%.0f",$cid."091200100");
$j=0;
$k=0;
while($k<2){
while($j<100){
for($i=0;$i<30;$i++)
{ $cid=sprintf("%.0f",$cid+1);
query($cid);
}
$cid=$cid-30;
$cid=$cid+100;
$j++;
}
$cid=$_POST['cid'];
$cid=sprintf("%.0f",$cid."091200100");
$j=0;
$k++;

}
}
if(($_POST['tid'])!=0){
$tid=$_POST['tid'];
person_query($tid);
}
if(($_POST['cid'])!=0){
$cid=$_POST['cid'];
college_query($_POST['cid']);
}
echo "</table>
</body>
</html>";
?>

没有什么好讲的吧，主要是用到了php的libcurl库抓网页。

Tags: cet, curl, javascript, libcurl, php
Add Comment » No Comments

过了个CET-4

Posted in life on 03/01/2009 10:43 下午 by tunpishuang

有点意外，本来预期是750/2的分数，对于咋们小专科来说很8错了，但是我攀爬顶峰的脚步不会停滞的。下次准备CET-6。

ps:听说我们专业就我一个过了，哎，是悲哀还是意外？

Tags: cet, life
Add Comment » 4 Comments

Red Hot Chili Peppers – Snow (Hey Oh)

Posted in fun on 12/20/2008 06:07 下午 by tunpishuang

youtube被墙了，看下面的：

因为看了《Death Note 2 – The Last name》，没有想到片尾曲如此的熟悉，搜了一哈，尽然是Red Hot Chili Peppers的Snow,也叫Hey Oh （对此我有两囧，1囧：Band名字好长，2囧：这首歌尽然有两个名字）。
之所以这样惊讶主要是高中的时候听了太多次了，确实耐听，节奏明快，差点在寝室达到High tide。
So,来分享一下高中的特爱。lyrics below:
__________________
come to decide that the things that i tried
were in my life just to get high on

when i sit alone come get a little long
but i need more than myself this time

step from the road to the sea to the sky
and i do believe that we rely on

when i lay it on
come get to play it on
all my life to sacrifice

hey oh listen what i say oh
i got your
hey oh now listen what i say oh

when will i know that i really can’t go
to the well once more time to decide on

when it’s killing me
when will i really see
all that i need to look inside

come to believe that i better not leave
before i get my chance to ride

when it’s killing me
what do i really need
all that i need to look inside

hey oh listen what i say oh
come back and
hey oh look at what i say oh

the more i see the less i know
the more i like to let it go… hey oh… woah woah woah

deep beneath the cover of another perfect wonder
where it’s so white as snow

privately divided by a world so undecided
and there’s nowhere to go

in between the cover of another perfect wonder
and it’s so white as snow

running through the field where all my tracks will be concealed
and there’s nowhere to go

oh

[snow (hey oh) lyrics on http://www.metrolyrics.com]

when to descend to amend for a friend
all the channels that have broken down

now you bring it up
i’m gonna ring it up
just to hear you sing it out

step from the road to the sea to the sky
and i do believe what we rely on

when i lay it on
come get to play it on
all my life to sacrifice

hey oh listen what i say oh
i got your
hey oh listen what i say oh

the more i see the less i know
the more i like to let it go… hey oh
woah woah woah

people need the cover of another perfect wonder
where it’s so white as snow

privately divided by a world so undecided
and there’s nowhere to go

in between the cover of another perfect wonder
where it’s so white as snow

running through the field where all my tracks will be concealed
and there’s nowhere to go.

i said hey hey yeah… oh yeah,
tell my love now
hey yeah yeah oh yeah
tell my love now
deep beneath the cover of another perfect wonder
where it’s so white as snow
finally divided by a world so undecided
and there’s nowhere to go
deep beneath the cover of another perfect wonder
where it’s so white as snow

running through the field where all my tracks will be concealed
and there’s nowhere to go.

i said hey oh yeah… oh yeah,
tell my love now
hey oh yeah oh yeah oh yeah, oh yeah

______________________________歌词来源
同时最近看了一部名为《黑太阳731》的电影，被shock了，得以有此影评。
今天考了cet4,Let’s pray to God and Bodhisattva.
另外说说我的收藏歌曲手段，首先听到首好听的歌曲，然后寻找该专辑（一般上VeryCD）,如果专辑也符合你的口味，这个时候你可以搜寻该乐团或者歌手的全部专辑，如：