What the difference between bindParam and execute(array)?

Question

$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 =)

You have answered your question yourself.

Your Common Sense
– Your Common Sense

2013-03-03 11:46:04 +00:00
Commented Mar 3, 2013 at 11:46 — Your Common Sense
– Your Common Sense, Commented Mar 3, 2013 at 11:46
possible duplicate of PDO bindParam vs. execute

Steve Chambers
– Steve Chambers

2014-07-06 07:19:28 +00:00
Commented Jul 6, 2014 at 7:19 — Steve Chambers
– Steve Chambers, Commented Jul 6, 2014 at 7:19

PeeHaa · Accepted Answer · 2013-03-03 11:57:49Z

4

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

answered Mar 3, 2013 at 11:57

PeeHaa

73.1k60 gold badges195 silver badges264 bronze badges

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

Collectives™ on Stack Overflow

What the difference between bindParam and execute(array)?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related