I'm migrating my code from Informix 4GL to PHP, my problem now is how to
give the users the ability to make a query with the facilities that the
CONTRUCT verb gives in 4GL.
Suppose a form field name 'price' where the users can type the search
criteria
If the user type ... I need to get ...
123.23 "price = 123.23"
>100 "price > 100"
<=500 "price <= 500"
100..200 "price between 100 and 200"
100,200 "price in (100,200)"
In a string field named "city"
If the user type ... I need to get
sacramento "city = 'SACRAMENTO'"
sacra* "city MATCHES 'SACRA*'"
>Wy "city > 'WY"
etc.
Something like ..
$qbe = qbe('city','options')
$qry = "select * from customers where ".$qbe;
and the qbe function can get the typed from $_POST[$parm1] and using the
options chose between char or numeric data type , upshift or as is, matches
or like, etc.
Exist something like that?
I'm reinventing the wheel?
How are you solving this kind of problem?
TIA
--
Fernando Ortiz Muņoz
Fabrica de Jabon la Corona, SA de CV
MEXICO
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
