Invalid parameter number: parameter was not defined - PHP / MYSQL

Question

I get

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

when trying to run the following code, both with bindValue and bindParam yet can't seem to see what is wrong.

class Product {

    public function productAdd($x) {
        $core = Core::getInstance(); // This part works OK
        $stmt = $core->dbh->prepare('INSERT INTO Product (Product_Name) VALUES (:product-name)');
        $stmt->bindValue(':product-name', $x, PDO::PARAM_STR);
        $stmt->execute();
    }

}

$product = new Product;
$productadd = $product->productAdd('Blue Sunglasses');

I wonder if it's because of the -. Try without that, like :productName — gen_Eric
– gen_Eric, Commented Jun 12, 2013 at 15:30
OMG ? Duh, yup, that did it. Thanks!!! Can't believe that. It took me hours!!! Fresh eyes are always welcomed. — fizzy drink
– fizzy drink, Commented Jun 12, 2013 at 15:37

somedev · Accepted Answer · 2013-06-12 15:32:29Z

4

named parameters must be one of these:

BINDCHR     = [:][a-zA-Z0-9_]+;

change the hyphen to an underscore or remove it.

answered Jun 12, 2013 at 15:32

somedev

1,0531 gold badge9 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Invalid parameter number: parameter was not defined - PHP / MYSQL

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