Mercurial > hg > ywww

comparison xml/getAmazonInfo.php @ 46:b7376319d25a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
centralise db query even more
author Charlie Root
date Sun, 06 Jan 2019 12:15:42 -0500
parents 38d209611508
children da133c130c1d
comparison
equal deleted inserted replaced
45:8bc395c87c6f 46:b7376319d25a
249 //HST added 249 //HST added
250 break; 250 break;
251 } 251 }
252 $queryG = "CALL b_addBrowseNode($key,\"$value\")"; //add the name value pair for genre to new table 252 $queryG = "CALL b_addBrowseNode($key,\"$value\")"; //add the name value pair for genre to new table
253 //echo $queryG; 253 //echo $queryG;
254 include "../../private/db.php"; 254 include "private/db.php";
255 $resG = mysqli_query($link, $queryG); 255 $resG = my_query($queryG,'gai0');
256 mysqli_close($link); 256 mysqli_close($link);
257 257
258 switch ($loop) { 258 switch ($loop) {
259 case 1: 259 case 1:
260 $g1 = $key; 260 $g1 = $key;
309 if (strlen($review3)>500) { $review3=rtrim(substr($review3,0,500),"\\");} 309 if (strlen($review3)>500) { $review3=rtrim(substr($review3,0,500),"\\");}
310 310
311 $queryInsert = "CALL b_addNewBook(\"$searchparameterdata\",$title, $author,\"$binding\",\"$imageURL\", $dewey, $salesRank,$pubDate,$publisher,$g1,$g2,$g3,$loc)"; 311 $queryInsert = "CALL b_addNewBook(\"$searchparameterdata\",$title, $author,\"$binding\",\"$imageURL\", $dewey, $salesRank,$pubDate,$publisher,$g1,$g2,$g3,$loc)";
312 //echo $queryInsert; 312 //echo $queryInsert;
313 313
314 $res = mysqli_query($link, $queryInsert); 314 $res = my_query($queryInsert,'gai1');
315 if (!$res) {
316 $err=mysqli_error( $link );
317 mysqli_close($link);
318 dl("anb failed: $queryInsert\n$err\n");
319 exit($err);
320 }
321 $queryInsertReviews = "CALL b_insertReviews(\"$searchparameterdata\",\"$review1\",\"$review2\",\"$review3\")"; 315 $queryInsertReviews = "CALL b_insertReviews(\"$searchparameterdata\",\"$review1\",\"$review2\",\"$review3\")";
322 if($review1 != "") { 316 if($review1 != "") {
323 $res = mysqli_query($link, $queryInsertReviews); 317 $res = my_query($queryInsertReviews,'gai2');
324 if (!$res) {
325 $err=mysqli_error( $link );
326 mysqli_close($link);
327 dl("anr failed: $queryInsertReviews\n");
328 exit($err);
329 }
330 } 318 }
331 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop 319 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
332 } 320 }
333 321
334 echo $output; 322 echo $output;
343 global $output; 331 global $output;
344 //look up info from db 332 //look up info from db
345 include "../../private/db.php"; 333 include "../../private/db.php";
346 $query = "CALL b_getBookInfo('$searchparameterdata', $loc)"; 334 $query = "CALL b_getBookInfo('$searchparameterdata', $loc)";
347 //echo $query; 335 //echo $query;
348 $res = mysqli_query($link, $query) or exit( mysqli_error( $link )); 336 $res = my_query($query,'gai3');
349 337
350 $output = ""; 338 $output = "";
351 $output .= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"; 339 $output .= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
352 $output .= "<Details>"; 340 $output .= "<Details>";
353 if ( mysqli_num_rows( $res ) > 0 ) 341 if ( mysqli_num_rows( $res ) > 0 )