Update php

Leave a reply

update……
!DOCTYPE html>
<html>
<body>
<form action=”toupdate.php” method=”POST”/>
Enter Id number:<input type=”number” name=”Id” />
<br>
<input type=”submit” name=”submit” value=”Edit” />
<br/>
<?php
$con=mysql_connect(“”,”root”,””) or die(mysql_error());
mysql_select_db(“File”) or die(mysql_error());
if(isset($_POST[‘submit’])){
$Id=$_POST[‘Id’];
$Fname=$_POST[‘Fname’];
$Lname=$_POST[‘Lname’];
$query1=”UPDATE Filetbl set Fname=’$Fname’,
Lname=’$Lname’
Where Id=’$Id'”;
$result= mysql_query($query1) or die(mysql_error());
}
$query=”select * from Filetbl”;
$result= mysql_query($query) or die(mysql_error());

while($row=mysql_fetch_array($result)){

echo $row[‘Id’].’&nbsp’;

echo “”.$row[‘Fname’].’&nbsp’;

echo “”.$row[‘Lname’].’&nbsp’;
echo “</br>”;
}
mysql_close($con)
?>
</body>
</html>
<?php
$con=mysql_connect(“”,”root”,””) or die(mysql_error());
mysql_select_db(“File”) or die(mysql_error());
$Id=$_POST[‘Id’];
$query=”select * from Filetbl where Id=$Id”;
$result= mysql_query($query) or die(mysql_error());

while($row=mysql_fetch_array($result)){
echo “<form action=’update.php’ method=’Post’>”;
echo “Id<input type=’number’ name=’Id’ value=”.$row[‘Id’].”><br/>”;
echo “Fname<input type=’text’ name=’Fname’ value=”.$row[‘Fname’].”><br/>”;
echo “Lname<input type=’text’ name=’Lname’ value=”.$row[‘Lname’].”><br/>”;
}
echo “<input type=’submit’ name=’submit’ value=’Update’/>”;
echo “</form>”;
mysql_close($con)
?>