PHP-MySQLi-Database-Class
PHP-MySQLi-Database-Class copied to clipboard
Pagination and join
How can i use the pagination with a join?
$page = 1; $db->pageLimit = 2; $db->join("recept_types rt", "rt.id=r.type_id", "INNER"); $products = $db->paginate("products", $page); echo "showing $page out of " . $db->totalPages;
How can i change the italic part?
Did you ever manage to do this, I want to do the same?
Can't you just use the fluent api for this?
$result = $database->objectBuilder()->join(...)->paginate(...);
Works fine for me with version 2.9.3 on PHP 7.4