index.php
<html>
<head>
</head>
<body>
<?php
include('connect.php');
?>
<h2> Form Study </h2>
<form method="post">
Name:<input type="text" name="name"><br>
Age:<input type="text" name="age"><br>
Sex:<select name="sex">
<option>Male</option>
<option>Female</option>
</select><br>
DOB:<select name="date">
<option value="1">1</option>
<option value="26">26</option>
<option value="31">31</option>
</select>
<select name="month">
<option value="jan">Jan</option>
<option value="may">May</option>
<option value="dec">Dec</option>
</select>
<select name="year">
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
</select><br>
Hobbies:<input type="checkbox" name="hobbies[]" value="reading">Reading<br>
<input type="checkbox" name="hobbies[]" value="talking">Talking<br>
<input type="checkbox" name="hobbies[]" value="eating">Eating<br>
<input type="checkbox" name="hobbies[]" value="singing">Singing<br>
Bike:<input type="radio" name="bike" value="yes">Yes<br>
<input type="radio" name="bike" value="no">No<br>
<input type="submit" name="sub" value="save">
</form>
<?php
if(isset($_POST['sub']))
{
$nname=$_POST['name'];
$nage=$_POST['age'];
$nsex=$_POST['sex'];
$ndate=$_POST['date'];
$nmonth=$_POST['month'];
$nyear=$_POST['year'];
$nhobbies=$_POST['hobbies'];
$nselected_hobbies= "";
foreach($nhobbies as $nhobbie)
{
$nselected_hobbies .= $nhobbie . ", ";
}
$nselected_hobbies = substr($nselected_hobbies, 0, -3);
$nbike=$_POST['bike'];
echo $nbike;
echo "insert into form values('','$nname','$nage','$nsex','$ndate','$nmonth','$nyear','$nselected_hobbies','$nbike')";
$sql = mysql_query("insert into form values('','$nname','$nage','$nsex','$ndate','$nmonth','$nyear','$nselected_hobbies','$nbike')");
}
?>
</body>
</html>
_______________________________________________________________________________
connect.php
<?php
$con=mysql_connect('localhost','root','');
mysql_select_db('formstudy',$con);
?>
________________________________________________________________________________
fetch.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']))
{
$fid=$_POST['id'];
$fname=$_POST['name'];
$sql=mysql_query("SELECT * FROM form WHERE id='$fid' or 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>
____________________________________________________________________________
<html>
<head>
</head>
<body>
<?php
include('connect.php');
?>
<h2> Form Study </h2>
<form method="post">
Name:<input type="text" name="name"><br>
Age:<input type="text" name="age"><br>
Sex:<select name="sex">
<option>Male</option>
<option>Female</option>
</select><br>
DOB:<select name="date">
<option value="1">1</option>
<option value="26">26</option>
<option value="31">31</option>
</select>
<select name="month">
<option value="jan">Jan</option>
<option value="may">May</option>
<option value="dec">Dec</option>
</select>
<select name="year">
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
</select><br>
Hobbies:<input type="checkbox" name="hobbies[]" value="reading">Reading<br>
<input type="checkbox" name="hobbies[]" value="talking">Talking<br>
<input type="checkbox" name="hobbies[]" value="eating">Eating<br>
<input type="checkbox" name="hobbies[]" value="singing">Singing<br>
Bike:<input type="radio" name="bike" value="yes">Yes<br>
<input type="radio" name="bike" value="no">No<br>
<input type="submit" name="sub" value="save">
</form>
<?php
if(isset($_POST['sub']))
{
$nname=$_POST['name'];
$nage=$_POST['age'];
$nsex=$_POST['sex'];
$ndate=$_POST['date'];
$nmonth=$_POST['month'];
$nyear=$_POST['year'];
$nhobbies=$_POST['hobbies'];
$nselected_hobbies= "";
foreach($nhobbies as $nhobbie)
{
$nselected_hobbies .= $nhobbie . ", ";
}
$nselected_hobbies = substr($nselected_hobbies, 0, -3);
$nbike=$_POST['bike'];
echo $nbike;
echo "insert into form values('','$nname','$nage','$nsex','$ndate','$nmonth','$nyear','$nselected_hobbies','$nbike')";
$sql = mysql_query("insert into form values('','$nname','$nage','$nsex','$ndate','$nmonth','$nyear','$nselected_hobbies','$nbike')");
}
?>
</body>
</html>
_______________________________________________________________________________
connect.php
<?php
$con=mysql_connect('localhost','root','');
mysql_select_db('formstudy',$con);
?>
________________________________________________________________________________
fetch.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']))
{
$fid=$_POST['id'];
$fname=$_POST['name'];
$sql=mysql_query("SELECT * FROM form WHERE id='$fid' or 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