PHP bindParam（）函数有多个参数

Question

What's up guys,

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?

Answer 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);