-
Notifications
You must be signed in to change notification settings - Fork 0
/
user.php
108 lines (91 loc) · 3.14 KB
/
user.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
class User{
var $userid;
var $nombre;
var $correo;
var $contrasena;
var $valoracion;
var $rol;
var $nombre_completo;
function setNuevoUsuario($nombreCompleto, $nombre, $correo, $contrasena, $confirmar){
require_once('dbm.php');
if($nombreCompleto == "" OR $nombre == "" OR $correo == "" OR $contrasena == "" OR $confirmar == "")
return false;
if($contrasena != $confirmar)
return false;
$datab = new DataBase();
$datab->open();
$connect = $datab->get_connect();
$query = "INSERT INTO usuario (nombre_completo, nombre, correo, contrasena, valoracion, rol)
SELECT * FROM ( SELECT '".$nombreCompleto."','".$nombre."','".$correo."','".$contrasena."',0,'autor') AS tmp
WHERE NOT EXISTS (
SELECT nombre FROM usuario WHERE nombre = '".$nombre."') LIMIT 1;";
if(mysqli_query($connect, $query)==false){
mysqli_close($connect);
return false;
}
$col_afectadas = mysqli_affected_rows($connect);
if($col_afectadas == 0){
mysqli_close($connect);
$this->nombre_completo = $nombreCompleto;
$this->nombre = $nombre;
$this->correo = $correo;
$this->contrasena = $contrasena;
return false;
}
mysqli_close($connect);
return true;
}
function getNombre(){
return $this->nombre;
}
function getCorreo(){
return $this->correo;
}
function getContrasena(){
return $this->contrasena;
}
function getValoracion(){
return $this->valoracion;
}
function getRol(){
return $this->rol;
}
function getNombreCompleto(){
return $this->nombre_completo;
}
function getUser($userid){
$this->userid = $userid;
require_once('dbm.php');
$data = new DataBase();
$query = "SELECT * FROM usuario WHERE id_usuario = $userid";
$data->open();
$result = mysqli_query($data->get_connect(),$query);
while($row = mysqli_fetch_array($result)){
$this->nombre = $row[1];
$this->correo = $row[2];
$this->contrasena = $row[3];
$this->valoracion = $row[4];
$this->rol = $row[5];
$this->nombre_completo = $row[6];
}
}
function list_of_files(){
// Esta funcion devolvera un arreglo de objetos para los archivos
require_once('dbm.php');
$data = new DataBase();
$userid = $this->userid;
$query = "SELECT * FROM archivo WHERE id_usuario = $userid";
$data->open();
$result = mysqli_query($data->get_connect(),$query);
$list_of_files = array();
while($row = mysqli_fetch_array($result)) {
$elemento = new element_book($row[1], $row[2], $row[3], $row[4]);
$elemento->setId($row[0]);
$list_of_files[] = $elemento;
}
$data->close();
return $list_of_files;
}
}
?>