rudolfcms / rudolf

     *

     * @return array

     */

    public function getCategoryInfo($slug, $type)

    {

        $stmt = $this->pdo->prepare("

            SELECT *

            FROM {$this->prefix}categories

            WHERE slug = :slug

              AND TYPE = :type

        ");

        $stmt->bindValue(':slug', $slug, \PDO::PARAM_INT);

        $stmt->bindValue(':type', $type, \PDO::PARAM_STR);

        $stmt->execute();

        $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);

        return $results[0];

    }

    /**

     * Get category info.

     *

     * @return array|bool

     */

    public function getUserDataByEmail($email)

    {

        $stmt = $this->pdo->prepare("

            SELECT *

            FROM {$this->table}

            WHERE email = :email

        ");

        $stmt->bindValue(':email', $email, \PDO::PARAM_STR);

        $stmt->execute();

        $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);

        if (empty($results[0])) {

            return false;

        }

        return $results[0];

    }

    /**

     * Validate email.