Guest User

Untitled

a guest
May 21st, 2012
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.53 KB | None | 0 0
  1. public function getBusiness ($item)
  2.  
  3.     {
  4.         $row = "";
  5.        
  6.         $result = mysqli_query($this->connection, "SELECT * FROM businesses");
  7.        
  8.         echo "<?xml version=\"1.0\" ?><map>";
  9.        
  10.         while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
  11.         {
  12.             echo "<business><businessid>" . $row["businessid"] . "</businessid>";
  13.             echo "<type>" . $row["type"] . "</type>";
  14.             echo "<name>" . $row["name"] . "</name>";
  15.             echo "<street>" . $row["street"] . "</street>";
  16.             echo "<city>" . $row["city"] . "</city>";
  17.             echo "<country>" . $row["country"] . "</country>";
  18.             echo "<postcode>" . $row["postcode"] . "</postcode>";
  19.             echo "<latitude>" . $row["latitude"] . "</latitude>";
  20.             echo "<longitude>" . $row["longitude"] . "</longitude>";
  21.             echo "<phonenumber>" . $row["phonenumber"] . "</phonenumber>";
  22.             echo "<email>" . $row["email"] . "</email>";
  23.             echo "<website>" . $row["website"] . "</website>";
  24.             echo "<facebookid>" . $row["facebookid"] . "</facebookid>";
  25.             echo "<twitterid>" . $row["twitterid"] . "</twitterid>";
  26.             echo "<youtubeid>" . $row["youtubeid"] . "</youtubeid>";
  27.             echo "<flickrid>" . $row["flickrid"] . "</flickrid>";
  28.             echo "<description>" . $row["description"] . "</description>";
  29.             echo "<likes>" . $row["likes"] . "</likes>";
  30.             echo "<datesubmitted>" . $row["datesubmitted"] . "</datesubmitted></business>";
  31.         }
  32.         echo "</map>";
  33.      
  34.  
  35.     }
Advertisement
Add Comment
Please, Sign In to add comment