view php/read/getLinkedBooks.php @ 49:a67bf725e87b

put both paths in include_path and depend on that
author Charlie Root
date Wed, 16 Jan 2019 13:42:15 -0500
parents b7376319d25a
children
line wrap: on
line source

<?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");
}

$linkedBooks = 0;
include "similar.php"; 

//$isbn = $_GET['isbn'];

if(isset($_GET['isbn'])){
	$isbn = $_GET['isbn'];
}

if(isset($_GET['loc'])){
	$loc = $_GET['loc'];
}
else{
	$loc = 1;	//default location is 1
} 

include "db.php"; 

if(isset($ret))
{
	$loc = $countryCode; //passed from index.php when googlebot is crawling
}
else
{
	$ret = 0;
}	

$query = "CALL b_getLinksForISBN('$isbn',$loc)";
//echo $query;
$results = my_query($query,'glb');

$output = "<?xml version=\"1.0\"?>";
$output .= "<results>";

while($line = mysqli_fetch_assoc($results)) {

	$linkID = $line["LinkID"];
	$lISBN=trim($line["LinkedISBN"]);
	$lID = trim($line["LinkID"]);
	if($lISBN != "" && $lID != "")
	{
		$output .=  "<type>0</type>";
		$output .=  "<isbn>" . $lISBN . "</isbn>";
		$output .=  "<linkID>" . $lID . "</linkID>";
		/*$output .=  "<pos>" . $pos . "</pos>";
		$output .=  "<search>" . $search . "</search>";*/
		$linkedBooks++;
	}
	/*else{		//this should never happen-> if there is a link, there must be a link ID and also an ISBN to link to
		echo "**ERROR**"
		echo "LinkedISBN=$lISBN";		//uncomment this to help debug if this ever happens.
		echo "LinkID=$lID";
	}*/
}

if( $linkedBooks < 8 )
{
$amazonBooks=addAmazonSimilarBooks($isbn,$loc,$ret);  
$output .=  $amazonBooks;
}

$output .=  "</results>";

if($ret==1)
	return $output;
else
	echo $output;

mysqli_close($link);

?>