Single record

// media($searchBy, $value)
$media = $fetcher->media('title', 'Nature Photo');

// article($searchBy, $value, $level = 0)
$article = $fetcher->article('slug', 'php-basics', 2);

// user($searchBy, $value)
$user = $fetcher->user('username', 'john_doe');

// category($searchBy, $value)
$category = $fetcher->category('name', 'Technology');

// tag($searchBy, $value)
$tag = $fetcher->tag('tags', 'coding');

// role($searchBy, $value)
$role = $fetcher->role('name', 'Admin');

// preference($searchBy, $value)
$preference = $fetcher->preference('key', 'dark_mode');

// webset($searchBy, $value)
$webset = $fetcher->webset('key', 'site_name');

Multiple records

// medias($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$medias = $fetcher->medias('title', 'Nature Photo', 1, 10, 'id', 'ASC');

// articles($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC', $level = 0)
$articles = $fetcher->articles('title', 'PHP Basics', 1, 10, 'id', 'DESC', 1);

// users($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$users = $fetcher->users('username', 'john_doe');

// categories($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$categories = $fetcher->categories('name', 'Technology');

// tags($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$tags = $fetcher->tags('tags', 'coding');

// roles($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$roles = $fetcher->roles('name', 'Admin');

// websets($searchBy, $value, $page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$websets = $fetcher->websets('key', 'site_name');

All records

// allMedia($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$allMedias = $fetcher->allMedia(1, 10, 'id', 'ASC');

// allArticles($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC', $level = 0)
$allArticles = $fetcher->allArticles(1, 10, 'id', 'DESC', 2);

// allUsers($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$allUsers = $fetcher->allUsers();

// allCategories($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$allCategories = $fetcher->allCategories();

// allTags($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$allTags = $fetcher->allTags();

// allRoles($page = 1, $recordsPerPage = 10, $sortBy = 'id', $sortOrder = 'ASC')
$allRoles = $fetcher->allRoles();

// allWebsets($page = 1, $recordsPerPage = 10, $sortBy = 'key', $sortOrder = 'ASC')
$allWebsets = $fetcher->allWebsets();

// allLevels()
$levels = $fetcher->allLevels();

Count records

// countMedia($filter = '')
$mediaCount = $fetcher->countMedia();

// countArticles($filter = '')
$articleCount = $fetcher->countArticles(['level' => '<=2']);

// countUsers($filter = '')
$userCount = $fetcher->countUsers(['role_id' => 1]);

// countCategories($filter = '')
$categoryCount = $fetcher->countCategories(['name' => 'Technology']);

// countTags($filter = '')
$tagCount = $fetcher->countTags();

// countRoles($filter = '')
$roleCount = $fetcher->countRoles(['level' => 1]);

// countWebsets($filter = '')
$websetCount = $fetcher->countWebsets(['key' => 'site_name']);

Filter example

$filter = [
  'level' => '>=2',
  'status' => 'active',
  'FIND_IN_SET("php", REPLACE(tags, ", ", ","))' => 'php'
];

$count = $fetcher->countArticles($filter);