-
Notifications
You must be signed in to change notification settings - Fork 1
/
rss.php
47 lines (44 loc) · 1.15 KB
/
rss.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
<?php
// header("Content-type: text/html; charset=utf-8");
mysql_connect("localhost","root","");
mysql_select_db("FT-MTServe");
mysql_query("set names utf8");
// $row=mysql_fetch_assoc($result);
$act=$_GET['act'];
switch ($act) {
case 'add':
$name=$_COOKIE['username'];
$rss_id=$_GET['id'];
$sql="SELECT * FROM rss_user WHERE name='{$name}' AND rss_id='{$rss_id}'";
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
if (mysql_num_rows($result)>0) {
echo '{"error":"0"}';
exit();
}
$sql="INSERT INTO rss_user(id,name,rss_id) VALUES('','$name','$rss_id')";
mysql_query($sql);
$id=mysql_insert_id();
echo '{"error":"0","id":'.$id.'}';
break;
case 'del':
$name=$_COOKIE['username'];
$rss_id=$_GET['id'];
$sql="DELETE FROM rss_user WHERE name='{$name}' AND rss_id='{$rss_id}'";
mysql_query($sql);
if (mysql_affected_rows()>0) {
echo '{"error":"0"}';
exit();
}
echo '{"error":"1"}';
break;
case 'get':
$name=$_COOKIE['username'];
$sql="SELECT * FROM rss_user WHERE name='{$name}'";
$result=mysql_query($sql);
while ($row=mysql_fetch_assoc($result)) {
echo $row['rss_id'].",";
}
break;
}
?>