Classe: Horde_SQL_Keywords - X-Ref
This class provides a parser which can construct an SQL WHERE
clause from a Google-like search expression.
$Horde: framework/SQL/SQL/Keywords.php,v 1.2.10.4 2006/01/01 21:28:33 jan Exp $
Copyright 2004-2006 Cronosys, LLC <http://www.cronosys.com/>
See the enclosed file COPYING for license information (LGPL). If you
did not receive this file, see http://www.fsf.org/copyleft/lgpl.html.
The expression recognizes boolean "AND", "OR", and "NOT" (providing
no operator between keywords implies "AND"), like so:
cat and dog
cat or dog
cat and not dog
If no operator appears between keywords or quoted strings, "AND" is
assumed. A comma can be used instead of "OR":
cat dog
cat, dog
cat not dog
The parser recognizes parentheses, so complex expressions can be
created:
cat and not (dog or puppy)
Quoted strings are also recognized, and are taken as literal
keywords:
"cat and dog"
Parsing is designed to be as fuzzy as possible, so it shouldn't
error unless people search for "AND", "OR", or "NOT" without
quoting it or use unbalanced parentheses.
|
parse($column, $expr)
X-Ref
|
Parse a keyword expression.
param: string $column This is the SQL field name the resulting
param: string $expr This is the keyword expression we want to
return: mixed the query expression or a PEAR_Error on failure.
|