findAll

Navigation:  Development > Function Reference > CategorySet >

findAll

Previous pageReturn to chapter overviewNext page

This function fetch a multipe row from a table. See bellw format
 

App::CategorySet(NAME)->findAll(CONDITION);
 

We can pass condition of WHERE clause as parameter of the function.

 

For example: 
$data = App::CategorySet('blog-cat')->findAll();
$data = App::CategorySet('blog-cat')->findAll("title LIKE '%a%'");
 
// Return value 
/*

Array

(

    [data] => Array

        (

            [0] => Array

                (

                    [id] => 1

                    [fkey] => 0

                    [adminref] => 1

                    [parentid] => 0

                    [image] => 

                    [title] => Page Manager

                    [description] => 

                    [type] => blog-cat

                    [generic] => 

                    [entrydate] => 2012-12-13 10:47:18

                    [lastmodified] => 2012-12-13 10:47:18

                )

 

            [1] => Array

                (

                    [id] => 2

                    [fkey] => 0

                    [adminref] => 1

                    [parentid] => 0

                    [image] => 

                    [title] => Applications

                    [description] => 

                    [type] => blog-cat

                    [generic] => 11

                    [entrydate] => 2012-12-13 10:08:41

                    [lastmodified] => 2012-12-13 10:08:41

                )

 

        )

 

)

*/