Mercurial > hg > ywww
view php/read/setThumbState.php @ 35:86f79bc1d142
refactor to split out shareable fn to actually do an Amazon API request
author | Charlie Root |
---|---|
date | Fri, 04 Jan 2019 12:54:12 -0500 |
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); ?>