PDO利用占位符绑定SQL语句出现如下错误,
Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
$sql1="INSERT INTO t_project (project_name, project_active,project_date,project_usedflag) VALUES( :project_name,:project_active,: project_date,:project_usedflag)"; //type字段名, stext关键字
echo $sql1;
// echo $type;
// echo $stext;
$project_name =$_POST['project_name'];
$project_active =$_POST['project_active'];
$project_date =$_POST['project_date'];
echo ($project_name);
echo ($project_active);
echo($project_date);
$project_usedflag ='否';
$stmt = $pdo->prepare($sql1);
//$stmt->set