[PHP-DB] Construct, Q+E, QBE From: Fernando Ortiz (fortiz <email protected>)
Date: 07/17/02

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