public function index()
{
$data = array();
$blogCollection = new BlogCollection();
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$perPage = 5;
$offset = $page ? ($page - 1) * $perPage : 0;
$rows = count($blogCollection->getAll());
$pagination = new Pagination();
$pagination->setPerPage($perPage);
$pagination->setTotalRows($rows);
$pagination->setBaseUrl("http://localhost/Lectures/Lek15/softacadTours/index.php?c=blog&m=index");
$blogs = $blogCollection->getAll(array(), $offset, $perPage);
$data['blogs'] = $blogs;
$data['pagination'] = $pagination;
$this->loadFrontView('blog/listing', $data);
}
public function index()
{
if (!$this->loggedIn()) {
header('Location: index.php?c=login&m=login');
}
$data = array();
$usersCollection = new UserCollection();
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$perPage = 5;
$offset = $page ? ($page - 1) * $perPage : 0;
$rows = count($usersCollection->getAll());
$pagination = new Pagination();
$pagination->setPerPage($perPage);
$pagination->setTotalRows($rows);
$pagination->setBaseUrl("http://localhost/Lectures/Lek15/softacadTours/admin/index.php?c=user&m=index");
$users = $usersCollection->getAll(array(), $offset, $perPage);
$data['users'] = $users;
$data['pagination'] = $pagination;
$this->loadView('users/listing', $data);
}
public function index()
{
$data = array();
$categoryId = isset($_GET['id']) ? $_GET['id'] : 0;
$toursCollection = new ToursCollection();
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$perPage = 6;
$offset = $page ? ($page - 1) * $perPage : 0;
if ($categoryId > 0) {
$where = array('category_id' => $categoryId);
$rows = count($toursCollection->getAll($where));
$tours = $toursCollection->getAll($where, $offset, $perPage);
} else {
$rows = count($toursCollection->getAll());
$tours = $toursCollection->getAll(array(), $offset, $perPage);
}
$pagination = new Pagination();
$pagination->setPerPage($perPage);
$pagination->setTotalRows($rows);
$pagination->setBaseUrl("http://localhost/Lectures/Lek15/softacadTours/index.php?c=tours&m=index&id=" . $categoryId);
$data['pagination'] = $pagination;
$data['tours'] = $tours;
$this->loadFrontView('tours/listing', $data);
}
public function index()
{
$data = array();
if (!$this->loggedIn()) {
header('Location: index.php?c=login&m=login');
}
$search = isset($_GET['search']) ? $_GET['search'] : '';
if (trim($search) != '') {
$like = array('name', htmlspecialchars(trim($search)));
} else {
$like = array();
}
$perPageSelect = isset($_GET['perPage']) ? (int) $_GET['perPage'] : 0;
switch ($perPageSelect) {
case 0:
$perPage = 10;
break;
case 1:
$perPage = 5;
break;
case 2:
$perPage = 10;
break;
case 3:
$perPage = 20;
break;
case 4:
$perPage = 50;
break;
default:
$perPage = 10;
}
$orderBy = isset($_GET['orderBy']) ? (int) $_GET['orderBy'] : 0;
switch ($orderBy) {
case 0:
$order = array('id', 'DESC');
break;
case 1:
$order = array('name', 'ASC');
break;
case 2:
$order = array('name', 'DESC');
break;
case 3:
$order = array('category_id', 'ASC');
break;
case 4:
$order = array('category_id', 'DESC');
break;
default:
$order = array('id', 'DESC');
}
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$offset = $page ? ($page - 1) * $perPage : 0;
$toursCollection = new ToursCollection();
$rows = count($toursCollection->getAll(array(), -1, 0, $order, $like)) == 0 ? 1 : count($toursCollection->getAll(array(), -1, 0, $order, $like));
$pagination = new Pagination();
$pagination->setPerPage($perPage);
$pagination->setTotalRows($rows);
$pagination->setBaseUrl("http://localhost/Lectures/Lek15/softacadTours/admin/index.php?c=tour&m=index&perPage={$perPageSelect}&orderBy={$orderBy}&search={$search}");
$tours = $toursCollection->getAll(array(), $offset, $perPage, $order, $like);
$data['tours'] = $tours;
$data['pagination'] = $pagination;
$data['search'] = $search;
$data['perPageSelect'] = $perPageSelect;
$data['orderBy'] = $orderBy;
$data['page'] = $page;
$this->loadView('tours/listing', $data);
}
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<?php
$usersCollection = new UserCollection();
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$perPage = 5;
$offset = $page ? ($page - 1) * $perPage : 0;
$rows = count($usersCollection->getAll());
$pagination = new Pagination();
$pagination->setPerPage($perPage);
$pagination->setTotalRows($rows);
$pagination->setBaseUrl("http://localhost/Lectures/Lek15/softacadTours/admin/users.php");
$users = $usersCollection->getAll(array(), $offset, $perPage);
foreach ($users as $user) {
?>
<tr>
<td><?php
echo $user->getUsername();
?>
</td>
<td class="center"><?php
echo $user->getEmail();
?>
</td>
<td class="center"><?php