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