php - Call to a member function prepare() on a non-object in

Question

I get this error:

Fatal error: Call to a member function prepare() on a non-object in /home/folder/public_html/includes/name.php on line 1768

This is the function:

function _FC_GET($typ, $data, $username){

            global $dbh;
            $stmt = $dbh->prepare("SELECT * FROM stats_clicks WHERE typ=:typ AND user=:username AND data=:data LIMIT 1;");
            $stmt->bindParam(':typ', $typ);
            $stmt->bindParam(':username', $username);
            $stmt->bindParam(':data', $data);
            try {
            $stmt->execute();
            }
            catch(PDOException $e) {
                die( _OP_ERROR($e->getMessage(), __FILE__ ,__LINE__) );     
            }

            $QUERY_DAT = $stmt->fetchAll();
            return empty($QUERY_DAT['value']) ? 0 : $QUERY_DAT['value'];

        }

And this is line 1768:

$stmt = $dbh->prepare("SELECT * FROM stats_clicks WHERE typ=:typ AND user=:username AND data=:data LIMIT 1;");

I can't seem to find what is causing this. I use the $dbh-prepare(); statement in other functions in the same file.

use var_dump($dbh) to see what's inside this object – Oyeme Jan 14 '14 at 09:40 — Oyeme, Jan 14 '14 at 09:40
Where is your `new PDO(..)` for `$dbh`? – Maarkoize Jan 14 '14 at 09:40 — Maarkoize, Jan 14 '14 at 09:40
`var_dump($dbh)` return `NULL` – oliverbj Jan 14 '14 at 09:42 — oliverbj, Jan 14 '14 at 09:42
variable $dbh is null that's the answer to your question – Oyeme Jan 14 '14 at 09:43 — Oyeme, Jan 14 '14 at 09:43

score 0 · Accepted Answer · answered Jan 14 '14 at 09:45

0

$dbh is not defined at that line. Check where you create the object $dbh if it is before the line 1768 or it is not in any condition which is not fulfilled.

answered Jan 14 '14 at 09:45

cibi

16

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

0

Try this :

Look at here

Probably the cause of your connection.

edited May 23 '17 at 12:29

Community

1
1

answered Jan 14 '14 at 09:50

Shail Paras

1,125
1
14
34

php - Call to a member function prepare() on a non-object in

2 Answers2