php - 如何在php中应用多个数据？

Question

我正在工作，但仍然出现错误，请帮助我...

if(isset($_POST['add']))
{
$id=$_POST['id'];
                $bfcp=$bfcp=$_POST['bfcp'];
                $casualwear=$_POST['casualwear'];
                $popularity=$_POST['popularity'];
                $formalwear=$_POST['formalwear'];
                $talent=$_POST['talent'];
                $questionandanswer=$_POST['questionandanswer'];
                $Total= $bfcp + $casualwear + $popularity + $formalwear + $talent + $questionandanswer;
$sql="INSERT INTO criteria (id, bfcp, casualwear, popularity, formalwear, talent, questionandanswer, Total)
values('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total')
,('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total')";mysql_query($sql,$conn)or die(mysql_error());

}

请帮助我......

Answer 1

使用这个

您的查询有误。请使用下面的内容

if(isset($_POST['add']))
{
$id=$_POST['id'];
                $bfcp=$bfcp=$_POST['bfcp'];
                $casualwear=$_POST['casualwear'];
                $popularity=$_POST['popularity'];
                $formalwear=$_POST['formalwear'];
                $talent=$_POST['talent'];
                $questionandanswer=$_POST['questionandanswer'];
                $Total= $bfcp + $casualwear + $popularity + $formalwear + $talent + $questionandanswer;
$sql="INSERT INTO criteria (id, bfcp, casualwear, popularity, formalwear, talent, questionandanswer, Total)
values('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total'");
mysql_query($sql,$conn)or die(mysql_error());

}