Cant access SQL data outside my while loop

Question

When I save a result of a SQL query in a variable (in the code in $test2), the variable is empty outside the while loop. Why?

Generally defining varibales inside that loop works (see $test1). And the SQL query works too.

$connection = new mysqli($servername,$username,$password,$dbname) or die("Error: " . mysqli_error($connection));
$query = "SELECT * FROM Table ORDER BY `id` ASC";
$result = mysqli_query($connection, $query);
while($row = mysqli_fetch_object($result)) {
    $test1 = "some text";
    $test2 = $row->id;
    echo $row->id // Output is the id -> works
}
echo $test1; // Output is "some text" -> works
echo $test2; // Output is nothing -> doesn't work. Why?

If you want to use something outside a loop and not $tests, consider using an array $test = array(); created before the loop, then add whatever in your loop as $test[] = array("id"=>$row->id,"foo"=>"that"); — user1299518
– user1299518, Commented May 28, 2014 at 12:44

Steve · Accepted Answer · 2014-05-28 12:43:14Z

2

You are overwritting the variables in each loop itteration. Save them all to an array and look at the results:

while($row = mysqli_fetch_object($result)) {
    $test1[] = "some text";
    $test2[] = $row->id;
    echo $row->id // Output is the id -> works
}
print_r($test1); 
print_r($test2);

answered May 28, 2014 at 12:43

Steve

20.5k5 gold badges47 silver badges71 bronze badges

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

Comments

Ing. Michal Hudak · Accepted Answer · 2014-05-28 12:39:40Z

2

$row = mysqli_fetch_array($result) return an array

and you are using $test2 = $row->id; as object

edited May 28, 2014 at 12:39

answered May 28, 2014 at 12:34

Ing. Michal Hudak

5,66212 gold badges64 silver badges95 bronze badges

2 Comments

Marek Over a year ago

mysqli_fetch_object, as the name implies, returns an object.

Ing. Michal Hudak Over a year ago

@Marek OP edited question many times, before it was mysql_fetch_array

Collectives™ on Stack Overflow

Cant access SQL data outside my while loop

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related