I get an error message, and I do not know what it is

Question

I got this Error, could somebody help me? :)

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in ....... on line 98

PDO:

function createNewNews($autor, $titel, $news) {
    $stmt = self::$_db->prepare('INSERT INTO eintraege (Autor, Headline, Datum, Eintrag) VALUES (:autor, :Headline, :datum, :news)');   
    $stmt->bindParam(":autor", $autor);
    $stmt->bindParam(":datum", $datum);
    $stmt->bindParam(":news", $titel);
    $stmt->bindParam(":titel", $news);

    if($stmt->execute()) {
        return true;    
    } else {
        return false;   
    }

}

PHP:

if(isset($_POST['submit'])) {
    $autor = $_POST['autor'];
    $datum = $_POST['datum'];
    $news = $_POST['titel'];
    $titel = $_POST['news'];

    if($db->createNewNews($autor, $titel, $news)) {
        echo "YES!";    
    } else {
        echo "No!"; 
    }
}

`$datum` doesn't exist in the scope of the function? Pass it as an argument! — Mark Baker, Jun 17 '17 at 12:46

score 2 · Answer 1 · answered Jun 17 '17 at 12:47

2

you have missing parameter $datum in createNewNews function.

answered Jun 17 '17 at 12:47

Vibha Chosla

733
5
12

thaaaank you i found my mistake – L. Herbst Jun 17 '17 at 12:50

score 0 · Answer 2 · answered Jun 17 '17 at 12:49

You need to pass $datum also as argument

function createNewNews($autor, $datum,$titel, $news) {
    $stmt = self::$_db->prepare('INSERT INTO eintraege (Autor, Headline, Datum, Eintrag) VALUES (:autor, :Headline, :datum, :news)');   
    $stmt->bindParam(":autor", $autor);
    $stmt->bindParam(":datum", $datum);
    $stmt->bindParam(":news", $titel);
    $stmt->bindParam(":titel", $news);

    if($stmt->execute()) {
        return true;    
    } else {
        return false;   
    }

}

PHP:

if(isset($_POST['submit'])) {
    $autor = $_POST['autor'];
    $datum = $_POST['datum'];
    $news = $_POST['titel'];
    $titel = $_POST['news'];

    if($db->createNewNews($autor, $datum,$titel, $news)) {
        echo "YES!";    
    } else {
        echo "No!"; 
    }
}

I get an error message, and I do not know what it is

2 Answers2