cassell/Parm

<?php

namespace Parm\Binding;

use Parm\DataAccessObjectFactory;

class ContainsBinding implements SQLString
{
    /**
     * The field/column to filter on
     * @var string
     */
    public $field;

    /**
     * The value to filter the field/column on
     * @var string
     */
    public $query;

    /**
     * Filter rows where the field/column contains the query string
     * @param $field string
     * @param $query string
     */
    public function __construct($field, $query)
    {
        $this->field = $field;
        $this->query = $query;
    }

    /**
     * Return the SQL String
     *
     * @param $factory DataAccessObjectFactory
     * @return string
     */
    public function getSQL(\Parm\DataAccessObjectFactory $factory)
    {
        return $this->field . " LIKE " . $factory->escapeString('%'.str_replace("_", "\\_", str_replace("%", "\\%", $this->query)).'%') . "";
    }
}