akalongman / php-telegram-bot

     * @return bool If the insert was successful

     * @throws \Longman\TelegramBot\Exception\TelegramException

     */

    public static function insertInlineQueryRequest(InlineQuery $inline_query)

    {

        if (!self::isDbConnected()) {

            return false;

        }

        try {

            $sth = self::$pdo->prepare('

                INSERT IGNORE INTO `' . TB_INLINE_QUERY . '`

                (`id`, `user_id`, `location`, `query`, `offset`, `created_at`)

                VALUES

                (:inline_query_id, :user_id, :location, :query, :param_offset, :created_at)

            ');

            $date            = self::getTimestamp();

            $inline_query_id = $inline_query->getId();

            $from            = $inline_query->getFrom();

            $user_id         = null;

            if ($from instanceof User) {

                $user_id = $from->getId();

                self::insertUser($from, $date);

            }

            $location = $inline_query->getLocation();

            $query    = $inline_query->getQuery();

            $offset   = $inline_query->getOffset();

            $sth->bindParam(':inline_query_id', $inline_query_id, PDO::PARAM_INT);

            $sth->bindParam(':user_id', $user_id, PDO::PARAM_INT);

            $sth->bindParam(':location', $location, PDO::PARAM_STR);

            $sth->bindParam(':query', $query, PDO::PARAM_STR);

            $sth->bindParam(':param_offset', $offset, PDO::PARAM_STR);

            $sth->bindParam(':created_at', $date, PDO::PARAM_STR);

            return $sth->execute();

        } catch (PDOException $e) {

            throw new TelegramException($e->getMessage());

        }

    }

    /**

     * Insert chosen inline result request into database

     * @return bool If the insert was successful

     * @throws \Longman\TelegramBot\Exception\TelegramException

     */

    public static function insertChosenInlineResultRequest(ChosenInlineResult $chosen_inline_result)

    {

        if (!self::isDbConnected()) {

            return false;

        }

        try {

            $sth = self::$pdo->prepare('

                INSERT INTO `' . TB_CHOSEN_INLINE_RESULT . '`

                (`result_id`, `user_id`, `location`, `inline_message_id`, `query`, `created_at`)

                VALUES

                (:result_id, :user_id, :location, :inline_message_id, :query, :created_at)

            ');

            $date      = self::getTimestamp();

            $result_id = $chosen_inline_result->getResultId();

            $from      = $chosen_inline_result->getFrom();

            $user_id   = null;

            if ($from instanceof User) {

                $user_id = $from->getId();

                self::insertUser($from, $date);

            }

            $location          = $chosen_inline_result->getLocation();

            $inline_message_id = $chosen_inline_result->getInlineMessageId();

            $query             = $chosen_inline_result->getQuery();

            $sth->bindParam(':result_id', $result_id, PDO::PARAM_STR);

            $sth->bindParam(':user_id', $user_id, PDO::PARAM_INT);

            $sth->bindParam(':location', $location, PDO::PARAM_STR);

            $sth->bindParam(':inline_message_id', $inline_message_id, PDO::PARAM_STR);

            $sth->bindParam(':query', $query, PDO::PARAM_STR);

            $sth->bindParam(':created_at', $date, PDO::PARAM_STR);

            return $sth->execute();

        } catch (PDOException $e) {

            throw new TelegramException($e->getMessage());

        }

    }

    /**

     * Insert callback query request into database