pagelisting.php.............
<html>
<head>
<h3 style="text-align:center;background-color:yellow">THIS THE LISTING PAGE</h3>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php
include("home.php");
?>
</head>
<body>
<form action="" method="post" name="form1">
<br/><br/>
<a href="fillup.php"><tr><th>Contacts</th></tr></a>
<br/><br/>
<input type="text" name="searchtext"/>
<input type="submit" name="submit" Value="Search"/>
</body>
</html>
<?php
include("database.php");
$var=$_POST['searchtext'];
if(isset($_POST['submit']))
{
$sql="SELECT * FROM information WHERE fname LIKE '{$var}%'";
$q=mysql_query($sql) or die("some errror".mysql_error());
echo "<table border='1'>
<tr>
<th>SNO</th>
<th>FirstName</th>
<th>LastName</th>
<th>Address</th>
<th>Phone NO</th>
</tr>";
while ($row = mysql_fetch_array($q)) {
echo "<tr>";
echo "<td>" . $row[sno] . "</td>";
echo "<td>" . $row[fname] . "</td>";
echo "<td>" . $row[lname] . "</td>";
echo "<td>" . $row[addr] . "</td>";
echo "<td>" . $row[phone] . "</td>";
echo ("<td>"."<a href=\"update.php\?slno=$row[sno]\">UPDATE</a>"."</td>");
echo "</tr>";
}
echo "</table>";
//mysql_close($con);
}
/*if($_GET['status']=='pagelisting')
{
echo "this is main page";
}*/
?>
update.php.....................
<?php
include("database.php");
//$a=$_GET['slno'];
$sql="SELECT * FROM information WHERE sno='{$slno}'";
$q=mysql_query($sql);
while($row=mysql_fetch_array($q)){
$sno=$row['sno'];
$fname=$row['fname'];
$lname=$row['lname'];
$addr=$row['addr'];
$phone=$row['phone'];
}
mysql_free_result($q);
?>
<html>
<head><h2>edit the data...</h2></head>
<body>
<form action="update_data.php" method="post">
SNO:<br/>
<input type="text" value="<?php echo $sno; ?>" name="serno" disabled />
<br/>
FirstName:<br/>
<input type="text" value="<?php echo $fname; ?>" name="fstname" />
<br/>
LastName:<br/>
<input type="text" value="<?php echo $lname; ?>" name="lstname" />
<br/>
Address:<br/>
<input type="text" value="<?php echo $addr; ?>" name="adrs" />
<br/>
Phone No:<br/>
<input type="text" value="<?php echo $phone; ?>" name="phon" />
<br/>
<input type="submit" value="submit changes" />
</form>
</body>
</html>
update_data.php...........................
<?php
include ("database.php");
//include("home.php");
$sno=$_POST['serno']
$fn=$_POST['fstname'];
$ln=$P_OST['lstname'];
$adr=$POST['adrs'];
$pn=$POST['phon'];
$sql="UPDATE information SET fname='$fn',lname='$ln',addr='$adr',phone='$pn' WHERE sno='$sno'";
mysql_query($sql) or die("Error: "mysql_error());
echo "successful.<a href=\"pagelisting.php\"> Return </a>" ;
?>
This is my update.php code file...... here 'slno' ** is coming from another file named **pagelisting.php.Now when I click the submit button of "update.php file " after putting new data it is not goiing to the destination file named "update_data.php". Guys please help me...??
