Exemplos de ConnexionBD em PHP

Exemplo n.º 1

Arquivo: PersonnePDO.php Projeto: pierrebiazotto/PHP_FW_Gestion-de-Personne

 public function supprimerPersonne($nomP, $prenomP)
 {
     $maConnexion = new ConnexionBD();
     $req2 = "DELETE FROM Personne WHERE nomP = '{$nomP}' AND prenomP = '{$prenomP}';";
     echo $req2;
     $res = $maConnexion->getConnexion()->exec($req2);
     if (!$res) {
         throw new ModeleExceptions(1);
     }
 }

Exemplo n.º 2

Arquivo: ConnexionBD.php Projeto: Benbb96/CPOA-GPTL

 public static function getInstance()
 {
     if (!isset(self::$_instance)) {
         self::$_instance = new self();
     }
     return self::$_instance;
 }

Exemplo n.º 3

Arquivo: Arbitres.php Projeto: Benbb96/CPOA-GPTL

 public function __construct()
 {
     $bdd = ConnexionBD::getInstance();
     $operations = $bdd->getData("SELECT * FROM operations");
     $i = 0;
     while ($data = $operations->fetch(PDO::FETCH_OBJ)) {
         $result = new Operations($data->idOperations, $data->idCompte, $data->typeOperations, $data->titreOperations, $data->contenuOperations, $data->dateOperations);
         $this->_listeOperations[$i] = $result;
         $i += 1;
     }
     $type = $bdd->getData("SELECT * FROM typeoperations");
     $i = 0;
     while ($data = $type->fetch(PDO::FETCH_OBJ)) {
         $result = new TypeOperations($data->idType, $data->nomType);
         $this->_listeType[$i] = $result;
         $i += 1;
     }
 }

Exemplo n.º 4

Arquivo: functions.php Projeto: Benbb96/CPOA-GPTL

<?php

require "../Models/ConnexionBD.php";
require "../Models/Message.php";
require "../Models/Operations.php";
$bdd = ConnexionBD::getInstance();
session_start();
function str_random($length)
{
    $chaine = "0123456789azertyuiopqsdfghjklmwxcvbnAZERTYUIOPQSDFGHJKLMWXCVBN";
    return substr(str_shuffle(str_repeat($chaine, $length)), 0, $length);
}

Exemplo n.º 5

Arquivo: ajout.php Projeto: hechemeljed/OBT_Finance

include 'DAO/ConnexionBD.php';
include 'DAO/GestionBD.php';
include 'DAO/EmpruntDAO.php';
include 'Metier/Emprunt.php';
$_libelleEmp = $_POST['libelleEmp'];
$_emetteur = $_POST['emetteur'];
$_inter = $_POST['inter'];
$_isin = $_POST['isin'];
$_mnemonique = $_POST['mnemonique'];
$_libelle = $_POST['libelle'];
$_taux = $_POST['taux'];
$_duree = $_POST['duree'];
$_nominal = $_POST['nominal'];
$_mode = $_POST['mode'];
$_nombre = $_POST['nombre'];
$_montant = $_POST['montant'];
$_dateJ = $_POST['dateJ'];
$_datePE = $_POST['datePE'];
$_dateDE = $_POST['dateDE'];
$_Connexion = new ConnexionBD();
$_Connexion->connect();
$_GestionBD = new GestionBD($_Connexion);
$_empruntDAO = new EmpruntDAO($_GestionBD);
$_emprunt = new emprunt($_libelleEmp, $_emetteur, $_inter, $_isin, $_mnemonique, $_libelle, $_taux, $_duree, $_nominal, $_mode, $_nombre, $_montant, $_dateJ, $_datePE, $_dateDE);
try {
    $_empruntDAO->AddObj($_emprunt);
    header("Location: index.php#start");
} catch (Exception $e) {
    header("Location: create.php?message=error");
}