canon

Using something like the WHERE part of an SQL query to evaluate an array like thing is true or false.

Basic Usage

use EUAutomation\Canon\Processor;
$processor = new Processor();
$expressions = $processor->process('foo = "bar"');
$expressions->evaluate([ "foo" => "bar" ]); // true

Supports

• Basic Operators (=, !=, >, >=, <, <=) foo > 9000
• LIKE Operator foo LIKE "shoes%"
• LIKE ANY Operator foo LIKE ANY ("shoes%", "socks%")
• IN Operator foo IN (1, 2)
• Nested Columns Refs foo.bar = 'baz'
• Brackets foo = 2 AND (bar = 3 OR baz < 10)

Acknowledgments

• https://github.com/greenlion/PHP-SQL-Parser - lots of the parser code is from here