->query()
Runs a set of SurrealQL statements against the database.
Method Syntax$db->query($query, $vars)
Arguments | Type | Description | |||
---|---|---|---|---|---|
$query required | string | Specifies the SurrealQL statements. | |||
$vars optional | associative array | Assigns variables which can be used in the query. |
// Assign the variable on the connection $result = db->query( 'CREATE person SET name = "John"; SELECT * FROM type::table($tb);', [ "tb" => "person" ] ); // Get the first result from the first query $created = $result[0]->result[0]; // Get all of the results from the second query $people = $result[1]->result;