Mercurial > hg > ywww
view php/read/setThumbState.php @ 15:385ddd7c4b55 testing
use test_db.php to get mysqld_test instance
author | Henry S. Thompson <ht@inf.ed.ac.uk> |
---|---|
date | Sun, 19 Feb 2017 16:17:53 +0000 |
parents | 077b0a0a3e6d |
children |
line wrap: on
line source
<?PHP $userID = strval($_GET['userID']); //echo $userID; $linkList = strval($_GET['list']); //echo $linkList; include "../../../../private/db_test.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); ?>