->let()
Assigns a value as a parameter for this connection.
Method Syntax$db->let($key, $val)
Arguments
| Arguments | Description | ||
|---|---|---|---|
key | Specifies the name of the variable. | ||
val | Assigns the value to the variable name. |
Example Usage
// Assign the variable on the connection
$db->let('name', [
"first" => "Tobie",
"last" => "Morgan Hitchcock",
]);
// Use the variable in a subsequent query
$db->query('CREATE person SET name = $name');
// Use the variable in a subsequent query
$db->query('SELECT * FROM person WHERE name.first = $name.first');
You can remove the variable from the connection using the unset() method.