XML to MySQL with php

Question

I have a field in my xml like this :

<radar snb="09H0000" ver="1023" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="icomsData.xsd">

How can get the variable "xsi:noNamespaceSchemaLocation"

My code to get "snb" and "ver" works fine but not for the 2 others :/

My code :

    $fichier = 'test.xml'; 

    $radar = simplexml_load_file($fichier);

    echo '</br> Radar : 
        </br> snb : <strong>'.$radar['snb'].' </strong>ver : <strong>'.$radar['ver'].'</strong> xmlns:xsi : <strong>'.$radar['xmlns:xsi'].' </strong> xsi:noNamespaceSchemaLocation : <strong>'.$radar['xsi:noNamespaceSchemaLocation'].'</strong>';

I tried with " and ' it doesn't change anything.

which variable from xml do you want to use ?

Pouya Darabi
– Pouya Darabi

2014-09-22 12:14:50 +00:00
Commented Sep 22, 2014 at 12:14 — Pouya Darabi
– Pouya Darabi, Commented Sep 22, 2014 at 12:14
All the variables even if they are useless.

Booba__2012
– Booba__2012

2014-09-22 12:18:04 +00:00
Commented Sep 22, 2014 at 12:18 — Booba__2012
– Booba__2012, Commented Sep 22, 2014 at 12:18

Pouya Darabi · Accepted Answer · 2014-09-22 16:21:49Z

you can use this code to access variables in xml file :

<?php

$xmlFile = 'test.xml';
$xml = simplexml_load_file($xmlFile);
$radarAttr = $xml->attributes();
$noNamespaceSchemaLocation = $xml->attributes('xsi', true)->noNamespaceSchemaLocation->__tostring();
$radarSnb  = $radarAttr['snb']->__tostring();
$radarVer  = $radarAttr['ver']->__tostring();

foreach($xml->log as $log) {
    $LogAttrs = $log->attributes();
    $logTs = $LogAttrs['ts']->__tostring();
    $logVb = $LogAttrs['vb']->__tostring();

    $site = $log->site->__tostring();

    $evArray = $log->ev;
    foreach($evArray as $ev) {
        $EvAttrs = $ev->attributes();
        $evTs = $EvAttrs['ts']->__tostring();

        $evData = $ev->children();

        $ev_sp = $evData->sp->__tostring();
        $ev_lg = $evData->lg->__tostring();
        $ev_dir = $evData->dir->__tostring();
    }


}

Awesome mate, you did almost all the job for me ^^ Thank you very much.

MaxiWheat · Accepted Answer · 2014-09-22 12:54:15Z

0

For this solution you would need to take these step as follows

First write a script that convert all xml files to CSV format.
Make a script that upload CSV file to DB.

edited Sep 22, 2014 at 12:54

MaxiWheat

6,2497 gold badges53 silver badges77 bronze badges

answered Sep 22, 2014 at 11:56

Ranjeet Singh

6925 silver badges13 bronze badges

1 Comment

Booba__2012 Over a year ago

I would have see more like : The script reads the "xml" then I do directly the INSERT query when I finished to read.

Collectives™ on Stack Overflow

XML to MySQL with php

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related