Mercurial > hg > ywww
view php/read/setThumbState.php @ 10:5aa24c984a3b
if no code show entire response
author | Henry S. Thompson <ht@markup.co.uk> |
---|---|
date | Sat, 18 Feb 2017 12:28:36 +0000 |
parents | 077b0a0a3e6d |
children | 385ddd7c4b55 a67bf725e87b |
line wrap: on
line source
<?PHP $userID = strval($_GET['userID']); //echo $userID; $linkList = strval($_GET['list']); //echo $linkList; include "../../../private/db.php"; $query1 = "select * from b_thumbstate where UserID= $userID and LinkID in ($linkList) and state <> 0"; //CALL b_setThumbState($userID, $linkList)"; //echo $query1; $data1 = mysqli_query($link, $query1); echo "<?xml version=\"1.0\"?>"; echo "<results>"; while($line = mysqli_fetch_assoc($data1)) { if ($line["State"] == 1) echo "<up>" . trim($line["LinkID"]) . "</up>"; else if ($line["State"] == -1) echo "<down>" . trim($line["LinkID"]) . "</down>"; } echo "</results>"; mysqli_close($link); ?>