PHP bindParam() function with multiple parameters

Question

I have the following code:

$selectUserQuery = 'SELECT email_address, password FROM user WHERE email_address = :email_address AND password = :password';
$prepSelectUser = $conn->prepare($selectUserQuery);
/*
* HOW DO I ADD MULTIPLE PARAMETERS TO THIS BINDPARAM() FUNCTION?
*/
$prepSelectUser->bindParam(':email_address', $email, PDO::PARAM_INT);
$prepSelectUser->execute();
$userResult = $prepSelectUser->fetchAll();
$userCount = count($userResult);

How can I add multiple parameters to the bindParam() function?

You just call bindParam() once for each parameter you wish to bind — DaveRandom
– DaveRandom, Commented Mar 28, 2014 at 12:14

Your Common Sense · Accepted Answer · 2014-03-28 12:16:17Z

6

You don't actually need this function at all. as well as most of other code you used.

$sql  = 'SELECT 1 FROM user WHERE email_address = ? AND password = ?';
$stmt = $conn->prepare($sql);
$stmt->execute([$email, $password]);
$userCount = $stmt->fetchColumn();

answered Mar 28, 2014 at 12:16

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Comments

dkasipovic · Accepted Answer · 2014-03-28 12:15:43Z

1

First, change

$prepSelectUser->bindParam(':email_address', $email, PDO::PARAM_INT);

to

$prepSelectUser->bindParam(':email_address', $email, PDO::PARAM_STR);

then call another bindParam, like

$prepSelectUser->bindParam(':password', $password, PDO::PARAM_STR);

answered Mar 28, 2014 at 12:15

dkasipovic

6,1301 gold badge23 silver badges27 bronze badges

1 Comment

user3456043 Over a year ago

Okay, yeah I noticed the mistake. I made it because I had copied this code from another website and didn't really understand PDO (it looks like Arabic at the beginning :D). I fixed it, changed it into STR. So basically, I just need to add a second bindParam() function to get this to work? Thanks!

Collectives™ on Stack Overflow

PHP bindParam() function with multiple parameters

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related