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(); } }