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

PHP Login Page with MD5 possword

This post for PHP beginners Login Page Example. I want to explain creating database, posting form values, storing the session value and destroy the session. It's is very useful and simple.

 DATABASE

CREATE TABLE admin
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(40) UNIQUE,
password VARCHAR(40)
); 

CODE



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");
?>
 
 Login.php

<?php
include("config.php");
if(isset($_POST['submit']))
{
session_start();
$name = $_POST["username"];
$password = $_POST["psw"];
$password = md5($password);
$sql = "select * from login where username ='".$name."' and  password ='".$password."' ";
$result=mysql_query($sql);
$count = mysql_num_rows($result);
if($count==1)
{   
     while($row=mysql_fetch_row($result))
    {   
                   $_SESSION['username'] = $_POST['username'];
            header("Location: user.php");
       }
}
else
{
    header("Location: login.php");
}
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<script type="text/javascript">
function change(){
   
    var uname = document.getElementById("username").value;
    var psw = document.getElementById("psw").value;
    //alert(uname);
    if(uname == "")
    {   
        document.getElementById('u').innerHTML = 'Plese Enter User name';
    }
    else
    {
        document.getElementById('u').innerHTML = '';
    }
}
function changep(){
       var psw = document.getElementById("psw").value;
    if(psw == "")
    {
        document.getElementById('p').innerHTML = 'Plese Enter Password';
    }
    else
    {
        document.getElementById('p').innerHTML = '';
    }
}
</script>
</head>
<body><center>
<form action="" method="post">
<table width="503" height="117" border="0">
  <tr>
    <td width="117">User Name</td>
    <td width="160"><input type="text" id="username" name="username" onblur="change()"/></td>
    <td width="260"><label id="u"> </label></td>
  </tr>
  <tr>
    <td>Password</td>
    <td><input type="password" name="psw" id="psw" onblur="changep()" /></td>
    <td width="260"><label id="p"> </label></td>
  </tr>
   <tr>
    <td><input type="reset"  /></td>
    <td><input type="submit" value="submit" id="submit"  name="submit"/></td>
  </tr>
</table>
</form>
</center>
</body>
</html>

user.php

<body>

<h1>Welcome </h1>
</body>

Read More