Caute, potrebujem z MySQL vygenerovat XML vystup, ale nemam s tym ziadne skusenosti. Nasiel som si hotovy script, ktory som si hodil do CMSka vlastneho, ale nefunguje to...
PHP:
Kód:
$query = "SELECT * FROM sluzby WHERE zobrazit='ano' AND zaciatok < NOW() AND koniec > NOW()";
$result = mysql_query($query);
$doc = new DomDocument('1.0');
// create root node
$root = $doc->createElement('people');
$root = $doc->appendChild($root);
while($array = mysql_fetch_assoc($result))
{
// add node for each row
$occ = $doc->createElement('person');
$occ = $root->appendChild($occ);
$child = $doc->createElement('firstname');
$child = $occ->appendChild($child);
$value = $doc->createTextNode($array['nazov']);
$value = $child->appendChild($value);
$child = $doc->createElement('surname');
$child = $occ->appendChild($child);
$value = $doc->createTextNode($array['cena']);
$value = $child->appendChild($value);
}
$xml_string = $doc->saveXML();
header('Content-Type: application/xml; charset=UTF-8');
echo $xml_string;
?>
<div id="container"></div>
<input type="submit" id="getData" name="getData" value="Get Data!" />
<?
JavaScript:
Kód:
$(document).ready(function() {
$("#getData").click(function(){
var data = "";
xml.php("thexml.xml", function(theXML){
$('person',theXML).each(function(i){
var firstname = $(this).find("firstname").text();
var surname = $(this).find("surname").text();
data = data + " " + firstname + " " + surname + "<br>";
});
$("#container").html(data);
});
});
});
thexml.xml:
Kód:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<people>
<person>
<firstname></firstname>
<surname></surname>
</person>
</people>
Problem je ten, ze do suboru xml to nic nezapise a ked dam php zobrazit ako html, tak to zobrazi vystupy z DB v jednom riadku... Mne ide vsak len o to XML.... ak by niekto vedel poradit budem vdacny...