1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
<?php
// === CONNEXION A LA BDD ===
$isLocal=($_SERVER["SERVER_NAME"]=="localhost");
$host = "localhost";
$user = "user";
$pass = "pass";
$bdd = "bdd";
// connexion
$conn = mysql_connect($host,$user,$pass);
mysql_select_db($bdd);
$SQL = "SELECT * FROM markersfr" . " ORDER BY ID DESC";
$res = mysql_query($SQL);
if (!$res) {
die('erreur de requete: ' . mysql_error());
}
echo"test";
//echo domxml_open_doc('../locations');
$docfr = domxml_new_doc("1.0");
echo"test";
$nodefr = $docfr->create_element("markers");
echo"test";
$parnodefr = $docfr->append_child($nodefr);
echo"test";
while($val = mysql_fetch_array($res)){
$nodefr = $docfr->create_element("marker");
$newnode = $parnodefr->append_child($nodefr);
$newnode->set_attribute("name",$val["name"]);
$newnode->set_attribute("adr",$val["adr"]);
$newnode->set_attribute("desc",$val["descr"]);
if($val["pic"] != null){
$newnode->set_attribute("pic",$val["pic"]);
}else{
$newnode->set_attribute("pic","#");
}
$newnode->set_attribute("lat",$val["lat"]);
$newnode->set_attribute("lng",$val["lng"]);
}
$docfr->dump_file('../locationsfr.xml');
$xmlfilefr = $docfr->dump_mem();
echo "<br>locationsFR: <br><br>";
echo $xmlfilefr;
$SQLen = "SELECT * FROM markersen" . " ORDER BY ID DESC";
$resen = mysql_query($SQLen);
if (!$resen) {
die('erreur de requete: ' . mysql_error());
}
$docen = domxml_new_doc("1.0");
$noden = $docen->create_element("markers");
$parnoden = $docen->append_child($noden);
while($valen = mysql_fetch_array($resen)){
$noden = $docen->create_element("marker");
$newnode = $parnoden->append_child($noden);
$newnode->set_attribute("name",$valen["name"]);
$newnode->set_attribute("adr",$valen["adr"]);
$newnode->set_attribute("desc",$valen["descr"]);
if($val["pic"] != null){
$newnode->set_attribute("pic",$valen["pic"]);
}else{
$newnode->set_attribute("pic","#");
}
$newnode->set_attribute("lat",$valen["lat"]);
$newnode->set_attribute("lng",$valen["lng"]);
}
$docen->dump_file('../locationsen.xml');
$xmlfilen = $docen->dump_mem();
echo "<br>locationsEN: <br><br>";
echo $xmlfilen;
mysql_close($conn);
?> |
Partager