| Index
» Projects
» phpMyEdit
» Forum
» question about filters |
 |
mrodent
Joined: 01 Mar 2015
Posts: 6
Posted: 2015-03-26 13:56
Back to top
Reply with quote
|
Hi,
I have spent the past few weeks developing this project so it implements subform functionality (using JQuery).
I have a question about the filter mechanism, and you might be able to save me several more hours of puzzling away at the phpMyEdit.class.php file.
In the function gather_query_opts I am trying to work out what the variables $m, $mc and $mi identify?
At the moment, whenever I put '>[xxx]' in a filter box, the resulting WHERE clause comes out as "LIKE '%>[xxx]%', even if this is a numeric field and [xxx] can be parsed as numeric, or even if this is a date field and [xxx] can be parsed as a date.
I just wanted to check that there is currently no way of applying a "comparison filter" (i.e. "<", ">=", etc.) to numeric, date (or string for that matter) fields.
Thanks
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2015-03-26 14:52
Back to top
Reply with quote
|
http://opensource.platon.org/projects/doc.php/phpMyEdit/html/configuration.basic-options.html
Set select to N
I don't know what $m, $mc and $mi represent. Echo them temporarily to determine their value.
echo "\n".'<p>$m = '.$m.'</p>';
A good debugging aid can be found at
http://dbug.ospinto.com/
|
mrodent
Joined: 01 Mar 2015
Posts: 6
Posted: 2015-03-26 16:22
Back to top
Reply with quote
|
thanks... from experimentation I find this comparison filtering also works for Date and String values.
I've been using logging extensively during this development phase, specifically log4php. I don't think I need to find out everything about these variables now thanks to your answer...
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
