php create xml file from mysql, Here I am giving you the very basic sample code for creating XML file through PHP and MYsql. We given code sample for this.
php create xml file from mysql
<?php // We'll be outputting a PDF header('Content-type: text/xml'); echo "" $db_name = "testDB"; $connection = mysql_connect("example.com", "username", "password") or die("Could not connect."); $table_name = 'user'; $query = "select * from " . $table_name; $result = mysql_query($query, $connection) or die("Could not complete database query"); $num = mysql_num_rows($result); while ($row = mysql_fetch_assoc($result)) { echo "". $row['firstname'].""; echo "". $row['lastname'].""; echo " ". $row['address']." "; echo "". $row['age'].""; } ?>
thanks this is very usefull.