php - 数据库错误: SQLSTATE[HY093]

Question

<?php

include_once __DIR__ . '/../includes/DatabaseConnection.php';
include_once __DIR__ . '/../includes/totalJokes.php';

function query($pdo,$sql,$parameters=[]){
    $query = $pdo->prepare($sql);
    foreach($parameters as $name=>$value){
        $query->bindValue($name,$value);
    }
    $query->execute();
    return $query;
}
function getJoke($pdo,$id){

    $query = 'SELECT * FROM `joke` WHERE `id`= :id';
    $parameters = [':id'=>$id];
    $row = query($pdo,$query,$parameters);
    return $row->fetch();
}

function insertJoke($pdo,$joketext,$authorid){
    $parameters = [':joketext'=>$joketext,'authorid:'=>$authorid];
    $query = 'INSERT INTO `joke` SET `joketext`= :joketext,
    `jokedate` = CURDATE(), `authorid`= :authorid';
    query($pdo,$query,$parameters);
}
function updateJoke($pdo,$id,$joketext,$authorid){
    $parameters = [':authorid'=>$authorid, ':joketext'=> $joketext, ':id'=>$id];
    $query = 'UPDATE `joke` SET `authorid`= :authorid,`joketext`= :joketext WHERE `id`= :id';
    query($pdo,$query,$parameters);

}
?>

调用函数 insertJoke() 时出现以下错误。

Database error: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in: /home/vagrant/Code/Project/includes/DatabaseFunctions.php11

Answer 1

您传递的参数无效。

authorid: 不存在。 : 应该在

之前而不是之后

$parameters = [':joketext'=>$joketext,':authorid'=>$authorid];