-
Notifications
You must be signed in to change notification settings - Fork 0
/
news.php
65 lines (56 loc) · 1.79 KB
/
news.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
<?php
header("Content-type: text/html; charset=UTF-8");
require('connectdb.php');
$getIDs=$_GET["ID"];
$getNext=$_GET["next"];
$legal=ifIDLegal($getIDs)&&ifNextLegal($getNext);
$multiID= ifMultiID($getIDs);
$final="";
$counter=0;
if($legal){
$query='';
$array2;
$counter2=0;
$start=((integer)$getNext-1)*20;
$end=((integer)$getNext)*20;
if($multiID){
$query="select id,date,title,content from news WHERE id IN $getIDs order by date DESC limit $start,$end";
}else{
$query="select id,date,title,content from news WHERE id=$getIDs order by date DESC limit $start,$end";
}
$result=mysql_query($query)or die("Invalid query: ".mysql_error());
while($result_row=mysql_fetch_row(($result)))//取出结果并显示
{
$id=$result_row[0];
$date=$result_row[1];
$title=urlencode(preg_replace($search,$replace,trim($result_row[2])));
//$title=urlencode($result_row[2]);
//$title=urlencode(replace($result_row[2]));
$content=urlencode(preg_replace($search,$replace,trim($result_row[3])));
//$content=urlencode($result_row[3]);
//$content=urlencode(replace($result_row[3]));
//$content=preg_replace($search,$replace,$result_row[3]);
$arr=array("id"=>$id,"date"=>$date,"title"=>$title,"content"=>$content);
$array2[$counter2]=$arr;
$counter2++;
}
// }
$final=json_encode($array2);
// preg_replace("#\\\u([0-9a-f]{4})#ie", "iconv('UCS-2BE', 'UTF-8', pack('H4', '\\1'))", $json);
echo preg_replace("#\\\u([0-9a-f]{4})#ie", "iconv('UCS-2', 'UTF-8', pack('H4', '\\1'))", urldecode($final));
//echo urldecode($final);
}else{
echo 'Parameters Error!';
}
//判断next是否合法的函数
function ifNextLegal($next){
if($next==null){
return false;
}
if(is_numeric($next)){
return true;
}else{
return false;
}
}
?>