Getting result in an array from a function with while loop in PHP

Question

I have a function in a class called database, the function as below

function getTaskData(){ 
    $q = "SELECT * FROM ".TBL_CLIENT ;
    $result = mysqli_query( $this->connection,$q);
    if(!$result || (mysqli_num_rows($result) < 1)){
        return NULL;
    }
    /* Return result array */
    ;
    while ($dbarray = mysqli_fetch_array($result)) {
        return $dbarray;    
    }
}

Please note that $dbarray is from while loop, however, i want to call the function to loop out specific data from the table in a while loop

please see below, i am calling the function from another page

$taskData= $database->getTaskData();
$taskStatus = $taskData['status'];
echo $taskStatus

I want $taskStatus to be in a loop.

You either collect all rows to one array and return it from your function, or return $result from your function and iterate it where you need. — u_mulder
– u_mulder, Commented Nov 6, 2018 at 15:45

u_mulder · Accepted Answer · 2018-11-06 15:52:57Z

1

Replace your loop in a function with:

$results = [];
while ($dbarray = mysqli_fetch_array($result)) {
    $results[] = $dbarray;    
}

return $results;

Somewhere else:

$taskData = $database->getTaskData();
foreach ($taskData as $item) {
    echo $item['status'];
}

answered Nov 6, 2018 at 15:52

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Getting result in an array from a function with while loop in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related