Return last n record of a JSON file in php

Question

Return last n record of a JSON file in php

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

Doubt PHP with JSON: I already know how to loop in a JSON file and show all records and also show only the last record using the END. How can I show the last 5, 10 record, for example?

php json

asked by anonymous 10.07.2018 / 04:07

2 answers

Save checkbox in mysql with php javascript and html drag and drop to react

score 0 · Answer 1

To use a portion of an array, just use array_splice .

$input = array( "vermelho" , "verde" , "azul" , "amarelo" , "preto" , "cinza" );
array_splice( $input , 0 , -5 );
print_r( $input );

output

Array
(
    [0] => verde
    [1] => azul
    [2] => amarelo
    [3] => preto
    [4] => cinza
)

score 0 · Answer 2

That's not what I need. I have a JSON file and I already know how to loop and return all records. If I only need the last record I use the END like this:

    $pesquisa = json_decode(file_get_contents("nomedoarquivo"),true);
    $ultimoRegistroPesq = end($pesquisa["registros"]);
    $strCampo = $ultimoRegistroPesq['campo'];

I want to know if you can limit your search to the last 5 records, for example. If I were searching for a database I would use LIMIT 5 in the query. But with JSON I do not know.