我得到
致命错误:未被捕获的PDOException:SQLSTATE [HY093]:无效的参数编号:参数未定义” ... PDOStatement-> execute()#1 {main}抛出61行。61行为$ stmt-> execute ();
$add_joke = filter_input(INPUT_POST,'add_joke');
if ($add_joke != NULL){
$actual_date = date('Y-m-d');
$actual_id = null;
$sql = 'INSERT INTO joke (id,JokeText,Joke Date) VALUES (:id,:JokeText,:Joke Date)';
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':id',$actual_id);
$stmt->bindParam(':JokeText',$add_joke);
$stmt->bindParam(':Joke Date',$actual_date);
$stmt->execute();
}