access_url_edit_sessions_to_url_functions.lib.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. /* For licensing terms, see /chamilo_license.txt */
  3. /**
  4. * Access_url_edit_session_to_url class
  5. * Contains several functions dealing with displaying,
  6. * editing,... of a Access_url_edit_session_to_url_functions
  7. *
  8. * @version 1.0
  9. * @author Toon Keppens <toon@vi-host.net>
  10. * @author Julio Montoya - Cleaning code
  11. * @author Ricardo Rodriguez - Separated the function and code
  12. *
  13. */
  14. require_once ('xajax/xajax.inc.php');
  15. class Accessurleditsessionstourl {
  16. function search_sessions($needle, $id)
  17. {
  18. global $tbl_session;
  19. $xajax_response = new XajaxResponse();
  20. $return = '';
  21. if(!empty($needle)) {
  22. // xajax send utf8 datas... datas in db can be non-utf8 datas
  23. $charset = api_get_setting('platform_charset');
  24. $needle = api_convert_encoding($needle, $charset, 'utf-8');
  25. $needle = Database::escape_string($needle);
  26. // search sessiones where username or firstname or lastname begins likes $needle
  27. $sql = 'SELECT id, name FROM '.$tbl_session.' u
  28. WHERE (name LIKE "'.$needle.'%")
  29. ORDER BY name, id
  30. LIMIT 11';
  31. $rs = Database::query($sql);
  32. $i=0;
  33. while ($session = Database :: fetch_array($rs)) {
  34. $i++;
  35. if ($i<=10) {
  36. $return .= '<a href="#" onclick="add_user_to_url(\''.addslashes($session['id']).'\',\''.addslashes($session['name']).' ('.addslashes($session['id']).')'.'\')">'.$session['name'].' </a><br />';
  37. } else {
  38. $return .= '...<br />';
  39. }
  40. }
  41. }
  42. $xajax_response -> addAssign('ajax_list_courses','innerHTML',api_utf8_encode($return));
  43. return $xajax_response;
  44. }
  45. }
  46. ?>