Just upgraded my DB to Postgres 9.2 to get Index only Counts but now, getting a ->result() from a database query can’t be Looped Through with a foreach.
function get_provider_address_by_id($id){
$this->db->select('id');
$this->db->select('address1');
$this->db->select('address2');
$this->db->select('city');
$this->db->select('state');
$this->db->select('zip');
$this->db->from('list_address');
$this->db->where('provider_id', $id);
$addresses = $this->db->get();
$addresses = $addresses->result();
echo var_dump($addresses);
foreach($addresses as $key=>$address){
//Get how many times it's used
$address->uses = $this->countAddressUses($address->id);
$addresses[$key]=$address;
}
return $addresses;
}
Results in
A PHP Error was encountered
Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: database/DB_active_rec.php
Line Number: 82
Any Ideas? There’s something funky with the Driver Somewhere. Previously, not only did this work, but the object didn’t have ‘public’ or ‘$’ associated with each name.
Edit: Should also add, the below does the same thing.
function get_provider_address_by_id($id){
$this->db->select('id');
$this->db->select('address1');
$this->db->select('address2');
$this->db->select('city');
$this->db->select('state');
$this->db->select('zip');
$this->db->from('list_address');
$this->db->where('provider_id', $id);
$addresses = $this->db->get();
//$addresses = $addresses->result();
//echo var_dump($addresses);
foreach($addresses->result() as $key=>$address){
//Get how many times it's used
$address->uses = $this->countAddressUses($address->id);
$addresses[$key]=$address;
}
return $addresses;
}