PHP - MySQL - XML tutorial - basics: Difference between revisions
Jump to navigation
Jump to search
m (Created page with '{{Stub}} == 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 (…') |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Stub}} | {{Stub}} | ||
== Introduction == | == Introduction == | ||
[[XML]] is often used to transport data between applications. In this tutorial (once it's fully done) we shall see how to: | [[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 | * Store simple XML data (e.g. tabular data) in MySQL | ||
* Query a database with SQL, get the result in XML and render in HTML | * 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 == | == Rendering a database query with XSLT == | ||
=== Retrieving data as XML === | |||
Since SQL query results | |||
[[Category: XML]] | [[Category: XML]] | ||
| Line 13: | Line 21: | ||
[[Category: databases]] | [[Category: databases]] | ||
[[Category: Web technology tutorials]] | [[Category: Web technology tutorials]] | ||
[[Category: AMP]] | |||
Revision as of 19:13, 7 February 2010
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