如何使用mysqli在mysql数据库中插入数据，数据检查在同一个“日期”中没有相同的“id”

Question

guy's i need your help. im trying to make an insert form with php with this condition.

"id cant be same in same date"

my database name is : "ssl",
table name is : "try"
with table col: "id", "date", "name", "city"

im have try a lot to make this but still get some eror. but when i delete the php script for checking it can running well..

please help me. im really apreciated when you give me an example of that.

sorry for my english and sorry im still newbie and need study more for something like this

this my script for insert

<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "silo");


// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}


// Attempt insert query execution
$sql="Insert into termocouple 
        Select * from temp1";
if(mysqli_query($link, $sql)){
    echo "Data inserted successfully.";
} else{
    echo "Data inserted Failed " . mysqli_error($link);
}

// Close connection
mysqli_close($link);
?>

Answer 1

can i just use something like this? i get from Copy rows from one table to another, ignoring duplicates

<?php
$sql="INSERT INTO termocouple
SELECT no,tanggal,silo,... 
FROM temp1
WHERE NOT EXISTS(SELECT * 
                 FROM destTable 
                 WHERE (temp1.no=termocuple.no and
                       temp1.tanggal=termocouple.s_tanggal...etc.)
                 )";
                 ?>