现在要给全部用户或者指定用户发送邮件，“发送”操作是由我们后台人员触发的。
发送操作提交后，我们就要给用户发送了，在发送过程中可能会存在一个问题，就是发送了一段时间后，程序因某些原因死掉了，这样就导致一些用户没有收到邮件，所以我的想法是发送前先把数据库里的用户全写入到一个文件中，发送时从文件中取用户，然后再弄个用户发送日志以记录哪些用户发送了，这样出问题后，可以从出问题的“那个地方”接着执行发送.....
不知道我的想法行不行，另外我担心“把数据库中的用户写入到文件中”这个过程所花费的时间会很长，从而导致性能上会存在隐患。谢谢大家讨论我的想法，给些意见或指点！
回复内容：
现在要给全部用户或者指定用户发送邮件，“发送”操作是由我们后台人员触发的。
发送操作提交后，我们就要给用户发送了，在发送过程中可能会存在一个问题，就是发送了一段时间后，程序因某些原因死掉了，这样就导致一些用户没有收到邮件，所以我的想法是发送前先把数据库里的用户全写入到一个文件中，发送时从文件中取用户，然后再弄个用户发送日志以记录哪些用户发送了，这样出问题后，可以从出问题的“那个地方”接着执行发送.....
不知道我的想法行不行，另外我担心“把数据库中的用户写入到文件中”这个过程所花费的时间会很长，从而导致性能上会存在隐患。谢谢大家讨论我的想法，给些意见或指点！
和@舞林 同学的想法有点相似：
- 把待发的邮件，存储到列表（Lists）中，通过
lpush插入到Redis消息队列中 - 负责发送邮件的代码中通过BRPOP依次消息队列中的内容并进行处理，如果没有新邮件则会阻塞等待直到有新的消息
这样的话不管程序死掉或者什么原因都不会千万消息丢失，同时也可以不用另外加一个定时任务
相比于写文件或者是其它的方法，Redis是目前最合适的
Redis是一个开源、支持网络、基于内存、键值对存储数据库
参考：http://zh.wikipedia.org/zh/Redis
我的做法是邮件队列，放redis，crontab每分钟发送，脚本起来的时候发现上个脚本还在跑就退出，为了避免异常，脚本最多执行110秒。做好失败的监控，没啥问题。
还有什么呢，继续吧...
PHP's Purpose: Building Dynamic WebsitesApr 15, 2025 am 12:18 AMPHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.
PHP: Handling Databases and Server-Side LogicApr 15, 2025 am 12:15 AMPHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
How do you prevent SQL Injection in PHP? (Prepared statements, PDO)Apr 15, 2025 am 12:15 AMUsing preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.
PHP and Python: Code Examples and ComparisonApr 15, 2025 am 12:07 AMPHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.
PHP in Action: Real-World Examples and ApplicationsApr 14, 2025 am 12:19 AMPHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.
PHP: Creating Interactive Web Content with EaseApr 14, 2025 am 12:15 AMPHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.
PHP and Python: Comparing Two Popular Programming LanguagesApr 14, 2025 am 12:13 AMPHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
The Enduring Relevance of PHP: Is It Still Alive?Apr 14, 2025 am 12:12 AMPHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
SublimeText3 Chinese version
Chinese version, very easy to use
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Dreamweaver Mac version
Visual web development tools
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
