# coding=gbk import smtplib import MySQLdb import datetime import time from email.mime.text import MIMEText mail_to = "" mail_host = "smtp.qq.com" mail_user = "****@qq.com" mail_pass = "****" mail_postfix = "qq.com" def query_indb() : db = MySQLdb.connect("****","****","****","****" ) cursor = db.cursor() sql = "select * from **** where UNIX_TIMESTAMP(create_at)>= UNIX_TIMESTAMP() - 86400 and UNIX_TIMESTAMP(create_at) <= UNIX_TIMESTAMP()" result = "" title = '' try: cursor.execute(sql) results = cursor.fetchall() result = result + "" + str(len(results)) + "\n\n"
python查询数据库并发送邮件
该脚本使用Python连接MySQL数据库查询过去一天的新注册用户,并生成包含详细信息的HTML邮件。邮件主题显示新注册用户总数,邮件内容包括用户ID、姓名、邮箱、公司、电话和创建时间等字段。邮件通过SMTP使用QQ邮箱发送,如果发送失败,则发送纯文本错误通知。
摘要由CSDN通过智能技术生成