Skip to Main Content
XML and PHP
book

XML and PHP

by Vikram Vaswani
June 2002
Intermediate to advanced content levelIntermediate to advanced
384 pages
7h 53m
English
Sams
Content preview from XML and PHP

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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

PHP Development Tool Essentials

PHP Development Tool Essentials

Chad Russell
PHP Web Services

PHP Web Services

Lorna Jane Mitchell

Publisher Resources

ISBN: 0735712271Purchase book