如何避免重复记录插入PHP mysqli？[重复]

Question

如何避免在PHP MYSQLi中插入重复记录？这是我的剧本：

$nama=$_POST['nama'];
$member=$_POST['member'];
$peserta=$_POST['peserta'];
$tour=$_POST['tour'];

mysqli_query($conn,"insert into gathering (nama, member, peserta, tour) values ('$nama', '$member', '$peserta', '$tour')");

header('location:index.php');

Answer 1

添加主键列

ALTER TABLE gathering ADD COLUMN `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

Answer 2

1.您可以更改具有唯一约束的表：

ALTER TABLE mytbl ADD UNIQUE (columnName);

在插入记录之前从表中获取记录，并检查记录是否已经存在。

$dupesql = "SELECT * FROM gathering where (nama = '$nama' )";
$duperaw = mysql_query($dupesql);
if (mysql_num_rows($duberaw) > 0) {
   show error msg;
}else{
   mysqli_query($conn,"insert into gathering (nama, member, peserta, tour) values ('$nama', '$member', '$peserta', '$tour')");
}

Answer 3

以下代码将帮助您插入唯一数据：

$result = mysqli_query($conn, "SELECT nama, member, peserta, tour FROM gathering where nama = '$nama' and member = '$member' and peserta='$peserta' and tour='$tour'")
$total = mysqli_num_rows($result);

if($total==0)
{
    mysqli_query($conn,"insert into gathering (nama, member, peserta, tour) 
values ('$nama', '$member', '$peserta', '$tour')");
}