SurrealQL statements against the database.
Method Syntax$db->query($query, $vars)
Arguments | Description | ||
---|---|---|---|
$query required | Specifies the SurrealQL statements. | ||
$vars optional | 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;