PHP pagination on table
So for a school project, I'm making an inventory system, one of the pages contains a table with all the available stock. But there is way too much data to display in the table and I don't want the table to be 300 records long. So i decided I wanted to implement pagination on the already existing table. Now the thing is that I have no idea where to begin. I'm doing this with Object-oriented PHP. I hope someone can send me into the right direction of where to begin.
PHP code where i fill my table with data:
<?php
require_once('classes/Database.php');
$db = new Database;
$query = $db->query("SELECT * FROM producten");
$count = $query->rowCount();
if($count > 0) {
while($row = $query->fetch())
{
echo "<tr>";
echo "<td id='td1'>" . $row[0] . "</td>";
echo "<td id='td2'>" . $row[1] . "</td>";
echo "<td id='td3'>" . $row[2] . "</td>";
echo "<td id='td4'>" . $row[3] . "</td>";
echo "<td id='td4'>" . $row[4] . "</td>";
echo "<td id='td5'><a onclick='document.getElementById("id").value=".$row[0]."' data-toggle='modal' data-target='#exampleModal' href=''><img data-toggle='tooltip' data-id='$row[0]' data-placement='top' title='Edit' src='img/edit.svg' height='25'></a></td>";
echo "<td id='td6'><a id='btn_link' href='php/Delete.php?id=".$row[0]."'><img data-toggle='tooltip' data-placement='top' title='Delete' src='img/delete_2.svg' height='25'></a></td>";
//echo "<td id='td5'><button type='button' class='btn btn-danger'>Delete</button></td>";
echo "</tr>";
}
}
?>
Then in my HTML file, I just include this PHP file so it's being displayed on the page.
php
add a comment |
So for a school project, I'm making an inventory system, one of the pages contains a table with all the available stock. But there is way too much data to display in the table and I don't want the table to be 300 records long. So i decided I wanted to implement pagination on the already existing table. Now the thing is that I have no idea where to begin. I'm doing this with Object-oriented PHP. I hope someone can send me into the right direction of where to begin.
PHP code where i fill my table with data:
<?php
require_once('classes/Database.php');
$db = new Database;
$query = $db->query("SELECT * FROM producten");
$count = $query->rowCount();
if($count > 0) {
while($row = $query->fetch())
{
echo "<tr>";
echo "<td id='td1'>" . $row[0] . "</td>";
echo "<td id='td2'>" . $row[1] . "</td>";
echo "<td id='td3'>" . $row[2] . "</td>";
echo "<td id='td4'>" . $row[3] . "</td>";
echo "<td id='td4'>" . $row[4] . "</td>";
echo "<td id='td5'><a onclick='document.getElementById("id").value=".$row[0]."' data-toggle='modal' data-target='#exampleModal' href=''><img data-toggle='tooltip' data-id='$row[0]' data-placement='top' title='Edit' src='img/edit.svg' height='25'></a></td>";
echo "<td id='td6'><a id='btn_link' href='php/Delete.php?id=".$row[0]."'><img data-toggle='tooltip' data-placement='top' title='Delete' src='img/delete_2.svg' height='25'></a></td>";
//echo "<td id='td5'><button type='button' class='btn btn-danger'>Delete</button></td>";
echo "</tr>";
}
}
?>
Then in my HTML file, I just include this PHP file so it's being displayed on the page.
php
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
2
Look into the MySQLLIMIT
clause
– Scuzzy
Nov 20 '18 at 10:57
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43
add a comment |
So for a school project, I'm making an inventory system, one of the pages contains a table with all the available stock. But there is way too much data to display in the table and I don't want the table to be 300 records long. So i decided I wanted to implement pagination on the already existing table. Now the thing is that I have no idea where to begin. I'm doing this with Object-oriented PHP. I hope someone can send me into the right direction of where to begin.
PHP code where i fill my table with data:
<?php
require_once('classes/Database.php');
$db = new Database;
$query = $db->query("SELECT * FROM producten");
$count = $query->rowCount();
if($count > 0) {
while($row = $query->fetch())
{
echo "<tr>";
echo "<td id='td1'>" . $row[0] . "</td>";
echo "<td id='td2'>" . $row[1] . "</td>";
echo "<td id='td3'>" . $row[2] . "</td>";
echo "<td id='td4'>" . $row[3] . "</td>";
echo "<td id='td4'>" . $row[4] . "</td>";
echo "<td id='td5'><a onclick='document.getElementById("id").value=".$row[0]."' data-toggle='modal' data-target='#exampleModal' href=''><img data-toggle='tooltip' data-id='$row[0]' data-placement='top' title='Edit' src='img/edit.svg' height='25'></a></td>";
echo "<td id='td6'><a id='btn_link' href='php/Delete.php?id=".$row[0]."'><img data-toggle='tooltip' data-placement='top' title='Delete' src='img/delete_2.svg' height='25'></a></td>";
//echo "<td id='td5'><button type='button' class='btn btn-danger'>Delete</button></td>";
echo "</tr>";
}
}
?>
Then in my HTML file, I just include this PHP file so it's being displayed on the page.
php
So for a school project, I'm making an inventory system, one of the pages contains a table with all the available stock. But there is way too much data to display in the table and I don't want the table to be 300 records long. So i decided I wanted to implement pagination on the already existing table. Now the thing is that I have no idea where to begin. I'm doing this with Object-oriented PHP. I hope someone can send me into the right direction of where to begin.
PHP code where i fill my table with data:
<?php
require_once('classes/Database.php');
$db = new Database;
$query = $db->query("SELECT * FROM producten");
$count = $query->rowCount();
if($count > 0) {
while($row = $query->fetch())
{
echo "<tr>";
echo "<td id='td1'>" . $row[0] . "</td>";
echo "<td id='td2'>" . $row[1] . "</td>";
echo "<td id='td3'>" . $row[2] . "</td>";
echo "<td id='td4'>" . $row[3] . "</td>";
echo "<td id='td4'>" . $row[4] . "</td>";
echo "<td id='td5'><a onclick='document.getElementById("id").value=".$row[0]."' data-toggle='modal' data-target='#exampleModal' href=''><img data-toggle='tooltip' data-id='$row[0]' data-placement='top' title='Edit' src='img/edit.svg' height='25'></a></td>";
echo "<td id='td6'><a id='btn_link' href='php/Delete.php?id=".$row[0]."'><img data-toggle='tooltip' data-placement='top' title='Delete' src='img/delete_2.svg' height='25'></a></td>";
//echo "<td id='td5'><button type='button' class='btn btn-danger'>Delete</button></td>";
echo "</tr>";
}
}
?>
Then in my HTML file, I just include this PHP file so it's being displayed on the page.
php
php
asked Nov 20 '18 at 10:55
stefan de boerstefan de boer
567
567
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
2
Look into the MySQLLIMIT
clause
– Scuzzy
Nov 20 '18 at 10:57
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43
add a comment |
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
2
Look into the MySQLLIMIT
clause
– Scuzzy
Nov 20 '18 at 10:57
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
2
2
Look into the MySQL
LIMIT
clause– Scuzzy
Nov 20 '18 at 10:57
Look into the MySQL
LIMIT
clause– Scuzzy
Nov 20 '18 at 10:57
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43
add a comment |
2 Answers
2
active
oldest
votes
Try using jQuery DataTables https://datatables.net/, its very easy and useful for handle many record and support Server-side processing .
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
add a comment |
You can use Bootstrap datatable with zero configuration.
Here is the link
You can easily configure as per your preferences and requirements. Go through the docs they are easy to understand.
Other way would be:
Use Mysql query with limit
and offset
but that would be another long way around though.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53391454%2fphp-pagination-on-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try using jQuery DataTables https://datatables.net/, its very easy and useful for handle many record and support Server-side processing .
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
add a comment |
Try using jQuery DataTables https://datatables.net/, its very easy and useful for handle many record and support Server-side processing .
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
add a comment |
Try using jQuery DataTables https://datatables.net/, its very easy and useful for handle many record and support Server-side processing .
Try using jQuery DataTables https://datatables.net/, its very easy and useful for handle many record and support Server-side processing .
answered Nov 20 '18 at 11:09
Javier AgueroJavier Aguero
264
264
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
add a comment |
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
Hey Javier, somehow when I add the CDN's and the jquery to my code, it's not working. Could this be because I'm filling my table in an external file?
– stefan de boer
Nov 20 '18 at 12:35
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
I already fixed the problem, apparently I put the CDN's in the wrong order.
– stefan de boer
Nov 20 '18 at 13:10
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
Nice, remember use "server processing" for database
– Javier Aguero
Nov 22 '18 at 13:21
add a comment |
You can use Bootstrap datatable with zero configuration.
Here is the link
You can easily configure as per your preferences and requirements. Go through the docs they are easy to understand.
Other way would be:
Use Mysql query with limit
and offset
but that would be another long way around though.
add a comment |
You can use Bootstrap datatable with zero configuration.
Here is the link
You can easily configure as per your preferences and requirements. Go through the docs they are easy to understand.
Other way would be:
Use Mysql query with limit
and offset
but that would be another long way around though.
add a comment |
You can use Bootstrap datatable with zero configuration.
Here is the link
You can easily configure as per your preferences and requirements. Go through the docs they are easy to understand.
Other way would be:
Use Mysql query with limit
and offset
but that would be another long way around though.
You can use Bootstrap datatable with zero configuration.
Here is the link
You can easily configure as per your preferences and requirements. Go through the docs they are easy to understand.
Other way would be:
Use Mysql query with limit
and offset
but that would be another long way around though.
answered Nov 20 '18 at 11:03
Dinesh SutharDinesh Suthar
7210
7210
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53391454%2fphp-pagination-on-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Bootstrap Datatables
– Dieter Kräutl
Nov 20 '18 at 10:56
2
Look into the MySQL
LIMIT
clause– Scuzzy
Nov 20 '18 at 10:57
“Now the thing is that I have no idea where to begin.” - why not? This is everything but a new topic, so you should be able to find plenty of resources that explain the basics of how this works.
– misorude
Nov 20 '18 at 11:43