-
Notifications
You must be signed in to change notification settings - Fork 0
/
Database.php
executable file
·65 lines (54 loc) · 2.08 KB
/
Database.php
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
class Database{
// Atributos
private static $host = 'localhost';
private static $dbname = 'videoteca';
private static $dbuser = 'root';
private static $dbpass = 'root';
private static $cont = null;
// Métodos
public function __construct(){
die('No se puede instanciar esta conexión.');
}
public static function conectar(){
if( self::$cont == null ){
try {
self::$cont = new PDO("mysql:host=".self::$host.";dbname=".self::$dbname.";charset=utf8", self::$dbuser, self::$dbpass);
self::$cont->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return self::$cont;
} catch (PDOException $e) {
echo "Error al intentar conectarse a la BD: ".$e->getMessage();
}
}
}// end conectar
public static function desconectar(){
self::$cont = null;
}// end desconectar
public static function verificaUsuario($usuario, $contra){
try {
$datos = array('user'=>$usuario, 'pass'=>$contra);
$consulta = self::$cont->prepare("SELECT * FROM USUARIOS WHERE usuario=:user AND password=:pass");
$consulta->execute($datos);
if( $consulta->rowCount()==1 ){
return $consulta->fetch(PDO::FETCH_ASSOC);
}
} catch (PDOException $e) {
echo "No se ha encontrado al usuario: ".$e->getMessage();
}
}// end verificaUsuario
public static function insertaPeli($titulo,$anno,$duracion,$director,$genero){
try {
$datos = array('titulo'=>$titulo, 'year'=>$anno, 'duracion'=>$duracion, 'director'=>$director, 'id_genero'=>$genero);
$q = self::$cont->prepare('INSERT INTO PELICULAS (titulo,year,duracion,director,id_genero) VALUES (:titulo,:year,:duracion,:director,:id_genero)');
$q->execute($datos);
if( $q->rowCount() == 1 ){
echo '<script>'.
'alert("Película insertada correctamente.");'.
'</script>';
}
} catch (PDOException $e) {
echo $e->getMessage();
}
}// end insertaPeli
}// end class
?>