Solved

PHP flush() not working to flush output to browser before script is done

Posted on 2007-12-05
11
2,414 Views
Last Modified: 2010-04-21
My script is a basic PHP script calling data from a MYSQL database
but it takes about 2 minutes to run the script as it emails out 1000 people on an email list
I want it to display the email address on screen AS it emails each one instead of all at once at the end of 2 minutes lists them all

I have tried adding

ob_implicit_flush();

at the top, no. that does not work.

and

ob_flush();
flush();

after every echo of the email address to the screen.

Still doesn't work.

help please.

0
Comment
Question by:brianharrell
  • 8
  • 3
11 Comments
 
LVL 5

Expert Comment

by:nacker2000
ID: 20416446
Hi,

So you your code is somethings like:
<?php

	//DO QUERY TO GET EMAILS

	

	//loop through records

	while($rst = mysql_fetch_array($result)){

		//get email address

		$email = trim($rst['email']);

		//send mail and check it was sent

		if(mail($email, 'Subject', 'Message', 'From:you@yourdomain.com')){

			//ouptut to screen

			print('Sent email to: ' . $email);

		}

	}

?>

Open in new window

0
 

Author Comment

by:brianharrell
ID: 20416477
my code say echo instead of print but very much the same.


right after

                        print('Sent email to: ' . $email);


I put the flush() code but ob_flush() and flush() don't seem to output to browser except when the whole script is done (over 1000 emails)
0
 
LVL 5

Accepted Solution

by:
nacker2000 earned 200 total points
ID: 20418262
Have you tried pausing the script? You could try sleeping the script for a faction of a second after the echo. However, this will make the script even slower if it works because you would be waiting X number of milliseconds on each email.
<?php

	//DO QUERY TO GET EMAILS

	

	//loop through records

	while($rst = mysql_fetch_array($result)){

		//get email address

		$email = trim($rst['email']);

		//send mail and check it was sent

		if(mail($email, 'Subject', 'Message', 'From:you@yourdomain.com')){

			//ouptut to screen

			print('Sent email to: ' . $email);

			// wait for 100 milliseconds (1 second = 1000000)

			usleep(100000);

		}

	}

?>

Open in new window

0
 

Author Comment

by:brianharrell
ID: 20424146
I'll test that shortly.
0
 
LVL 5

Expert Comment

by:nacker2000
ID: 20429248
Did that work for you?
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

Author Comment

by:brianharrell
ID: 20429512
still waiting to test on a large email batch
0
 

Author Comment

by:brianharrell
ID: 20437487
No that did not work.

In my script I have this near the start of the script (not in the email loop part)

ob_implicit_flush();

ob_flush(); // added 12-05-2007
flush(); // added 11-15-2007 BH

My email script loop is below:

     $row = mysql_fetch_array($result); // get the data!
     if ( $row != "" ) {  
      // GOT vendor info!
        echo "Emailing Vendor ID ".$v_id." ... success!<br>";
        ob_flush(); // added 12-05-2007
        flush(); // added 11-15-2007 BH
    // wait for 100 milliseconds (1 second = 1000000)
    usleep(100000);
    mail($vendor_email_address_here, $subject, $vendor_message , $extra_stuff_here_from_reply_address);
    }


Above always prints ALL of them to the screen AFTER it completes the loop.




0
 

Author Comment

by:brianharrell
ID: 20437621
Also, when a large query is running like this, ALL other queries to that database from browsers seem to STALL until this query finishes emailing the list of 1000 vendors.   Isn't MYSQL capable of more than one query at a time from the same browser (Firefox, separate tab)?
0
 

Author Comment

by:brianharrell
ID: 20437628
Tested that issue in IE and it doesn't seem to care how many client files are opened at once while the query is running, must be a FIREFOX issue.   Didn't mean to mix issues here but there may be a shred of relevance to the current issue.  No need to work on the FFox or IE issue in this thread any more.  Back to why the output is not getting to the screen during the emailing...
0
 

Author Comment

by:brianharrell
ID: 20576673
It is erratic and sometimes firefox does them one by one to the screen and other times it waits until 300-500 are to print and others only until the browser finishes the script.
Don't know how to fix this one.
I think it is a browser issue.
0
 

Author Closing Comment

by:brianharrell
ID: 31413021
Seems to work in IE now.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now