Mercurial > hg > ywww
diff php/read/map/getMapRecommendations.php @ 6:077b0a0a3e6d
remaining originals according to dependency walk
author | Robert Boland <robert@markup.co.uk> |
---|---|
date | Thu, 16 Feb 2017 22:29:02 +0000 |
parents | |
children | 385ddd7c4b55 a67bf725e87b |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/php/read/map/getMapRecommendations.php Thu Feb 16 22:29:02 2017 +0000 @@ -0,0 +1,66 @@ +<?PHP +if(!isset($ret)) +{ +header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); +header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); +header("Cache-Control: no-store, no-cache, must-revalidate"); +header("Cache-Control: post-check=0, pre-check=0", false); +header("Pragma: no-cache"); +} + +//$isbn = $_GET['isbn']; + +if(isset($_GET['user'])){ + $user = $_GET['user']; +} + +if(isset($_GET['listname'])){ + $listName = $_GET['listname']; +} +else{ + $listName = "MyMap"; //default location is 1 +} + +if(isset($_GET['loc'])){ + $loc = $_GET['loc']; +} +else{ + $loc = 1; //default location is 1 +} + +include "../../../../private/db.php"; + +$query = "CALL b_getMap_relatedBooks($user,$loc,\"$listName\")"; +//echo $query; +$results = mysqli_query($link, $query) or exit( mysqli_error( $link )); + +$output = "<?xml version=\"1.0\"?>"; +$output .= "<results>"; + +while($line = mysqli_fetch_assoc($results)) { + + $ISBN=trim($line["ISBN"]); + $Title = htmlspecialchars($line["Title"]); + $Author = htmlspecialchars($line["Author"]); + $ImageURL = trim($line["ImageURL"]); + + $output .= "<BOOK>" ; + $output .= "<ISBN>" . $ISBN . "</ISBN>"; + $output .= "<Title>" . $Title . "</Title>"; + $output .= "<Author>" . $Author . "</Author>"; + $output .= "<ImageURL>" . $ImageURL . "</ImageURL>"; + $output .= "</BOOK>"; + + $linkedBooks++; +} + +$output .= "</results>"; + +if($ret==1) + return $output; +else + echo $output; + +mysqli_close($link); + +?> \ No newline at end of file