Invalid parameter number: parameter not defined. Explanation

Question

Im using a simple test form to try and debug this error.

I am trying to write a script where users can update their user information, I searched for SO but did not find anything specific to help me.

My test code is as follows:

HTML

<form name="info" method="post" enctype="multipart/form-data">
    <input type="text" name="username" id="username">
    <input type="submit" name="submitBtn">
</form>

Php

        if(isset($_POST['submitBtn'])){
       //Display Errors
      {{ PDO::ATTR_ERRMODE; }}
        $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );

        $uname =  $_POST['username']; //this displays correct after submit
        $userID = $_SESSION['userID']//this prints correctly when user logged in, which he is
        $sql="UPDATE USERS SET username =:name
              WHERE userID =:uID";
        $stmnt= $db->prepare($sql);

        $stmnt->bindValue('name', $uname);
        $stmnt->bindValue('userID', $userID);
        $result = $stmnt->execute();
        if($result){
            ?>
        <h2>SUCCESS</h2>
    <?php
        }//end result
        else{
            ?>
        <h2>FAIL</h2>
    <?php
        }//else
    }//isset

ERROR MESSAGE

PDOStatement :: execute (): SQLSTATE [HY093]: Invalid parameter number: parameter not defined

Answer 1

absent :(colon)

   $stmnt->bindValue(':name', $uname);
   $stmnt->bindValue(':userID', $userID);