As I give echo in array

Question

   public static function getAllCount(){
    $sql = "SELECT COUNT(Title) from ".self::$tablename." GROUP BY category_id";
    $query = Executor::doit($sql);
    return Model::many($query[0],new EventData());
}
 FOREACH ---

 foreach ($evcount as $c) {      
 }

 print_r($evcount);

?>  

RETORNO -----

  Array
  (
    [0] => EventData Object
    (
        [name] => 
        [lastname] => 
        [email] => 
        [category_id] => NULL
        [password] => 
        [created_at] => NOW()
        [COUNT(Title)] => 4
    )

[1] => EventData Object
    (
        [name] => 
        [lastname] => 
        [email] => 
        [category_id] => NULL
        [password] => 
        [created_at] => NOW()
        [COUNT(Title)] => 62
    )

I want to give echo pulling the COUNT(title)=>

But when I echo he gives that mistake

Call to Undefined method Eventdata::COUNT()

Answer 1

The query returns an object with the database columns that see properties so treat them properly :COUNT() is not a method.

"SELECT COUNT(Title) from ".self::$tablename." GROUP BY category_id"

To resolve this, give an alias for the column and then access it as a normal sequence.

"SELECT COUNT(Title) as total from ".self::$tablename." GROUP BY category_id"

Inside the foreach do:

echo $c->total;

If the object has no methods, it is simpler to return a stdclass.