Set maximum row of the table with page-break and show remaining data to next page
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I want to set the maximum number of row in each table and continue the data to the next page in the html. For example, I have 44 records and I need to show only 10 records in first html page and another 10 in another html page and goes on and finally with the last 4 records in the last page. I just need to know the logic to be used in this with for loop.
I tried this to display the first 10 records but, how to display the other records
<% for (var i = 0; i < 10; i++) { %>
html node.js row page-break
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
add a comment |
I want to set the maximum number of row in each table and continue the data to the next page in the html. For example, I have 44 records and I need to show only 10 records in first html page and another 10 in another html page and goes on and finally with the last 4 records in the last page. I just need to know the logic to be used in this with for loop.
I tried this to display the first 10 records but, how to display the other records
<% for (var i = 0; i < 10; i++) { %>
html node.js row page-break
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
add a comment |
I want to set the maximum number of row in each table and continue the data to the next page in the html. For example, I have 44 records and I need to show only 10 records in first html page and another 10 in another html page and goes on and finally with the last 4 records in the last page. I just need to know the logic to be used in this with for loop.
I tried this to display the first 10 records but, how to display the other records
<% for (var i = 0; i < 10; i++) { %>
html node.js row page-break
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
I want to set the maximum number of row in each table and continue the data to the next page in the html. For example, I have 44 records and I need to show only 10 records in first html page and another 10 in another html page and goes on and finally with the last 4 records in the last page. I just need to know the logic to be used in this with for loop.
I tried this to display the first 10 records but, how to display the other records
<% for (var i = 0; i < 10; i++) { %>
html node.js row page-break
html node.js row page-break
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
edited Jan 4 at 14:38
Brian Tompsett - 汤莱恩
4,2571339104
4,2571339104
asked Jan 4 at 6:43
TinaTina
188
asked Jan 4 at 6:43
TinaTina
188
asked Jan 4 at 6:43
TinaTina
188
188
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I guess you need a simple pager but with data on different independent pages
Here is a part of code ... you just need to change $pageno variable to current page .. or you can catch it with GET or extract from pagename.
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 10;
$offset = ($pageno-1) * $no_of_records_per_page;
$conn=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$total_pages_sql = "SELECT COUNT(*) FROM table";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$sql = "SELECT * FROM table LIMIT $offset, $no_of_records_per_page";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
//here goes the data
}
mysqli_close($conn);
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
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%2f54034164%2fset-maximum-row-of-the-table-with-page-break-and-show-remaining-data-to-next-pag%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I guess you need a simple pager but with data on different independent pages
Here is a part of code ... you just need to change $pageno variable to current page .. or you can catch it with GET or extract from pagename.
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 10;
$offset = ($pageno-1) * $no_of_records_per_page;
$conn=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$total_pages_sql = "SELECT COUNT(*) FROM table";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$sql = "SELECT * FROM table LIMIT $offset, $no_of_records_per_page";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
//here goes the data
}
mysqli_close($conn);
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
add a comment |
I guess you need a simple pager but with data on different independent pages
Here is a part of code ... you just need to change $pageno variable to current page .. or you can catch it with GET or extract from pagename.
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 10;
$offset = ($pageno-1) * $no_of_records_per_page;
$conn=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$total_pages_sql = "SELECT COUNT(*) FROM table";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$sql = "SELECT * FROM table LIMIT $offset, $no_of_records_per_page";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
//here goes the data
}
mysqli_close($conn);
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
add a comment |
I guess you need a simple pager but with data on different independent pages
Here is a part of code ... you just need to change $pageno variable to current page .. or you can catch it with GET or extract from pagename.
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 10;
$offset = ($pageno-1) * $no_of_records_per_page;
$conn=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$total_pages_sql = "SELECT COUNT(*) FROM table";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$sql = "SELECT * FROM table LIMIT $offset, $no_of_records_per_page";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
//here goes the data
}
mysqli_close($conn);
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
I guess you need a simple pager but with data on different independent pages
Here is a part of code ... you just need to change $pageno variable to current page .. or you can catch it with GET or extract from pagename.
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 10;
$offset = ($pageno-1) * $no_of_records_per_page;
$conn=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$total_pages_sql = "SELECT COUNT(*) FROM table";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
$sql = "SELECT * FROM table LIMIT $offset, $no_of_records_per_page";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
//here goes the data
}
mysqli_close($conn);
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
answered Jan 4 at 7:03
Boris JanjetovicBoris Janjetovic
8413
8413
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%2f54034164%2fset-maximum-row-of-the-table-with-page-break-and-show-remaining-data-to-next-pag%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
