public static function getById($id)
{
try {
$connection = Database::instance();
$sql = "SELECT * from usuarios WHERE id = ?";
$query = $connection->prepare($sql);
$query->bindParam(1, $id, \PDO::PARAM_INT);
$query->execute();
return $query->fetch();
} catch (\PDOException $e) {
print "Error!: " . $e->getMessage();
}
}
public static function getUserPassword($user_name, $password)
{
try {
$connection = Database::instance();
$sql = "SELECT * from usuarios WHERE nombre_usuario = ? AND clave_usuario = ?";
$query = $connection->prepare($sql);
$query->bindParam(2, $user_name, $password, \PDO::PARAM_INT);
$query->execute();
return $query->fetch();
} catch (\PDOException $e) {
print "Error!: " . $e->getMessage();
}
}
