jan_flanders

Untitled

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