Sending Database Requests

Database Actions

A database action defines what format the function should return the data it retrieves from the database in. For more information on Database Actions please see the actions page.

Database Actions

Select

The Select() function allows you to select information from the database.

Select(string $what, string $from, string|null $where, string $action, string|null $order = null, string|null $limit = null)

Parameters

Parameter	Type	Description	Example
$what	string	What it should select.	id
$from	string	The database table (don't include the prefix, it does this automatically).	pages
$where	string or null	Any conditions you require.	`content` IS NOT NULL
$action	string	What it should do with the data.	all:assoc
$order	string or null (optional)	Any specific order you'd like the data in.	`url` DESC
$limit	string or null (optional)	Limit the amount of data being returned.	100

Example: Selecting the logged in user.

use Saturn\DatabaseManager\DBMS;
$DB = new DBMS();

// Returns the first value as a JSON object.
$DB->Select('*', 'user', 'uuid = '.$_SESSION['uuid'], 'first:object');

Insert

The Select() function allows you to insert information into the database.

Insert(string $into, string $columns, string $values);

Parameters

Parameter	Type	Description	Example
$into	string	The database table (don't include the prefix, it does this automatically).	id
$columns	string	The columns to insert data into.	pages
$values	string	The data to insert.	`content` IS NOT NULL

Example: Creating a new page.

use Saturn\DatabaseManager\DBMS;
$DB = new DBMS();

$DB->Insert("pages", "`id`,`url`,`title`,`content`", "NULL, '/test', 'Test page', 'This is a test page.'");