2
+ − 1 <?php
+ − 2
+ − 3 function findGenre($browseNode, &$ID, &$gen)
+ − 4 {
+ − 5 if($browseNode->Name == "Subjects")
+ − 6 {
+ − 7 return true;
+ − 8 }
+ − 9 else
+ − 10 {
+ − 11 if($browseNode->Ancestors->BrowseNode)
+ − 12 {
+ − 13 if(findGenre($browseNode->Ancestors->BrowseNode, $ID, $gen) == true)
+ − 14 {
+ − 15 $gen = $browseNode->Name;
+ − 16 $ID = $browseNode->BrowseNodeId;
+ − 17
+ − 18 //if($browseNode->Name == "Literature & Fiction") //to return one level up the tree as well
+ − 19 // return true;
+ − 20 }
+ − 21 }
+ − 22 return false;
+ − 23 }
+ − 24 }
+ − 25
+ − 26 if(isset($_GET['isbn'])){
+ − 27 $isbn = $_GET['isbn'];
+ − 28 if(isset($_GET['locale'])){
+ − 29 $locale=$_GET['locale'];
+ − 30
+ − 31 switch ($locale) {
+ − 32 case "uk":
+ − 33 $loc = 1;
+ − 34 break;
+ − 35 case "us":
+ − 36 $loc = 0;
+ − 37 break;
+ − 38 case "ca":
+ − 39 $loc = 2;
+ − 40 break;
+ − 41 case "de":
+ − 42 $loc = 3;
+ − 43 break;
+ − 44 case "fr":
+ − 45 $loc = 4;
+ − 46 break;
+ − 47 case "":
+ − 48 $loc = 0;
+ − 49 break;
+ − 50 }
+ − 51 }
+ − 52 else{
+ − 53 $loc=0;
+ − 54 }
+ − 55 $output = "";
+ − 56
+ − 57 $output .= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
+ − 58 $output .= "<BookDetails>";
+ − 59
+ − 60 $proceed = true;
+ − 61 include "../../../private/db.php";
+ − 62
+ − 63 $query = "CALL b_getBookInfo('$isbn', $loc)";
+ − 64 //select Timestamp,Title,Author,Binding,DeweyDecimal,ImageURL,SalesRank,PublicationDate,Publisher,Genre1,Genre2,Genre3 from books where ISBN = '$isbn'";
+ − 65 //echo $query;
+ − 66 $res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
+ − 67
+ − 68 if ( mysqli_num_rows( $res ) > 0 )
+ − 69 {
+ − 70 $rows=mysqli_fetch_array($res, MYSQLI_ASSOC);
+ − 71 $timestamp=$rows['Timestamp'];
+ − 72 //echo $timestamp;
+ − 73 date_default_timezone_set('UTC');
+ − 74 $dbStamp = strtotime($timestamp);
+ − 75 //echo $dbStamp;
+ − 76 $unixTime = time();
+ − 77 //echo $unixTime;
+ − 78 $timeDiff = $unixTime - $dbStamp;
+ − 79 //echo $timeDiff;
+ − 80
+ − 81 if($timeDiff < 2592000) //if it has been updated in the last 30 days
+ − 82 {
+ − 83 $proceed = false;
+ − 84 $output .= "<ISBN>" . $isbn . "</ISBN>";
+ − 85 $output .= "<Title>" . htmlspecialchars($rows["Title"]) . "</Title>";
+ − 86 $output .= "<Author>" . htmlspecialchars($rows["Author"]) . "</Author>";
+ − 87 $output .= "<Binding>" . htmlspecialchars($rows["Binding"]) . "</Binding>";
+ − 88 $output .= "<Dewey>" . htmlspecialchars($rows["DeweyDecimal"]) . "</Dewey>";
+ − 89 $output .= "<ImageURL>" . htmlspecialchars($rows["ImageURL"]) . "</ImageURL>";
+ − 90 $output .= "<SalesRank>" . htmlspecialchars($rows["SalesRank"]) . "</SalesRank>";
+ − 91 $output .= "<PublicationDate>" . htmlspecialchars($rows["PublicationDate"]) . "</PublicationDate>";
+ − 92 $output .= "<Publisher>" . htmlspecialchars($rows["Publisher"]) . "</Publisher>";
+ − 93 $output .= "<Genre1>" . htmlspecialchars($rows["Genre1"]) . "</Genre1>";
+ − 94 $output .= "<Genre2>" . htmlspecialchars($rows["Genre2"]) . "</Genre2>";
+ − 95 $output .= "<Genre3>" . htmlspecialchars($rows["Genre3"]) . "</Genre3>";
+ − 96 $output .= "<ProductGroup>Book</ProductGroup>";
+ − 97 }
+ − 98 }
+ − 99 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+ − 100 include "../../../private/db.php";
+ − 101
+ − 102 if($proceed == true)
+ − 103 {
+ − 104 include "aws_signed_request.php";
+ − 105 //book does not exist already so look up all the info from browse nodes....
+ − 106
+ − 107 $Adefault=array(
+ − 108 'language' =>'en', //what language to render the page in
+ − 109 'locale' =>'us', //which server's products? available: ca,de,fr,jp,uk,us
+ − 110 'page' =>1, //first page to show (we are counting from 1 not 0)
+ − 111 'operation' =>'ItemLookup', //what to do? //ItemSearch
+ − 112 'searchparameter' =>'ItemId', //what kind of search?
+ − 113 'searchindex' => 'Books',
+ − 114 'searchparameterdata'=>$isbn, //what to search for?
+ − 115 'search' =>$isbn,
+ − 116 //here some debugging flags you can put at the end of the URL to call this script with, like: '?show_array=true'
+ − 117 'show_array' =>false, //debug: show complete incoming array? You can use this to see what other information Amazon is sending
+ − 118 'show_url' =>false, //debug: show XML request url to be send to Amazon?
+ − 119 'show_xml' =>false, //debug: show incoming XML code from Amazon?
+ − 120 );
+ − 121 //change the debug options to true if you want to activate them or call the script with '?show_array=true' to see what actual information you're getting from Amazon and how little my standard script is actually showing of it
+ − 122
+ − 123 $Aassociates_id=array(
+ − 124 'uk' => 'bookwhack-21',
+ − 125 'us' => 'your02b-20',
+ − 126 'ca' => 'book009-20',
+ − 127 'de' => 'book04c-21',
+ − 128 'fr' => 'book07f-21',
+ − 129 );
+ − 130
+ − 131 $Aserver=array(
+ − 132 'ca' => array(
+ − 133 'ext' => 'ca' , //Canadian normal server
+ − 134 'nor' => 'http://www.amazon.ca' , //Canadian normal server
+ − 135 'xml' => 'http://xml.amazon.com' , //Canadian xml server
+ − 136 ),
+ − 137 'de' => array(
+ − 138 'ext' => 'de' , //German normal server
+ − 139 'nor' => 'http://www.amazon.de' , //German normal server
+ − 140 'xml' => 'http://xml-eu.amazon.com', //German xml server
+ − 141 ),
+ − 142 'fr' => array(
+ − 143 'ext' => 'fr' , //French normal server
+ − 144 'nor' => 'http://www.amazon.fr' , //French normal server
+ − 145 'xml' => 'http://xml-eu.amazon.com', //French xml server
+ − 146 ),
+ − 147 'jp' => array(
+ − 148 'ext' => 'jp' , //Japanese normal server, not co.jp!
+ − 149 'nor' => 'http://www.amazon.co.jp' , //Japanese normal server
+ − 150 'xml' => 'http://xml.amazon.com' , //Japanese xml server
+ − 151 ),
+ − 152 'uk' => array(
+ − 153 'ext' => 'co.uk' , //UK normal server
+ − 154 'nor' => 'http://www.amazon.co.uk' , //UK normal server
+ − 155 'xml' => 'http://xml-eu.amazon.com', //UK xml server
+ − 156 ),
+ − 157 'us' => array(
+ − 158 'ext' => 'com' , //USA normal server
+ − 159 'nor' => 'http://www.amazon.com' , //USA normal server
+ − 160 'xml' => 'http://xml.amazon.com' , //USA xml server
+ − 161 ),
+ − 162 );
+ − 163
+ − 164 $public_key ="AKIAJBXEHTNCU6LLFNIA";
+ − 165 $private_key="Dgyv7aR6uGe3OtY95Dj6hHpDS/UEtyboMWpJchYA";
+ − 166
+ − 167 //for all parameters see if the user has overruled it or use the default
+ − 168 foreach ($Adefault as $i=>$d) {
+ − 169 $$i=isset($_GET[$i])?$_GET[$i]:$d;
+ − 170 }
+ − 171
+ − 172 $parameters=array(
+ − 173 'Operation' =>$operation ,
+ − 174 'Keywords' =>urlencode($search) ,
+ − 175 'SearchIndex' =>$searchindex , //Books for example.
+ − 176 "$searchparameter"=>$searchparameterdata ,
+ − 177 'ItemPage' =>$page , //which page?
+ − 178 'AssociateTag' =>$Aassociates_id[$locale],
+ − 179 'ResponseGroup' =>'ItemAttributes,Images,SalesRank,BrowseNodes'
+ − 180 );
+ − 181
+ − 182
+ − 183 $ext=$Aserver[$locale]['ext'];
+ − 184 $file_data=$ext;
+ − 185 ksort($parameters);
+ − 186 foreach ($parameters as $i=>$d) {
+ − 187 $file_data.='&'.$i.'='.$d;
+ − 188 }
+ − 189
+ − 190 $url=aws_signed_request($ext,$parameters,$public_key,$private_key);
+ − 191 //echo $url;
+ − 192
+ − 193 $crl = curl_init();
+ − 194 $timeout = 5;
+ − 195 curl_setopt ($crl, CURLOPT_URL,$url);
+ − 196 curl_setopt ($crl, CURLOPT_ENCODING , "gzip");
+ − 197 curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
+ − 198 curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
+ − 199 $out = curl_exec($crl);
+ − 200 curl_close($crl);
+ − 201
+ − 202 //echo $out;
+ − 203
+ − 204 $xml = new SimpleXMLElement($out);
+ − 205 //use this xml to pull out the necessary information and save it
+ − 206
+ − 207 $title="";
+ − 208 $author="";
+ − 209 $binding="";
+ − 210 $dewey="";
+ − 211 $imageURL="";
+ − 212 $salesRank="";
+ − 213 $pubDate="";
+ − 214 $publisher="";
+ − 215
+ − 216 $title = $xml->Items->Item->ItemAttributes->Title;
+ − 217 $author = $xml->Items->Item->ItemAttributes->Author;
+ − 218 $binding = $xml->Items->Item->ItemAttributes->Binding;
+ − 219 $dewey = $xml->Items->Item->ItemAttributes->DeweyDecimalNumber;
+ − 220 if($dewey == "")
+ − 221 $dewey = "null";
+ − 222 $imageURL = $xml->Items->Item->MediumImage->URL;
+ − 223 $salesRank = $xml->Items->Item->SalesRank;
+ − 224 $pubDate = $xml->Items->Item->ItemAttributes->PublicationDate;
+ − 225 $publisher = $xml->Items->Item->ItemAttributes->Publisher;
+ − 226
+ − 227 /*echo $title;
+ − 228 echo $author;
+ − 229 echo $binding;
+ − 230 echo $dewey;
+ − 231 echo $imageURL;
+ − 232 echo $salesRank;
+ − 233 echo $pubDate;
+ − 234 echo $publisher;*/
+ − 235
+ − 236 $genreID = "";
+ − 237 $genre = "";
+ − 238 $genArr = array();
+ − 239 $g1 = "null";
+ − 240 $g2 = "null";
+ − 241 $g3 = "null";
+ − 242 if(isset($xml->Items->Item->BrowseNodes->BrowseNode)){
+ − 243 for($i=0;$i<sizeof($xml->Items->Item->BrowseNodes->BrowseNode);$i++){
+ − 244 //sexy recursive function
+ − 245 findGenre($xml->Items->Item->BrowseNodes->BrowseNode[$i], $genreID, $genre);
+ − 246
+ − 247 if($genre != "")
+ − 248 $genArr[strval($genreID)] = strval($genre);
+ − 249 //$genArr[$i] = array(strval($genreID) => strval($genre));
+ − 250
+ − 251 //echo $genre;
+ − 252 //echo $genreID;
+ − 253
+ − 254 $genre = "";
+ − 255 $genreID = "";
+ − 256 }
+ − 257
+ − 258 $g1 = "null";
+ − 259 $g2 = "null";
+ − 260 $g3 = "null";
+ − 261 $loop = 1;
+ − 262
+ − 263 foreach ($genArr as $key => $value) {
+ − 264 //echo "$key => $value";
+ − 265 $queryG = "CALL b_addBrowseNode($key,\"$value\")"; //add the name value pair for genre to new table
+ − 266 //echo $queryG;
+ − 267 $resG = mysqli_query($link, $queryG);
+ − 268
+ − 269 switch ($loop) {
+ − 270 case 1:
+ − 271 $g1 = $key;
+ − 272 break;
+ − 273 case 2:
+ − 274 $g2 = $key;
+ − 275 break;
+ − 276 case 3:
+ − 277 $g3 = $key;
+ − 278 break;
+ − 279 }
+ − 280
+ − 281 $loop++;
+ − 282 }
+ − 283 }
+ − 284
+ − 285 if($salesRank == "")
+ − 286 $salesRank = "null";
+ − 287
+ − 288 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+ − 289 include "../../../private/db.php";
+ − 290
+ − 291 $title = strtr($title, '"', "'");
+ − 292 $queryInsert = "CALL b_addNewBook(\"$isbn\",\"$title\", \"$author\",\"$binding\",\"$imageURL\", $dewey, $salesRank,\"$pubDate\",\"$publisher\",$g1,$g2,$g3,$loc)";
+ − 293 //echo $queryInsert;
+ − 294
+ − 295 $resG = mysqli_query($link, $queryInsert) or exit( mysqli_error( $link ));
+ − 296 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
+ − 297
+ − 298
+ − 299 $output .= "<ISBN>" . htmlspecialchars($isbn) . "</ISBN>";
+ − 300 $output .= "<Title>" . htmlspecialchars($title) . "</Title>";
+ − 301 $output .= "<Author>" . htmlspecialchars($author) . "</Author>";
+ − 302 $output .= "<Binding>" . htmlspecialchars($binding) . "</Binding>";
+ − 303 $output .= "<Dewey>" . htmlspecialchars($dewey) . "</Dewey>";
+ − 304 $output .= "<ImageURL>" . htmlspecialchars($imageURL) . "</ImageURL>";
+ − 305 $output .= "<SalesRank>" . htmlspecialchars($salesRank) . "</SalesRank>";
+ − 306 $output .= "<PublicationDate>" . htmlspecialchars($pubDate) . "</PublicationDate>";
+ − 307 $output .= "<Publisher>" . htmlspecialchars($publisher) . "</Publisher>";
+ − 308 $output .= "<Genre1>" . htmlspecialchars($g1) . "</Genre1>";
+ − 309 $output .= "<Genre2>" . htmlspecialchars($g2) . "</Genre2>";
+ − 310 $output .= "<Genre3>" . htmlspecialchars($g3) . "</Genre3>";
+ − 311 $output .= "<ProductGroup>Book</ProductGroup>";
+ − 312 }
+ − 313
+ − 314 $output .= "</BookDetails>";
+ − 315
+ − 316 echo $output;
+ − 317 }
+ − 318 ?>
