database.php
919 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php
class Database {
private $host;
private $db;
private $user;
private $password;
//private $charset;
public function __construct(){
$this->host = constant ('HOST');
$this->db = constant ('DB');
$this->user = constant ('USER');
$this->password = constant ('PASSWORD');
//$this->charset = constant ('CHARSET');
$this->port = constant ('PORT');
}
function connect(){
try{
$connection ="pgsql:host=".$this->host.";port=".$this->port.";dbname=".$this->db;
$options=[
PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION,
PDO::ATTR_EMULATE_PREPARES =>false,
];
$pdo = new PDO($connection,$this->user,$this->password,$options);
return $pdo;
}catch(PDOException $e){
//print_r('Error connection: '.$e->getMessage());
echo '<script>
alert("Ha ocurrido un error en la conexion de la Base de datos.");
location.href="'.constant('URL').'login";
</script>';
}
}
}
?>