bind param usage on multiple values with single query

Question

$stmt2 = $db->prepare("INSERT INTO friend(`uId`,`friendId`) VALUES (?,?), VALUES(?,?)");
$stmt2->bind_param('ssss', $userId,$friendId,$friendId,$userId);

I expect it would insert 2 rows with the result

uId friendId
1    2
2    1

but it returned

Call to a member function bind_param() on a non-object

Does this answer your question? mysqli_fetch_assoc() expects parameter / Call to a member function bind_param() errors. How to get the actual mysql error and fix it? — Dharman
– Dharman ♦, Commented Mar 6, 2020 at 19:49

Bill Karwin · Accepted Answer · 2014-05-08 14:20:41Z

1

INSERT takes only one VALUES clause, even if the VALUES clause includes multiple tuples.

INSERT INTO friend(`uId`,`friendId`) VALUES (?,?), (?,?)

But more importantly, you should always check the return value of prepare() because it returns false if there's an error in your query. Of course you cannot call a the bind_param() method on a false value, because false is not an object with methods at all.

answered May 8, 2014 at 14:20

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

3 Comments

user3522457 Over a year ago

I tried your format but how is the bind param look like? this $stmt2->bind_param('ssss', $userId,$friendId,$friendId,$userId); doesn't work

Bill Karwin Over a year ago

Did you check for errors as I suggested? What error was output? See an example here: php.net/manual/en/mysqli.error.php

user3522457 Over a year ago

yes I tried your answer but it return Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement

Thiago França · Accepted Answer · 2014-05-08 14:49:08Z

0

Try this

$a = '';
$b = '';

$stmt2 = $db->prepare("INSERT INTO friend(`uId`,`friendId`) VALUES (?,?)");
$stmt2->bind_param('ss', $a, $b);

$a = $userId;
$b = $friendId;
$stmt2->execute();

$a = $friendId;
$b = $userId;
$stmt2->execute();

edited May 8, 2014 at 14:49

answered May 8, 2014 at 14:34

Thiago França

1,8571 gold badge16 silver badges20 bronze badges

1 Comment

Thiago França Over a year ago

@user3522457 you're using mysqli or pdo?

Collectives™ on Stack Overflow

bind param usage on multiple values with single query

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related