PHP script returns: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

Question

I have looked over some of the other questions that are similar in nature to my issue, but I'm not using an array or loops in this PDO database writer script. Confused by what some of the other solutions were, I still find myself stuck on this issue.

My script is written like this:

<?php
class DatabaseWriter
{
    public function writeUserToDatabase($email , $name , $age , $gender , $country , $category)
    {   
        $host = '***********';
        $dbname = 'emailcollection';
        $user = '**********';
        $pass = '**********';
        $jointime = '2013-01-07 11:19:08';

        try {
            $connection = new PDO("mysql:host=" . $host . ";dbname=" . $dbname, $user, $pass);
            $connection -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
            $statement = $connection -> prepare("INSERT INTO emailcollection (emailaddress, name, age, gender, country, category, jointime) VALUES (:emailaddress, :name, :age, :gender, :country, :category, :jointime)");
            $statement -> bindValue(':email', $email);
            $statement -> bindValue(':name', $name);
            $statement -> bindValue(':age', $age);
            $statement -> bindValue(':gender', $gender);
            $statement -> bindValue(':country', $country);
            $statement -> bindValue(':category', $category);
            $statement -> bindValue(':jointime', $jointime);
            $statement -> execute();

            $connection = NULL;
        }catch (PDOException $e){
            echo $e -> getMessage();
        }
    }
}

?>

The output:

SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

You might be wondering what $jointime is. That is the last column in the table, and because I'm receiving something that says "Invalid parameter number", I thought that I should match the number of columns exactly (I'm trying to add a timestamp when the user is written, in PHP or SQL somehow).

Thanks for the feedback in advance.

Welcome to Stack Overflow. Unfortunately, your question being too localized to be asked on this site. Please learn to find typos you your code by your own effort, especially with help from an error message you have. Please double-check if your names are all correct and match. It is not that hard. Then please delete your question. You are welcome back any time with real question on some programming problem — Your Common Sense
– Your Common Sense, Commented Mar 29, 2013 at 5:35
There are no typos in the code, and it is a real programming question. — Tyler Smith
– Tyler Smith, Commented Mar 30, 2013 at 1:33

Tyler Smith · Accepted Answer · 2013-03-30 02:47:16Z

1

The solution is that the query was using the column name, :emailaddress, while bindValue() was referencing to :email.

answered Mar 30, 2013 at 2:47

Tyler Smith

411 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP script returns: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related