view php/read/saveUserList.php @ 51:e6976d92cfc9

refactor 503
author Charlie Root
date Thu, 06 Jun 2019 16:32:56 -0400
parents a67bf725e87b
children
line wrap: on
line source

<?PHP

if( !empty($_POST) ){

	include "db.php"; 

	//echo $_POST["xml"];
	//echo print_r($_POST);
	$xml = new SimpleXMLElement(stripslashes($_POST["xml"]));
	
	$userID = $xml->UserID;
	//echo $userID;
	
	$listName = stripslashes($xml->List->SavedListName);
	//echo $listName;
	
	for($i=0;$i<sizeof($xml->List->ListDetails->Book);$i++){	
		$isbn = $xml->List->ListDetails->Book[$i]->ISBN;
		$picURL = $xml->List->ListDetails->Book[$i]->PictureURL;
		$title = stripslashes($xml->List->ListDetails->Book[$i]->BookTitle);
	
		//echo "$isbn,$picURL,$title-";
		$add = "CALL b_insertSaveList($userID,\"$listName\",\"$isbn\",\"$picURL\",\"$title\")";  //"insert into usersave values(null,$userID,\"$listName\",'$isbn','$picURL',\"$title\",1)"; 
		echo $add;
		$run = mysqli_query($link, $add); //add the book to the list in usersave
	}
}
else
{
	echo "Empty Post";
}

?>