PHP - MySQL - XML tutorial - basics

Draft

Introduction

XML is often used to transport data between applications. In this tutorial (once it's fully done) we shall see how to:

• Store simple XML data (e.g. tabular data) in MySQL
• Query a database with SQL, get the result in XML and render in HTML

Remark: We don't plan to write a tutorial on how to store complex XML data in an SQL database, because it's a too difficult subject for educational technology or computer application students. We rather suggest to an XML database for that.

Rendering a database query with XSLT

Retrieving data as XML

Since SQL query results