Reading Most Recent CSV File in Directory
Posted on
16th Feb 2014 07:03 pm by
admin
I thought I had wrapped this project up, but found out that the program I use to FTP a csv file to my website is best used in time stamp mode.
That is, each day a newly named csv file is uploaded with that days data.
Did you know?Explore Trending and Topic pages for more stories like this.
I currently have this script that I use to display the data on my website:
PHP Code:
echo "<table align='left' width='685' bordercolor='ccc' border='1'>";
echo "<tr><td><strong>Date</strong></td><td><strong>MPSAS</strong></td><td><strong>NELM</strong></td><td><strong>Temp (C)</strong></td></td>";
$file = "myfile.csv";
$content=file("$file");
for ($i = count($content) - 1; $i >=1 ; $i--) {
$row = explode(",", $content[$i]);
echo "<tr><td>{$row[0]}</td><td>{$row[1]}</td><td>{$row[2]}</td><td>{$row[7]}</td></td>";}echo "</table>";
?>
To read the most recent file I know I need to list the dir contents, sort, and then select the newest file, but I need some help getting started.
Anyone have experience with that is willing to help me out?
No comments posted yet
Your Answer:
Login to answer
164 
26 
Other forums
$get problem
Hi Guys ...
can you please tell me what i am doing wrong here
Code: <?php
PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi
Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh
Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d
reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key
Hits this week counter
I have a counter on my site that tracks hits, IP's, etc. into a mySQL database. It also includes the
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&PHP Captcha Error help - replace the "die" command
Hi All,
I am after a bit of help with a Captcha spam protection box.
The site gave me need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896
Out of:
Binary String: xV4
| 
