Message:

This question already has answers here:

My Answer:
You can use the `bindParam` method in PHP PDO to bind named parameters of a prepared statement without knowing their names. Here is an example:

php

$stmt = $pdo->prepare("SELECT * FROM table WHERE column1 = :value1 AND column2 = :value2");



$values = array(':value1' => 'some_value1', ':value2' => 'some_value2');



foreach ($values as $key => $value) {

    $stmt->bindParam($key, $value);

}



$stmt->execute();

In this example, we have a prepared statement with named parameters `:value1` and `:value2`. We then create an array `$values` with the parameter names as keys and their values. We loop through the array and bind each parameter using the `bindParam` method. Finally, we execute the statement.

Rate this post

5 of 5 based on 2901 votes

John Davidson

mysql - In PHP PDO, how can I bind named parameters of a prepared statement without knowing their names?