Unknown error in bind_param in mysql

Asked Jan 26 '16 at 15:48

Active Jan 26 '16 at 16:46

Viewed 53 times

Hi i got this error message on mysql query which has taken a toll of my time.

Fatal error: Uncaught Error: Call to a member function bind_param() on unknown in ...

Anyone encounter this unknown error before?

How can mysql display the error?

Below is my query:

($db->prepare('INSERT INTO program_list(
            PROGRAM_CODE_ID, MONTH, PDATE, HOURS, PUNIQUE, AUNIQUE, 
            EYEBALL, LEVEL, REMARK, REVENUE, TRAINER_ID, CLIENT_ID, ADMIN_ID, UPD_TIME) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)')) || fail('MySQL prepare', $db->error);

$stmt->bind_param('ssssssssssssss', $program_code, $month, $pdate, $hours,  $unique, $adult, $eyeball, $lvl,  $remark, $revenue, $trainer_id, $client_id,  $admin_id, $time) || fail('MySQL bind_param', $db->error);

I did the echo of the query with variables and able to execute the query successfully on phpmyadmin.

edited Jan 26 '16 at 16:46

asked Jan 26 '16 at 15:48

davidlee

5,611
17
56
82

What is the query? How are you firing it? You really need to mention this. – Mangesh Jan 26 '16 at 15:49
and the code is..... – bansi Jan 26 '16 at 15:51
2

Show ALL THE ERROR MESSAGE and the code that goes with it. Nobody here is **clairvoyant** – RiggsFolly Jan 26 '16 at 15:53
Although it is probably because the previous `prepare()` failed. I dont suppose you are doing any checks for errors after the `prepare()` – RiggsFolly Jan 26 '16 at 15:55
If you have gone to Lunch, thats fine, just that we wont be here when you get back! – RiggsFolly Jan 26 '16 at 16:12
You have 14 binds, but only 13 variables binded. – ʰᵈˑ Jan 26 '16 at 16:39
@ʰᵈˑ, sorry updated the question. Left out the last var just now. – davidlee Jan 26 '16 at 16:47

Unknown error in bind_param in mysql

0 Answers0