| 69 |
aurelien |
1 |
<?php
|
|
|
2 |
require_once 'JrestService.php';
|
|
|
3 |
|
|
|
4 |
class DBAccessor extends JrestService {
|
|
|
5 |
|
|
|
6 |
public function connectDB($config, $base = 'database') {
|
|
|
7 |
require_once 'DB.php';
|
|
|
8 |
$dsn = $config[$base];
|
|
|
9 |
|
|
|
10 |
$DB =& DB::connect($dsn);
|
|
|
11 |
if (DB::isError($DB)) {
|
|
|
12 |
die($DB->getMessage());
|
|
|
13 |
}
|
|
|
14 |
$DB->query("SET NAMES 'utf8'");
|
|
|
15 |
|
|
|
16 |
return $DB;
|
|
|
17 |
}
|
|
|
18 |
|
|
|
19 |
public function connecterPDO($config, $base = 'database') {
|
|
|
20 |
$cfg = $config[$base];
|
|
|
21 |
$dsn = $cfg['phptype'].':dbname='.$cfg['database'].';host='.$cfg['hostspec'];
|
|
|
22 |
try {
|
|
|
23 |
$PDO = new PDO($dsn, $cfg['username'], $cfg['password']);
|
|
|
24 |
} catch (PDOException $e) {
|
|
|
25 |
echo 'La connexion à la base de donnée via PDO a échouée : ' . $e->getMessage();
|
|
|
26 |
}
|
|
|
27 |
// Passe en UTF-8 la connexion à la BDD
|
|
|
28 |
$PDO->exec("SET NAMES 'utf8'");
|
|
|
29 |
// Affiche les erreurs détectées par PDO (sinon mode silencieux => aucune erreur affiché)
|
|
|
30 |
$PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
|
31 |
return $PDO;
|
|
|
32 |
}
|
|
|
33 |
}
|
|
|
34 |
?>
|