问使用超链接从输入中获取值

EN

<?php
  // connect to the database
  include('Connections/connect.php');

  $studentId = ($_SESSION['student']);

  if ($result = $mysqli->query("SELECT * FROM tbllanguage WHERE studentId=$studentId"))
  {
    if ($result->num_rows != 0) {

      // display data in table

      echo "<p>";              
      echo "<div id='body'>";
      echo "<div id='content'>";
      echo "<table align='center' border='0' width='400'>";
      echo "<tr> <th>Language</th> <th>Spoken</th>  <th>Writen</th> <th></th><th></th><th></th></tr>";

      while($row = mysqli_fetch_array($result)) {

        // echo out the contents of each row into a table
        echo "<form id=\"Form".$row[0]."\" accept-charset='UTF-8'>";//DO THIS: ADD THIS
        echo "<input type='hidden' name='id' id='".$row[0]."'>";//DO THIS: ADD THIS
        //echo "<input type='text' name='id' value='".$row[0]."'>";   

        echo "<tr>";
        echo "<td>";
        echo '<select id="language" name="language" style="width:200px;float:left;" class="form-control">
                <option value='.$row[1].'> '.$row[1].'</option>
                <option value="Malay">Malay</option>
                <option value="English">English</option>
                <option value="Chinese">Chinese</option>
                <option value="Tamil">Tamil</option>
              </select>';
        echo "</td>";
        echo "<td>";
        echo '<select id="spoken" name="spoken" style="width:200px;float:left;" class="form-control">
                <option value='. $row[2] .'>'. $row[2] .'</option>
                <option value="Very Good">Very Good</option>
                <option value="Good">Good</option>
                <option value="Moderate">Moderate</option>
                <option value="Bad">Bad</option>
                <option value="Very Bad">Very Bad</option>
              </select>';
        echo "</td>";
        echo "<td>";
        echo '<select name="writen" id="writen" style="width:200px;float:left;" class="form-control">
                <option value='. $row[3] .'>'. $row[3] .'</option>
                <option value="Very Good">Very Good</option>
                <option value="Good">Good</option>
                <option value="Moderate">Moderate</option>
                <option value="Bad">Bad</option>
                <option value="Very Bad">Very Bad</option>
              </select>';
        echo "</td>";
        echo '<td>'. "&nbsp;" .'</td>';
        echo "<td>";
        echo '<a href="deleteLanguage.php?id=' . $row[0] . '"><img src="image/delete.png" width="16" height="16" /></a>';
        echo "</td>";
        echo '<td>'. "&nbsp;" .'</td>';
        echo '<td>'. "&nbsp;" .'</td>';
        echo '<td>'. "&nbsp;" .'</td>';
        echo "<td>";
        echo '<a href="#" id="'.$row[0].'" onclick="editData(this.id)"><img src="image/save.png" width="16" height="16" /></a>';
        echo "</td>";
        echo "</tr>";
      }

      echo "</table>";
      echo "</div>";
      echo "</div>";
      echo "</center>";
      echo "<p></p>";
      echo '<input type="submit" value="Cancel" id="btnCancel" name="cancel" class="btn btn-danger" />';
      echo "</form>";

    }
  }

  // close database connection
  $mysqli->close();

?>

<?php
  error_reporting(E_ALL);
  // connect to the database
  include('Connections/connect.php');

  function renderForm($id='')
    if (isset($_POST['id']) && is_numeric($_POST['id']))
    {  
      $id = $_POST['id'];
      $language = $_POST['language'];
      $spoken = $_POST['spoken'];
      $writen = $_POST['writen'];

      // update record from database
      if ($stmt = $mysqli->prepare("UPDATE tbllanguage SET language = ?, spoken = ?, writen = ? WHERE languageId=?"))
      {
        $stmt->bind_param("sssi",$language,$spoken,$writen, $id);  
        $stmt->execute();
        $stmt->close();
        echo "Success";//return this string to js if form success
      } else {
         echo "ERROR: could not prepare SQL statement.";
      } 
    }

  $mysqli->close();

?>

<script>
function editData(id) {
    var url = "editLanguage.php";
    var xhttp = new XMLHttpRequest();
    var formId = "Form"+id;
    if (confirm("Confirm update data?")) {
        var form = document.getElementById(formId);
        var formData = new FormData(form);
        xhttp.onreadystatechange = function() {
           if (xhttp.readyState == 4 && xhttp.status == 200) {
               if (xhttp.responseText == "Success"){
                   //alert("Updated successfully");
                   //location.reload(true);
                   window.document.write(xhttp.responseText);
               }else{
                   //alert("Something went wrong");
                   //location.reload(true);  
                     window.document.write(xhttp.responseText);                        
               }   
           }                       
       }

        xhttp.open("POST",url,true);
        xhttp.send(formData);
    }else{
        alert("Cancelled, no changes made.");
        return false;
    }
}
</script>