public function findByEntraineurId($id) { $reponse = $this->db->query(self::FIND_BY_ENTRAINEUR_ID . "'{$id}'"); $equipes = array(); while ($data = $reponse->fetch()) { $equipe = new Equipe(); $equipe->setId($data['NUMERO_EQUIPE']); $equipe->setNomCategorie($data['NOM_CATEGORIE']); array_push($equipes, $equipe); } $reponse->closeCursor(); return $equipes; }
while ($resultidequipe = $result1->fetch()) { $idequipe = $resultidequipe['id_equipe']; $_SESSION['test'] = $idequipe; $_GET['id_equipe'] = $idequipe; echo $_GET['id_equipe']; } $result3 = $bd->prepare('SELECT pseudo FROM utilisateur u JOIN appartenir a ON u.id_utilisateur = a.id_utilisateur WHERE a.id_equipe in (SELECT a.id_equipe from appartenir a JOIN equipe e on a.id_equipe = e.id_equipe join utilisateur u on a.id_utilisateur = u.id_utilisateur where e.nom = ? and u.pseudo = ? )'); $result3->execute(array($test, $pseudo)); while ($resultmembrequipe = $result3->fetch()) { echo $resultmembrequipe['pseudo'] . '<br />'; } require_once '../includes/equipe.class.php'; include '../includes/boutonsEquipe.php'; if (isset($_POST['Ajouter']) && isset($_POST['info'])) { $info = $_GET['info']; $equipe = Equipe::ajouter($_GET['info']); echo $info; } //echo $equipe= ajouter($info); //echo $info; //echo $info = $_POST['info']; } ?> </fieldset> </form> </div> </div> </div> </div> </div> </div>
/** * / * @param [type] $app [description] * @return [type] [description] */ public function route($app) { $app->view->setLayout($layout); $app->get('/tag/:tag', function ($tag) use($app) { })->name('tag')->conditions(array('' => '')); $app->get('/', function () use($app) { $result = Content::query($app->db, 'findPublished'); $app->view->setData($result); $app->view->render(''); })->name('home'); $app->get('/perfil', function () use($app) { $result = User::query($app->db, 'show', $app->sessionDataStore->getUserId()); $app->view->setData($result); $app->view->render(''); })->name('perfil'); $app->get('/perfil/editar', function () use($app) { $app->view->setData($result); $app->view->render(''); })->name('salvar_perfil'); $app->post('/perfil/salvar', function () use($app) { $record = $app->handler->handlePostRequest(); $app->redirect($app->urlFor('')); })->name('salvar_perfil'); $app->post('/comentar', function () use($app) { $record = $app->handler->handlePostRequest(); $app->redirect($app->urlFor('')); })->name('comentar'); $app->get('/programacao(/:pagina)', function ($pagina = 1) use($app) { $result = Event::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('programacao')->conditions(array('' => '')); $app->get('/evento/:slug/:id', function ($slug, $id) use($app) { $result = Event::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('evento')->conditions(array('' => '')); $app->get('/espacos(/:pagina)', function ($pagina = 1) use($app) { $result = Content::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('espacos')->conditions(array('' => '')); $app->get('/espaco/:slug/:id', function ($slug, $id) use($app) { $result = Content::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('espaco')->conditions(array('' => '')); $app->get('/galerias(/:pagina)', function ($pagina = 1) use($app) { $result = Content::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('galerias')->conditions(array('' => '')); $app->get('/galeria/:slug/:id', function ($slug, $id) use($app) { $result = Content::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('galeria')->conditions(array('' => '')); $app->get('/revista(/:pagina)', function ($pagina = 1) use($app) { $result = Content::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('revista')->conditions(array('' => '')); $app->get('/materia/:slug/:id', function ($slug, $id) use($app) { $result = Content::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('materia')->conditions(array('' => '')); $app->get('/notas(/:pagina)', function ($pagina = 1) use($app) { $result = Content::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('notas')->conditions(array('' => '')); $app->get('/secao/:slug/:id', function ($id) use($app) { $result = Content::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('nota')->conditions(array('' => '')); $app->get('/equipe', function () use($app) { $result = Equipe::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('equipe'); $app->get('/consultas(/:pagina)', function ($pagina = 1) use($app) { $result = ConsultaPublica::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('consultas')->conditions(array('' => '')); $app->get('/consulta/:id', function ($id) use($app) { $result = ConsultaPublica::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('consulta')->conditions(array('' => '')); $app->get('/editais(/:pagina)', function ($pagina = 1) use($app) { $result = Edital::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('editais')->conditions(array('' => '')); $app->get('/edital/:id', function ($id) use($app) { $result = Edital::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('edital')->conditions(array('' => '')); $app->get('/projetos(/:pagina)', function ($pagina = 1) use($app) { $result = Content::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('projetos')->conditions(array('' => '')); $app->get('/projeto/:id', function ($id) use($app) { $result = Content::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('projeto')->conditions(array('' => '')); $app->get('/leis(/:pagina)', function ($pagina = 1) use($app) { $result = LeiIncentivo::query($app->db, 'findPublished', $pagina); $app->view->setData($result); $app->view->render(''); })->name('leis')->conditions(array('' => '')); $app->get('/lei/:id', function ($id) use($app) { $result = LeiIncentivo::query($app->db, 'showPublished', $id); $app->view->setData($result); $app->view->render(''); })->name('lei')->conditions(array('id' => '\\d+')); return $app; }
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Tests Classe Equipe Std</title> </head> <body> <h1>Tests Classe Equipe</h1> <?php require_once 'test.php'; require_once '../classes/element.php'; require_once '../classes/souleur.php'; require_once '../classes/a_equipe.php'; require_once '../classes/equipe/equipeStd.php'; $eq = new Equipe(); $eq->offsetGet(11)->position = 2; echo "Position joueur 11:" . $eq->offsetGet(11)->position; $eq[7]->position = 3; echo "<br>Position joueur 7:" . $eq->offsetGet(7)->position . " PtVie:" . $eq->offsetGet(7)->ptVie; echo "<br>Position joueur 8:" . $eq->offsetGet(8)->position; echo "<br><br>*** Test toString Equipe ***<br>"; echo $eq; ?> </body> </html>
<?php // inclure user.php et connect_bd.php dans chaque page ayant besoin des informations de l'utilisateur //require_once 'equipe.class.php'; if (isset($_POST['Ajouter']) && isset($_POST['info'])) { try { $info = $_POST['info']; $equipe = Equipe::ajouter($_POST['info']); } catch (Exception $e) { $loginError = $e->getMessage(); } } echo json_encode(['equipe' => $equipe]); system . out . println($info);
public function excluirAction() { $this->_helper->viewRenderer->setNoRender(); $this->_helper->layout->disableLayout(); $db = new Equipe(); $request = $this->getRequest(); $id = $request->getParam('id'); $db->deleteProfissional($id); $this->_helper->redirector('listar', 'equipe'); }