Mercurial > hg > ywww

view php/read/getBrowseNodes.php @ 43:dbc006408d2b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
ASSUMES we have SetEnv PHP_VALUE "include_path =.:/var/test/private:/var/test/ywww:/usr/share/php" in apache2/.../test.conf use dl(...) for debug logging, defined in dlog.php use doAmazonRequest in amazonBookSearch use ../private/web.php (q.v., not in mercurial) for Aserver and Aassociates Started by updating from 40:c24ae74bf6d5, i.e. just before the bug on the main line
author Charlie Root
date Sat, 05 Jan 2019 18:00:10 -0500
parents 077b0a0a3e6d
children 385ddd7c4b55 a67bf725e87b
line wrap: on
line source

<?PHP

include "../../../private/db.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);


?>