PHP PDO Invalid parameter number: parameter was not defined

Question

This is my code :

It gives no error when i change the array to index type instead of associative. But the moment i change it back to associative it starts giving error. Any help on this ?

$dbh=new PDO("mysql:host=localhost;dbname=sj_db", 'root', '');

$entryData = array(
    "Team Name"=>$_POST['name']
  , "Won"=>$_POST['w']
  , "Lost"=>$_POST['l']
  , "Draw"=>$_POST['d']
  , "Points"=>$_POST['p']
  );


$sql="INSERT INTO fb (`Team Name`, Won, Lost, Draw, Points) VALUES (?, ?, ?, ?, ?)";
$sth=$dbh->prepare($sql);
//$sth->execute($entryData[`Team Name`],$entryData['Won'],$entryData['Lost'],$entryData['Draw']
//  ,$entryData['Points']);
$sth->execute($entryData);

//$sth->closeCursor();

Your $entryData associative array has 10 items in it, five values and five keys. You need to have just the values in there. — andrewsi
– andrewsi, Commented Sep 6, 2013 at 13:49
But i needed the keys for further uses. Any way to do that ? — Ashish
– Ashish, Commented Sep 6, 2013 at 13:50
-1 for just stating "it starts giving error" but not posting the error itself. — Your Common Sense
– Your Common Sense, Commented Sep 6, 2013 at 13:56

Your Common Sense · Accepted Answer · 2013-09-06 13:52:44Z

1

Placeholders in your query are positional (?) ones.
Either change them to named (:name)
or pass array_values($entryData) into execute

Though you have to remove a space from Team Name key in order to use named placeholders

answered Sep 6, 2013 at 13:52

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

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

7 Comments

Ashish Over a year ago

And about the space thing.. Can't i use ` instead of ' for Team Name...wudnt that do ?

Your Common Sense Over a year ago

Neither ` nor ' symbol has nothing to do with placeholders, mind you. That's why you've been told to remove a space - that's the only way

Ashish Over a year ago

Then it means there's no way to use placeholders for the columns having a space in their name ?

Your Common Sense Over a year ago

Add to your question what have you tried. We cannot know it just from your words "i did try"

Your Common Sense Over a year ago

Who said it's impossible? remove a space from the key name as you have been told

|

Collectives™ on Stack Overflow

PHP PDO Invalid parameter number: parameter was not defined

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related