This is default featured post 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Showing posts with label php. Show all posts
Showing posts with label php. Show all posts

Tuesday, 24 July 2012

Create Mysqldata to xml using php

04:14  nilesh  1 comment


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

Saturday, 21 July 2012

PHP Login Page with MD5 possword

03:32  nilesh  90 comments

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
Twitter Delicious Facebook Digg Stumbleupon Favorites More