* @author Julio Montoya - Cleaning code * @author Ricardo Rodriguez - Separated the function and code * @package chamilo.include */ /** * Code */ require_once ('xajax/xajax.inc.php'); /** * Class * @package chamilo.include */ 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_system_encoding(); $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 .= ''.$session['name'].'
'; } else { $return .= '...
'; } } } $xajax_response -> addAssign('ajax_list_courses','innerHTML',api_utf8_encode($return)); return $xajax_response; } } ?>