phpmysqlamazon-simpledb

How to do pagination in simpledb

I have tried offset in simpledb but it's not working as it was working in MySQL. I want to do paging for my database API in PHP so that I send the pagenumber and pagelength to the query and it will return the data of that page only.

How can I do this in simpledb?

    select * from second 
where time_stamp is not null and gibid = '54' and gibview = 'O' 
order by time_stamp asc limit $pagelength

Offset is not working so I can't add offset in query. I have Googled and find there is next token is returned but I am not getting nexttoken. How to check for nexttoken?

Solution

  • Done By Using NextToken in simple db 

    $files = $this->db->select($domain, $query, $offset)

    Here $offset is nexttoken string which will pass in query. and will return next page.