Import xml data into mysql database

Question

i need to import this xml data into mysql database.. i dont have clear idea about it.

this is my .xml file

<employee>
        <row>
            <field name="employee_name">Syed</field>
            <field name="employee_code">101</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">7412347798</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">21</field>
        </row>
        <row>
            <field name="employee_name">Hari</field>
            <field name="employee_code">102</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">9895852525</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">23</field>
        </row>
        <row>
            <field name="employee_name">Raja</field>
            <field name="employee_code">103</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">9956853458</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">23</field>
        </row>
        <row>
            <field name="employee_name">imran</field>
            <field name="employee_code">104</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">9836052525</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">21</field>
        </row>
        <row>
            <field name="employee_name">Sam</field>
            <field name="employee_code">105</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">8625852525</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">21</field>
        </row>
        <row>
            <field name="employee_name">vinod</field>
            <field name="employee_code">106</field>
            <field name="employee_email">[email protected]</field>
            <field name="employee_designation">Trainee</field>
            <field name="employee_number">7225852525</field>
            <field name="employee_salary">6000</field>
            <field name="employee_age">24</field>
        </row>
    </employee>

my routine for this function is,

 if ($file) {
                $handle = simplexml_load_file($file);                           //  Open the file and read
                while($strBookData = fgets($handle, 4096)) {        //  To get Array 
                    $strDatas[] = $strBookData;
                    $strTableColumn = count($strBookData);              // To Get Column count
                }

i dont know what to do further.. can any one give me suggestions?? thanks in advance :)

petritz · Accepted Answer · 2014-08-22 14:26:58Z

1

You simply have to get all rows as an array. Just do it in a loop. And then update the table. Like so:

while($row = $this->nextRow()) {
    mysql_query("INSERT INTO table (name, code) VALUES ($row['name']), $row['code']");
}

answered Aug 22, 2014 at 14:26

petritz

1821 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alkis Kalogeris Over a year ago

Never use mysql_query. Use mysqli_query or PDO instead.

petritz Over a year ago

For beginners I would suggest mysql_query its a lot easier. But you are right more object-orientated would be mysqli_query or PDO

Collectives™ on Stack Overflow

Import xml data into mysql database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related