Guest User

Untitled

a guest
Jul 21st, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. $q = Heap::construct('HeapAccount')->getQuery();
  2. $qparams = array(
  3. 'status' => HeapAccount::Active,
  4. 'roles' => 'enseignant',
  5. );
  6. $q->where($qparams);
  7. Heap::log($q->toSql());
  8.  
  9. [MilleJoursProfilController.php:113]
  10. SELECT idx.id,idx.slug,idx.time_created,idx.time_modified,idx.status,idx.publish_start,idx.publish_end,idx.latitude,idx.longitude,idx.profile_id,idx.username,idx.email,idx.roles,idx.code,idx.last_login,idx.dashboard
  11. FROM HeapAccount AS idx
  12. WHERE ((idx.status = 'A') AND (idx.roles = 'enseignant'))
  13.  
  14. $q = Heap::construct('HeapAccount')->getQuery();
  15. $qparams = array(
  16. 'status' => HeapAccount::Active,
  17. 'roles' => array('enseignant'),
  18. );
  19. $q->where($qparams);
  20. Heap::log($q->toSql());
  21.  
  22. [MilleJoursProfilController.php:113]
  23. SELECT idx.id,idx.slug,idx.time_created,idx.time_modified,idx.status,idx.publish_start,idx.publish_end,idx.latitude,idx.longitude,idx.profile_id,idx.username,idx.email,idx.roles,idx.code,idx.last_login,idx.dashboard
  24. FROM HeapAccount AS idx
  25. WHERE ((idx.status = 'A') AND (idx.roles = 'a:1:{i:0;s:10:\"enseignant\";}'))
Add Comment
Please, Sign In to add comment