How to access while array outside the loop in PHP

Question

I want to access while array $row2 outside the loop so that I can compare in if else condition, because $row2 array contains many number. Is there any solution make $row array accessible outside the loop or any other method?

<?php
$sql = (" SELECT * FROM result ");
$query = mysqli_query($db, $sql);

while($row = mysqli_fetch_array($query)) {
    $row2 $row['id'];
}

for($i=1;$i<=10;$i++) {
    if ($i<= $row2) {
        echo "<font color='red'><font size='50px'>".$i."</font></font>"."<br>";
        continue;
    } else {
        echo $i.'<br>';
    }
}
?>

Set $row = array(); before the while loop, you will be able to read it afterwards. — Phiter
– Phiter, Commented Apr 14, 2016 at 18:57
I don't really understand, what's the purpose of the code? It just doesn't make any sense to me. Maybe context will help. — Daniel
– Daniel, Commented Apr 14, 2016 at 19:00
@Mike i am changing color of those number which are available in database and i am saving thode number in $row2 array — Raahull
– Raahull, Commented Apr 14, 2016 at 19:05

marc_s · Accepted Answer · 2016-04-14 21:02:37Z

1

If you want to loop over two dependent things you need to nest them or else $row2 will always contain the last value in the while loop:

<?php

$sql = (" SELECT * FROM result ");
$query = mysqli_query($db, $sql);

while ($row = mysqli_fetch_array($query)) {
    $row2 = $row['id']; // I added an = sign here.

    for($i=1;$i<=10;$i++) {
        if ($i<= $row2) {
            echo "<font color='red'><font size='50px'>".$i."</font></font>"."<br>";
            continue;
        } else {
            echo $i.'<br>';
        }
    }
}

If this isn't what you want please clarify your question.

edited Apr 14, 2016 at 21:02

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 14, 2016 at 19:04

Mike

24.5k14 gold badges84 silver badges93 bronze badges

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

4 Comments

Raahull Over a year ago

yes its showing last value but i want to show every value in array that's the real problem

Mike Over a year ago

@Raahull So does this answer do what you would want then?

Raahull Over a year ago

no $row contains 1,2,3,4,7 your code out put is 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10

Mike Over a year ago

What is the output supposed to be?

marc_s · Accepted Answer · 2016-04-14 21:01:50Z

0

Pass your variable to a separate function that performs whatever task you want.

<?php
while($row = mysqli_fetch_array($query))
{
     MyFunction($row2);
}

function MyFunction($passed_row2_value){
    // perform whatever task you want here.
}
?>

edited Apr 14, 2016 at 21:01

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 14, 2016 at 18:58

TV-C-1-5

7342 gold badges13 silver badges19 bronze badges

Comments

Saic Siquot · Accepted Answer · 2016-04-14 21:23:33Z

0

This shows with some format the ids retrieved by the query and fills the blanks without format.

<?php
$sql = (" SELECT * FROM result ");
$query = mysqli_query($db, $sql);

$row2 = [];
while($row = mysqli_fetch_array($query)) {
    $row2[$row['id']] = true;
}

for($i=1;$i<=10;$i++) {
    if ($row2[$i]) {
        echo "<font color='red'><font size='50px'>".$i."</font></font>"."<br>";
    } else {
        echo $i.'<br>';
    }
}
?>

edited Apr 14, 2016 at 21:23

answered Apr 14, 2016 at 21:17

Saic Siquot

6,5135 gold badges37 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to access while array outside the loop in PHP

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related