migracion datos xml a my sql

TEMA: Migracion datos XML a MySQLObjetivo: Pasar de XML a MySQL con PHP

Pablo Galeana BaileyMéxico Distrito Federal a 04 de Enero de 2013Correo Electrónico: knoppix_yast@hotmail.com

1.- Estructura del archivo XML

LibrosXML.xml

2.- Estructura de la tabla

3.- Script PHP

4.- Pruebas

5.- Resultados

Archivo XML de ejemplo para copiar y pegar y realizar pruebas:

<libros>

<libro year="1999">

<num>3</num>

<name>ActionScript 3.0</name>

<resumen>ActionScript is a scripting libro based onECMAScript. ActionScript is used primarily for the development ofwebsites and software using the Adobe Flash Player platform (in theform of SWF files embedded into Web pages).</resumen>

<autor>Autor Uno</autor>

<decs>Describe dos</decs>

<precio>122.50</precio>

</libro>

<libro year="1995">

<num>13</num>

<name>PHP</name>

<resumen>PHP is a scripting libro originally designed forproducing dynamic web pages. It has evolved to include a commandline interface capability and can be used in standalone graphicalapplications.</resumen>

<autor>Autor 123</autor>

<decs>Describe dos dos</decs>

<precio>12.506</precio>

</libro>

<libro year="1995">

<num>23</num>

<name>Java</name>

<resumen>Java is a programming libro originally developedby James Gosling at Sun Microsystems and released in 1995 as a corecomponent of Sun Microsystems Java platform. Java applications aretypically compiled to bytecode that can run on any Java virtual machineregardless of computer architecture.</resumen>

<autor>Autor 456</autor>

<decs>Describe dos dos dos</decs>

<precio>28.10</precio>

</libro>

<libro year="2007">

<num>33</num>

<name>LOLCODE</name>

<resumen>LOLCODE is an esoteric programming libroinspired by the libro expressed in examples of the lolcat Internetmeme. The libro was created in 2007 by Adam Lindsay, researcher atthe Computing Department of Lancaster University.</resumen>

<autor>Autor 789</autor>

<decs>Describe dos dos dos dos</decs>

<precio>252.09</precio>

</libro>

<libro year="2007">

<num>666</num>

<name>Ruby</name>

<resumen>RoR home; full stack, Web applicationframework optimized for sustainable programming productivity, allowswriting sound code by favoring convention over ....</resumen>

<autor>Autor PGB 789</autor>

<decs>Describe paradigma MVC</decs>

<precio>352.019</precio>

</libro>

</libros>