Mercurial > hg > ywww

comparison php/read/setThumbState.php @ 6:077b0a0a3e6d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
remaining originals according to dependency walk
author Robert Boland <robert@markup.co.uk>
date Thu, 16 Feb 2017 22:29:02 +0000
parents
children 385ddd7c4b55 a67bf725e87b
comparison
equal deleted inserted replaced
5:55445b456ad0 6:077b0a0a3e6d
1 <?PHP
2 $userID = strval($_GET['userID']);
3 //echo $userID;
4 $linkList = strval($_GET['list']);
5 //echo $linkList;
6
7
8 include "../../../private/db.php";
9
10 $query1 = "select * from b_thumbstate where UserID= $userID and LinkID in ($linkList) and state <> 0"; //CALL b_setThumbState($userID, $linkList)";
11 //echo $query1;
12 $data1 = mysqli_query($link, $query1);
13
14 echo "<?xml version=\"1.0\"?>";
15 echo "<results>";
16 while($line = mysqli_fetch_assoc($data1)) {
17 if ($line["State"] == 1)
18 echo "<up>" . trim($line["LinkID"]) . "</up>";
19 else if ($line["State"] == -1)
20 echo "<down>" . trim($line["LinkID"]) . "</down>";
21 }
22 echo "</results>";
23 mysqli_close($link);
24
25 ?>