let | SurrealDB Docs

Assigns a value as a parameter for this connection.

Method Syntax

$db->let($name, $value)

Arguments

Arguments	Type	Description
`name`	`string`	Specifies the name of the variable.
`value`	`mixed`	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.