PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- public static function getCategoryList()
- {
- $db = Db::getConnection();
- $lang = self::Language();
- $categoryList = [];
- $result = $db->query("SELECT id, title$lang,slug$lang, sub_category_id FROM blog_category WHERE status='1' ORDER BY sort_order ASC");
- foreach($result as $row){
- $categoryList[] = [
- 'id' => $row[0],
- 'title' => $row[1],
- 'slug' => $row[2]
- ];
- }
- return $categoryList;
- }