require_once ('../classes/conexion.php'); require_once ('../classes/globales.php'); require_once ('../classes/cache_control.php'); ?> function getRolById($id) { $query = "SELECT * FROM risk_rol WHERE id = '$id' AND activo = 'Y'"; $rs_query = mysql_query($query); $row = mysql_fetch_assoc($rs_query); $rol = $row['rol']; return $rol; } function getAllUsers() { $query = "SELECT * FROM risk_users"; return $query; } function getRoles() { $query = "SELECT * FROM risk_rol"; return $query; } function insertUsuarios($nombre,$apellido,$usuario,$password,$cedula,$activo) { $query = "INSERT INTO risk_users(`Names`,`LastNames`,`user`,`password`,`ci`,`active`) VALUES ('".$nombre."','".$apellido."','".$usuario."','".$password."','".$cedula."','".$activo."')"; $rs_query = mysql_query($query); return $rs_query; } function getListAccountsByEnterprise($enterprise) { $query = "SELECT * FROM risk_balances WHERE activo = 'S' and id_enterprise = '".$enterprise."' order by id_cta"; $rs_query = mysql_query($query); return $rs_query; } function getUsersByCi($id) { $query = "SELECT * FROM `risk_users` WHERE `ci` ='$id'"; $rs_query = mysql_query($query); return $rs_query; //$row_user = mysql_fetch_assoc(rs_query); //return $row_user; } function updateUsuarios($nombre,$apellido,$usuario,$password,$cedula,$activo) { $query = "UPDATE risk_users SET Names='$nombre',LastNames='$apellido', user='$usuario',password='$password', active='$activo' WHERE ci='$cedula'"; $rs_query = mysql_query($query); return $rs_query; } ?>
GESTION DE USUARIOS |
![]() ![]() |
Id | CI | Nombres | Apellidos | user |
| |||
136 | Edwin | Porras | eporras | |||||
135 | Homero | Escalante | hescalante | |||||
134 | 0956666644 | Cristian Huilla | Huilla | chuilla | ||||
130 | 999999999 | OSCAR | INTRIAGO | ointriago | ||||
129 | 950468900 | JOFRE | ANDRANGO | jandrango | ||||
125 | 987654321 | Test | Test | test@test | ||||
124 | 1111111111 | Diego | Pineda 2 | dpinedab2 | ||||
123 | 88878777 | PASTOR | YAGUANA | pyaguana | ||||
122 | 917579914 | Ladyx | Mendozax | lmendoza | ||||
121 | 0 | USUARIO | USUARIO2022 | nuevouser |
![]() | Pagina 1 de 7 |
![]() |
![]() |