Jump to content
Stef's Super Nerd Coding Community
Sign in to follow this  
phpNOvice

Error In Updating Learner Information

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...