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
| <?php
function xml2mysql_attribute($fichier, $table, $tab) {
if(!$dom = domxml_open_file($fichier)) {
echo "Erreur lors de l'analyse du document\n";
return;
}
$root = $dom->document_element();
$child = $root->first_child();
// Construction de la requete :
$rqt = "INSERT INTO ".$table." (";
foreach($tab as $valeur) {
$rqt .= strtoupper($valeur).", ";
}
$rqt = substr($rqt, 0, strrpos($rqt, ", ")).") VALUES ('";
$nb_reponse = 0;
while($child) {
if ($child->node_type() != XML_TEXT_NODE) {
foreach ($tab as $valeur) {
$rqt .= mysql_real_escape_string($child->get_attribute($valeur))."', '";
}
$rqt = substr($rqt, 0, strrpos($rqt, ", '"))."), ('";
$nb_reponse++;
}
$child = $child->next_sibling();
}
return array(substr($rqt, 0, strrpos($rqt, ", ('")), $nb_reponse);
}
?> |
Partager