Fatal error: Call to a member function bindParam() on boolean in D:\xampp\htdocs\ipack\insertstatus.php on line 14

Question

I am getting an error while running this code:

Fatal error: Call to a member function bindParam() on boolean in D:\xampp\htdocs\ipack\insertstatus.php on line 9

<?php

    header('Access-Control-Allow-Origin: *');
    include 'dbconnection.php';
    $jobno = "AFE/0001/2015";
    $jobseq = 0;
    //to get INTJOBNO
    $intjobno = "";
    $data = $dbh->query("select INTJOBNO from PRTJOBHD where JOBNO = :jobno and JOBSEQ = :jobseq");
    $data->bindParam(':jobno',$jobno,PDO::PARAM_STR);
    $data->bindParam(':jobseq',$jobseq,PDO::PARAM_STR);
    $data->execute();
    foreach($data as $row) {
         $intjobno = $row['INTJOBNO'];
         echo $intjobno;      
    }
>

You don't prepare your statement – Rizier123 Sep 13 '15 at 13:10 — Rizier123, Sep 13 '15 at 13:10

GiamPy · Answer 1 · 2015-09-13T13:16:01.417

0

PDO::query() returns a PDOStatement object, or FALSE on failure.

Source

It means your query has failed for some reason.

In this case you are using the wrong function to do what you want to do.

You need to prepare your statement since you want to bind two parameters in your query.

Use $dbh->prepare() instead of $dbh->query().

edited Sep 13 '15 at 13:16

answered Sep 13 '15 at 13:09

GiamPy

3,543
3
30
51

`date()` returns a string.... And how should that solve OP's error ? – Rizier123 Sep 13 '15 at 13:11
`Fatal error: Call to a member function bindParam() on boolean` it means that `$db->query()` has failed. – GiamPy Sep 13 '15 at 13:12
Reason why I told him to use `PDO::errorInfo()`. – GiamPy Sep 13 '15 at 13:13
Fixed @Rizier123, better? – GiamPy Sep 13 '15 at 13:16
Thanks @GiamPy. Its working for me.. – Vipin KA Sep 14 '15 at 07:58

score 0 · Accepted Answer · edited May 23 '17 at 12:29

Have a look at this answer: PDO's query vs execute. You cannot bind parameters to PDO query, you need to use prepare instead.

header('Access-Control-Allow-Origin: *');
include 'dbconnection.php';
$jobno = "AFE/0001/2015";
$jobseq = 0;
//to get INTJOBNO
$intjobno = "";
$data = $dbh->prepare("select INTJOBNO from PRTJOBHD where JOBNO = :jobno and JOBSEQ = :jobseq");
$data->bindParam(':jobno',$jobno,PDO::PARAM_STR);
$data->bindParam(':jobseq',$jobseq,PDO::PARAM_STR);
$data->execute();
foreach($data as $row) {
     $intjobno = $row['INTJOBNO'];
     echo $intjobno;      
}

Thanks... Its working for me – Vipin KA Sep 14 '15 at 07:59 — Vipin KA, Sep 14 '15 at 07:59

Fatal error: Call to a member function bindParam() on boolean in D:\xampp\htdocs\ipack\insertstatus.php on line 14

2 Answers2