public function execute() { $db = Connexion::getConnexion(); $statement = $db->prepare("DELETE FROM shows WHERE id = ?"); $statement->bindValue(1, $_POST["id"], PDO::PARAM_INT); $statement->execute(); }
public function __construct($dbhost, $dbname, $user, $password) { $this->host = $dbhost; $this->dbname = $dbname; $this->user = $user; $this->password = $password; $this->bdd = Connexion::getConnexion($dbhost, $dbname, $user, $password); }
public static function addShow($name, $season, $nb_epi_total, $status) { $db = Connexion::getConnexion(); $statement = $db->prepare("INSERT INTO shows (name,season,nb_episodes_total,status) VALUES(?,?,?,?)"); $statement->bindValue(1, $name, PDO::PARAM_STR); $statement->bindValue(2, $season, PDO::PARAM_STR); $statement->bindValue(3, $nb_epi_total, PDO::PARAM_INT); $statement->bindValue(4, $status, PDO::PARAM_INT); $statement->execute(); }
public static function obtenirLeClassement($idClassement) { try { $conn = Connexion::getConnexion(); $sql_matches = "select e1.nom as equipe_1, e2.nom as equipe_2, scoreEquipe1, scoreEquipe2, joue FROM championnats INNER JOIN journees ON journees.id_championnats = championnats.id INNER JOIN matches_basket ON id_journees = journees.id INNER JOIN equipes e1 ON id_equipe1 = e1.id INNER JOIN equipes e2 ON id_equipe2 = e2.id WHERE championnats.id = :Classement"; $sth1 = $conn->prepare($sql_matches); $c = array("Classement" => $idClassement); $sth1->execute($c); $matches = $sth1->fetchALL(PDO::FETCH_CLASS); $sql_equipes = "select nom FROM equipes where id_championnats = :Classement"; $sth2 = $conn->prepare($sql_equipes); $tabE = array("Classement" => $idClassement); $sth2->execute($tabE); $equipes = $sth2->fetchALL(PDO::FETCH_CLASS); /* a partir de la, a verifier */ $rEquipes = array("nom" => $equipes, "points" => array(), "joues" => array(), "victoires" => array(), "nuls" => array(), "defaites" => array()); foreach ($matches as $match) { if ($match['joue'] == 1) { if ($match['equipe_1'] === $rEquipes['nom']) { if ($match['scoreEquipe1'] > $match['scoreEquipe2']) { $rEquipes['points'] += 3; $rEquipes['victoires'] += 1; } if ($match['scoreEquipe1'] == $match['scoreEquipe2']) { $rEquipes['points'] += 1; $rEquipes['nuls'] += 1; } if ($match['scoreEquipe1'] > $match['scoreEquipe2']) { $rEquipes['defaites'] += 1; } $rEquipes['joues'] += 1; } if ($match['equipe_2'] === $rEquipes['nom']) { if ($match['scoreEquipe1'] > $match['scoreEquipe2']) { $rEquipes['points'] += 3; $rEquipes['victoires'] += 1; } if ($match['scoreEquipe1'] == $match['scoreEquipe2']) { $rEquipes['points'] += 1; $rEquipes['nuls'] += 1; } if ($match['scoreEquipe1'] > $match['scoreEquipe2']) { $rEquipes['defaites'] += 1; } $rEquipes['joues'] += 1; } } } return $rEquipes; } catch (PDOException $e) { $erreur = $e->getMessage(); } }
public function execute() { $db = Connexion::getConnexion(); $statement = $db->prepare("SELECT nb_episodes_watched, nb_episodes_total FROM shows WHERE id = ?"); $statement->bindValue(1, $_POST["id"], PDO::PARAM_INT); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); $previousValue = $result[0]["nb_episodes_watched"]; $total = $result[0]["nb_episodes_total"]; $statement = $db->prepare("UPDATE shows SET nb_episodes_watched=? WHERE id=?"); $statement->bindValue(1, $previousValue + 1, PDO::PARAM_INT); $statement->bindValue(2, $_POST["id"], PDO::PARAM_INT); $statement->execute(); $returnValue = array($previousValue + 1, $total); return $returnValue; }
public function execute() { Connexion::getConnexion(); if (!empty($_GET["logout"])) { if (!$_SESSION["logout"]) { session_unset(); session_destroy(); session_start(); $_SESSION["logout"] = true; } } if (empty($_SESSION["visibility"])) { $_SESSION["visibility"] = CommonAction::$VISIBILITY_PUBLIC; } if ($_SESSION["visibility"] < $this->pageVisibility) { header("location:index"); exit; } $this->executeAction(); Connexion::closeConnexion(); }
<?php require_once "../templates/connexion.php"; //On créer un objet connexion: $c = new Connexion(); $connexion = $c->getConnexion(); //Si on ajoute une oeuvre if (!empty($_GET['idOeuvreAttente'])) { $idOeuvreAttente = $_GET['idOeuvreAttente']; } //Si on supprime une oeuvre if (!empty($_GET['idOeuvreValidee'])) { $idOeuvreValidee = $_GET['idOeuvreValidee']; } //Pour supprimer l'oeuvre de la table des oeuvres validées if (!empty($idOeuvreValidee)) { $connexion->exec("DELETE FROM `oeuvre_validee` WHERE idOeuvre='" . $idOeuvreValidee . "'"); header("Location: jury.php?msg=1"); exit; } //Pour ajouter l'oeuvre non validée dans les validées if (!empty($idOeuvreAttente)) { $resultats = $connexion->prepare("INSERT INTO `oeuvre_validee` SELECT * FROM `oeuvre_attente`WHERE idOeuvre='" . $idOeuvreAttente . "'"); $resultats->execute(); /*//On récupère tous les attributs de la ligne $requete = $connexion->query("SELECT * FROM `oeuvre_attente` WHERE idOeuvre='".$idOeuvreAttente."'"); $requete->setFetchMode(PDO::FETCH_OBJ); $resultat = $requete->fetch(); $idArtiste = $resultat->idArtiste; $nomOeuvre = $resultat->nomOeuvre;
public function __construct() { $instance = new Connexion(); $this->connexion = $instance->getConnexion(); }
public function persist($obj) { $table = $obj->table; $columns = $obj->columns; $infos = $obj->infos; $exist = $this->getById($table, $obj->id); if (empty($exist)) { self::$queryType = strtoupper('insert'); $query = 'INSERT INTO ' . $table; $query .= '(' . implode(', ', $columns); $query .= ') VALUE ('; for ($i = 0; $i < count($infos) - 1; $i++) { $query .= '"' . $infos[$i] . '", '; } $query .= '"' . $infos[count($infos) - 1] . '"'; $query .= ');'; var_dump($query); $prepare = parent::getConnexion()->prepare($query); self::$prepare = $prepare; $prepare->execute(); } else { $this->update($table, $columns, $infos, 'id', $infos[0]); } }
public function __construct($host, $dbname, $dbuser, $dbpass) { $this->bdd = Connexion::getConnexion($host, $dbname, $dbuser, $dbpass); }