diff php/read/getAllSavedBooks.php @ 23:d606320ec331

post-5.7-upgrade efforts to reduce dropped connections, db insertion fails
author Charlie Root
date Sun, 30 Dec 2018 07:00:09 -0500
parents 077b0a0a3e6d
children a67bf725e87b
line wrap: on
line diff
--- a/php/read/getAllSavedBooks.php	Sun Dec 30 06:59:13 2018 -0500
+++ b/php/read/getAllSavedBooks.php	Sun Dec 30 07:00:09 2018 -0500
@@ -32,6 +32,7 @@
 
 $prevListName = "";
 
+if ($results) {
 while($line = mysqli_fetch_assoc($results)) {
 
 	$listName = htmlspecialchars(trim($line["SavedListName"]));
@@ -58,12 +59,14 @@
 		
 	$savedBooks++;
 }
-	
-	if($savedBooks != 0)
-	{
-		$output .=  "</ListDetails>";
-		$output .=  "</List>";
-	}
+ $results->free();
+ }
+mysqli_close($link);	
+if($savedBooks != 0)
+  {
+    $output .=  "</ListDetails>";
+    $output .=  "</List>";
+  }
 $output .=  "</results>";
 
 if(isset($ret))
@@ -71,7 +74,7 @@
 else
 	echo $output;
 
-mysqli_close($link);
+
 
 
 ?>
\ No newline at end of file