How do I convert a csv file to xml in php?

[saywhatyousee]

I have a csv file which contains this data:

 

person1,person2,person3

first,john,steve,mike

last,doe,whinney,speirs

 

I want to create an xml file which looks like this:

 

<root>

    <person1>

        <first>

            john

        </first>

        <last>

           doe

        </last>

    </person1>

    <person2>

        <first>

            steve

        </first>

        <last>

           whinney

        </last>

    </person2>

    <person3>

        <first>

            mike

        </first>

        <last>

           speirs

        </last>

    </person3>

</root>

 

Thanks

[mac_gyver]

what have you tried? can you even read the csv file and access the data for each row? have you tried to even create the output file? exactly where are you stuck at in doing this?

[Irate]

If you have created the output file, I suggest you use fopen, fgetcsv, feof and fputs or fwrite.

[Barand]

I'd also recommend a better structure for your XML

<root>
    <person seq="1">
        <first>
            john
        </first>
        <last>
           doe
        </last>
    </person>

    etc
</root>