pips Posted December 2, 2014 Share Posted December 2, 2014 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> Quote Link to comment https://forums.phpfreaks.com/topic/292839-update-php-mysql-using-fancybox-not-working-please-help/ Share on other sites More sharing options...
Ch0cu3r Posted December 2, 2014 Share Posted December 2, 2014 Cool Quote Link to comment https://forums.phpfreaks.com/topic/292839-update-php-mysql-using-fancybox-not-working-please-help/#findComment-1498273 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.