What is the difference between bind_param() and bindParam()?

Question

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?

Answer 1

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

Answer 2

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