Paginating content without the need for a database

Question

Paginating content without the need for a database

Seeking assistance on implementing pagination for displaying trading history API responses, without utilizing a database. Can anyone provide guidance and help with the necessary logic?

Here is an excerpt of my code:

     <?php

 error_reporting(E_ALL);

$url = "https://www.myfxbook.com/api/login.json?";

$email="<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="b7d1cfdad6c5dcd2c3d4d6c4c3f7d0dad6dedb99d4d8da">[email protected]</a>";
$password="**********";


$url .= '&email='.$email;
$url .= '&password='.$password;

$ch = curl_init(); 

curl_setopt($ch, CURLOPT_URL,$url); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$result = curl_exec($ch);
$propertyarr = json_decode($result, true);
$session = $propertyarr['session'];
$url2 = "https://www.myfxbook.com/api/get-history.json?";
$url2 .= 'session='.$session;
$url2 .= '&id=908596';

$ch2 = curl_init(); 
curl_setopt($ch2, CURLOPT_URL,$url2); 
curl_setopt($ch2, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch2, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch2, CURLOPT_SSL_VERIFYPEER, false);

$result2 = curl_exec($ch2);
$result2 = json_decode($result2);
$result2 = (array)$result2;


$newres = array();
foreach ($result2 as $res) {
            $newres  = $res;

    }
    var_dump($newres['0']);
    ?>
    <div class="trade_history">
    <div id="trade_titles" align="center" >
        <h>OPEN TIME</h>
        <h>CLOSE TIME</h>
        <h>OPEN PRICE</h>
        <h >CLOSE PRICE</h>
        <h>LOTS</h>
        <h>TYPE</h>
        <h>PAIR</h>
        <h>PIPS</h>
        </div>
    <?php
    //
    //echo '<table border="1">';

    for($i=0;$i<=sizeof($newres)-1;$i++)
    {

        ?>
        <div id="trade_data">
        <div id="opent_time">
                <?php echo $newres[$i]->openTime; ?>
                </div>
                <div id="close_time">
                <?php echo $newres[$i]->closeTime; ?>
                </div>
                <div id="opent_price">
                <?php echo $newres[$i]->openPrice; ?>
                </div>
                <div id="close_price">
                <?php echo $newres[$i]->closePrice; ?>
                </div>
                <div id="lots">
                <?php echo $newres[$i]->sizing->value; ?>
                </div>
                <div id="type">
                <?php echo $newres[$i]->action; ?>
                </div>
                <div id="pair">
                <?php echo $newres[$i]->symbol; ?>
                </div>
                <div id="pips">
                <?php echo $newres[$i]->pips; ?>
                </div>

                </div>
<?php


    }?>
    </div>

Currently, the response is displayed as follows:

Is it possible to format the results in the following manner?

If you can offer any assistance, I would greatly appreciate it. Thank you in advance.

javascript php jquery pagination

Answer 1

Answer №1

Thanks to everyone for their prompt responses.

I finally grasped the logic. Here is the code with the solution provided:

<?php

//error_reporting(E_ALL);

$url = "https://www.myfxbook.com/api/login.json?";

$email="<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="e086988d81928b859483819394a0878d81898cce838f8d">[email protected]</a>";
$password="********";


$url .= '&email='.$email;
$url .= '&password='.$password;

$ch = curl_init(); 

curl_setopt($ch, CURLOPT_URL,$url); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$result = curl_exec($ch);
$propertyarr = json_decode($result, true);
$session = $propertyarr['session'];
$url2 = "https://www.myfxbook.com/api/get-history.json?";
$url2 .= 'session='.$session;
$url2 .= '&id=908596';

$ch2 = curl_init(); 
curl_setopt($ch2, CURLOPT_URL,$url2); 
curl_setopt($ch2, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch2, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch2, CURLOPT_SSL_VERIFYPEER, false);

$result2 = curl_exec($ch2);
$result2 = json_decode($result2);
$result2 = (array)$result2;


$newres = array();
foreach ($result2 as $res) {
            $newres  = $res;

    }
    //var_dump($newres['0']);
    ?>
    
    <div class="trade_history">
    <div id="trade_titles" align="center" >
        <h>OPEN TIME</h>
        <h>CLOSE TIME</h>
        <h>OPEN PRICE</h>
        <h >CLOSE PRICE</h>
        <h>LOTS</h>
        <h>TYPE</h>
        <h>PAIR</h>
        <h>PIPS</h>
        </div>
    
    <?php
    if(empty($_GET['page_num']))
    {
        $page_num=1;
    }
    else
    {
    $page_num = $_GET['page_num'];
    }

    $i=$page_num*10;
    $srow = $i;
    $endrow = $srow-10;
   
    
    for($i=$endrow;$i<=$srow-1;$i++)
    {

        ?>
        
        <div id="trade_data">
        <div id="opent_time">
                <?php echo $newres[$i]->openTime; ?>
                </div>
                <div id="close_time">
                <?php echo $newres[$i]->closeTime; ?>
                </div>
                <div id="opent_price">
                <?php echo $newres[$i]->openPrice; ?>
                </div>
                <div id="close_price">
                <?php echo $newres[$i]->closePrice; ?>
                </div>
                <div id="lots">
                <?php echo $newres[$i]->sizing->value; ?>
                </div>
                <div id="type">
                <?php echo $newres[$i]->action; ?>
                </div>
                <div id="pair">
                <?php echo $newres[$i]->symbol; ?>
                </div>
                <div id="pips">
                <?php echo $newres[$i]->pips; ?>
                </div>

                </div>

<?php


    }?>
    </div>

    <div class="pagination">
            <?php $numpages = count($newres)/10;
            $numpages = ceil($numpages);


            $Path='forex-signals';
            $URI='http://localhost/fx/'.$Path;
            $current = $page_num;
            $prev = $current-1;
            $next = $current+1;


                echo '<div id="first"><a href='.$URI.'?page_num=1#trade_history>First</a></div>';   
                echo '<div id="prev"><a href='.$URI.'?page_num='.$next.'#trade_history>Previous</a></div>';
            for($n=1;$n<=$numpages;$n++)
            {
                echo '<div id="page_num"><a href='.$URI.'?page_num='.$n.'#trade_history>'.$n.'</a></div>';
            }
            echo '<div id="next"><a href='.$URI.'?page_num='.$next.'#trade_history>Next</a></div>';
            echo '<div id="last"><a href='.$URI.'?page_num='.$numpages.'#trade_history>Last</a></div>'; 

            ?>

    </div>

Answer 2

Thanks to everyone for their prompt responses.

I finally grasped the logic. Here is the code with the solution provided:

<?php

//error_reporting(E_ALL);

$url = "https://www.myfxbook.com/api/login.json?";

$email="<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="e086988d81928b859483819394a0878d81898cce838f8d">[email protected]</a>";
$password="********";


$url .= '&email='.$email;
$url .= '&password='.$password;

$ch = curl_init(); 

curl_setopt($ch, CURLOPT_URL,$url); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$result = curl_exec($ch);
$propertyarr = json_decode($result, true);
$session = $propertyarr['session'];
$url2 = "https://www.myfxbook.com/api/get-history.json?";
$url2 .= 'session='.$session;
$url2 .= '&id=908596';

$ch2 = curl_init(); 
curl_setopt($ch2, CURLOPT_URL,$url2); 
curl_setopt($ch2, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch2, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch2, CURLOPT_SSL_VERIFYPEER, false);

$result2 = curl_exec($ch2);
$result2 = json_decode($result2);
$result2 = (array)$result2;


$newres = array();
foreach ($result2 as $res) {
            $newres  = $res;

    }
    //var_dump($newres['0']);
    ?>
    
    <div class="trade_history">
    <div id="trade_titles" align="center" >
        <h>OPEN TIME</h>
        <h>CLOSE TIME</h>
        <h>OPEN PRICE</h>
        <h >CLOSE PRICE</h>
        <h>LOTS</h>
        <h>TYPE</h>
        <h>PAIR</h>
        <h>PIPS</h>
        </div>
    
    <?php
    if(empty($_GET['page_num']))
    {
        $page_num=1;
    }
    else
    {
    $page_num = $_GET['page_num'];
    }

    $i=$page_num*10;
    $srow = $i;
    $endrow = $srow-10;
   
    
    for($i=$endrow;$i<=$srow-1;$i++)
    {

        ?>
        
        <div id="trade_data">
        <div id="opent_time">
                <?php echo $newres[$i]->openTime; ?>
                </div>
                <div id="close_time">
                <?php echo $newres[$i]->closeTime; ?>
                </div>
                <div id="opent_price">
                <?php echo $newres[$i]->openPrice; ?>
                </div>
                <div id="close_price">
                <?php echo $newres[$i]->closePrice; ?>
                </div>
                <div id="lots">
                <?php echo $newres[$i]->sizing->value; ?>
                </div>
                <div id="type">
                <?php echo $newres[$i]->action; ?>
                </div>
                <div id="pair">
                <?php echo $newres[$i]->symbol; ?>
                </div>
                <div id="pips">
                <?php echo $newres[$i]->pips; ?>
                </div>

                </div>

<?php


    }?>
    </div>

    <div class="pagination">
            <?php $numpages = count($newres)/10;
            $numpages = ceil($numpages);


            $Path='forex-signals';
            $URI='http://localhost/fx/'.$Path;
            $current = $page_num;
            $prev = $current-1;
            $next = $current+1;


                echo '<div id="first"><a href='.$URI.'?page_num=1#trade_history>First</a></div>';   
                echo '<div id="prev"><a href='.$URI.'?page_num='.$next.'#trade_history>Previous</a></div>';
            for($n=1;$n<=$numpages;$n++)
            {
                echo '<div id="page_num"><a href='.$URI.'?page_num='.$n.'#trade_history>'.$n.'</a></div>';
            }
            echo '<div id="next"><a href='.$URI.'?page_num='.$next.'#trade_history>Next</a></div>';
            echo '<div id="last"><a href='.$URI.'?page_num='.$numpages.'#trade_history>Last</a></div>'; 

            ?>

    </div>

Answer 3

Answer №2

If you're looking to easily display a table on your website, I recommend checking out datatables.net. It's a great jQuery plugin that allows you to customize and present your data in a user-friendly way. The default setup should meet your requirements perfectly.

Answer 4

If you're looking to easily display a table on your website, I recommend checking out datatables.net. It's a great jQuery plugin that allows you to customize and present your data in a user-friendly way. The default setup should meet your requirements perfectly.

Answer 5

Answer №3

Are you in a situation where you're retrieving a large array from a service API without the use of a database?

If you're looking for a solution on the PHP side, I recommend creating a temporary storage option for the incoming data.

temporary file with serialized array data
session storage
SQLite database

Having this store will prevent unnecessary re-fetching of data from the service API and allow for independent pagination calls to your script.

The pagination logic revolves around using 'array_slice':

$items_total = count($items);
$per_page = 10;    
$max_pages = ceil($items_total / $per_page);    
$page = array_slice($items, $per_page * intval($_GET['page']) - 1, $per_page);

if($_GET['page'] > 1) {
    $prev_link = '<a href="script.php?page='.($_GET['page']-1).'"> previous </a>';
}

if($_GET['page'] < $max_pages) {
    $next_link = '<a href="script.php?page='.($_GET['page']+1).'"> next </a>';
}

An alternative approach is to utilize a JavaScript/client-side solution, where the entire dataset is passed from PHP to JS as JSON and implemented into a table plugin like datatables or tablesorter ().

Answer 6

Are you in a situation where you're retrieving a large array from a service API without the use of a database?

If you're looking for a solution on the PHP side, I recommend creating a temporary storage option for the incoming data.

temporary file with serialized array data
session storage
SQLite database

Having this store will prevent unnecessary re-fetching of data from the service API and allow for independent pagination calls to your script.

The pagination logic revolves around using 'array_slice':

$items_total = count($items);
$per_page = 10;    
$max_pages = ceil($items_total / $per_page);    
$page = array_slice($items, $per_page * intval($_GET['page']) - 1, $per_page);

if($_GET['page'] > 1) {
    $prev_link = '<a href="script.php?page='.($_GET['page']-1).'"> previous </a>';
}

if($_GET['page'] < $max_pages) {
    $next_link = '<a href="script.php?page='.($_GET['page']+1).'"> next </a>';
}

An alternative approach is to utilize a JavaScript/client-side solution, where the entire dataset is passed from PHP to JS as JSON and implemented into a table plugin like datatables or tablesorter ().

Paginating content without the need for a database

Answer №1

Answer №2

Answer №3

Similar questions

What is the best approach to tackle this design?

Refresh cookies on monitor using Vue.js

An issue arises when trying to import the modal popup

Inheriting the Powers of Magical Sensation

When you open the responsive navigation bar, it automatically closes

StartsWith() function failing when used in conjunction with takeWhile()

Number of database rows - PHP prepared statements - querying data

Import and load numerous JSON files into a responsive and visually appealing Bootstrap table

React-router-sitemap lacks a definition for 'Require'

Learn how to store the outcomes of an HTTP operation within array.map() in JavaScript

Utilize typehead.js in Python Django to retrieve an updated data list directly from the database

Learn how to incorporate a click event with the <nuxt-img> component in Vue

Encoding the output as JSON and displaying the result

Is AngularJS primarily a client-side or server-side framework, or does it have elements

TS type defined by JS constants

Using the reduce method in JavaScript or TypeScript to manipulate arrays

searchByTextContentUnderListItemAnchorTag

The drop-down menu does not maintain its selected option after the window is refreshed

Steps for interacting with a button of the <input> tag in Selenium using Python

Retrieving the initial array element within a foreach loop