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.