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');
}
