我写这段代码是为了通过表单收集post信息并将其插入我的数据库，它确实在做它的工作。问题是，每次执行代码时，它都会插入从表单中获得的信息的多个副本。你知道怎么阻止这种事情发生吗？下面是上下文的代码片段:

$query= $connect->prepare("insert into posts (title,date,author,content,image) values('$title','$date','$author','$content','$fileNameNew');");
$query->execute();

if($query->execute()){
    echo('POST UPLOADED SUCESSFULLY');
    $query->close();  
}else{
    echo('POST UPLOADED HAS FAILED');
}

顺晟科技：

要防止插入复制，可以使用下一段代码:

$query= $connect->prepare("insert into posts (title,date,author,content,image) values('$title','$date','$author','$content','$fileNameNew');");
$query->execute();

if($query->execute()){
    echo('POST UPLOADED SUCESSFULLY');
    $query->close();  
}else{
    echo('POST UPLOADED HAS FAILED');
}

php PDO在线测试

此代码还使用准备好的语句中的参数来防止SQL注入