Mercurial > hg > ywww
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 ?> |
