PHP PDO Error - : Invalid parameter number

Question

I'm trying to insert into a database for the first time using PDO but I keep getting the error

 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined' on line 25

Google tells me there is a mis match somewhere with the values I'm inserting but from what I can tell they add up

    $db = new PDO("mysql:host=$servername;dbname=$dbname",$username,$password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $db->prepare("INSERT INTO ticket (userid, tID, query, date, status) VALUES (:userid, :ticketid, :query, :timestamp, :status)");

$stmt->bindParam(':userid', $userid, PDO::PARAM_STR, 100);
$stmt->bindParam(':tID', $ticketid, PDO::PARAM_STR, 100);
$stmt->bindParam(':query', $query, PDO::PARAM_STR, 100);
$stmt->bindParam(':date', $date, PDO::PARAM_STR, 100);
$stmt->bindParam(':status', $status, PDO::PARAM_STR, 100);

if($stmt->execute()) {
  echo "Ticket has successfully been added";
}
else {
  echo "Didnt work";
}

$db = null;

Any advice?

:ticketid vs :tID, and :timestamp vs :date

iainn
– iainn

2016-07-21 11:29:22 +00:00
Commented Jul 21, 2016 at 11:29 — iainn
– iainn, Commented Jul 21, 2016 at 11:29

Jens · Accepted Answer · 2016-07-21 11:32:01Z

3

You bind paramater tID and date

$stmt->bindParam(':tID', $ticketid, PDO::PARAM_STR, 100);
$stmt->bindParam(':date', $date, PDO::PARAM_STR, 100);

But you named it :ticketid and timestamp in your query.

VALUES (:userid, :ticketid,:query, :timestamp,

So you have two Options.

First rename Parameter in bind Statement:

$stmt->bindParam(':ticketid', $ticketid, PDO::PARAM_STR, 100);
$stmt->bindParam(':timestamp', $date, PDO::PARAM_STR, 100);

or change your Statement to:

VALUES (:userid, :tID,:query, :date,

edited Jul 21, 2016 at 11:32

answered Jul 21, 2016 at 11:30

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

1 Comment

user3080562 Over a year ago

Cheers guys, was over looking the obvious. Working perfectly now

Collectives™ on Stack Overflow

PHP PDO Error - : Invalid parameter number

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related