[PHP] pobierz, plaintext 
 
//connect
 
 
//Start XML file
 
 if ($_POST)
{
  if (!empty($_POST['region']) && is_scalar($_POST['region']))
  {
     $region = mysql_real_escape_string($_POST['region']);
 
$query = "SELECT * FROM dane_koncowe  WHERE region= '".$region."'  AND temperature=24   ORDER BY 'dzien','czas' DESC ";
$result = mysql_query($query)or die(mysql_error());
 
 
 
// Select all the rows in the markers table
$dom = new DOMDocument("1.0");
$node = $dom->createElement("dane_koncowe");
$parnode = $dom->appendChild($node); 
 
 
// Iterate through the rows, adding XML nodes for each
 
while ($row = mysql_fetch_array($result)){  
 
  // ADD TO XML DOCUMENT NODE  
  $node = $dom->createElement("marker");  
  $newnode = $parnode->appendChild($node);   
  $newnode->setAttribute("name_pl",$row['name_pl']);
  $newnode->setAttribute("dzien", $row['dzien']); 
  $newnode->setAttribute("czas", $row['czas']);
  $newnode->setAttribute("type", $row['type']);
  $newnode->setAttribute("lat", $row['lat']);  
  $newnode->setAttribute("lng", $row['lng']);  
  $newnode->setAttribute("wind_dir", $row['wind_dir']);
  $newnode->setAttribute("wind_force", $row['wind_force']);
  $newnode->setAttribute("temperature", $row['temperature']);
  $newnode->setAttribute("pressure", $row['pressure']);
        }
    }    
}
 
echo $dom->saveXML();
 
 
[PHP] pobierz, plaintext