本文整理匯總了PHP中DataMapper::where方法的典型用法代碼示例。如果您正苦於以下問題：PHP DataMapper::where方法的具體用法？PHP DataMapper::where怎麽用？PHP DataMapper::where使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DataMapper的用法示例。
在下文中一共展示了DataMapper::where方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: like_with_overlay
/**
* Add like condition to where clause for column which can be translated with language overlay.
* @param DataMapper $object model object which will be using this function.
* @param string $column column name in table.
* @param string $value search text.
* @param string $wrap wraping constant, can be 'both', 'before', 'after'.
* @param bool $strip_html if set to TRUE it will strip html tags from column.
* @param string $lang_idiom language idiom, default is NULL = current language idion set in language object.
* @return DataMapper returns object for method chaining.
*/
public function like_with_overlay($object, $column, $value, $wrap = 'both', $strip_html = FALSE, $lang_idiom = NULL)
{
$CI =& get_instance();
if (is_null($lang_idiom)) {
$lang_idiom = $CI->lang->get_current_idiom();
}
$like = $wrap == 'before' ? '%' . $object->db->escape_like_str($value) : ($wrap == 'after' ? $object->db->escape_like_str($value) . '%' : '%' . $object->db->escape_like_str($value) . '%');
$subquery = ($strip_html === TRUE ? 'fnStripTags(' : '') . '(SELECT `text` AS `like_text`
FROM `lang_overlays`
WHERE `table` = "' . $object->db->escape_str($object->table) . '" AND `table_id` = ' . $object->db->protect_identifiers($object->table) . '.`id` AND `column` = "' . $object->db->escape_str($column) . '" AND `idiom` = "' . $object->db->escape_str($lang_idiom) . '"
UNION
SELECT ' . $object->db->protect_identifiers($object->table) . '.' . $object->db->protect_identifiers($column) . ' AS `like_text`
LIMIT 1)' . ($strip_html === TRUE ? ') COLLATE ' . $object->db->dbcollat : '') . ' LIKE "' . $like . '"';
$object->where($subquery);
return $object;
}