function date_time_fomat($date) { $row = explode(" ", $date); $row_time = $row['1']; $row_date = date_fomat($row['0']); echo $row_time . ' - ' . $row_date; }
function lists($select = '*', $where = '', $ordering = '', $limit = '', $other = '') { $select = str_replace(',', ',b.', $select); if ($ordering == '') { $ordering = 'b.' . $this->key . ' DESC'; } if ($other != '') { $select = $select . ',cat.category_id as cat_id, cat.name as cat_name, cat.s_intro as sintro'; $other = "LEFT JOIN 8x_blog_category as cat ON cat.category_id = b.category_id"; } $result = $this->db->lists($this->table . ' AS b', 'b.' . $select, $where, $ordering, $limit, $other); $i = 0; while ($row = $this->db->fetch_assoc($result)) { $list[$i]->blog_id = $row[$this->key]; $list[$i]->title = $row['title']; $list[$i]->keyword = $row['keyword']; $list[$i]->meta = $row['meta']; $list[$i]->cat_name = $row['cat_name']; $list[$i]->cat_id = $row['cat_id']; $list[$i]->body = $row['body']; $list[$i]->publishdate = date_fomat($row['publishdate']); $list[$i]->status = $row['status']; $list[$i]->desc = $row['description']; $list[$i]->alias = $row['alias']; $list[$i]->s_intro = $row['sintro']; $i++; } $this->db->free_result($result); return $list; }
function lists($select = '*', $where = '', $ordering = '', $limit = '', $other = '') { $select = str_replace(',', ',c.', $select); if ($ordering == '') { $ordering = 'c.' . $this->key . ' DESC'; } if ($other != '') { $select = $select . ',b.blog_id as blog_id, b.title'; $other = "LEFT JOIN 8x_blogs as b ON b.blog_id = c.blog_id"; } $result = $this->db->lists($this->table . ' as c', 'c.' . $select, $where, $ordering, $limit, $other); $i = 0; while ($row = $this->db->fetch_assoc($result)) { $list[$i]->comment_id = $row[$this->key]; $list[$i]->name = $row['name']; $list[$i]->email = $row['email']; $list[$i]->blog_id = $row['blog_id']; $list[$i]->title = $row['title']; $list[$i]->comments = $row['comments']; $list[$i]->url = $row['url']; $list[$i]->commentdate = date_fomat($row['commentdate']); $list[$i]->status = $row['status']; $i++; } $this->db->free_result($result); return $list; }
function lists($select = '*', $where = '', $ordering = '', $limit = '', $other = '') { if ($where != '') { $where = ' && ' . $where; } $where = 'n.lang = ' . $_SESSION['lang'] . $where; $select = str_replace(',', ',n.', $select); if ($ordering == '') { $ordering = 'n.' . $this->key . ' DESC'; } if ($other != '') { $cha = new channel_news(); $cat = new category_news(); $select = $select . ',cha.cha_id,cha.name as cha_name,cat.cat_id,cat.name as cat_name'; $other = "LEFT JOIN " . $cha->table . " as cha ON cha.cha_id = n.cha_id\n\t\t\t\t\tLEFT JOIN " . $cat->table . " as cat ON cat.cat_id = n.cat_id"; } $result = $this->db->lists($this->table . ' AS n', 'n.' . $select, $where, $ordering, $limit, $other); $i = 0; while ($row = $this->db->fetch_assoc($result)) { $list[$i]->news_id = $row['news_id']; $list[$i]->cha_name = $row['cha_name']; $list[$i]->cat_name = $row['cat_name']; $list[$i]->alias = $row['alias']; $list[$i]->name = $row['name']; $list[$i]->special = $row['special']; $list[$i]->description = $row['description']; $list[$i]->detail = $row['detail']; $list[$i]->hit = $row['hit']; $list[$i]->date_up = date_fomat($row['date_up']); $list[$i]->image = $row['image']; $list[$i]->ordering = $row['ordering']; $list[$i]->cards_list = $row['cards_list']; $list[$i]->card_slogan = $row['card_slogan']; $i++; } $this->db->free_result($result); return $list; }
function lists($select, $where = '', $limit) { /* if ($where != ''){ $where = ' && '.$where; } $where = 'lang = '.$_SESSION['lang'].$where;*/ $result = $this->db->lists($this->table, '', $where, 'ordering', $limit); $i = 0; while ($row = $this->db->fetch_assoc($result)) { $list[$i]->faq_id = $row[$this->key]; $list[$i]->name = $row['name']; $list[$i]->email = $row['email']; $list[$i]->subject = $row['subject']; $list[$i]->question = $row['question']; $list[$i]->answer = $row['answer']; $list[$i]->status = $row['status']; $list[$i]->date = date_fomat($row['date']); $list[$i]->ordering = intval($row['ordering']); $i++; } $this->db->free_result($result); return $list; }