Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. public function actionmyjob()
  2. {
  3. $row = Yii::app()->db->createCommand()
  4. ->select('j.title,j.company_name')
  5. ->from('job_application a')
  6. ->join('jobs j','a.job_id = j.id')
  7. ->queryRow();
  8. echo $count=count($row);
  9. $this->render('myjob',array('row' =>$row));
  10. }
  11.  
  12. <?php
  13. foreach($row as $rows)
  14. {
  15. echo $row->title."</br>";
  16. }
  17.  
  18. ?>
  19.  
  20. <?php
  21. foreach($row as $rows)
  22. {
  23. echo $rows."</br>"; // If you want to use only title then try $row['title']
  24. }
  25. ?>
  26.  
  27. public function actionmyjob()
  28. {
  29. $row = Yii::app()->db->createCommand()
  30. ->select('j.title,j.company_name')
  31. ->from('job_application a')
  32. ->join('jobs j','a.job_id = j.id')
  33. ->queryAll();
  34. echo $count=count($row);
  35. $this->render('myjob',array('row' =>$row));
  36. }
  37.  
  38. <?php
  39. foreach($row as $rows)
  40. {
  41. echo $rows['title']."</br>"; // change $row to $rows
  42. }
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement