| public fetchRelations ( string $sql, array $params = [] ) : array | ||
| $sql | string | SQL query with placeholders "SELECT '__users', u.*, '__users_profile', up.* FROM users u LEFT JOIN users_profile up ON up.userId = u.id WHERE u.name = :name" |
| $params | array | params for query placeholders (optional) array (':name' => 'John') |
| return | array | |
public function fetchRelations($sql, $params = [])
{
$stmt = $this->prepare($sql, $params);
$result = $stmt->fetchAll(\PDO::FETCH_ASSOC);
// prepare results
$result = Relations::fetch($result);
$stmt->closeCursor();
$this->ok();
return $result;
}