Advertisement
uzielweb

JEA - Default Image of a Property

Aug 16th, 2017
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.43 KB | None | 0 0
  1.                 $dbjea = JFactory::getDbo();
  2.                 $queryjea = $dbjea->getQuery(true);
  3.                 $queryjea->select('images');
  4.                 $queryjea->from('#__jea_properties');
  5.                 $queryjea->where('id=' . $jeaitem->id);
  6.                 $dbjea->setQuery($queryjea);
  7.                 $jeaimages = $dbjea->loadObjectList();
  8.  
  9. /*
  10.  O resultado do var_dump do banco de dados é o seguinte:
  11.  O Que preciso é da primeira imagem : 2017-08-14-PHOTO-00000020.jpg
  12.  
  13. array(1) {
  14. [0]=>
  15. object(stdClass)#11406 (1) {
  16. ["images"]=>
  17. string(898) "[{"title":"","description":"","name":"2017-08-14-PHOTO-00000020.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000030.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000019.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000021.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000022.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000028.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000029.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000031.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000032.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000035.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000036.jpg"},{"title":"","description":"","name":"2017-08-14-PHOTO-00000037.jpg"},{"name":"2017-08-14-PHOTO-00000039.jpg","title":"","description":""}]"
  18. }
  19. }
  20. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement