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"); } ?> Quote 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 (edited) 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. Edited October 3, 2013 by jazzman1 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.