[TYPO3-mvc] Need help with search form

[Mam Violeng]

Thanks Steffen, it helps me a lot.

Violeng

Steffen Ritter wrote:
> Mam Violeng schrieb:
>> Hi All,
>>
>> I have one form with a keyword text box to search the keyword through 
>> the fields in the table (more than 5 fields). I was wondering if 
>> extbase also provide some function similar 
>> GLOBALS['TYPO3_DB']->searchQuery($searchWords, $fields, $table) or not.
> 
> You have to implement such functions on your own. The table field won't 
> match, since there are no tables in extbase or mvc. You may Implement an 
>  searchFor($keywords=array, $inProperties=array) in an abstract 
> Repository which all of your repositories are extending, than it's easy 
> to build a search query with likes...
> Have a look at the thread of "repository chain multiple likes" - the 
> results may help you,.
> 
>>
>> Please give me some hints. I also have one more question regarding 
>> using $query->statement($statement, $parameters, $language) I don't 
>> what this function do, and how to use it, anyone has any real examples 
>> how to use it?
> 
> Hey, the last to parameters you may drop quietly... just use $result = 
> $query->statement('SELECT * from caz")->execute() as
> 
> $data = $GLOBALS['TYPO3_DB']->sql_query('SELECT * from caz);
> $result =array();
> whhile($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($data)) {
>     $result[] = newExtbaseDomainObjectFromData($row);
> }
> 
> newExtbaseDomainObjectFromDatafor shure is only a description of what 
> would be done...
> 
>> Thanks in advance.
>>
>> Regards,
>>
>> Violeng Mam