Fatal error: Uncaught Error: Call to a member function bind_param() on bool - couldn´t catch it

Asked Jul 07 '20 at 09:54

Active Jul 07 '20 at 09:56

Viewed 47 times

may I´m blind after writing over 1000 lines of code, but I couldn´t catch the error.

if ($stmt = $con->prepare('UPDATE cb_coachingreport SET pdfsr1 = ?, pdfsr2 = ?. pdfsr3 = ?, pdfgesamt = ? WHERE id = ?')); 
{
    $stmt->bind_param('ssssi', $output_file_sr1, $output_file_sr2, $output_file_sr3, $output_file_gesamt, $insert_id);
    $stmt->execute();
    $stmt->close();
}

This get following error:

Fatal error: Uncaught Error: Call to a member function bind_param() on bool

So i checked the vars if there is a type mismatch.

pdfs/pdf_coaching_22_xxx_xxx.pdf Vartype: string

pdfs/pdf_coaching_22_yyy_yyy.pdf Vartype: string

pdfs/pdf_coaching_22_zzz_zzz.pdf Vartype: string

pdfs/pdf_coaching_22_gggg_gggg.pdf Vartype: string

22 Vartype: integer

Should fit, but throws an error. DB fields exits with correct data type setting.

Thanks for any hint, Markus

asked Jul 07 '20 at 09:54

rambrand

Always check for SQL errors like `pdfsr2 = ?. pdfsr3`. – Nigel Ren Jul 07 '20 at 09:57
1

Your `$con->prepare` call returned false, but it executes the following statements anyway, because you have a stray `;` after your `if`. – CBroe Jul 07 '20 at 09:58
https://stackoverflow.com/questions/22662488/mysqli-fetch-assoc-expects-parameter-call-to-a-member-function-bind-param – CBroe Jul 07 '20 at 09:58
@CBroe ... thanks, now I know i´m blind :-) – rambrand Jul 07 '20 at 09:59
It fails before the binding. Use error reporting to see why. – user3783243 Jul 07 '20 at 10:01

Fatal error: Uncaught Error: Call to a member function bind_param() on bool - couldn´t catch it

0 Answers0