PHP|Débutant :: Forums

$dom = new DomDocument();
$dom->preserveWhiteSpace = false;
$dom->formatOutput = true;
$dom->load("../galeries/Gallery.xml");
//$albumsnode = $dom->getElementsByTagName("albums")->item(0);
$albumstodelete = $dom->getElementsByTagName("album");
foreach($albumstodelete as $album) { $album->parentNode->removeChild($album); } // ca ne supprime que le premier <album> et je voudrais que ca les supprime tous

// on recupere toutes les infos de la table et on réécrit le fichier entierement

$db = mysql_connect($cfgHote, $cfgUser, $cfgPass) or die ("Impossible de se connecter : " . mysql_error());
mysql_select_db($cfgBase,$db);
$query = "SELECT * FROM w_albums";
$send = mysql_query($query, $db) or die('Erreur SQL !<br />'.$query.'<br />'.mysql_error());
 
while($data = mysql_fetch_array($send))
{
$nomalbum = $data['nomalbum'];
$descriptionalbum = $data['descriptionalbum'];
$lienlogo = $data['lienlogo'];
$lienphoto1 = $data['lienphoto1'];
$legende1 = $data['legende1'];

$nouvelalbum = $dom->createElement("album");
$nouvelalbum->setAttribute("icon" , $lienlogo);
$nouvelalbum->setAttribute("thumbnailsFolder" , "galeries/".$nomalbum."/pictos/");
$nouvelalbum->setAttribute("imagesFolder" , "galeries/".$nomalbum."/images/");
$nouvelalbum->setAttribute("description" , $descriptionalbum);

$photo1 = $dom->createElement("image");
$nomphoto1 = substr($lienphoto1, -5);
$photo1->setAttribute("name",$nomphoto1);
$photo1->setAttribute("description"," : ".$legende1);
$photo1->setAttribute("thumbnail",$nomphoto1);
$nouvelalbum->appendChild($photo1);

if ($data['lienphoto2']!="") {
$nomphoto2 = substr($data['lienphoto2'], -5);
$photo2 = $dom->createElement("image");
$photo2->setAttribute("name",$nomphoto2);
$photo2->setAttribute("description"," : ".$data['legende2']);
$photo2->setAttribute("thumbnail",$nomphoto2);
$nouvelalbum->appendChild($photo2);
}

$albumsnode = $dom->getElementsByTagName("albums")->item(0);
$albumsnode->appendChild($nouvelalbum);

} // fin du while
$dom->save("../galeries/Gallery.xml");
}

function writexml(){
   require "cfg_config.php";
   $dom = new DomDocument();
   $dom->load("../galeries/Gallery.xml");
   $albumsnode = $dom->getElementsByTagName('albums')->item(0);
   $albumstodelete = $dom->getElementsByTagName('album');
   // donc a partir de là la suppression ne semble pas marcher
   foreach($albumstodelete as $album) $albumsnode->removeChild($album);
   $dom->save("../galeries/Gallery.xml"); // j'ai essayé de sauver le fichier
   // puis de le rouvrir...
   $dom = new DomDocument();
   $dom->load("../galeries/Gallery.xml");
   // on recupere toutes les infos de la table et on réécrit le fichier entierement
   $db = mysql_connect($cfgHote, $cfgUser, $cfgPass) or die ("Impossible de se connecter : " . mysql_error());
   mysql_select_db($cfgBase,$db);
   $query = "SELECT * FROM w_albums";
   $send = mysql_query($query, $db) or die('Erreur SQL !<br />'.$query.'<br />'.mysql_error());
 
   while($data = mysql_fetch_array($send)){
      $nomalbum = $data['nomalbum'];
      $descriptionalbum = $data['descriptionalbum'];
      $lienlogo = $data['lienlogo'];
      $lienphoto1 = $data['lienphoto1'];
      $legende1 = $data['legende1'];
     
      $nouvelalbum = $dom->createElement("album");
      $nouvelalbum->setAttribute("icon" , $lienlogo);
      $nouvelalbum->setAttribute("thumbnailsFolder" , "galeries/".$nomalbum."/pictos/");
      $nouvelalbum->setAttribute("imagesFolder" , "galeries/".$nomalbum."/images/");
      $nouvelalbum->setAttribute("description" , $descriptionalbum);

      $photo1 = $dom->createElement("image");
      $nomphoto1 = substr($lienphoto1, -5);
      $photo1->setAttribute("name",$nomphoto1);
      $photo1->setAttribute("description"," : ".$legende1);
      $photo1->setAttribute("thumbnail",$nomphoto1);

      if ($data['lienphoto2']!="") {
          $nomphoto2 = substr($data['lienphoto2'], -5);
          $photo2 = $dom->createElement("image");
          $photo2->setAttribute("name",$nomphoto2);
          $photo2->setAttribute("description"," : ".$data['legende2']);
          $photo2->setAttribute("thumbnail",$nomphoto2);
      }

      $nouvelalbum->appendChild($photo1);
      if (isset($nomphoto2)) { $nouvelalbum->appendChild($photo2); }

      $albums = $dom->getElementsByTagName("albums")->item(0);
      $albums->appendChild($nouvelalbum);
   } // fin du while
   $dom->save('../galeries/Gallery.xml');
}