aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Lee <alee14498@protonmail.com>2024-02-07 18:29:24 -0500
committerAndrew Lee <alee14498@protonmail.com>2024-02-07 18:29:24 -0500
commit7474e6255b5f9d5a67770b2613d0668056224f2d (patch)
treeff5f294129efe89c27979ad8364c5b0848181fcd
parentb21f48d0a0b3c6d32b8eb9a3b5c84f8ff3dbc136 (diff)
downloadpersonal-website-7474e6255b5f9d5a67770b2613d0668056224f2d.tar.gz
personal-website-7474e6255b5f9d5a67770b2613d0668056224f2d.tar.bz2
personal-website-7474e6255b5f9d5a67770b2613d0668056224f2d.zip
Fixed pagination
-rw-r--r--src/components/Guestbook.jsx6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/components/Guestbook.jsx b/src/components/Guestbook.jsx
index caa092a..c2df8e2 100644
--- a/src/components/Guestbook.jsx
+++ b/src/components/Guestbook.jsx
@@ -16,9 +16,9 @@ class Guestbook extends Component {
const start = (page - 1) * perPage;
const end = start + perPage - 1;
- let { data: messages, error } = await supabase
+ let { data: messages, error, count } = await supabase
.from('guestbook')
- .select('*')
+ .select('*', { count: 'exact' })
.range(start, end)
.order('created_at', { ascending: false });
if (error) {
@@ -27,7 +27,7 @@ class Guestbook extends Component {
} else {
this.setState({
message: messages,
- totalPages: Math.ceil(messages.length / perPage)
+ totalPages: Math.ceil(count / perPage)
});
}
}