Add empty items at the end of array

Question

Add empty items at the end of array

Asked 4 years, 2 months ago

Viewed 53 times

-1

This is what I need to do, and I’m not up to it. I have to create an array to generate a json output with 50 items for example, but if the database contains only 30 it completes the 50 items with empty values. With the same Keys, but no values.

while ($rowx = $stmtx->fetch(PDO::FETCH_ASSOC)){

                    extract($rowx);

                    $emp_itemx=array(
                        "idhis" => $idhis,      
                        "id_user_cartao" => $id_user_cartao,
                        "ponto" => $ponto,
                        "id_user" => $id_user,
                        "qtde_pontos" => $qtde_pontos,
                        "iduserpromo" => $iduserpromo
                    );

                }

                echo json_encode($emp_itemx);

Why this line of PDO doesn’t look like this: $rowx = $stmtx->fetchAll(); since several copies of bd will come, fetchAll is more indicated

– Marcos Vinicius

2020/04/13 at 21:51
thus it would not be necessary to call the function Extract since the result would already come like $emp_itemx= array([0] =>array( "idhis" => "xxxx", "id_user_card" => "xxxx", "dot" => "xxxx", "id_user" => "xxxx", "qtde_points" => "xxxx", "iduserpromo" => "xxxx") );

– Marcos Vinicius

2020/04/13 at 22:00
Marcos, thanks for the tip, but my problem is as I described above, the question of the database data I’m not having problems. I really need to complete the blank data in the array!!

– Lucas Dolci

2020/04/13 at 22:02
the array you represented is wrong, it is easier to iterate over the return using a foreach at the end rather than while

– Marcos Vinicius

2020/04/13 at 22:04
back Array ( [0] => Array ( [idhis] => 'xxx', [id_user_card] => 'xxx', [dot] => 'xxx', [id_user] => 'xxx', [qtde_points] => 'xxx', [idupromoser] => 'xxx'&#Xa#; )

– Marcos Vinicius

2020/04/13 at 22:07
All right, but how could I complete the result I need?

– Lucas Dolci

2020/04/13 at 22:09

Show 1 more comment

2 answers

0

in this case I am assuming that there is only one record returned from the BD:

$emp_itemx=array(array(
                "idhis" => 'xxx',      
                "id_user_cartao" => 'xxxx',
                "ponto" => 'xxx',
                "id_user" => 'xxx',
                "qtde_pontos" => 'xxx',
                "iduserpromo" => 'xxxx'
            ));


for($i = count($emp_itemx);$i < 50;$i++){
$emp_itemx[$i] = array(
"idhis" => '',      
"id_user_cartao" => '',
"ponto" => '',
"id_user" => '',
"qtde_pontos" => '',
    "iduserpromo" => '');

}

this way it will add as many as it takes to reach the 50 records

I’ll test and I’ll let you know!! Thanks

– Lucas Dolci

2020/04/13 at 22:14
Marcos, she is repeating the amount that is missing to fill 50 after each item that comes from the bank and not only end of all!! If I have 20 lines in the bank it puts over 30 after each one, getting 600 lines in the array.

– Lucas Dolci

2020/04/13 at 22:34
is that the question, you must have entered the for inside the while

– Marcos Vinicius

2020/04/13 at 22:37
Really, I falter. It’s completing the right one outside the while, but it’s only returning 1 item coming from the bank!!

– Lucas Dolci

2020/04/13 at 22:44
so I told you about replacing fetch() with fetchAll();

– Marcos Vinicius

2020/04/13 at 22:46
like: $emp_itemx = $stmtx->fetchAll(); you save a while() and an Extract(); and you won’t even need to iterate that array. json_encode already understands

– Marcos Vinicius

2020/04/13 at 23:22
Who knows. Thanks Marcão. I was suffering here, now that I got your reasoning, I didn’t need any of that, I’m not used to PDO, I always use msqli.

– Lucas Dolci

2020/04/14 at 00:33
Here’s how I did it: 
$card_arrx=array();
 $emp_itemx = $stmtx->fetchAll();

 for($i = count($emp_itemx);$i < 15;$i++){
 //echo "cont: ".$i;
 $emp_itemx[$i] = array(
 "idhis" => '', 
 "id_user_cartao" => '',
 "ponto" => '',
 "id_user" => '',
 "qtde_pontos" => '',
 "iduserpromo" => '');
 }

– Lucas Dolci

2020/04/14 at 00:34
inserts into the question the lines of code that come before, not understanding this line $card_arrx=array();

– Marcos Vinicius

2020/04/14 at 10:37
Mark, I just started the array type variable.

– Lucas Dolci

2020/04/14 at 23:05
so it worked?

– Marcos Vinicius

2020/04/15 at 09:54
It did work, thanks to two tips. Thank you!!

– Lucas Dolci

2020/04/17 at 15:22

Show 7 more comments

Browser other questions tagged php json array loop

You are not signed in. Login or sign up in order to post.

by Augusto Vasques • **15,321** points · Answer 1 · 2020-04-14T01:27:02+00:00

Fill an array with a given value through the function array_fill() and combine two or more arrays by function array_merge()

<?php
$array1 = []; 

//Define um elemento vazio para posterior preenchimento
$vazio = [
  "idhis" => null,      
  "id_user_cartao" => null,
  "ponto" => null,
  "id_user" => null,
  "qtde_pontos" => null,
  "iduserpromo" => null
];

//Simula um preenchimento de 30 itens de $array1
foreach(range(1,30) as $n){
   $array1[] = [
    "idhis" => -$n,      
    "id_user_cartao" => $n,
    "ponto" => $n * 10,
    "id_user" => $n * 100,
    "qtde_pontos" => $n * 1000,
    "iduserpromo" => $n * 10000
  ];
}

//Cria um array 20 elementos definidos como sendo vazios
$array2 = array_fill(0, 20, $vazio);

//Junta $array1 e $array2
$resultado = array_merge($array1 , $array2);

print_r($resultado);

Test code running on https://repl.it/repls/RemarkableWatchfulDemand