12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- <?php
- require_once 'xajax/xajax.inc.php';
- class Accessurleditsessionstourl
- {
-
- public function search_sessions($needle, $id)
- {
- $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
- $xajax_response = new xajaxResponse();
- $return = '';
- if (!empty($needle)) {
-
- $charset = api_get_system_encoding();
- $needle = api_convert_encoding($needle, $charset, 'utf-8');
- $needle = Database::escape_string($needle);
-
- $sql = 'SELECT id, name FROM '.$tbl_session.' u
- WHERE (name LIKE "'.$needle.'%")
- ORDER BY name, id
- LIMIT 11';
- $rs = Database::query($sql);
- $i = 0;
- while ($session = Database::fetch_array($rs)) {
- $i++;
- if ($i <= 10) {
- $return .= '<a href="#" onclick="add_user_to_url(\''.addslashes($session['id']).'\',\''.addslashes($session['name']).' ('.addslashes($session['id']).')'.'\')">'.$session['name'].' </a><br />';
- } else {
- $return .= '...<br />';
- }
- }
- }
- $xajax_response->addAssign(
- 'ajax_list_courses',
- 'innerHTML',
- api_utf8_encode($return)
- );
- return $xajax_response;
- }
- }
|