插入php变量到mysql的表中

Question

  $query="INSERT INTO BasicInformation
           (Motor_ID,Position,Motor_pic,Company,Power,Frequence,Voltage,Current,Phase,Pole,RPM,Funcation)
          VALUES('','{$Motor_ID}','{$Position}','{$Motor_pic}','{$Company}','{$Frequence}','{$Voltage}','{$Current}','{$Phase}','{$Pole}','{$RPM}','{$Funcation}');";
  echo $query;

Answer 1

你没有加那个括号：$query="INSERT INTO BasicInformation (Motor_ID,Position,Motor_pic,Company,Power,";
$query=$query."Frequence,Voltage,Current,Phase,Pole,RPM,Funcation)";
$query=$query." VALUES('','".$Motor_ID."','".$Position."','".$Motor_pic."',";
$query=$query."'".$Company."','".$Frequence."','".$Voltage."',";
$query=$query."'".$Current."','".$Phase."','".$Pole."','".$RPM."',";
$query=$query."'".$Funcation."');";