Mercurial > hg > ywww
view php/read/getBrowseNodes.php @ 23:d606320ec331
post-5.7-upgrade efforts to reduce dropped connections, db insertion fails
author | Charlie Root |
---|---|
date | Sun, 30 Dec 2018 07:00:09 -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); ?>