Mercurial > hg > ywww
view php/read/getLinkedBooks.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 b7376319d25a |
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 } if(isset($ret)) { include "../../private/db.php"; $loc = $countryCode; //passed from index.php when googlebot is crawling } else { include "../../../private/db.php"; $ret = 0; } $query = "CALL b_getLinksForISBN('$isbn',$loc)"; //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)) { $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); ?>
