CODEWITHSUNDEEP
phppdo
user2062756
user2062756

Reputation: 59

What the difference between bindParam and execute(array)?

$stmt = $this->_db->prepare("SELECT userid FROM users WHERE login = ? AND md5pass = ?");
#$stmt->bindParam(1, $login, PDO::PARAM_INT);
#$stmt->bindParam(2, $pass, PDO::PARAM_STR);
$stmt->execute(array($login,$pass));
$res = $stmt->fetch(PDO::FETCH_NUM);

Which way is better to transfer variables to prepeared statment bindParam or execute(array)? Both working but what is differense? Only PDO::PARAM checking? For SELECT I think array would be enough and for INSERT I sould use the bindParam. Am I right? Thanks to all. Just learning =)

Upvotes: 3

Views: 2067

Answers (1)

PeeHaa
PeeHaa

Reputation: 72662

With bindParam you can add the datatype and also important with bind param you are binding the variables by reference.

Upvotes: 4

Related Questions