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