เชื่อมต่อกับ phpmyadmin ได้แล้ว แต่ตอนป้อนข้อมูล ข้อมูลขึ้นเป็น 0 ใน DATABASE

ผมลองใส่ข้อมูล แล้วกด submit ข้อมูลมันขึ้นใน DATABASE แต่ทุกช่องขึ้นเป็น 0 หมดเลยอะครับ ขอคำแนะนำหน่อยครับ

<?php

      $con = mysqli_connect ("localhost", "root", "", "unlv") or die ("Failed to connect mysql server " .mysqli_connect_error());

      $course_group = mysqli_real_escape_string($con, $_POST['course_group']);
      $term_group = mysqli_real_escape_string($con, $_POST['term_group']);
      $title_group = mysqli_real_escape_string($con, $_POST['title_group']);
      $firstname = mysqli_real_escape_string($con, $_POST['firstname']);
      $surname = mysqli_real_escape_string($con, $_POST['surname']);
      $birthday = mysqli_real_escape_string($con, $_POST['birthday']);
      $age = mysqli_real_escape_string($con, $_POST['age']);
      $address = mysqli_real_escape_string($con, $_POST['address']);
      $county_group = mysqli_real_escape_string($con, $_POST['county_group']);
      $postaladdress = mysqli_real_escape_string($con, $_POST['postaladdress']);
      $home_no = mysqli_real_escape_string($con, $_POST['home_no']);
      $moblie_no = mysqli_real_escape_string($con, $_POST['moblie_no']);
      $email = mysqli_real_escape_string($con, $_POST['email']);
      $nationality = mysqli_real_escape_string($con, $_POST['nationality']);
      $citizenship = mysqli_real_escape_string($con, $_POST['citizenship']);
      $institute = mysqli_real_escape_string($con, $_POST['institute']);
      $course_title = mysqli_real_escape_string($con, $_POST['course_title']);
      $course = mysqli_real_escape_string($con, $_POST['course']);
      $graduation_year = mysqli_real_escape_string($con, $_POST['graduation_year']);
      $lastcourse = mysqli_real_escape_string($con, $_POST['lastcourse']);
      $gpa = mysqli_real_escape_string($con, $_POST['gpa']);

      $query = "INSERT INTO registration(course_group, term_group, title_group, firstname, surname, birthday, age, address, county_group, postaladdress, home_no, moblie_no,  email, nationality, citizenship, institute, course_title, course, graduation_year, lastcourse, gpa)
      VALUES('$course_group', '$term_group', '$title_group', '$firstname', '$surname', '$birthday', '$age',
        '$address','$county_group', '$postaladdress', '$home_no', '$moblie_no', '$email', '$nationality',
        '$citizenship', '$institute', '$course_title', '$course', '$graduation_year', '$lastcourse', '$gpa')";


               if(!mysqli_query($con, $query))
             {
                  echo "Error" .mysqli_error($con);
              }
                 else
               {
                    header ("Location: register_test.php?msg=1");
              }

?>
แสดงความคิดเห็น
โปรดศึกษาและยอมรับนโยบายข้อมูลส่วนบุคคลก่อนเริ่มใช้งาน อ่านเพิ่มเติมได้ที่นี่