本文整理匯總了PHP中PerchUtil::implode_for_sql_in方法的典型用法代碼示例。如果您正苦於以下問題：PHP PerchUtil::implode_for_sql_in方法的具體用法？PHP PerchUtil::implode_for_sql_in怎麽用？PHP PerchUtil::implode_for_sql_in使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類PerchUtil的用法示例。
在下文中一共展示了PerchUtil::implode_for_sql_in方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: get_by
/**
* Get a collection of items where the given column matches the given value. e.g. get_by('catID', 2) would get all rows with catID=2.
* If $val is an array, does a SQL WHERE IN(array)
*
* @param string $col
* @param string $val
* @param string $order_by_col
* @return void
* @author Drew McLellan
*/
public function get_by($col, $val, $order_by_col = false, $Paging = false)
{
if (is_object($Paging)) {
$select = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT ';
} else {
$select = 'SELECT ';
}
if (is_array($val)) {
$sql = $select . ' * FROM ' . $this->table . ' WHERE ' . $col . ' IN (' . PerchUtil::implode_for_sql_in($val) . ') ' . $this->standard_restrictions();
} else {
$sql = $select . ' * FROM ' . $this->table . ' WHERE ' . $col . '=' . $this->db->pdb($val) . ' ' . $this->standard_restrictions();
}
if ($order_by_col) {
$sql .= ' ORDER BY ' . $order_by_col;
} else {
if ($this->default_sort_column) {
$sql .= ' ORDER BY ' . $this->default_sort_column . ' ' . $this->default_sort_direction;
}
}
if (is_object($Paging) && $Paging->enabled()) {
$limit = ' LIMIT ' . $Paging->lower_bound() . ', ' . $Paging->per_page();
$sql .= $limit;
}
$rows = $this->db->get_rows($sql);
if (is_object($Paging) && $Paging->enabled()) {
$sql = "SELECT FOUND_ROWS() AS count";
$total = $this->db->get_value($sql);
$Paging->set_total($total);
}
return $this->return_instances($rows);
}