PHP: Function to iterate results from another function and output

Question

Seems like this would be pretty simple, however, I'm running into an issue:

Here's the code:

function getValidCustomers() {
    global $db;
    $getCustomers = $db->GetAll("SELECT * from customers where CustomerActive='1' AND protected IS NULL or protected=0;");
    foreach($getCustomers as $customer) {
        echo $customer['CustomerID']."\n";
    }
}

function updateValidCustomers() {
    $customers = getValidCustomers();
    for ($i = 0; $i < sizeof($customers); $i++) {
        echo "DEBUG: $customers[$i]\n";
    }
}

updateValidCustomers();

Basically, the output right now is a list of the CustomerIDs (from updateValidCustomers()). I just want updateValidCustomers() to get the data from getValidCustomers() and then loop through it, so that I can run another query on it that will actually manipulate the database.

Any ideas?

Mark Elliot · Accepted Answer · 2011-07-31 23:45:39Z

2

getValidCustomers doesn't return anything, maybe you mean this:

function getValidCustomers() {
    global $db;
    $getCustomers = $db->GetAll("SELECT * from customers where CustomerActive='1' AND protected IS NULL or protected=0;");
    foreach($getCustomers as $customer) {
        echo $customer['CustomerID']."\n";
    }
    return $getCustomers;
}

answered Jul 31, 2011 at 23:45

Mark Elliot

77.4k23 gold badges147 silver badges162 bronze badges

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

1 Comment

drewrockshard Over a year ago

sighs - so, so close. You're right (along with everyone else). I originally added return $customer['CustomerID']; and replaced echo $customer['CustomerID']."\n";, but then read that it would basically exit after that matched and that obviously did not resolve my issue. Thanks for the tip guys!

Flambino · Accepted Answer · 2011-07-31 23:46:26Z

2

getValidCustomers() doesn't return anything - it just echoes

Add return $getCustomers to the end of getValidCustomers()

answered Jul 31, 2011 at 23:46

Flambino

18.9k2 gold badges44 silver badges59 bronze badges

Comments

Kaken Bok · Accepted Answer · 2011-07-31 23:46:18Z

1

Add return $getCustomers; to getValidCustomers() :D

answered Jul 31, 2011 at 23:46

Kaken Bok

3,3851 gold badge21 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP: Function to iterate results from another function and output

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related