@@ 3286-3294 (lines=9) @@ | ||
3283 | } |
|
3284 | ||
3285 | $keywordCondition = ''; |
|
3286 | if (!empty($keyword)) { |
|
3287 | $keyword = Database::escape_string($keyword); |
|
3288 | $keywordCondition = " AND (s.name LIKE '%$keyword%' ) "; |
|
3289 | ||
3290 | if (!empty($description)) { |
|
3291 | $description = Database::escape_string($description); |
|
3292 | $keywordCondition = " AND (s.name LIKE '%$keyword%' OR s.description LIKE '%$description%' ) "; |
|
3293 | } |
|
3294 | } |
|
3295 | ||
3296 | $whereConditions .= $keywordCondition; |
|
3297 | $subQuery = $sessionQuery.$courseSessionQuery; |
@@ 3243-3251 (lines=9) @@ | ||
3240 | ||
3241 | $keywordCondition = null; |
|
3242 | ||
3243 | if (!empty($keyword)) { |
|
3244 | $keyword = Database::escape_string($keyword); |
|
3245 | $keywordCondition = " AND (name LIKE '%$keyword%' ) "; |
|
3246 | ||
3247 | if (!empty($description)) { |
|
3248 | $description = Database::escape_string($description); |
|
3249 | $keywordCondition = " AND (name LIKE '%$keyword%' OR description LIKE '%$description%' ) "; |
|
3250 | } |
|
3251 | } |
|
3252 | ||
3253 | $tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
3254 | $access_url_id = api_get_current_access_url_id(); |