phpNOvice Posted July 3, 2014 Report Posted July 3, 2014 Hello everyone, I am confused with these little codes why it keeps error in updating the learner information. These are my codes so far. These are the bits of Student_Info.php which i think would be useful in my query. <?php if(!empty($_GET['flag']) && $_GET['flag'] == "success") { ?> <span class="stylered style1"><span class="style5">Learner Information updated successfully.</span></span> <?php } else if(!empty($_GET['flag']) && $_GET['flag'] == "error") { ?> <span class="stylered style3 style5"><span class="style1">Error while updating Learner Information. Please try again</span></span> <?php } ?> </td> This is the Student_Edit_Handler codes. <?php session_start(); $session_id = $_SESSION['user_id']; if($session_id == null){ header("location:Student_Edit.php"); die(); } include 'Connect.php'; $flag = ""; $student_id = $_POST['student_id']; $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $gender = $_POST['gender']; $date_of_birth = date("Y-m-d",strtotime($_POST['date_of_birth'])); $contact_no = $_POST['contact_no']; $grade = $_POST['grade']; $section = $_POST['section']; $LRN = $_POST['LRN']; $email1 = $_POST['email1']; $email2 = $_POST['email2']; $address = $_POST['address']; $description = $_POST['description']; $query = "UPDATE student_information SET learner_id='$learner_id',first_name='$first_name',last_name='$last_name',"; $query .= "gender='$gender',date_of_birth='$date_of_birth',contact_no='$contact_no',grade='$grade',section='$section',"; $query .= "LRN='$LRN',email1='$email1',email2='$email2',address='$address',description='$description'"; $query .= " WHERE student_id='{$_SESSION['user_id']}'"; $result = mysql_query($query, $link_id); if(mysql_error() != null){ die(mysql_error()); } else{ $flag="error"; } if($flag == "success"){ mysql_query(" COMMIT "); $flag="success"; if(mysql_error() != null){ die(mysql_error()); } } header("location:Student_Edit.php?flag=$flag&student_id='{$_SESSION['user_id']}'"); ?> It flags the error on else{$flag="error";} I am stuck with these codes guys, please do help me modify it so learner information will be update. Quote
falkencreative Posted July 3, 2014 Report Posted July 3, 2014 Looks like a logic problem to me. You're running the query, and saying if there is an error, show the error, otherwise set the $flag to "error". According to your code above, your $flag will never equal success. Quote
phpNOvice Posted July 4, 2014 Author Report Posted July 4, 2014 Hello Ben, hahaha,, i am so dumb!! Why i haven't think of that....thank you for that hint Ben.. I solve it,,and for the benefit of those future reader on this thread. ill post the solution. $query = "UPDATE student_information SET learner_id='$learner_id',first_name='$first_name',last_name='$last_name',"; $query .= "gender='$gender',date_of_birth='$date_of_birth',contact_no='$contact_no',grade='$grade',section='$section',"; $query .= "LRN='$LRN',email1='$email1',email2='$email2',address='$address',description='$description'"; $query .= " WHERE student_id='{$_SESSION['user_id']}'"; $result = mysql_query($query, $link_id); if(mysql_error() != null){ die(mysql_error()); } else{ $flag="success"; } header("location:Student_Edit.php?flag=$flag&student_id='{$_SESSION['user_id']}'"); ?> Thank you Ben. Quote
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.
Note: Your post will require moderator approval before it will be visible.