Patches item #939197, was opened at 2004-04-21 10:18
Message generated for change (Comment added) made by rubo77
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=939197&group_id=23067
Category: Interface
Group: Basic idea, not for release
Status: Open
Resolution: None
Priority: 5
Submitted By: Ruben Barkow (rubo77)
Assigned to: Marc Delisle (lem9)
Summary: a patch to search faster in one table
Initial Comment:
i move this here from the help forum (i posted it there
before on
http://sourceforge.net/forum/forum.php?thread_id=1053187&forum_id=72909
)
usually if you use the search function in phpmyadmin,
you write a word and every time, you have to add the
'%' before and after the searchword.
this should be optional for non-text fields. 'LIKE'
should be the second option and a new option is fist
'search' which just means, that you don`t have to add
the '%'
to add it to your myadmin, change this in the script
tbl_select.php:
change line 39 from
$textfunctions = array('LIKE', '=', '!=');
to
$textfunctions = array('search', 'LIKE', '=', '!=');
and add this:
if ($func[$i]=='search') {
$func[$i]='LIKE';
$fields[$i]='%'.$fields[$i].'%';
}
to line 282, before
$sql_query .= ' AND ' .
PMA_backquote(urldecode($names[$i])) . ' ' . $func[$i]
. ' ' . $quot . PMA_sqlAddslashes($fields[$i]) . $quot;
----------------------------------------------------------------------
>Comment By: Ruben Barkow (rubo77)
Date: 2004-05-04 23:20
Message:
Logged In: YES
user_id=334647
sounds good, and this as default is very handy, cause
usually you are looking for something within one of the strings
----------------------------------------------------------------------
Comment By: Marc Delisle (lem9)
Date: 2004-05-03 17:08
Message:
Logged In: YES
user_id=210714
I like the idea. However, instead of putting "search"
(anyway it would have to be $strSearch), and because the
column title is now "operator", maybe we could put this in
the choice:
LIKE %...%
----------------------------------------------------------------------
Comment By: Ruben Barkow (rubo77)
Date: 2004-05-01 06:44
Message:
Logged In: YES
user_id=334647
i downloaded version 2.14 of tbl_select.php from the CVS
http://cvs.sourceforge.net/viewcvs.py/phpmyadmin/phpMyAdmin/tbl_select.php#rev2.12
and added the lines.
i put the changed tbl_select.php as an attachement here,
since i cannot upload it in the CVS-tree
Ruben Barkow
----------------------------------------------------------------------
Comment By: Ruben Barkow (rubo77)
Date: 2004-05-01 06:13
Message:
Logged In: YES
user_id=334647
can i try implement this in the CVS?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377410&aid=939197&group_id=23067
|
