PHP a little help

[medib]

hi
I have this problem I'm using laravel livewire and I want to paginate a table using JSON data that I got from curl. I wonder if anyone can help. i don't know if it's ok to post the link just to give you an idea of what i want. i dont want to paginate from the database

 

[Ordep-20]

Did you try the simple html Js pagination, get the table if from DB,


If is from DB you can use Limit range in SQL;


Example


<?php

global $html;
global $total_records;
global $total_pages;
global $page;


$results_per_page = (int)10;


 if(isset($_GET['page']))
 {
      $page = (int) $_GET['page'];
      $page = (int) $page -1;
      $page = (int) $page * $results_per_page;
  }
else $page =0;


$SQL = 'SELECT COUNT(id) FROM  TABLE X  WHERE';

$total_records = $count;  // VALUE WITCH IS THE RETURN OF THIS SQL;

// Lets Calculate the total of pages

 
if($total_records>$results_per_page)
{
    $total_pages = ceil($total_records / $results_per_page); //get the total records and divide from the amount of data  you want show in this case will be 10  
}
else $total_pages=1;

// Now get the data

$SQL= 'SELECT  (FIELDS) FROM YourTable a (LEFT, RIGHT) JOIN  Table b   Limit '.$page.' , '.$results_per_page

Now we have to use the JS

   $(document).ready(function ()
    {
        totalPages = <?=$total_pages?>; //This tag <?= passes the value from PHP to Js
        totalRecords = "<?=$total_records?>";
        if((totalRecords)>10)
        {
            for (let i = 1; i < totalPages; i++)
            {
                $(".pagination").append('<a id="'+(i+1)+'" onclick="toNextPage(this);">'+(i+1)+'</a>');
                if(i+1===totalPages)
                {
                    $(".pagination").append('<a onclick="toLastPage(this);">&raquo;</a>');
                }
            }
           
        }
   
        $("#navpage").css("visibility", "visible");
        $("#navpage").css("display", "block");
        $("#navpage").removeClass("hidden").addClass("active");
       
     
    function toFirstPage()
    {
        location.href='url?page='+1;
    }

    function toLastPage()
    {
        location.href='url?page='+totalPages;
    }

    function toNextPage(page)
    {
        last_id= page.id-1;
        location.href='url?page='+page.id;
        event.preventDefault();
     
    }
     

    });

?>

 

[Ordep-20]

if you want use from JSON yes its possible, but you have to 'slice' the data all using JS, can you post the JSON data