par
alassane » 16 janv. 2015, 00:06
Voici ma classe connexion:
<?php
class connexion{
public $conn;
function __construct(){
try {
$mode = "PROD";
if($mode == "DEV"){
$dsn = 'sqlsrv:Server=192.xxx.x.xx;Database=DEV_stock';
$user = 'bduser';
$password = 'xxxx';
}else{
$dsn = 'sqlsrv:Server=192.xxx.x.xx;Database=Stock';
$user = 'bduser';
$password = 'xxxxxx';
}
$this->conn = new PDO($dsn, $user, $password, null);
}catch (PDOException $e){
echo 'Connexion échouée : ' . $e->getMessage();
}
}
function query($query){
return $this->conn->query($query);
}
function lastInsertId(){
//return $this->conn->lastInsertId();
$prep = $this->prepare("SELECT SCOPE_IDENTITY() as ID");
$prep->execute();
$res = $prep->fetch();
return $res['ID'];
}
function prepare($req){
return $this->conn->prepare($req);
}
function errorInfo(){
var_dump($this->conn->errorInfo());
}
}
?>
Voici ma classe connexion:
<?php
class connexion{
public $conn;
function __construct(){
try {
$mode = "PROD";
if($mode == "DEV"){
$dsn = 'sqlsrv:Server=192.xxx.x.xx;Database=DEV_stock';
$user = 'bduser';
$password = 'xxxx';
}else{
$dsn = 'sqlsrv:Server=192.xxx.x.xx;Database=Stock';
$user = 'bduser';
$password = 'xxxxxx';
}
$this->conn = new PDO($dsn, $user, $password, null);
}catch (PDOException $e){
echo 'Connexion échouée : ' . $e->getMessage();
}
}
function query($query){
return $this->conn->query($query);
}
function lastInsertId(){
//return $this->conn->lastInsertId();
$prep = $this->prepare("SELECT SCOPE_IDENTITY() as ID");
$prep->execute();
$res = $prep->fetch();
return $res['ID'];
}
function prepare($req){
return $this->conn->prepare($req);
}
function errorInfo(){
var_dump($this->conn->errorInfo());
}
}
?>