Create Mysqldata to xml using php

Hi friends, I have code for how to create a xmll file with mysql data using php code.

Follow the below steps to retrieve the data from database to xmlfile

Config.php

<?php

$host="localhost"; // Host name

$username=""; // Mysql username

$password=""; // Mysql password

$db_name="test"; // Database name

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

?>

Xmlcreate.php

<?php

                include("config.php");

                $query = "SELECT * FROM product";

                $result = mysql_query($query);

                $file= fopen("results.xml", "w");

                $_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";

                $_xml .= "<table>\n";

                while ($row = mysql_fetch_array($result)) {

                if ($row[1]) {

                $_xml .="\t<id title=\"".$row[0]."\">";

                $_xml .="\t<name>".$row[1]."</name>";

                $_xml .="\t<q>".$row[2]."</q>";

                $_xml .="\t<price>".$row[3]."</price>";

                $_xml .="\t</id>\n";

                } else {

                $_xml .="\t<id title=\"Nothing Returned\">";

                $_xml .="\t<file>none</file>";

                $_xml .="\t</id>";

                } }

                $_xml .="</table>";

                fwrite($file, $_xml);

                fclose($file);

echo "XML has been written.<a href=\"result.php\">View the XML.</a>";

?>

Result.php

<?php

        include("config.php");

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

                echo $xml->asXML();

?>

Read More

How To Create excel file with Mysql Data using php Code.

Hi friends, I have code for how to create a excel file with mysql data using php code.

Follow the below steps to retrieve the data from database

Config.php

<?php

$host="localhost"; // Host name

$username=""; // Mysql username

$password=""; // Mysql password

$db_name="test"; // Database name

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

?>

a.php

<?php

          include("config.php");

          $filename = "excelwork.xls";

          $exists = file_exists('excelwork.xls');

          if($exists)

          {

                   unlink($filename);

          }

                   $filename = "excelwork.xls";

                   $fp = fopen($filename, "wb");

                   $sql = "select * from product";

                   $result = mysql_query($sql);

                   $schema_insert = "";

                   $schema_insert_rows = "";

                   for ($i = 1; $i < mysql_num_fields($result); $i++)

                   {

                   $insert_rows .= mysql_field_name($result,$i) . "\t";

                   }

                   $insert_rows.="\n";

                   fwrite($fp, $insert_rows);

                   while($row = mysql_fetch_row($result))

                   {

$insert = $row[1]. "\t" .$row[2]. "\t".$row[3]. "\t".$row[4]. "\t".$row[5];

                   $insert .= "\n";               //       serialize($assoc)

                   fwrite($fp, $insert);

                   }

                   if (!is_resource($fp))

                   {

                             echo "cannot open excel file";

                   }

                   echo "success full export";

                   fclose($fp);

?>

This is the steps to create excel file with mysql data using php code.

Once u run a.php it create excelwork file.

Read More