public static function getInstance() { if (!isset(self::$_instance)) { // Si aucune instance de DBConnectionManager trouvée self::$_instance = new DBConnectionManager(); // alors créer une instance } return self::$_instance; // Retour de l'objet connection }
public function __construct($type, $phase) { try { $i = 0; $db = DBConnectionManager::getInstance(); $resultMatch = $db->getListeMatch($type, $phase); foreach ($resultMatch as $data) { $this->_listeMatch[$i] = new Match($data['noMatch'], $data['noCourt'], $data['noCreneau'], $data['phase'], $data['noJoueur1'], $data['noJoueur2'], $data['noJoueur3'], $data['noJoueur4'], $data['nbPlacesRestantes'], $data['date'], $data['resultatJ1'], $data['resultatJ2'], $data['gagnant'], $data['Type']); $i++; } $db->closeCursor(); } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } }
public function __construct() { try { $i = 0; $db = DBConnectionManager::getInstance(); $resultCourt = $db->getCourts(); foreach ($resultCourt as $data) { $this->_listeCourt[$i] = new Court($data['noCourt'], $data['nomCourt'], $data['typeCourt'], $data['reserve']); $i++; } $db->closeCursor(); } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } }
public function __construct() { try { $i = 0; $db = DBConnectionManager::getInstance(); $resultJoueur = $db->getJoueurs(); foreach ($resultJoueur as $data) { $this->_listeJoueur[$i] = new Joueur($data['noJoueur'], $data['nomJoueur'], $data['prenomJoueur'], $data['dob'], $data['nationalite'], $data['typeEntree']); $i++; } $db->closeCursor(); } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } }
public static function ExecuteQuery($sql) { $connection = DBConnectionManager::get_connection(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME); $db = MDB::cursor($connection, ''); return $db->fetchObject($db->query($sql)); }
public function __construct() { $DBManager = new DBConnectionManager(); $this->db = $DBManager->connect(); }
public function escapeString($string) { #Para poder executar o realEscapeString, precisamos ter uma conexão aberta. if (!$this->conn) { $this->SetConnection(DBConnectionManager::getMasterConnection()); } return mysqli_real_escape_string($this->conn, $string); }
$CDAO = new ClimbingAreaDAO(); $areaid = 7; $indoor = 1; var_dump($CDAO->climbingAreaExists($areaid, $indoor)); $UserDAO = new UserDAO(); echo $UserDAO->getNumUsers(); var_dump($UserDAO->getUserPrefs(954)); var_dump($UserDAO->setUserPrefs(954, array("show_boulder" => 1, "minL" => 3))); var_dump($UserDAO->getUserPrefs(954)); var_dump($UserDAO->getUserProfile(954)); var_dump($UserDAO->getUserRecords(954)); $WorkoutService = new WorkoutLoggingService(); $workout_segments_abs = array(array("climb_type" => "boulder", "ascent_type" => "flash", "grade_index" => 1, "reps" => 1), array("climb_type" => "toprope", "ascent_type" => "project", "grade_index" => 9, "reps" => 5), array("climb_type" => "lead", "ascent_type" => "redpoint", "grade_index" => 11, "reps" => 6), array("climb_type" => "boulder", "ascent_type" => "onsight", "grade_index" => 13, "reps" => 2)); var_dump($WorkoutService->calcWorkoutPoints($workout_segments_abs)); // Save a workout $DBManager = new DBConnectionManager(); $db = $DBManager->connect(); // userid, date_workout, gymid, boulder_notes, // tr_notes, lead_notes, other_notes $userid = 4; $workout_info = array("userid" => $userid, "date_workout" => "2015-10-23", "gymid" => 1, "boulder_notes" => "bouldering!", "tr_notes" => "tr rocks", "lead_notes" => "", "other_notes" => "other notes!!!"); $workout_info["boulder_points"] = 200; $workout_info["TR_points"] = 300; $workout_info["Lead_points"] = 400; $userrecordDAO = new UserRecordsDAO(); var_dump($userrecordDAO->getUserRecords($userid)); $results = $WorkoutService->saveWorkoutAbsGrades($workout_info, $workout_segments_abs); echo $results; //$grading_systems = array("boulder"=>2,"route"=>4); //$results = $WorkoutService->saveWorkoutRelGrades($workout_info, $workout_segments_abs, $grading_systems); //$gradingConversionService = new GradingConversionService();
public static function ExecuteQuery($sql, $use_memcache = USE_MEMCACHE, $memcache_seconds = MEMCACHE_SECONDS, $memcache_custom_key = NULL) { $db = MDB::cursor(''); $db->SetConnection(DBConnectionManager::getProperConnection($sql)); return $db->query($sql, $use_memcache, $memcache_seconds, $memcache_custom_key); }
<?php require_once '../Model/DBConnectionManager.php'; require_once '../Model/ListeMatch.php'; require_once '../Model/ListeJoueur.php'; require_once '../Model/Commande.php'; try { $dbb = DBConnectionManager::getInstance(); if (isset($_COOKIE['id']) && isset($_COOKIE['prenom'])) { session_start(); $_SESSION['id'] = $_COOKIE['id']; $_SESSION['prenom'] = $_COOKIE['prenom']; $_SESSION['type'] = $_COOKIE['type']; $_SESSION['phase'] = $_COOKIE['phase']; } $listeMatch = new ListeMatch($_COOKIE['type'], $_COOKIE['phase']); $errormsg = ''; $listeJoueur = new ListeJoueur(); //$commande = Commande::getInstance(null,null,null,null,null,null); if (isset($_GET['action'])) { if ($_GET['action'] == 'reservation') { require_once '../View/choixtype.php'; } else { if ($_GET['action'] == 'type') { if ($_GET['value'] == 'simple') { //$commande->setTypeMatch('simple'); setcookie('type', 'simple', time() + 365 * 24 * 3600, null, null, false, true); require_once '../View/choixphase.php'; } elseif ($_GET['value'] == 'double') { //$commande->setTypeMatch('double'); setcookie('type', 'double', time() + 365 * 24 * 3600, null, null, false, true);