Help create jquery album

Help create jquery album

I make jQuery but I have not seen jquery

it is my customController

  1. public function actionGetgallery()
  2. {
  3. $usersId = isset($_POST['usersId'])?$_POST['usersId']:'';
  4. Yii::app()->user->setState('dash_usersId', $usersId);

  6. echo json_encode('yes');
  7. return;
  8. }

  10. public function actionGetImage()
  11. {
  12. $sql = ' SELECT a.picture AS picture, c.username, e.name FROM activity a JOIN usersorganization b ';
  13. $sql .= 'ON a.users_organization_id = b.users_organization_id ';
  14. $sql .= 'JOIN users c ON b.users_id = c.users_id ';
  15. $sql .= 'JOIN clientorganization d ON b.client_organization_id = d.client_organization_id ';
  16. $sql .= ' JOIN organization e ON d.organization_id = e.organization_id ORDER BY activity_id DESC';
  17. // $sql =' SELECT a.picture AS picture, d.name AS name FROM activity a JOIN usersorganization b ON a.users_organization_id = b.users_organization_id JOIN clientorganization c ON b.client_organization_id = c.client_organization_id JOIN organization d ON c.organization_id = d.organization_id ORDER BY activity_id DESC ';

  19. $dataProvider = new CSqlDataProvider(
  20. $sql,array(
  21. 'keyField' => 'picture',
  22. )
  23. );

  25. foreach($dataProvider->getData() AS $i=>$ii)
  26. // echo var_dump($ii);
  27. {
  28. $gambar = array();
  29. echo '<div class="superbox-list img1"><table border="2" color="black">
  30. <tr>
  31. <td><img class="superbox-img" src="'.$gambar[$i] = (int)$ii['picture'].'"/></td></tr><center>
  32. <tr><td><h5>'.$gambar[$i] = (int)$ii['name'].'</center></h5></td></tr></table>
  33. </div>';
  34. }
  35. echo json_encode($gambar);
  36. return;
  37. }

and this my views

  1. <script type="text/javascript">

  3. var Imgx = $("#image").val();

  5. $(document).ready(function() 
  6. {
  7. getImgx();
  8. });

  10. function setProgr()
  11. {
  12. var e = document.getElementById("users_id");
  13. var usersId = e.options[e.selectedIndex].value;

  15. var uri = '<?php 
  16. echo Yii::app()->createAbsoluteUrl("Custom/Getgallery"); 
  17. ?>';
  18. jQuery.ajax(
  19. {
  20. type: 'POST',
  21. async: false,
  22. dataType: "json",
  23. url: uri,
  24. data: {usersId:usersId},
  25. success: function(result) 
  26. {
  27. getImgx();
  28. // alert(getImgx);
  29. }
  30. });
  31. }

  33. function getImgx()
  34. {
  35. var e = document.getElementById("users_id");
  36. var usersId = e.options[e.selectedIndex].value;

  38. var uri = '<?php echo Yii::app()->createAbsoluteUrl("Custom/GetImage"); ?>';
  39. jQuery.ajax(
  40. {
  41. type: 'POST',
  42. async: false,
  43. dataType: "json",
  44. url: uri,
  45. data: {usersId:usersId},
  46. success: function(result) 
  47. {
  48. alert(Imgx);
  49. Imgx = result;
  50. }
  51. });
  52. }

  54. </script>