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
| $serveur = mysql_connect("localhost","root","");
if (!$serveur)
{
die('Non connecté : ' . mysql_error());
}
$db = mysql_select_db("MyPMEAssistant", $serveur);
if (!$db)
{
die ('Impossible d\'utiliser la base : ' . mysql_error());
}
$query = "select * from `contact`";
$result = mysql_query($query) or die("Impossible d'interroger la base de données");
$num = mysql_num_rows($result);
$nb = mysql_num_fields($result);
if ($num != 0) {
$file= fopen("contact.xml", "w");
$_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";
$_xml .="<root>\r\n";
while ($row = mysql_fetch_array($result)) {
$_xml .="\t<contact>\r\n";
for ( $i=0; $i<$nb; $i++ ){
$nomchamp = mysql_field_name($result, $i);
$_xml .="\t\t<".$nomchamp.">" . $row[$i] . "</".$nomchamp.">\r\n";
}
$_xml .="\t</contact>\r\n";
}
$_xml .="</root>";
fwrite($file, $_xml);
fclose($file);
}
$query = "select * from `contact`";
$result = mysql_query($query) or die("Impossible d'interroger la base de données");
$num = mysql_num_rows($result);
$nb = mysql_num_fields($result);
if ($num != 0) {
$file= fopen("contactchamp.txt", "w");
$nom ="nb=".$nb;
for ( $i=0; $i<$nb; $i++ ){
$nomchamp = mysql_field_name($result, $i);
$nom .="&varia".$i."=".$nomchamp;
}
fwrite($file, $nom);
fclose($file);
}
echo "ok"; |
Partager