view php/read/getBrowseNodes.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

include "../../../../private/db_test.php";

$query = "CALL b_getBrowseNodes()";
$results = mysqli_query($link, $query) or exit( mysqli_error( $link ));

$output = "";
$output .=  "<?xml version=\"1.0\"?>";
$output .=  "<BrowseNodeKey>";

while($line = mysqli_fetch_assoc($results)) {
	
	$output .=  "<Node>";
	$output .=  "<Key>" . htmlspecialchars(trim($line["BrowseNodeID"])) . "</Key>";
	$output .=  "<Value>" . htmlspecialchars(trim($line["BrowseNodeValue"])) . "</Value>";
	$output .=  "</Node>";
}

$output .=  "</BrowseNodeKey>";

echo $output;

mysqli_close($link);


?>