how to retrieve data from mysql db with loops other than while loop in php?

Question

I am working with mysqli in php but i'd like to know how can i retrieve data from DB with loops other than while loop?

I always use while loop to retrieve data and I've never seen anybody to use another loop to do it. is this the only way to retrieve data!!?

$select_query = "SELECT * FROM article";
if($get_from_db = $db_connection->query($select_query)){
    if($get_from_db->num_rows > 0){
        while($result = $get_from_db->fetch_array(MYSQLI_ASSOC)){
            echo "id: " . $result['id'] . '<br>'; 
            echo "title: " . $result['title'] . '<br>'; 
            echo "context: " . $result['context'] . '<br>'; 
            echo "=========================================<br>";
        }
    }
    $get_from_db->free();
}else{
    //do somthing...
}

Possible duplicate of Use mysql_fetch_array() with foreach() instead of while() — BenM
– BenM, Commented Aug 27, 2019 at 11:37
It's not the only way but it's the simplest. Is there a problem or are you just curious? — ADyson
– ADyson, Commented Aug 27, 2019 at 11:46

Claudio · Accepted Answer · 2019-08-27 12:48:53Z

3

The while loop is not used to retrieve the data, it is used to fetch it from the mysqli instance that holds the query result, and to use another loop you would need to know before hand the number of rows returned from the query result.

What I think you can do is use fetch_all to fetch all the elements at once, and then you can use for example a foreach loop:

$rows = $get_from_db->fetch_all();

foreach ($rows as $row) {
    echo "id: " . $row['id'] . '<br>'; 
    echo "title: " . $row['title'] . '<br>'; 
    echo "context: " . $row['context'] . '<br>'; 
    echo "=========================================<br>";
}

Edit: You can also use for (with the same behaviour of while):

for (;$result = $get_from_db->fetch_array(MYSQLI_ASSOC);) {
    //...
}

edited Aug 27, 2019 at 12:48

answered Aug 27, 2019 at 11:37

Claudio

5,2112 gold badges25 silver badges34 bronze badges

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

Comments

Lets-c-codeigniter · Accepted Answer · 2019-08-27 11:44:17Z

1

If the data is in the form of array, you can use foreach loop

foreach($results as $result){
    echo "id: " . $result['id'] . '<br>'; 
    echo "title: " . $result['title'] . '<br>'; 
    echo "context: " . $result['context'] . '<br>'; 
    echo "=========================================<br>";
 }

edited Aug 27, 2019 at 11:44

answered Aug 27, 2019 at 11:38

Lets-c-codeigniter

7142 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

how to retrieve data from mysql db with loops other than while loop in php?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related