Re: [fw-general] Searching database
Thanks!
I have checked, but I am not good enough to see...
2007/7/12, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi José,
Have you checked the manual for Zend_Db_Table?
getAdapter()->quoteInto('bug_status = ?', 'NEW');
$order = 'bug_id';
// Return the 21st through 30th rows
$count = 10;
$offset = 20;
$rows = $table->fetchAll($where, $order, $count, $offset);
?>
This is outlined further at
http://framework.zend.com/manual/en/zend.db.table.html
-Ryan
On Thu, 12 Jul 2007 12:54:09 -0300, "José de Menezes Soares Neto" <
[EMAIL PROTECTED]> wrote:
> everyone forget things :P
>
> can I limit the numbers of results of a query using fetchAll()?
>
>
>
>
> 2007/7/11, ViShap <[EMAIL PROTECTED]>:
>>
>> ACK
>>
>> josé, look for tutorials and books to get the basics of php =)
>>
>> good ressources are google, o´reilleys and of corse ZEND (articles and
>> tutorials)!
>>
>> regards
>>
>> 2007/7/12, till < [EMAIL PROTECTED]>:
>> >
>> > On 7/11/07, ViShap < [EMAIL PROTECTED]> wrote:
>> > > (...)
>> > > 2007/7/11, José de Menezes Soares Neto < [EMAIL PROTECTED]>:
>> > > > (...)
>> >
>> > Guys,
>> >
>> > not to be mean - well forget that! ;-) But maybe a PHP primer is
>> > necessary here and this should be discussed off list?
>> >
>> > Regards,
>> > Till
>> >
>>
>>
>
>
Re: [fw-general] Searching database
Hi José,
Have you checked the manual for Zend_Db_Table?
getAdapter()->quoteInto('bug_status = ?', 'NEW');
$order = 'bug_id';
// Return the 21st through 30th rows
$count = 10;
$offset = 20;
$rows = $table->fetchAll($where, $order, $count, $offset);
?>
This is outlined further at
http://framework.zend.com/manual/en/zend.db.table.html
-Ryan
On Thu, 12 Jul 2007 12:54:09 -0300, "José de Menezes Soares Neto" <[EMAIL
PROTECTED]> wrote:
> everyone forget things :P
>
> can I limit the numbers of results of a query using fetchAll()?
>
>
>
>
> 2007/7/11, ViShap <[EMAIL PROTECTED]>:
>>
>> ACK
>>
>> josé, look for tutorials and books to get the basics of php =)
>>
>> good ressources are google, o´reilleys and of corse ZEND (articles and
>> tutorials)!
>>
>> regards
>>
>> 2007/7/12, till < [EMAIL PROTECTED]>:
>> >
>> > On 7/11/07, ViShap < [EMAIL PROTECTED]> wrote:
>> > > (...)
>> > > 2007/7/11, José de Menezes Soares Neto < [EMAIL PROTECTED]>:
>> > > > (...)
>> >
>> > Guys,
>> >
>> > not to be mean - well forget that! ;-) But maybe a PHP primer is
>> > necessary here and this should be discussed off list?
>> >
>> > Regards,
>> > Till
>> >
>>
>>
>
>
Re: [fw-general] Searching database
everyone forget things :P can I limit the numbers of results of a query using fetchAll()? 2007/7/11, ViShap <[EMAIL PROTECTED]>: ACK josé, look for tutorials and books to get the basics of php =) good ressources are google, o´reilleys and of corse ZEND (articles and tutorials)! regards 2007/7/12, till < [EMAIL PROTECTED]>: > > On 7/11/07, ViShap < [EMAIL PROTECTED]> wrote: > > (...) > > 2007/7/11, José de Menezes Soares Neto < [EMAIL PROTECTED]>: > > > (...) > > Guys, > > not to be mean - well forget that! ;-) But maybe a PHP primer is > necessary here and this should be discussed off list? > > Regards, > Till >
Re: [fw-general] Searching database
if a type http://localhost/search?query=123, its ok but if I type http://localhost/search it shows a notice "undefined index" 2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>: i want matching... but i try to get $query = $_GET["query"] and there appears a message: *Notice*: Undefined index: query in *C:\www\was\application\controllers\FuncionariosController.php * on line *81 * 2007/7/11, ViShap <[EMAIL PROTECTED]>: > > Hi josé! > > What kind of search should this be? Full-Text or matching (LIKE > %$string% ) ? > > For Like execute a simple Query select . from . LIKE %$string% limit > ... > > for full text i strongly recommend google-searching - many good articles > about it =) > (i think also zend has sth in their tutorials-section ... > > It was when I viewed it in Beginner Tutorials -> Using MySQL Full-text- > ... (26.01.06 ^^) > > I hope i helped ya out! > > regards > > 2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>: > > > > Hi friends, > > > > I would like to make a search for search user details in my database, > > how do I start with it? > > > > Best regards, > > > > José de Menezes > > > >
Re: [fw-general] Searching database
i want matching... but i try to get $query = $_GET["query"] and there appears a message: *Notice*: Undefined index: query in * C:\www\was\application\controllers\FuncionariosController.php* on line *81 * 2007/7/11, ViShap <[EMAIL PROTECTED]>: Hi josé! What kind of search should this be? Full-Text or matching (LIKE %$string% ) ? For Like execute a simple Query select . from . LIKE %$string% limit ... for full text i strongly recommend google-searching - many good articles about it =) (i think also zend has sth in their tutorials-section ... It was when I viewed it in Beginner Tutorials -> Using MySQL Full-text- ... (26.01.06 ^^) I hope i helped ya out! regards 2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>: > > Hi friends, > > I would like to make a search for search user details in my database, > how do I start with it? > > Best regards, > > José de Menezes >
Re: [fw-general] Searching database
ACK josé, look for tutorials and books to get the basics of php =) good ressources are google, o´reilleys and of corse ZEND (articles and tutorials)! regards 2007/7/12, till <[EMAIL PROTECTED]>: On 7/11/07, ViShap <[EMAIL PROTECTED]> wrote: > (...) > 2007/7/11, José de Menezes Soares Neto < [EMAIL PROTECTED]>: > > (...) Guys, not to be mean - well forget that! ;-) But maybe a PHP primer is necessary here and this should be discussed off list? Regards, Till
Re: [fw-general] Searching database
On 7/11/07, ViShap <[EMAIL PROTECTED]> wrote: (...) 2007/7/11, José de Menezes Soares Neto < [EMAIL PROTECTED]>: > (...) Guys, not to be mean - well forget that! ;-) But maybe a PHP primer is necessary here and this should be discussed off list? Regards, Till
Re: [fw-general] Searching database
oh ... ;)
do a if(isset($_GET['query']) { .. make you search and display the results
} else {
show the question-form
}
regards
2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>:
if a type http://localhost/search?query=123, its ok
but if I type http://localhost/search it shows a notice "undefined index"
2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>:
>
> i want matching...
>
> but i try to get $query = $_GET["query"]
>
> and there appears a message:
>
> *Notice*: Undefined index: query in
*C:\www\was\application\controllers\FuncionariosController.php
> * on line *81
>
>
>
> *
> 2007/7/11, ViShap <[EMAIL PROTECTED] >:
> >
> > Hi josé!
> >
> > What kind of search should this be? Full-Text or matching (LIKE
> > %$string% ) ?
> >
> > For Like execute a simple Query select . from . LIKE %$string% limit
> > ...
> >
> > for full text i strongly recommend google-searching - many good
> > articles about it =)
> > (i think also zend has sth in their tutorials-section ...
> >
> > It was when I viewed it in Beginner Tutorials -> Using MySQL
> > Full-text- ... (26.01.06 ^^)
> >
> > I hope i helped ya out!
> >
> > regards
> >
> > 2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>:
> > >
> > > Hi friends,
> > >
> > > I would like to make a search for search user details in my
> > > database, how do I start with it?
> > >
> > > Best regards,
> > >
> > > José de Menezes
> > >
> >
> >
>
Re: [fw-general] Searching database
Hi josé! What kind of search should this be? Full-Text or matching (LIKE %$string% ) ? For Like execute a simple Query select . from . LIKE %$string% limit ... for full text i strongly recommend google-searching - many good articles about it =) (i think also zend has sth in their tutorials-section ... It was when I viewed it in Beginner Tutorials -> Using MySQL Full-text- ... (26.01.06 ^^) I hope i helped ya out! regards 2007/7/11, José de Menezes Soares Neto <[EMAIL PROTECTED]>: Hi friends, I would like to make a search for search user details in my database, how do I start with it? Best regards, José de Menezes
