5

I'm confused finding the difference between bind_param() and bindParam() as both are supported in PHP5 but one takes type as the first parameter and other takes a placeholder. Can someone give me an example of when to use one or the other?

doelleri
  • 19,232
  • 5
  • 61
  • 65
user2904995
  • 93
  • 1
  • 5
  • 6
    which class contains `bind_param`? Current PDO doesn't look like it contains a `bind_param` method http://php.net/manual/en/book.pdo.php – dm03514 Oct 21 '13 at 23:12

2 Answers2

14

bind_param is a method on mysqli_stmt:

mysqli_stmt - bind_param

bindParam is a method on PDOStatement:

PDOStatement - bindParam

The difference?

  • mysqli is a replacement for the deprecated mysql functions
  • PDO (PHP Data Objects) is a general database abstraction layer with support for MySQL, but also many other databases (sqlite, postgresql, oracle,...).

For more info look at this:

What is the difference between mysql, mysqli and pdo

Community
  • 1
  • 1
Jeroen
  • 982
  • 1
  • 6
  • 14
5

bind_param() is mysqli and bindParam() is PDO. Apples and Oranges.

phil-lavin
  • 1,187
  • 7
  • 19