Importing XML Data into a Database

Now that you know how to convert database records into well-formed XML documents, let’s turn things around to look at how the process works in reverse. This section examines how data marked up with XML can be converted into SQL statements and inserted into a database.

Dynamically Constructing SQL Queries from an XML Document with SAX

Again, we’ll begin with a simple example—consider the XML document in Listing 7.10.

Listing 7.10. An XML Book List (books.xml)
<?xml version="1.0"?> 

<list> 
       <item> 
              <title>Waking Up With The Red-Eyed Bed Monster</title> 
              <author>J. I. M. Somniac</author> 
              <blurb>The blood-chillingly true story of one man's fight against the
 monsters under his bed.</blurb> </item> <item> <title>The ...

Get XML and PHP now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.