FuelPHP Forums

You are changing the loop variable of the foreach, which is always a copy, unless you use the & (by reference).

If you do that, you will get an exception, since database results are read-only and can not be modified.

Instead, I would have your RDBMS handle this using something like this:

    $query = DB::select('*')
      ->select(array(DB::expr('LEFT(`descricao`,10)'), 'descricao'))
      ->from('publics')
      ->limit(4)
      ->execute();

It saves you having to loop over the result. If you want the loop, do this:

public static function publics_slide()
{
    $query = DB::select()
        ->from('publics')
        ->limit(4)
        ->execute();

    $result = array();

    if ($query)
    {
        foreach($query as $row)
        {
            $row['descricao'] = Str::truncate($row['descricao'], 10);
            $result[] = $row;
        }
    }
   
    return $result;  
}