php function in a while Loop

Question

i searched all over the web or i just don't see it.

I want to do the following:

<?php

 function abc(){
   $sql = "SELECT * FROM table";
   $result = mysql_fetch_assoc($sql);
   $data = mysql_fetch_assoc($result);
}

?>

<? while(abc()) : ?>

   <?=article_title()?>
   <?=article_content()?>

<?=endwhile;?>

Could somebody give me a direction and/or example?

Thank you very much

something like wordpress they use, while(function()):, endwhile;. i want to make something similar, it makes a template designing much easier — raymond.idema
– raymond.idema, Commented Apr 23, 2012 at 18:03
do you want to print the results of the function ? do whiel loops r quite simple to use, but I still dont know what exactly u want to achieve, apart from using a do while loop ! Which u find all over the web ! So give us a bit more detail on why u want this loop, what u want to achieve ! — Alexander Grosse
– Alexander Grosse, Commented Apr 23, 2012 at 18:21

ThiefMaster · Accepted Answer · 2012-04-23 17:54:11Z

2

PHP does not have generator/iterator functions, so you cannot do that.

You can however return an array and iterate over that array:

function abc() {
    // ...
    $rows = array();
    while($row = mysql_fetch_assoc($result)) { $rows[] = $row; }
    return $rows;
}

foreach(abc() as $row) {
    // do something
}

If the functions you call need access to the row, pass it as an argument. Using global variables for it would be very bad/nasty

answered Apr 23, 2012 at 17:54

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

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

1 Comment

ThiefMaster Over a year ago

That's why I said iterator functions. In python you could do what the OP wanted using the yield keyword - which does not exist in PHP.

Andreu Ramos · Accepted Answer · 2012-04-23 17:58:41Z

1

have you tried to do something like that?

<?php
function getData(){
    //get the data from the database
    //return an array where each component is an element found
}

$elems = getData();
foreach($elems as $e){
    doSomethingWith($e);
}

answered Apr 23, 2012 at 17:58

Andreu Ramos

2,9082 gold badges27 silver badges37 bronze badges

Collectives™ on Stack Overflow

php function in a while Loop

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related