123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- <?php
- /* For licensing terms, see /chamilo_license.txt */
- /**
- * Access_url_edit_session_to_url class
- * Contains several functions dealing with displaying,
- * editing,... of a Access_url_edit_session_to_url_functions
- *
- * @version 1.0
- * @author Toon Keppens <toon@vi-host.net>
- * @author Julio Montoya - Cleaning code
- * @author Ricardo Rodriguez - Separated the function and code
- *
- */
- require_once ('xajax/xajax.inc.php');
- class Accessurleditsessionstourl {
- function search_sessions($needle, $id)
- {
- global $tbl_session;
- $xajax_response = new XajaxResponse();
- $return = '';
- if(!empty($needle)) {
- // xajax send utf8 datas... datas in db can be non-utf8 datas
- $charset = api_get_setting('platform_charset');
- $needle = api_convert_encoding($needle, $charset, 'utf-8');
- $needle = Database::escape_string($needle);
- // search sessiones where username or firstname or lastname begins likes $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;
- }
- }
- ?>
|