Issue with array echo

Question

I am trying to output data in pdf. Upto 10 values code is working fine but it is not display 11th value and it is continuing from 12th value. Please help me fix it.

<?php
$result=mysqli_query($conn,"SELECT * FROM TABLE");
$Items = array();
while ($row = mysqli_fetch_assoc($result)) {
  $Items[] = $row;
}

$x=0;
$y=0;
$a=5;
$b=5;

require('../pdf/alphapdf.php');
$pdf = new AlphaPDF();

$pdf->AddPage();
$title = 'Demo';
$pdf->SetTitle($title);
$pdf->SetLineWidth(1.5);
$pdf->SetAlpha(1);

foreach ($Items as $array) {
if($x<5){
    $pdf->Image('abc.png',$a,$b,-300);
    $pdf->SetFont('Arial', '', 9);
    $pdf->Text($a,$b,$array['userName']);
    $a=$a+58;
    $x++;
}elseif($x>=5 && $x<10){
    if($a>290){$a=5;}
    $b=100;
    $pdf->Image('abc.png',$a,$b,-300);
    $pdf->SetFont('Arial', '', 9);
    $pdf->Text($a,$b,$array['userName']);
    $a=$a+58;
    $x++;
}else{
    $x=0;
    $a=5;
    $b=5;
    $pdf->AddPage();
 }
}
$pdf->Output();
?>

I know the issue is because of the else statement that i am using but i am not sure how to fix it.

If $x > 10, you hit the else statement where you're adding a new page. But you don't then actually output the 11th item, you're moving on to process the 12th instead. — fubar
– fubar, Commented Mar 12, 2021 at 9:28

Death-is-the-real-truth · Accepted Answer · 2021-03-12 14:18:49Z

1

When 11th record coming in your code, then your code goes to else part and there you have written code only to create a new page, nothing else. That's why 11th record got skipped.

Also you are using repeated code multiple time, which is not needed actually, try like this:

$x=0;
$a=5;
$b=5;
foreach ($Items as $array) {

    if($x %10 == 0 ){ // after each 10 record add new page
        $x=0;
        $a=5;
        $b=5;
        $pdf->AddPage();
    }
    //add entries irrespective of pages.
    $pdf->Image('abc.png',$a,$b,-300);
    $pdf->SetFont('Arial', '', 9);
    $pdf->Text($a,$b,$array['userName']);
    $a=$a+58;
    $x++;
}

edited Mar 12, 2021 at 14:18

answered Mar 12, 2021 at 9:54

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Neeraj Kumar · Accepted Answer · 2021-03-12 09:40:55Z

0

Here is very quick and short solution for your this problem. You have to use less than and equal to both as well. Kindly update you code line:

}elseif($x>=5 && $x<=10){

Thanks!

answered Mar 12, 2021 at 9:40

Neeraj Kumar

5041 gold badge8 silver badges19 bronze badges

Collectives™ on Stack Overflow

Issue with array echo

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related