Page 1 of 1

File handling and time manipulation with lines

Posted: Thu Nov 01, 2007 4:00 am
by eon201
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


Hi,

Ive come across something that i just dont know how to approach.
Basically I have two pages of php.

Page 1 creates a file with lines of data, each line of data looks like this:

Code: Select all

Please call MrSmith immediately. On telephone number 02392666666. Thank you.1615
Now what I need to do with this data is take the last 4 digits of the strings (which are individual stamps of time etc 4:15pm) and work out:
1.How many lines appearred within the last hour.
2.If the last line is new (which would only be true if the time stamp on the line is equal to the current one of date('Gis').

Here is how far I have come so far. Any help would be greatly appreciatted.

Code: Select all

<?php 
$filename = 'phonecsv/'. date('ymd'). '.csv';

    if (file_exists($filename)) 
    {
        $fp = fopen($filename, "r");
    
        // works out how many callback requests today
        $lines = count(file($filename));
        echo "Today there have been $lines callback requests <br/>";
        
        // needs to work out from time sequence how many in last hour
        echo "In the last hour there have been x callback requests<br/>";
        
        // needs to work out from time sequence if new message
        echo "This is the latest callback request<br/>";
        
        $data = fgets($fp);        
    }
    
    else
    {
        echo "The file $filename does not exist!! Check the svr file and callback forwarder!<br/>";
    }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
    echo $data;
?>

<script type="text/javascript">
// set the page to reload every 20 sec
setTimeout('window.location.href = '<?php echo $_SERVER['php_self']; ?>', 20);
</script>
</body>
</html>
Thanks. eon201.


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Thu Nov 01, 2007 1:12 pm
by Christopher
You can use the string functions(or preg if necessary) to get the value out of the string. Then either explode() it and check the hour and minutes manually or use one of the time funtions.