ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilLikeObjectSearch.php
Go to the documentation of this file.
1<?php
2/*
3 +-----------------------------------------------------------------------------+
4 | ILIAS open source |
5 +-----------------------------------------------------------------------------+
6 | Copyright (c) 1998-2001 ILIAS open source, University of Cologne |
7 | |
8 | This program is free software; you can redistribute it and/or |
9 | modify it under the terms of the GNU General Public License |
10 | as published by the Free Software Foundation; either version 2 |
11 | of the License, or (at your option) any later version. |
12 | |
13 | This program is distributed in the hope that it will be useful, |
14 | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16 | GNU General Public License for more details. |
17 | |
18 | You should have received a copy of the GNU General Public License |
19 | along with this program; if not, write to the Free Software |
20 | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21 +-----------------------------------------------------------------------------+
22*/
23
35include_once 'Services/Search/classes/class.ilObjectSearch.php';
36
38{
39
44 function ilLikeObjectSearch(&$qp_obj)
45 {
46 parent::ilObjectSearch($qp_obj);
47 }
48
49
51 {
52 global $ilDB;
53
54 /*
55 $concat = " CONCAT(";
56 $concat .= 'title,description';
57 $concat .= ") ";
58 */
59
60 $concat = $ilDB->concat(
61 array(
62 array('title','text'),
63 array('description','text')));
64
65
66 $where = "WHERE (";
67 $counter = 0;
68 foreach($this->query_parser->getQuotedWords() as $word)
69 {
70 if($counter++)
71 {
72 $where .= "OR";
73 }
74
75 $where .= $ilDB->like($concat,'text','%'.$word.'%');
76
77 #$where .= $concat;
78 #$where .= ("LIKE ('%".$word."%') ");
79 }
80 $where .= ') ';
81 return $where;
82 }
83
84}
85?>
ilLikeObjectSearch(&$qp_obj)
Constructor @access public.
global $ilDB