public static function findByGame($id_game)
{
$class = get_called_class();
$table = strtolower($class);
$idtable = substr($table, -3) . "_id";
$list = array();
foreach (T_E_PHOTO_PHO::findAll() as $row) {
if ($row->T_E_JEUVIDEO_JEU->jeu_id == $id_game) {
$list[] = new $class($row->pho_id, $row->T_E_JEUVIDEO_JEU, $row->pho_url);
}
}
return $list;
}
public function gallery()
{
$j = T_E_JEUVIDEO_JEU::findAll();
$p = T_E_PHOTO_PHO::findAll();
$m = T_E_VIDEO_VID::findAll();
$listj = array();
foreach ($j as $k => $v) {
unset($list);
$list['nom'] = $v->jeu_nom;
foreach ($p as $x => $y) {
if ($y->T_E_JEUVIDEO_JEU->jeu_id == $v->jeu_id) {
$list['pho_url'][] = $y->pho_url;
}
}
foreach ($m as $x => $y) {
if ($y->T_E_JEUVIDEO_JEU->jeu_id == $v->jeu_id) {
$list['vid_url'][] = $y->vid_url;
}
}
array_push($listj, $list);
}
$this->render("gallery", $listj);
}
