Mercurial > hg > ywww
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); ?>
