noplanman / php-telegram-bot

     * @return array|bool Fetched data or false if not connected

     * @throws \Longman\TelegramBot\Exception\TelegramException

     */

    public static function selectTelegramUpdate($limit = null)

    {

        if (!self::isDbConnected()) {

            return false;

        }

        try {

            $sql = '

                SELECT `id`

                FROM `' . TB_TELEGRAM_UPDATE . '`

                ORDER BY `id` DESC

            ';

            if ($limit !== null) {

                $sql .= 'LIMIT :limit';

            }

            $sth = self::$pdo->prepare($sql);

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

            $sth->execute();

            return $sth->fetchAll(PDO::FETCH_ASSOC);

        } catch (PDOException $e) {

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

        }

    }

    /**

     * Fetch message(s) from DB

     * @return array|bool Fetched data or false if not connected

     * @throws \Longman\TelegramBot\Exception\TelegramException

     */

    public static function selectMessages($limit = null)

    {

        if (!self::isDbConnected()) {

            return false;

        }

        try {

            $sql = '

                SELECT *

                FROM `' . TB_MESSAGE . '`

                WHERE `update_id` != 0

                ORDER BY `message_id` DESC

            ';

            if ($limit !== null) {

                $sql .= 'LIMIT :limit';

            }

            $sth = self::$pdo->prepare($sql);

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

            $sth->execute();

            return $sth->fetchAll(PDO::FETCH_ASSOC);

        } catch (PDOException $e) {

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

        }

    }

    /**

     * Convert from unix timestamp to timestamp