2

I've just recently been asked to develop a PHP application that allows mass emailing. To do this, I have a PHP script that simply grabs the email addresses from a MySQLDatabase and loops through them personalising each one, and then sending them.

It works absolutely fine, however we have a slight issue in that whilst this PHP script is running (and it obviously takes several minutes to run) the user cannot do anything else on the application. Other people can access it, but the user in question cannot load any other page of the application whilst the emails are sending.

Is there some way of dealing with this or is this just something we are going to have to live with?

ProgramFOX
  • 6,131
  • 11
  • 45
  • 51
Raiden616
  • 1,545
  • 3
  • 18
  • 42

4 Answers4

2

The user in this case has a session open to the page, which is currently processing a PHP page. Because of this the user is unable to open (in the same session) another page on the same site.

A way of handling this is initiate this process by the user, but don't let the script the user is accessing send the e-mails. You could for example make a "todo" list in the database, and let a cronjob handle it. This way the user is still able to visit other pages.

Rene Pot
  • 24,681
  • 7
  • 68
  • 92
1

Make sure your long running script does not have sessions applied to them.

Matthew
  • 24,703
  • 9
  • 76
  • 110
1

have you took a look at a cronjob and a tutorial

locrizak
  • 12,192
  • 12
  • 60
  • 80
1

Basically, a php script is executed and then the page is send to the client. So, it is normal that the visitor is stuck to the page while the script is running.

Take a look at cronjobs for such tasks.

dkg
  • 1,775
  • 14
  • 34