Json respond all datra from database

jongyanlaw · October 27, 2015, 4:07am

Hi sorry i’m totaly new in programming

Below is the code i edit from my company existing project and edit it in one of the controller.

public function actionIndex()

	{


        &#036;Criteria = new CDbCriteria();


        &#036;model = FeatureImage::model()-&gt;find(&#036;Criteria);


        


        if (empty(&#036;model)) &#036;this-&gt;__fail('Not found');





        &#036;response = array(


            'id' =&gt; &#036;model-&gt;id,


            'image' =&gt; &#036;model-&gt;image_name,


            'SortOrder' =&gt; &#036;model-&gt;sortOrder,


            'Destktop Path' =&gt; &#036;model-&gt;image_1,


        );





        echo json_encode(&#036;response);


        exit();


}

It is work with output

{"id":"xx","image":"Image xx","SortOrder":"xx","Destktop Path":"xxx.jpg"}

Just can anyone help me how to list all data in database ? Becuz it just echo first data from the database… i wan it echo all data. Please help thanks.

dragan.zivkovic · October 27, 2015, 12:07pm

Hi,

find() method returns one DB record, what U need here is findAll (returns array of all records matching given criteria)


$models = FeatureImage::model()->findAll($Criteria);

after that I suppose U will need to go trough foreach and populate $result array:




$response = [];

foreach ($models as $model) {

    $response[] = array(

      'id' => $model->id,

      'image' => $model->image_name,

      'SortOrder' => $model->sortOrder,

     'Destktop Path' => $model->image_1,

    );

}

jongyanlaw · October 28, 2015, 1:55am

THX!!! It is work!!

jongyanlaw · October 28, 2015, 2:04am

However found out another problem which is

let said in mysql the correct path will be "/images/feature/562d9ff8173a88.26956287.jpg"

but json respond as below

"\/images\/feature\/562d9ff8173a88.26956287.jpg"

any idea on it?

haidt · October 28, 2015, 9:01am

Hello jongyanlaw,

If you are using ajax you can lack option: dataType: ‘json’

jongyanlaw · October 29, 2015, 6:27am

ok thank you.