无法将数据保存到mysql中(按“保存”按钮后页面变为空白)

Question

这是我的密码……按下“保存”按钮后，无法将数据保存到mysql中，该页变为空白。

<?php $nama_pengguna =$_GET['nama_pengguna']; ?>
<?php include('../Connections/connection_db.php'); ?>
<?php
$Nama = $_POST['Nama'];
$No_KP = $_POST['No_KP'];
$NoNDP = $_POST['NoNDP'];
$Semester = $_POST['Semester'];
$kursus = $_POST['kursus'];
$NoTelPelajar = $_POST['NoTelPelajar'];
$alamat_1 = $_POST['alamat_1'];
$alamat_2 = $_POST['alamat_2'];
$Poskod = $_POST['Poskod'];
$Bandar = $_POST['Bandar'];
$Negeri = $_POST['Negeri'];
$namabp = $_POST['namabp'];
$No_Tel_bp = $_POST['No_Tel_bp'];
$alamat_1_bp = $_POST['alamat_1_bp'];
$alamat_2_bp = $_POST['alamat_2_bp'];
$poskod_bp = $_POST['poskod_bp'];
$Bandar_bp = $_POST['Bandar_bp'];
$Negeri_bp = $_POST['Negeri_bp'];

$data =mysql_query ("INSERT INTO maklumat_pelajar (No_KP, Nama, No.NDP, Semester, Kursus, No_Tel_Pelajar, Alamat, Alamat_2, Poskod, Bandar, Negeri, Nama_BP, No_Tel_BP, Alamat_BP, Alamat_BP_2, Poskod_BP, Bandar_BP, Negeri_BP) VALUES ('".$_POST['No_KP']. "','".$_POST['Nama']. "','".$_POST['NoNDP']. "','".$_POST['Semester']. "','".$_POST['kursus']. "','".$_POST['NoTelPelajar']. "','".$_POST['alamat_1']. "','".$_POST['alamat_2']. "','".$_POST['Poskod']. "','".$_POST['Bandar']. "','".$_POST['Negeri']. "','".$_POST['namabp']. "','".$_POST['No_Tel_bp']. "','".$_POST['alamat_1_bp']. "','".$_POST['alamat_2_bp']. "','".$_POST['poskod_bp']. "','".$_POST['Bandar_bp']. "','".$_POST['Negeri_bp']. "')");

//$data = mysql_query($query);
echo $data;

//header ("location:../bppl/register_pelajar.php?nama_pengguna=$nama_pengguna");    
?>

有人能找到别的办法吗？

Answer 1

改变这一切

  No.NDP

至

 `No.NDP`

在你的专栏里

在插入变量之前，您应该先转义变量。

  mysql_real_escape_string()

要查看这样使用mysql_error()的错误是什么

   $data =mysql_query ("INSERT INTO ...........")or die (mysql_error());

Answer 2

尝尝这个。

              $sql=mysql_query("INSERT INTO maklumat_pelajar('$No_KP','$nama','$NoNDP',
'$smester','$kursus',
    '$NoTelPelajar','$alamat_1','$alamat_2','$Poskod','$Bandar','$Negeri',
    '$namabp','$No_Tel_bp','$alamat_1_bp','$alamat_2_bp','$poskod_bp',
    '$Bandar_bp','$Negeri_bp')");
    if(!$sql) {
        die("Database query failed: " . mysql_error());
    }