防止重复行插入php/mysql

CREATE UNIQUE INDEX index_name ON table_name (column_name);

// 假设连接到MySQL数据库的代码已经完成

// 要插入的数据
$data = array(
    'column1' => 'value1',
    'column2' => 'value2',
    // ...
);

// 查询数据库，检查数据是否已存在
$query = "SELECT * FROM table_name WHERE column1 = 'value1' AND column2 = 'value2'";
$result = mysqli_query($conn, $query);

// 如果查询结果为空，则插入数据
if (mysqli_num_rows($result) == 0) {
    $insertQuery = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')";
    mysqli_query($conn, $insertQuery);
} else {
    echo "数据已存在，无需插入";
}

INSERT IGNORE INTO table_name (column1, column2) VALUES ('value1', 'value2');