Viewing file:  editData.php (1.5 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<input type="hidden" name="ID" value="<? echo "$ID" ?>">
<html><head><title></title></head>
<body>
<?php
$con = mysql_connect("localhost","rb!bsa838mau","baserain_db838");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("baserain_dba838", $con);
if (isset($_GET["abc"]))
{
$ID=$_POST['licencenr'];
$Name = $_POST['first'];
$Telephone = $_POST['mobile'];
$Birthday = $_POST['birth'];
//Update database
$sql="UPDATE addmember
SET name='$Name', pan='$Telephone', occupation='$Birthday'
WHERE ID = $ID";
$result = mysql_db_query($db, $sql, $con);
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else {
echo "Updated successfully!";
}
//trying to mk the data appear into my textbox
//mysql_close($con);
}
?>
<?php
$query = mysql_query ("SELECT * from members WHERE ID = $ID");
?>
<table width="300" cellpadding="3" cellspacing="0" border="2">
<tr align="center" valign="top">
<td colspan="1" rowspan="1" align="center">
<form method="get">
<p>
<input type="hidden" name="ID" value="<? echo $ID; ?>">
<p><label>Name: </label>
<? echo "<input type=\"text\" name=\"Name\" value=\"$Name\">"; ?>
</p>
<p><label>Telephone: </label>
<? echo "<input type=\"text\" name=\"Telephone\" value=\"$Telephone\">"; ?>
</p>
<label>Birthday: </label>
<? echo "<input type=\"text\" name=\"Birthday\" value=\"$Birthday\">"; ?>
<br>
<br>
<input name="abc" type="Submit" value="Update">
</p>
</form></td></tr></table>
</body>
</html>
|