PDO: Binding parameter to connection?

Asked Mar 14 '16 at 01:51

Active Mar 14 '16 at 01:51

Viewed 16 times

Is there any way that one could bind a parameter directly to the connection variable so it could be replaced in every prepared statement?

Could this work? :

$database = 'users';
$pdo_conn = connection variable;
$pdo_conn->bindValue(':usersdb', $database, PDO::PARAM_STR);

// Query
$pdo_query = $pdo_conn->prepare("SELECT * FROM :usersdb.users");

Thanks in advance!

asked Mar 14 '16 at 01:51

Andrei Vlad

Use the variable in the string: `"$database"`. – Rizier123 Mar 14 '16 at 01:54
2

sorry but no, you can't bind table names, column names, just create a whitelist of those – Kevin Mar 14 '16 at 01:57

PDO: Binding parameter to connection?

0 Answers0