Binding parameters by PDO not working

Question

I've got this code:

$conn = new mysqli($servername, $username, $password, $dbname);
$jsonvprencode = json_encode($jsonvpr);
$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = :val WHERE `ID` = $idvpr");
$stmt->bind_param(":val", $jsonvprencode);
$stmt->execute();

When trying to execute it it returns Fatal error: Call to a member function bind_param() on a non-object in /var/www/html/crawlnew.php on line 432

I can't understand what is going on here -_-

You are using mysqli and you used named placeholder. Can't do. — frz3993
– frz3993, Commented Apr 21, 2015 at 11:47
I supose, but I don't understand why. Replacing the parameter with a string, and ID with a number, the query works right. Variables $jsonvprencode and $idvpr are valid strings as well :S — Cornezuelo del Centeno
– Cornezuelo del Centeno, Commented Apr 21, 2015 at 11:50
If I remember correctly mysqli only support ? as placeholder. If you want to use :val as a placeholder. It is pretty much like @niyou told you. — frz3993
– frz3993, Commented Apr 21, 2015 at 11:54

Umair Ayub · Accepted Answer · 2015-04-21 12:03:49Z

1

MySQLi with PreparedStatements

$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = ? WHERE `ID` = ?");
$stmt->bind_param("si", $jsonvprencode,$idvpr);

PDO with Prepared Statements

$stmt = $conn->prepare("UPDATE `wp_posts` SET  `post_content` = :jsonvprencode WHERE `ID` = :idvpr");

$stmt->bindParam(':jsonvprencode', $jsonvprencode);

$stmt->bindParam(':idvpr', $idvpr);

edited Apr 21, 2015 at 12:03

answered Apr 21, 2015 at 11:41

Umair Ayub

21.7k14 gold badges82 silver badges154 bronze badges

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

3 Comments

Cornezuelo del Centeno Over a year ago

This give me another error -_-

Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables in /var/www/html/crawlnew.php on line 435

niyou Over a year ago

imo this is maybe correct for mysqli...but he is asking about PDO.

Umair Ayub Over a year ago

@CornezuelodelCenteno see edits now ... there are 2 ways to bind parameters ... with MySQLi/PS and PDO/PS

niyou · Accepted Answer · 2015-04-21 11:40:18Z

0

You have to open a PDO connection

$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);

and then use this object

answered Apr 21, 2015 at 11:40

niyou

8791 gold badge11 silver badges23 bronze badges

5 Comments

Cornezuelo del Centeno Over a year ago

instead of my $conn one?

Cornezuelo del Centeno Over a year ago

your solution gives me Fatal error: Call to undefined method PDOStatement::bind_param() in /var/www/html/crawlnew.php on line 432

Cornezuelo del Centeno Over a year ago

I was using your method before, and the error was diferent, but still were errors, check my answer!

niyou Over a year ago

exactly - the method is bindParam

niyou Over a year ago

btw - you should aesily read the documentation at php.net: php.net/manual/en/book.pdo.php

René Höhle · Accepted Answer · 2015-04-21 11:50:32Z

0

I think you have an error in your statement.

printf("Errormessage: %s\n", $conn->error);

try to echo the error if you have one. If you have an error in your statement you didn't get an proper object.

edited Apr 21, 2015 at 11:50

answered Apr 21, 2015 at 11:43

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

1 Comment

Cornezuelo del Centeno Over a year ago

Using printf("Errormessage: %s\n", $conn->error); (I was suposed to change $mysqli for my connection variable, right?) don't returns any sql error :S

Collectives™ on Stack Overflow

Binding parameters by PDO not working

3 Answers 3

3 Comments

5 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

5 Comments

1 Comment

Related