<?php
//https://codeshack.io/how-to-create-pagination-php-mysql/
$mysqli = mysqli_connect('127.0.0.1', 'root', '123', 'iveco_fisa_turului_vehicul');
$total_pages = $mysqli->query('SELECT * FROM fisa_turului_vehicul')->num_rows;
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1;
$num_results_on_page = 5;
if ($stmt = $mysqli->prepare('SELECT * FROM fisa_turului_vehicul ORDER BY id LIMIT ?,?')) {
$calc_page = ($page - 1) * $num_results_on_page;
$stmt->bind_param('ii', $calc_page, $num_results_on_page);
$stmt->execute();
$result = $stmt->get_result();
$stmt->close();
}
if (ceil($total_pages / $num_results_on_page) > 0): ?>
<ul class="pagination-list">
<?php if ($page > 1): ?>
<li class="prev"><a href="1.php?page=<?php echo $page-1 ?>">Prev</a></li>
<?php endif; ?>
<?php if ($page > 3): ?>
<li class="start"><a href="1.php?page=1">1</a></li>
<li class="dots">...</li>
<?php endif; ?>
<?php if ($page-2 > 0): ?><li class="page"><a href="1.php?page=<?php echo $page-2 ?>"><?php echo $page-2 ?></a></li><?php endif; ?>
<?php if ($page-1 > 0): ?><li class="page"><a href="1.php?page=<?php echo $page-1 ?>"><?php echo $page-1 ?></a></li><?php endif; ?>
<li class="currentpage"><a href="1.php?page=<?php echo $page ?>"><?php echo $page ?></a></li>
<?php if ($page+1 < ceil($total_pages / $num_results_on_page)+1): ?><li class="page"><a href="1.php?page=<?php echo $page+1 ?>"><?php echo $page+1 ?></a></li><?php endif; ?>
<?php if ($page+2 < ceil($total_pages / $num_results_on_page)+1): ?><li class="page"><a href="1.php?page=<?php echo $page+2 ?>"><?php echo $page+2 ?></a></li><?php endif; ?>
<?php if ($page < ceil($total_pages / $num_results_on_page)-2): ?>
<li class="dots">...</li>
<li class="end"><a href="1.php?page=<?php echo ceil($total_pages / $num_results_on_page) ?>"><?php echo ceil($total_pages / $num_results_on_page) ?></a></li>
<?php endif; ?>
<?php if ($page < ceil($total_pages / $num_results_on_page)): ?>
<li class="next"><a href="1.php?page=<?php echo $page+1 ?>">Next</a></li>
<?php endif; ?>
</ul>
<?php endif; ?>
<!DOCTYPE html>
<html>
<head>
<title>PHP & MySQL Pagination by CodeShack</title>
<meta charset="utf-8">
<style>
html {
font-family: Tahoma, Geneva, sans-serif;
padding: 20px;
background-color: #F8F9F9;
}
#pagination-table {
border-collapse: collapse;
width: 500px;
}
#pagination-table td, #tpagination-table th {
padding: 10px;
}
#pagination-table th {
background-color: #54585d;
color: #ffffff;
font-weight: bold;
font-size: 13px;
border: 1px solid #54585d;
}
#pagination-table td {
color: #636363;
border: 1px solid #dddfe1;
}
#pagination-table tr {
background-color: #f9fafb;
}
#pagination-table tr:nth-child(odd) {
background-color: #ffffff;
}
.pagination-list {
list-style-type: none;
padding: 10px 0;
display: inline-flex;
justify-content: space-between;
box-sizing: border-box;
}
.pagination-list li {
box-sizing: border-box;
padding-right: 10px;
}
.pagination-list li a {
box-sizing: border-box;
background-color: #e2e6e6;
padding: 8px;
text-decoration: none;
font-size: 12px;
font-weight: bold;
color: #616872;
border-radius: 4px;
}
.pagination-list li a:hover {
background-color: #d4dada;
}
.pagination-list .next a, .pagination-list .prev a {
text-transform: uppercase;
font-size: 12px;
}
.pagination-list .currentpage a {
background-color: #518acb;
color: #fff;
}
.pagination-list .currentpage a:hover {
background-color: #518acb;
}
</style>
</head>
<body>
hello
<table id="pagination-table">
<tr>
<th>id</th>
<th>data</th>
<th>cansilier</th>
</tr>
<?php while ($row = $result->fetch_assoc()): ?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['data']; ?></td>
<td><?php echo $row['consilier']; ?></td>
</tr>
<?php endwhile; ?>
</table>
</body>
</html>
No comments:
Post a Comment