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

Question

I'm trying to insert the values using PDO statement using ajax. but everytime it throws mysql error. something is missing!

$st = $pdo->prepare('INSERT INTO payment_tbl (user_id, payment_mode, bank_name, cheque_no, pending_amt) 
       VALUES(  :user_id, :payment_mode, :bank_name, :cheque_no, :pending_amt )');


 $st->bindParam('user_id' , $user_id);
 $st->bindParam('payment_mode' , $pmode1);
 $st->bindParam('bank_name' , $bank_name1);
 $st->bindParam('cheque_no' , $cheque_no1);
 $st->bindParam('paid_amt' , $paid_amt1);

 $st->execute();

you forgot `:` in bindParam in all lines. And one typo in `$st->bindParam('paid_amt' , $paid_amt1);` it should be :- `$st->bindParam(':pending_amt' , $paid_amt1);` — Alive to die - Anant, Jan 25 '17 at 07:05
$st = $pdo->prepare("INSERT INTO payment_tbl (user_id, payment_mode, bank_name, cheque_no, transaction_date, remark) VALUES( '$user_id' , '$pmode1' , '$bank_name1', '$cheque_no1', '$trans_date' , '$remark')"); — shyamm, Jan 25 '17 at 11:49

score 0 · Answer 1 · answered Jan 25 '17 at 07:05

0

Looks like a simple issue of a typo. Should

    $st->bindParam('paid_amt' , $paid_amt1);

be

    $st->bindParam('pending_amt' , $pending_amt);

instead?

answered Jan 25 '17 at 07:05

chris g

1,088
10
18

For the questions caused by a typo you have to vote to close them, not answer – Your Common Sense Jan 25 '17 at 07:06
Unfortunately, I can't... I don't have reputation to do so. But I'm sure you knew that. – chris g Jan 25 '17 at 07:20
@chrisg you pointed correct thing. so +1. but still answer is not complete. you can look to my answer – Alive to die - Anant Jan 25 '17 at 10:23

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

1 Answers1