27 lines
687 B
PHP
27 lines
687 B
PHP
<?php
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Genre_model extends CI_Model {
|
|
|
|
public function __construct() {
|
|
parent::__construct();
|
|
$this->load->database();
|
|
}
|
|
|
|
public function get_all() {
|
|
$query = $this->db->get('genre');
|
|
return $query->result_array();
|
|
}
|
|
|
|
public function get_by_game($game_id) {
|
|
$this->db->select('genre.*');
|
|
$this->db->from('genre');
|
|
|
|
$this->db->join('game_genre', 'game_genre.genreId = genre.genreId');
|
|
|
|
$this->db->where('game_genre.gameId', $game_id);
|
|
|
|
$query = $this->db->get();
|
|
return $query->result_array();
|
|
}
|
|
} |