本文整理汇总了PHP中DataMapper::or_where方法的典型用法代码示例。如果您正苦于以下问题:PHP DataMapper::or_where方法的具体用法?PHP DataMapper::or_where怎么用?PHP DataMapper::or_where使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataMapper
的用法示例。
在下文中一共展示了DataMapper::or_where方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: or_like_with_overlay
/**
* Add like condition to where clause, with OR operator, 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 or_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->or_where($subquery);
return $object;
}