使用jquery更新复选框


Update using checkbox using jquery

我试图更新我的course_code到我的数据库时,复选框选中,但它失败了。我试着从别人那里修改,但似乎我犯了错误。谁能告诉我出了什么问题?

这是我的assigncourse。php

<?php require_once("../includes/session.php"); ?>
<?php require_once("sessioncourse.php"); ?>
<?php $course_codefac = $_SESSION['course_code'] ; ?>
<?php confirm_logged_in(); ?>
<?php require_once("../includes/connection.php") ?>
<?php require_once("../includes/functions.php") ?>

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
function Change(id) {
 $.ajax({
     type: "GET",
     url: "updateassigncourse.php",
     data: {"id": id},
     'success': function (response) {
            console.log(response);
            //TODO: use server response
        }
 });
};
</script>
<?php include("includes/header.php"); ?>
  <div id="main">
  <div class="full_w">
   <?php
          $querysel = "SELECT * FROM tblstudent ORDER BY student_id " ;
      $resultsel = mysql_query($querysel, $connection);
      echo "<h2><div class='"h_title'">Please tick the student to join this 
".$course_codefac." course</div></h2>";  
      echo "<table>";
      echo "<thead>";
      echo "<tr>";
      echo "<th scope='"col'">Matric ID</th>";
      echo "<th scope='"col'">Name</th>";
      echo "<th scope='"col'">Assign</th>";
      echo "</tr>";
      echo "</thead>";

          while($rowsel = mysql_fetch_array($resultsel)){
        if($rowsel['course_code'] == NULL){
            $id = $rowsel['id'];
                    echo "<tr>";
                    echo "<tr>"."<td class='"align-center'">".$rowsel['student_id']."  
</td>";
                    echo "<td class='"align-center'">".$rowsel['name']."</td>";
        echo "<td class='"align-center'">";
        echo "<input type='"checkbox'" onchange='"javascript:  
Change($id);'">";
echo "</td>";
        }
      }
      echo "</table>";


   ?>
  </div>
  </div>
<?php include("includes/footer.php"); ?>
这里是updateassigncourse。php
<?php require_once("../includes/session.php"); ?>
<?php require_once("sessioncourse.php"); ?>
<?php $course_codeapp = $_SESSION['course_code'] ; ?>
<?php confirm_logged_in(); ?>
<?php require_once("../includes/connection.php") ?>
<?php require_once("../includes/functions.php") ?>
<?php
$id = $_GET['id'];
$course = $course_codeapp;
$sql="UPDATE tblstudent set course_code  = ". mysql_real_escape_string($course) 
." WHERE id = " .mysql_real_escape_string($id);
$result = mysql_query($sql);
?>

如果这是您的确切代码,那么缺少';'

$course = $course_codeapp

应该是

$course = $course_codeapp;