comparison php/read/getBrowseNodes.php @ 6:077b0a0a3e6d

remaining originals according to dependency walk
author Robert Boland <robert@markup.co.uk>
date Thu, 16 Feb 2017 22:29:02 +0000
parents
children 385ddd7c4b55 a67bf725e87b
comparison
equal deleted inserted replaced
5:55445b456ad0 6:077b0a0a3e6d
1 <?PHP
2
3 include "../../../private/db.php";
4
5 $query = "CALL b_getBrowseNodes()";
6 $results = mysqli_query($link, $query) or exit( mysqli_error( $link ));
7
8 $output = "";
9 $output .= "<?xml version=\"1.0\"?>";
10 $output .= "<BrowseNodeKey>";
11
12 while($line = mysqli_fetch_assoc($results)) {
13
14 $output .= "<Node>";
15 $output .= "<Key>" . htmlspecialchars(trim($line["BrowseNodeID"])) . "</Key>";
16 $output .= "<Value>" . htmlspecialchars(trim($line["BrowseNodeValue"])) . "</Value>";
17 $output .= "</Node>";
18 }
19
20 $output .= "</BrowseNodeKey>";
21
22 echo $output;
23
24 mysqli_close($link);
25
26
27 ?>