Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getBusiness ($item)
- {
- $row = "";
- $result = mysqli_query($this->connection, "SELECT * FROM businesses");
- echo "<?xml version=\"1.0\" ?><map>";
- while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
- {
- echo "<business><businessid>" . $row["businessid"] . "</businessid>";
- echo "<type>" . $row["type"] . "</type>";
- echo "<name>" . $row["name"] . "</name>";
- echo "<street>" . $row["street"] . "</street>";
- echo "<city>" . $row["city"] . "</city>";
- echo "<country>" . $row["country"] . "</country>";
- echo "<postcode>" . $row["postcode"] . "</postcode>";
- echo "<latitude>" . $row["latitude"] . "</latitude>";
- echo "<longitude>" . $row["longitude"] . "</longitude>";
- echo "<phonenumber>" . $row["phonenumber"] . "</phonenumber>";
- echo "<email>" . $row["email"] . "</email>";
- echo "<website>" . $row["website"] . "</website>";
- echo "<facebookid>" . $row["facebookid"] . "</facebookid>";
- echo "<twitterid>" . $row["twitterid"] . "</twitterid>";
- echo "<youtubeid>" . $row["youtubeid"] . "</youtubeid>";
- echo "<flickrid>" . $row["flickrid"] . "</flickrid>";
- echo "<description>" . $row["description"] . "</description>";
- echo "<likes>" . $row["likes"] . "</likes>";
- echo "<datesubmitted>" . $row["datesubmitted"] . "</datesubmitted></business>";
- }
- echo "</map>";
- }
Advertisement
Add Comment
Please, Sign In to add comment