Jump to content

update php mysql using fancybox not working please help


pips

Recommended Posts

view_leader.php

 
<?php
include('../connect.php');
$message = "";
$id =$_REQUEST['id'];
$rs = mysql_query("SELECT * FROM leaders WHERE id  = '$id'");
$test = mysql_fetch_array($rs);
if (!$rs) 
{
die("Error: Data not found..");
}
$fname=$test['lname'] ;
if(isset($_POST['save']) )
{
$lname_save = $_POST['fname'];
 
mysql_query("UPDATE leaders SET lname ='$lname_save' WHERE id = '$id'")
or die(mysql_error()); 
echo "Saved!";
header("Location:../leaders.php");
}
mysql_close();
?>
<!DOCTYPE html>
<html>
<head>
<title>Restricted</title>
</head>
 
<body>
<form method="post">
<table>
<tr>
<td>Name:</td>
<td><input type="text" name="fname" value="<?php echo $fname ?>"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="save" value="Save" /></td>
</tr>
</table>
</body>
</html>
 
and this is the edit link
 
 
<a id='edit' class='iframe various' title='Update $names ?' href ='trans/view_leader.php?id=$id'><i class='fa fa-edit'></i></a>
 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.