PHP - I Can't Figure How To Work Output Buffer

I am using shell_exec, and it runs a ping on a server, is there any way to flush the buffer of the shell_exec as the data is getting written to the buffer?

Because I sometimes ping a site 10 times and nothing get written until the function finishes, so is there anyway to write out the output as soon as it is available?

btw, this isn't only for doing a ping it is for other things as well.

Hi all,

I post a strange behavior that could be reproduced (at least on apache2+php5).
I don't know if I am doing wrong but let me explain what I try to achieve.

I need to send chunks of binary data (let's say 30) and analyze the average Kbit/s at the end :

I sum each chunk output time, each chunk size, and perform my Kbit/s calculation at the end.

Code: [Select]
<?php

// build my binary chunk
$var= '';
$o=9000;
while($o--)
{
$var.= "testtest";
}

// get the size, prepare the memory.
$size = strlen($var);
$tt_sent = 0;
$tt_time = 0;

// I send my chunk 30 times
for ($i = 0; $i < 30; $i++)
{
// start time
$t = microtime(true);
echo $var."\n";
ob_flush();
flush();
$e = microtime(true);
// end time
// the difference should reprenent what it takes to the server to 
// transmit chunk to client right ?

// add this chuck bench to the total
$tt_time += round($e-$t,4);
$tt_sent += $size;
}

// total result
echo "\n total: ".(($tt_sent*8)/($tt_time)/1024)."\n";

?>

In this example above, it works so far ( on localhost, it oscillate from 7000 to 10000 Kbit/s through different tests).

Now, let's say I want to shape the transmission, because I know that the client will have enough of a chunk of data to process for a second.

I decide to use usleep(1000000), to mark a pause between chunk transmission.

Code: [Select]
<?php

// build my binary chunk
$var= '';
$o=9000;
while($o--)
{
$var.= "testtest";
}

// get the size, prepare the memory.
$size = strlen($var);
$tt_sent = 0;
$tt_time = 0;

// I send my chunk 30 times
for ($i = 0; $i < 30; $i++)
{
// start time
$t = microtime(true);
echo $var."\n";
ob_flush();
flush();
$e = microtime(true);
// end time
// the difference should reprenent what it takes to the server to 
// transmit chunk to client right ?

// add this chuck bench to the total
$tt_time += round($e-$t,4);
$tt_sent += $size;

usleep(1000000);
}

// total result
echo "\n total: ".(($tt_sent*8)/($tt_time)/1024)."\n";

?>

I am doing something wrong ? Does the buffer output is not synchronous ?

Thanks a Lot


Nunja

I need someone to look over this and just see if they can see why this won't work anymore?

It worked when the site was in development but when it came down to the day it's not working.

Basically it reads a CSV and inserted the driver into a Quali or Results table in the correct order but it's not working anymore?

If someone could have a read over it and suggest what might be going wrong that would be great.

Edit: It basically just added the same driver 24 times in the table.

Code: [Select]
Public Function ProcessUpload($UR, $RaceID, $RaceName) {
Global $MDB;
// Configuration - Your Options
  $allowed_filetypes = array('.csv'); // These will be the types of file that will pass the validation.
  $max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB).
  $upload_path = './resultsfiles/'; // The place the files will be uploaded to (currently a 'files' directory).

$filename = $_FILES['userfile']['name']; // Get the name of the file (including file extension).
$ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); // Get the extension from the filename.

If (strpos($filename, "Quali") == True) {
$tbl_name = "QualiPositions";
$FN = " - Qualifying";
} Else {
$tbl_name = "RacePositions";
$FN = " - Race";
}

$SQL = "SELECT count(*) FROM $tbl_name WHERE RaceID = $RaceID";
$Count = $MDB->prepare($SQL);
$Count->execute();
$Count = $Count->fetchColumn();

If ($Count == 24) {
$Msg = "<div class='error'>Error: We already have 24 Results for this Session.</div>";
}

// Check if the filetype is allowed, if not DIE and inform the user.
if(!in_array($ext,$allowed_filetypes))
  $Msg = "<div class='error'>Error: The file you attempted to upload is not allowed.</div>";

// Now check the filesize, if it is too large then DIE and inform the user.
if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
  $Msg ="<div class='error'>Error: The file you attempted to upload is too large.</div>";

// Check if we can upload to the specified path, if not DIE and inform the user.
if(!is_writable($upload_path))
  $Msg ="<div class='error'>Error: You cannot upload to the specified directory, please CHMOD it to 777.</div>";

If (strpos($Msg, "Error:") == False) {

// Upload the file to your specified path.
$filename = str_replace(" ", "", $RaceName)."$FN.csv";
if (move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename)) {
    $FilePath = $upload_path . $filename;
if (($handle = fopen($FilePath, "r")) !== FALSE) {
$Pos = 0;
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
       
        for ($c=0; $c < $num; $c++) {
        $Pos++;
        If ($Pos <= 24) {
            $Driver = explode(" ", $data[$c]);
            $FName = $Driver[0];
            $LName = $Driver[1]." ".$Driver[2]." ".$Driver[3];
            $STH = $MDB->query("SELECT * FROM Drivers WHERE FirstName = '$FName' AND LastName = '$LName'");
$STH->setFetchMode(PDO::FETCH_OBJ);
while($row = $STH->fetch()) {
$DriverID = $row->DriverID;
$ChassisID = $row->ChassisID;
$EngineID = $row->EngineID;
}
$STH = $MDB->prepare("INSERT INTO $tbl_name(RaceID, DriverID, ChassisID, EngineID, Position, DSQ) VALUES (:RID, :DID, :ChaID, :EngID, :Pos, :DSQ)");
$STH->execute(array('RID' => $RaceID, 'DID' => $DriverID, 'ChaID' => $ChassisID, 'EngID'=>$EngineID, 'Pos'=>$Pos, 'DSQ' => 0));
$Msg = "<div class='team_confirm'>The Results have been uploaded for the $RaceName</div>";
} Else {
If ($tbl_name == "RacePositions") {
$Driver = explode(" ", $data[$c]);
            $FName = $Driver[0];
            $LName = $Driver[1]." ".$Driver[2]." ".$Driver[3];
            $STH = $MDB->query("SELECT * FROM Drivers WHERE FirstName = '$FName' AND LastName = '$LName'");
$STH->setFetchMode(PDO::FETCH_OBJ);
while($row = $STH->fetch()) {
$DriverID = $row->DriverID;
}

$sql = "UPDATE RacePositions SET FastLap = 'Yes' WHERE RaceID=? AND DriverID = ?";
$q = $MDB->prepare($sql);
$q->execute(array($RaceID, $DriverID));
}
}
        }
    }
    fclose($handle);
}
} else {
     $Msg = 'There was an error during the file upload.  Please try again.'; // It failed :(.
}
}

Return $Msg;
}


That is the code, the CSV is basically like this:
Code: [Select]
Lewis Hamilton,
Jenson Button,
Romain Grosjean,
Michael Schumacher,
Mark Webber,
Sebastian Vettel,
Nico Rosberg,
Pastor Maldonado,
Nico Hulkenberg,
Daniel Ricciardo,
Jean-Eric Vergne,
Fernando Alonso,
Kamui Kobayashi,
Bruno Senna,
Paul di Resta,
Felipe Massa,
Kimi Raikkonen,
Heikki Kovalainen,
Vitaly Petrov,
Timo Glock,
Charles Pic,
Sergio Perez,
Pedro de la Rosa,
Narain Karthikeyan
Thanks for any help!

Hello guys, I devised the code block below, to retrieve all US zip codes that are located within a specified radius from the user's own zip code.  So basically, the user selects a maximum distance option from a form element (not shown here)which is appended to the variable $distance.  What the code below does is as follows:
The longitude and latitude corresponding to the user's zip code are retrieved in the first query.  Then in the second query, the longitudes and latitudes corresponding to every zip code in the database are retrieved. In the ensuing while loop, a distance calculation is made between the user's zip and every other zip using the longitudes and latitudes and if that distance falls within the selected $distance, that particular zip code is listed in a defined array called $range. Now everything works fine up to this point as tested.  The problem is with the very last line.  I try to implode the $range array into a string with the same name, separating the array elements with commas (,).  Then when I print out the resulting string, I get the list of desired zip codes but not separated by commas. For example:

9001190015900179003490037900439004790048900569006 19006290301 9030190301 90302

Well when I use a foreach loop as follows:

foreach ($range as $r) {echo $r.",";} the $range array behaves like any normal array yielding:

90011,90015,90017,90034,90037,90043,90047,90048,90056,90061,90062,90301 ,90301,90301 ,90302,

So why in the world is the implode function not working? Here is my code.


//Retrieve the zip codes within range.
// Connect to the database.
require('config.php');

//Retrieve longitude and latitude of logged in member.

$query = "SELECT* FROM members INNER JOIN zip_codes ON members.zip = zip_codes.zip WHERE members.member_id = '{$_SESSION['id']}'";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

$my_lon = $row['lon'];

$my_lat = $row['lat'];

//Query all longitudes and latitudes in database.

$query2 = "SELECT* FROM zip_codes INNER JOIN members ON members.zip = zip_codes.zip ";

$result2 = mysql_query($query2);

while ($row2 = mysql_fetch_assoc($result2)) { 

//Define array to hold zips found within range.

$range = array();  

if((rad2deg(acos(sin(deg2rad($my_lat))*sin(deg2rad($row2['lat'])) +cos (deg2rad($my_lat)) * cos (deg2rad($row2['lat'])) * cos(deg2rad($my_lon - $row2['lon']))   ) ) )*69.09 <= $distance )

 { $range[] = $row2['zip']; } 

//Implode the range arrary.

$range = implode(',' , $range);   echo $range;


}//End of while loop.