view php/read/setThumbState.php @ 43:dbc006408d2b

ASSUMES we have SetEnv PHP_VALUE "include_path =.:/var/test/private:/var/test/ywww:/usr/share/php" in apache2/.../test.conf use dl(...) for debug logging, defined in dlog.php use doAmazonRequest in amazonBookSearch use ../private/web.php (q.v., not in mercurial) for Aserver and Aassociates Started by updating from 40:c24ae74bf6d5, i.e. just before the bug on the main line
author Charlie Root
date Sat, 05 Jan 2019 18:00:10 -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);

?>