PHP query not working with bindParam but the query does work in itself

Question

I'm trying to insert information insto a mySQL database and I get the WSOD and this error:

PHP Fatal error: Call to a member function bindParam() on a non-object ...

This is the code:

try {
        $conectar1 = new PDO('mysql:host='.HOST.'; dbname='.DATABASE.'; charset=utf8', USER, PASS); 

    $guardarPost = $conectar1->query("
        INSERT INTO foro 
        (userID, estadoPost, asuntoPost, postUltimo, datosPost)
        VALUES (?, ?, ?, ?, ?)
    ");
    $guardarPost->bindParam(1, $userID); <============ ERROR LINE
    $guardarPost->bindParam(2, $estadoMensaje);
    $guardarPost->bindParam(3, $asuntoPost);
    $guardarPost->bindParam(4, $fechaMensaje);
    $guardarPost->bindParam(5, $datosPost);
    $ok = $guardarPost->execute();
} catch (PDOException $e) {
    echo "Error ".$e->getMessage();
}

I've tried stripping everything to check is the DB connection work, and it does.

I've tried entering the query manually into phpMyAdmin replacing the question marks for the text, and it does work.

Where's the problem?

You need to use ->prepare() not ->query() to use ->bindParam(). PDO::query() executes an SQL statement in a single function call vs PDO::prepare Prepares a statement for execution and returns a statement object — Sean
– Sean, Commented Feb 19, 2017 at 21:42

Albert221 · Accepted Answer · 2017-02-20 00:49:35Z

1

Try print_r($conectar1->errorInfo());

also use prepare() instead of query() to use bindParam()s

edited Feb 20, 2017 at 0:49

Albert221

7,8155 gold badges36 silver badges51 bronze badges

answered Feb 19, 2017 at 21:44

Abdul Rafay

3126 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rosamunda Over a year ago

That was it: I forgot to use prepare instead of query! Thanks! I'll accept the answer in a few minutes, when it let me do it. :)

Collectives™ on Stack Overflow

PHP query not working with bindParam but the query does work in itself

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related