Quering data
Namespace: Sphp \ Database
The SELECT clause
A SELECT statement retrieves zero or more rows from one or more database tables
or database views.
[1]
The Select object builds a SELECT statement that can be executed in a
database by using a SelectStatement instance. The SelectStatement only
retrieves data from the database and has no persistent effects on the database.
Some essential Select methods:
Synopsis
Methods: public columns ( string ... $columns ) : mixed
public groupBy ( string ... $columns ) : mixed
public orderBy ( string ... $columns ) : static
public limit ( int $limit ,
int $offset = 0 ) : static
Error Call to undefined method Sphp\Documentation\SyntaxHighlighting\AccordionBuilder::setup() code: 0 file: /home3/fjlpxeha/playground.samiholck.fi/manual-app/app/functions.php line: 129 Trace information file: /home3/fjlpxeha/playground.samiholck.fi/manual-app/content/docs/sphp-database-select.php
line: 42
function: Sphp\Manual\codeAccordion
file: /home3/fjlpxeha/playground.samiholck.fi/manual-app/app/php/classes/Man/Routers/ManualPageBuilder.php
line: 58
function: include
arguments: '/home3/fjlpxeha/playground.samiholck.fi/manual-app/content/docs/sphp-database-select.php' file: /home3/fjlpxeha/playground.samiholck.fi/manual-app/app/php/classes/Man/Routers/ManualPageBuilder.php
line: 43
class: Man\Routers\ManualPageBuilder
instance method: parse
arguments: 'sphp-database-select' class: Man\Routers\ManualPageBuilder
instance method: __invoke
arguments: object(Sphp\Router\RouteData) file: /home3/fjlpxeha/playground.samiholck.fi/sphp/php/Sphp/Router/Router.php
line: 149
function: call_user_func
arguments: object(Man\Routers\ManualPageBuilder) object(Sphp\Router\RouteData) file: /home3/fjlpxeha/playground.samiholck.fi/manual-app/app/php/loaders.php
line: 22
class: Sphp\Router\Router
instance method: execute
file: /home3/fjlpxeha/playground.samiholck.fi/index.php
line: 7
function: require_once
arguments: '/home3/fjlpxeha/playground.samiholck.fi/manual-app/app/php/loaders.php'