Error:SQLSTATE[HY093]: Invalid parameter number: parameter was not defined firts years student

Asked Jan 20 '21 at 14:18

Active Jan 20 '21 at 17:16

Viewed 29 times

I am having trouble of finding why my code is not working . I tried to look up on the internet but I can't seem to find the error Here's my function

<?php 
    include "gar-connect.php";
    try { 
        $stmt = $conn->prepare ("INSERT INTO gebruiker(voornaam,achternaam,gebruikerid,wachtwoord,) 
                                 VALUES (:voornaam, :achternaaam, :gebruikerid,:wachtwoord)");
        $stmt->bindParam(':voornaam ',$voornaam);
        $stmt->bindParam(':achternaam ',$achternaam);
        $stmt->bindParam(':gebruikerid ',$gebruikerid);
        $stmt->bindParam(':wachtwoord ',$wachtwoord);
 
        if(isset($_REQUEST['voornaam'])){
            $voornaam = $_POST['voornaam'];
            $achternaam = $_POST['achternaam'];
            $gebruikerid= $_POST['gebruikerid'];
            $wachtwoord= $_POST['wachtwoord'];
        $stmt->execute();
        header('location: select.php');
        }
    }
    catch(PDOException $e){
         echo "Error:" .$e->getMessage();
    }
    $conn = null;
?>

edited Jan 20 '21 at 17:16

Merrin K

1,602
1
16
27

asked Jan 20 '21 at 14:18

Dustin van Roon

There is an extra `,` in `wachtwoord,)`, try this first. – Nigel Ren Jan 20 '21 at 14:27
@Felippe Duarte the variables are stmt->bindparam after or not ?? – Dustin van Roon Jan 20 '21 at 16:56
@merrin K what was wrong with it what do i have to do with the editet code?? – Dustin van Roon Jan 20 '21 at 17:23
Why you re adding *spaces* to parameter names? – Your Common Sense Jan 20 '21 at 18:41
@FelippeDuarte FYI that's how it's supposed to work – Your Common Sense Jan 20 '21 at 18:41
@merrin K your code and my code looks the same – Dustin van Roon Jan 20 '21 at 21:42
Code edited is not the answer, I have improved the formatting of your code, the answer will be bellow the comment section – Merrin K Jan 21 '21 at 05:11

Error:SQLSTATE[HY093]: Invalid parameter number: parameter was not defined firts years student

0 Answers0