XML Integration in PHP

What is XML?

XML (eXtensible Markup Language) is a markup language used to store and transport data in a structured and readable format.

Exam Definition: XML is a self-descriptive language used for data storage and exchange.

Features of XML

• Platform independent
• Human and machine readable
• Supports hierarchical data
• Used in web services

XML vs HTML (Exam Comparison)

---

Creating an XML File from PHP with Database Records

Steps

1. Connect to database
2. Fetch records
3. Create XML structure
4. Save XML file

Example: Create XML from Database

$conn = mysqli_connect("localhost","root","","testdb");
$result = mysqli_query($conn,"SELECT * FROM users");

$xml = new SimpleXMLElement("<users/>");

while($row = mysqli_fetch_assoc($result)){
   $user = $xml->addChild("user");
   $user->addChild("id",$row['id']);
   $user->addChild("name",$row['name']);
   $user->addChild("email",$row['email']);
}

$xml->asXML("users.xml");

Exam Line: SimpleXMLElement is used to create XML in PHP.

---

Reading Information from XML File

Using simplexml_load_file()

$xml = simplexml_load_file("users.xml");

foreach($xml->user as $u){
   echo $u->name."<br>";
}

Using simplexml_load_string()

$data = file_get_contents("users.xml");
$xml = simplexml_load_string($data);

---

Advantages of XML Integration

• Easy data sharing
• Platform independent
• Structured format
• Used in APIs and web services

Web Services vs XML (Exam View)