WAMFT1 Posted October 3, 2013 Share Posted October 3, 2013 I have a problem that when I submit the page goes blank or goes to the location specified in header but it does not update the sql record. This used to work but I made some changes and now I cannot get it back. Any assistance would be appreciate. <?php require('edb.php'); $id=$_REQUEST['id']; $ActivateCode=$_REQUEST['ActivateCode']; $result=mysql_query("SELECT * FROM `eusers` WHERE id = '$id' && ActivateCode = '$ActivateCode'"); $test=mysql_fetch_array($result); if (!$result) { die("Error: Data not found.."); } $id=$test['id']; $FirstName=$test['FirstName']; $LastName=$test['LastName']; $State=$test['State']; $Username=$test['Username']; $Password=$test['Password']; $Email=$test['Email']; $Active=$test['Active']; $SecurityCode=$test['SecurityCode']; $AdviserCode=$test['AdviserCode']; $UserType=$test['UserType']; $ActivateCode=$test['ActivateCode']; if(isset($_POST['Submit'])) { $Password_save =sha1($_POST['Password']); $Email_save =$_POST['Email']; $Active_save =$_POST['Active']; $SecurityCode_save =$_POST['SecurityCode']; $ActivateCode_save =$_POST['ActivateCode']; mysql_query("UPDATE `eusers` SET Password ='$Password_save', Email ='$Email_save', Active ='$Active_save', SecurityCode ='$SecurityCode_save', ActivateCode ='$ActivateCode_save' WHERE id ='$id'") or die(mysql_error("Did not Save")); echo "Saved!"; header("Location: index.php"); } ?> Link to comment https://forums.phpfreaks.com/topic/282665-page-goes-blank-on-submit/ Share on other sites More sharing options...
jazzman1 Posted October 3, 2013 Share Posted October 3, 2013 Your code doesn't have error checking logic in it. Turn on the error_reporting functions on the top of this file! Also, you can show us the HTML form. Link to comment https://forums.phpfreaks.com/topic/282665-page-goes-blank-on-submit/#findComment-1452359 Share on other sites More sharing options...
Barand Posted October 3, 2013 Share Posted October 3, 2013 First place to look for problems is those bits you have just changed Link to comment https://forums.phpfreaks.com/topic/282665-page-goes-blank-on-submit/#findComment-1452416 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.