防止重复行插入php/mysql

Question

我正在尝试将文本框中的多条记录插入到mysql表中。如果我输入的记录超过2条，就会插入重复的记录。这是代码。我做错了什么？

更多信息

表信息

id (int) primary auto_increment
email (varchar)
imei (varchar)
date_ordered (datetime)
status(varchar)

因为这只是个开始，所以我对改变表结构没有任何问题。

$email = $_SESSION['email'];
$now = time():
$status = "1";

$imeis = $_POST['imeis'];
$row = explode("\n", $imeis);

foreach ($row as $key => $imei)
{
    $imei = mysql_real_escape_string($imei);

    $query = "SELECT * FROM orders WHERE imei = '$imei'";
    $result = mysqli_query($link, $query);

    if (mysqli_num_rows($result) == 0)
    {
        $query1 = "INSERT IGNORE INTO orders (email, imei, date_ordered, status) VALUES ('$email', '$imei', '$now', '$status')";
        $result1  = mysqli_query($link, $query1) OR die("fml");

        if ($result1)
        {   
            echo "Added $imei<br>";
        }
    }

    else
    {
        echo "<B>$imei</B> already there<br>";
    }

}