view php/read/saveUserList.php @ 15:385ddd7c4b55 testing

use test_db.php to get mysqld_test instance
author Henry S. Thompson <ht@inf.ed.ac.uk>
date Sun, 19 Feb 2017 16:17:53 +0000
parents 077b0a0a3e6d
children
line wrap: on
line source

<?PHP

if( !empty($_POST) ){

	include "../../../../private/db_test.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";
}

?>