Save CSV to Server (serialize?)

[danIT]

<?php
header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="tweets.csv"');

$tag = urlencode($_GET['tag']);

$max_pages = $_GET['maxpages'];
if ($max_pages > 50)
{
die("No way am i doing more than 50 pages. Sorry mate.");
}

echo 'name,date,uri,content' . "\r\n";
for($page = 1; $page <= $max_pages; $page++) 
	{
		$url = "http://search.twitter.com/search.atom?&q={$tag}&rpp=100&page={$page}";
		$xmlstr = file_get_contents($url);

		$xml = new SimpleXMLElement($xmlstr);
			foreach ($xml->entry as $entry) 
			{

$twitterdate = $entry->updated;
$middle = "&nbsp;";
$half = (int) ( (strlen($twitterdate)) ); // cast to int incase str length is odd
$left = substr($twitterdate, 0, $half);
$right = substr($twitterdate, $half);
$unixdate = strtotime($left);
$correctdate = date("d-m-Y H:i", $unixdate);


			echo $entry->author->name . "," . $correctdate . "," . $entry->author->uri . ",\"" . strip_tags($entry->content) . "\" \r\n";
			}
	}

This currently saves the RSS feed from the Twitter search to a .CSV file.

I'd like to not only allow the file to be downloaded but also get it saved to the server. How can I generate the file and once generated post it to the server?


*****Please excuse my horrible date functions!!!!!!

[danIT]

Could anyone suggest an alternative?

My RSS to CSV file below - When the CSV is downloaded I want to save a copy of the file generated in the background to my server?

<?php
header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="tweets.csv"');

$tag = urlencode($_GET['tag']);

$max_pages = $_GET['maxpages'];
if ($max_pages > 50)
{
die("No way am i doing more than 50 pages. Sorry mate.");
}

echo 'name,date,uri,content' . "\r\n";
for($page = 1; $page <= $max_pages; $page++) 
	{
		$url = "http://search.twitter.com/search.atom?&q={$tag}&rpp=100&page={$page}";
		$xmlstr = file_get_contents($url);

		$xml = new SimpleXMLElement($xmlstr);
			foreach ($xml->entry as $entry) 
			{

$twitterdate = $entry->updated;
$middle = "&nbsp;";
$half = (int) ( (strlen($twitterdate)) ); // cast to int incase str length is odd
$left = substr($twitterdate, 0, $half);
$right = substr($twitterdate, $half);
$unixdate = strtotime($left);
$correctdate = date("d-m-Y H:i", $unixdate);


			echo $entry->author->name . "," . $correctdate . "," . $entry->author->uri . ",\"" . strip_tags($entry->content) . "\" \r\n";
			}
	}
	
	
?>

[dwhyte85]

fopen to create the file and fwrite to put the contents into the created file.

so


$hndl = fopen('/path/to/myfile.csv', 'x');


//SOME FOR LOOP, WRITE FORMATTED TWITTER DATA eg, x,y,z,1,2,3

fwrite($hndl, $twitterstringvar);

//END FOR LOOP

fclose($hndl);

[tom_newton]

Just make sure the path to your serverside file does not contain *any* elements of user input (if it must, sanitise the hell out of them, but it is still a bad idea).