Friday, 15 November 2013

Coding to fetch data from database in php

<html>
<body>

<form method="post">
Enter id<input type="text" name="id"><br>
Enter name<input type="text" name="name">
<input type="submit" name="sub">
</form>
<?php
include('connect.php');
?>
<?php
if(isset($_POST['sub']))

$fname=$_POST['name'];
$sql=mysql_query("SELECT * FROM form WHERE name='$fname' ");
$row=mysql_fetch_array($sql);

$myname=$row['name'];
$myage=$row['age'];
$mysex=$row['sex'];
$mydate=$row['date'];
$mymonth=$row['month'];
$myyear=$row['year'];
$myhobbies=$row['hobbies'];
$mybike=$row['bike'];

echo $myname;
echo "<br>";
echo $myage;
echo "<br>";
echo  $mysex;
echo "<br>";
echo $mydate;
echo "<br>";
echo $mymonth;
echo "<br>";
echo $myyear;
echo "<br>";
echo $myhobbies;


}
?>

</body>
</html>


_________________________________________________________________________________

No comments:

Post a Comment