How can XML files be dynamically read and stored in a database using PHP?

To dynamically read and store XML files in a database using PHP, you can use the SimpleXML extension to parse the XML file and extract the data. Then, you can connect to your database using PDO or MySQLi and insert the extracted data into the database tables. 

<?php
// Load the XML file
$xml = simplexml_load_file('data.xml');

// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Iterate over the XML data and insert it into the database
foreach ($xml->children() as $child) {
    $stmt = $pdo->prepare("INSERT INTO your_table (column1, column2) VALUES (:value1, :value2)");
    $stmt->bindParam(':value1', $child->value1);
    $stmt->bindParam(':value2', $child->value2);
    $stmt->execute();
}

echo "Data inserted successfully!";
?>

Keywords

XML database PHP dynamic parsing

Related Questions