->let()
Assigns a value as a parameter for this connection.
Method Syntax$db->let($key, $val)
Arguments | Description | ||
---|---|---|---|
key required | Specifies the name of the variable. | ||
val required | Assigns the value to the variable name. |
// 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.