正确语法查询insert in to table(MySql) - Correct syntax query insert in to table(MySql)

Correct syntax query insert in to table(MySql)

本文关键字：table MySql to in 语法查询 insert | 更新日期: 2023-09-27

我知道这是mysqli，但我想知道如何得到这个查询正确。我想插入用户名，贝斯瓦尔斯和模块到表。但如果besvarese为空或null，我想写回消息，它已经交付。

$sql  = "INSERT INTO oppgave(username, besvarelse, modulid) 
         select '$username', '$besvarelse', '$modulid'
         from dual
         where not exists (select modulid from oppgave where modulid='$modulid')";
$result=mysql_query($sql, $tilkobling);
if(mysql_affected_rows()==0){
      echo "<h1>Allready delivered</h1>";
}else{
      echo "<h1>Delivery ok</h1>";
}
?>

//«if besvarelse is empty or null i want to write back message that its allready delivered.»
//To check besvarelse we shold not use SQL, it is much better to check it with PHP
if ($besvarelse=='' or is_null($besvarelse)) {
    $resp = "<h1>Allready delivered</h1>";    
} else {
    $sql  = ......;
    $result=mysql_query($sql, $tilkobling);
    if(mysql_affected_rows()==0){
        $resp="<h1>Allready delivered</h1>";
    }else{
        $resp="<h1>Delivery ok</h1>";
}
echo $resp;