What's being returned with this function?
Here's the code:
When I uncomment "echo $set," I get "Array," which is what I expect. I can't tell what that "foreach" is doing and if it's part of what's being "returned."
What do you think?
class AccountTimelines extends CI_Model {
function getAccountTimeline($accountid){
$sql = "select * from
view_AccountTimeline where accountid='$accountid'
order by eventdate asc";
//echo $sql;
$set = pconnectdb($sql, DEFAULT_DB, true);
//echo $set;
$runningbal = 0;
foreach($set as &$item){
if($item['eventtype'] == 'transaction'){
$runningbal += pfmoney::toCents($item['amount']);
$item['runningbal'] = pfmoney::fromCents($runningbal);
}
}
//echo $set;
return $set;
}
}When I uncomment "echo $set," I get "Array," which is what I expect. I can't tell what that "foreach" is doing and if it's part of what's being "returned."
What do you think?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Marco Gasi
You should find it somewhere in your project...
It looks like the function is adding up some figures and injecting them into the database query results set, then returning the results set in the form of an array.
PHP echo is the wrong tool. You'll get better information with var_dump()
When you echo an array, PHP unhelpfully returns the word "Array." So use var_dump() to see what is in the array, maybe to compare before-and-after snapshots of the array.
PHP echo is the wrong tool. You'll get better information with var_dump()
When you echo an array, PHP unhelpfully returns the word "Array." So use var_dump() to see what is in the array, maybe to compare before-and-after snapshots of the array.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Got it!
Marco, you were right. I did find the pconnectdb function and it had some notes documented at the top of the file that stated that all SELECT statements were being returned, by default, as an associative, multi-dimensional array. So, there's that piece.
Ray, I created a "sandbox" and used the var_dump to confirm some things and both you and Slick were right. I appreciate the commentary and references to other articles. I was able to figure out both the WHAT and the WHY.
Thank you!
Marco, you were right. I did find the pconnectdb function and it had some notes documented at the top of the file that stated that all SELECT statements were being returned, by default, as an associative, multi-dimensional array. So, there's that piece.
Ray, I created a "sandbox" and used the var_dump to confirm some things and both you and Slick were right. I appreciate the commentary and references to other articles. I was able to figure out both the WHAT and the WHY.
Thank you!