findAll in yii

Question

EmailArchive Table   id email id to from 1  101      uk  msm 2  102      uu  avc 3  101      rk  uk 4  103      xyz abc 5  104      xyz poi 6  104      abc xyz 7  101      xyz abc   Now in Yii I want record where email id 101 I am using below code  but its not working    id  101   criteria   new CDbCriteria     criteria- gt addCondition  email id  lt   email id     comments   EmailArchive  model  - gt findAll  criteria  array   email id    gt   id

User · Answer

if you user  criteria  I recommend blow usage    criteria   new CDbCriteria     criteria- gt compare  email id   101    comments   EmailArchive  model  - gt findAll  criteria

User · Answer

id   101    sql    SELECT   FROM ur tbl t WHERE t email id       id   email   Yii  app  - gt db- gt createCommand  sql - gt queryAll     var dump  email

User · Answer

Another simple way get by using findall in yii       id  101    comments   EmailArchive  model  - gt findAll array  condition   gt    email id   id     foreach  comments as  comments 1      echo   email    comments 1  email id

User · Answer

This is your safest way to do it    id  101     user id 25   criteria new CDbCriteria   criteria- gt condition  email id  lt   email id      criteria- gt addCondition  user id  user id     criteria- gt params array      email id    gt   id        user id    gt   user id      comments EmailArchive  model  - gt findAll  criteria     Note that if you comment out the commented lines you get a way to add more filtering to your search   After this it is recommend to check if there is any data returned like   if  isset  comments        We found some comments  we can sleep well tonight      do comments process or whatever

User · Answer

Try    id  101   comments   EmailArchive  model  - gt findAll  array  condition   gt  email id     id   order   gt  id       OR   id  101   criteria   new CDbCriteria     criteria- gt addCondition  email id  email id     criteria- gt params   array   email id    gt   id    comments   EmailArchive  model  - gt findAll  criteria     OR   Criteria   new CDbCriteria     Criteria- gt condition    email id    id    Products   Product  model  - gt findAll  Criteria

User · Answer

Just to add some alternate  you could do like this also    id  101   criteria   new CDbCriteria     criteria- gt condition    email id   email id    criteria- gt params   array   email id    gt   id    comments   EmailArchive  model  - gt findAll  criteria

User · Answer

Use the below code  This should work    comments   EmailArchive  find  - gt where   email id    gt   id  - gt all

User · Answer

If you use findAll    I recommend you to use this    data email   EmailArchive  model  - gt findAll                    array                         condition    gt   email id    email id                          params       gt  array   email id    gt   id

[php] findAll() in yii

Examples related to php

Examples related to yii

Examples related to yii-cactiverecord