ผมลองใส่ข้อมูล แล้วกด 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");
}
?>
เชื่อมต่อกับ phpmyadmin ได้แล้ว แต่ตอนป้อนข้อมูล ข้อมูลขึ้นเป็น 0 ใน DATABASE
<?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");
}
?>