Mercurial > hg > ywww
view php/read/setThumbState.php @ 51:e6976d92cfc9
refactor 503
author | Charlie Root |
---|---|
date | Thu, 06 Jun 2019 16:32:56 -0400 |
parents | a67bf725e87b |
children |
line wrap: on
line source
<?PHP $userID = strval($_GET['userID']); //echo $userID; $linkList = strval($_GET['list']); //echo $linkList; include "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); ?>