Get Started

Upgrade

Where Syntax

Query

Aggregation

Fetch

Transaction

Management

Advanced

Raw object

PDO object

Debug

Information

version: 2.1.12

get

Get only one record from the table.

get($table, $columns, $where)
get($table, $join, $columns, $where)
Return: [string/array/int/object] Return the data of the column.
$email = $database->get("account", "email", [
	"user_id" => 1234
]);

// $email = "foo@bar.com"

$profile = $database->get("account", [
	"email",
	"gender",
	"location"
], [
	"user_id" => 1234
]);

// $profile = array(
// 	"email" => "foo@bar.com",
// 	"gender" => "female",
// 	"location" => "earth"
// )

$data = $database->get("post", [
	"[>]account" => "user_id"
], [
	"post.content",
	"account.user_name",
	"account.location"
], [
	"ORDER" => "post.rate"
]);

// $data = array(
// 	"content" => "A new day",
// 	"user_name" => "foo",
// 	"location" => "earth"
// )