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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial