connect_error) { die("Connection failed: " . $conn->connect_error); } // Choose a table to export $table = "students"; // Change this to any table in your 'school' DB // Fetch data from the table $sql = "SELECT * FROM $table"; $result = $conn->query($sql); // Check if records exist if ($result && $result->num_rows > 0) { // Create DOMDocument $dom = new DOMDocument('1.0', 'UTF-8'); $dom->formatOutput = true; // Root node (e.g., ) $root = $dom->createElement($table); $dom->appendChild($root); while ($row = $result->fetch_assoc()) { // Each row becomes an $record = $dom->createElement("record"); foreach ($row as $column => $value) { $element = $dom->createElement($column, htmlspecialchars($value)); $record->appendChild($element); } $root->appendChild($record); } // Save to file $filename = $table . ".xml"; $dom->save($filename); // Also display in browser header("Content-Type: text/xml"); echo $dom->saveXML(); } else { echo "No records found in table '$table'."; } $conn->close(); ?>