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
|
connection = new Connection("root","","localhost");
$connection->connect();
#gestion des caractères accentués
$pasbon = array("é","è","ê","ë","â","ä","à","Â","Ä","î","ï","Ï","Î","ô","ö","Ô","Ö","û","ü","Û","Ü","ç");
$normal = array("é","è","ê","ë","â","ä","à","Â","Ä","î","ï","Ï","Î","ô","ö","Ô","Ö","û","ü","Û","Ü","ç");
#consultation d'une "fiche" de la base
$result =
mysql_query ("SELECT nomcanton,nomcommune,objet,coutprevu,coutreel,datedemande,subvention,coutaide,datesubvention,commentaire FROM projet WHERE Idfile='$Idfile';",$connection->getConnectionId()) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$num = mysql_num_rows($result);
if ($num !=0){
$doc = domxml_new_doc("1.0");
$root = $doc->create_element("FICHE");
$root = $doc->append_child($root);
while($ligne = mysql_fetch_array($result)){
$record = $doc->create_element("PROJETS");
$record = $root->append_child($record);
for ($j=0;$j<$num;$j++){
$projet = $doc->create_element("PROJET");
$projet = $record->append_child($projet);
for ($i=0;$i<mysql_num_fields($result);$i++){
$nom_col=mysql_field_name($result,$i);
$field = $doc->create_element($nom_col);
$field = $projet->append_child($field);
$champ=mysql_result($result,$j,$i);
#détection saut de ligne
$champ=str_replace("\n","<br />",$champ);
$champ=str_replace($pasbon,$normal,$champ);
$text = $doc->create_text_node(utf8_encode($champ));
$text=$field->append_child($text);
}
}
}
$xsl_file = "C:\Program Files\EasyPHP1-8\www\essai\stylesheets\fiche.xsl";
$xml_file= "C:\Program Files\EasyPHP1-8\www\essai\fichierXML\fiche.xml" ;
$doc->dump_file($xml_file,false,true);
$filename = "$xsl_file";
$xmldoc = domxml_open_file("C:\Program Files\EasyPHP1-8\www\essai\fichierXML\fiche.xml");
$xsldoc = domxml_xslt_stylesheet_file($filename);
$result = $xsldoc->process($xmldoc);
$xsldoc->result_dump_file($result,"C:\Program Files\EasyPHP1-8\www\essai\fichierXML\fiche.xml");
}
if(!$dom = domxml_open_file("C:\Program Files\EasyPHP1-8\www\essai\fichierXML\fiche.xml")){
echo "Erreur lors de l'analyse du document\n";
exit;
}
$int= readfile ("C:\Program Files\EasyPHP1-8\www\essai\fichierXML\fiche.xml", "r");
#déconnexion de la base
$connection->disconnect(); |
Partager