PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- function getFeaturedProducts($limit = 3){
- $sql = "SELECT COUNT(*) as total FROM products WHERE featured = 1";
- $query = $this->db->query($sql);
- $total = $query->row()->total;
- if($limit > $total) $limit = $total;
- $offset_str = '';
- for($i = 0; $i < $limit; $i++){
- $sql = "SELECT * FROM products WHERE featured = 1 " . $offset_str . " ORDER BY rand() LIMIT 1";
- $result = $this->db->query($sql)->row_array();
- $products[] = $result ? $result : $result;
- }
- return $products;
- }