| @@ 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(); |
|