如何在应用筛选器之后但在分页之前计算记录总数

# 假设使用Python和MySQL数据库进行示例

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 应用筛选器条件
filter_condition = "category = 'example'"

# 查询符合条件的记录总数
query = "SELECT COUNT(*) FROM table_name WHERE " + filter_condition
cursor.execute(query)
total_records = cursor.fetchone()[0]

# 分页操作
page_size = 10  # 每页显示的记录数量
current_page = 1  # 当前页码

# 计算起始位置和结束位置
start_index = (current_page - 1) * page_size
end_index = start_index + page_size

# 查询符合条件的记录
query = "SELECT * FROM table_name WHERE " + filter_condition + " LIMIT " + str(start_index) + ", " + str(page_size)
cursor.execute(query)
records = cursor.fetchall()

# 关闭数据库连接
cursor.close()
cnx.close()

# 输出结果
print("总记录数：", total_records)
print("当前页记录：", records)