[SOLVED] I need to export query results to a .txt file.

[JSHINER]

Here's some code:

 

function get($db) {
	return $db->getRow('SELECT field_1, field_2 FROM table WHERE pull = y');
}

$page = array();

$page['results'] = get($db);

foreach ($page['results'] as $c) {

echo $field1, ',http://www.site.com/', field2, '<br>';

}

 

Which will display results as:

 

00001,http://www.site.com/020202

00002,http://www.site.com/020203

00003,http://www.site.com/020204

 

I need this info displayed on a .txt file that is updated each time that text file is called up. So if a new result is added, when that text file is called up I need that new listing to appear there. Or every time a new result is added, it updates the text file. Whichever makes the most sense, I'm not sure.

 

How can I go about doing this?

[jaymc]

$contents = file_get_contents($textfile);

 

$newdata = $contents."\n$the_new_line_var_here";

 

file_put_contents($newdata, $textfile)

[JSHINER]

I'm not sure I follow ... ?

[JSHINER]

file_put_contents is not working.

[rarebit]

You probably haven't got an existing file... see http://us3.php.net/manual/en/function.file-put-contents.php

or

Here's an append function (if it's any use):

function file_append($fn, $s)
{
$fp = fopen($fn, "a");	// use to append
$written = 0;
while ($written == 0)	// keep trying until lock is free
{
	if (flock($fp, LOCK_EX))
	{
		fwrite($fp, $s);
		flock($fp, LOCK_UN);
		$written = 1;
	}
}
fclose($fp);

return 0;
}

[JSHINER]

$contents = file_get_contents('file.txt');

	$vara = $db->$_GET['vara'];

	$varb = $db->$_GET['varb'];

	$newdata = $contents."\n$vara,http://www.site.com/$varb";

	file_put_contents('file.txt', $newdata);

 

What is wrong with the above code? It does not write anything to the file.

[roopurt18]

I need this info displayed on a .txt file that is updated each time that text file is called up.

 

How exactly is this text file "called up?"  Through the web browser?

[JSHINER]

I have changed my plan of attack. I want to update the text file via the above code now.

[jscix]

$contents = file_get_contents('file.txt');

 

$vara = $db->$_GET['vara'];

 

$varb = $db->$_GET['varb'];

 

$newdata = $contents."\n$vara,http://www.site.com/$varb";

 

if (is_writable("file.txt")) {

                $txtfile = fopen('file.txt',a);

                fwrite($txtfile, $newdata);

                fclose($txtfile);

                }

 

 

should work .......

[roopurt18]

If the .txt file is being called up in a web browser, why not just change the link to the file to a .php script.  Then do the following:

 

<?php
  header("Content-type: text/plain");
  $sql = "SELECT ...";
  $q = mysql_query($sql);
  if($q){
    while($row = mysql_fetch_assoc($q)){
      echo "{$row['col1']},{$row['col2']}";
    }
  }
?>

[JSHINER]

Ok now how do I get line breaks in there? So it displays:

 

0000,g

0001,b

0002,t

[rarebit]

\n

[JSHINER]

header("Content-type: text/plain");

echo $row['num'], ',http://www.site.com/listing_view/', $row['id'], '\n';

 

Displays the results as:

 

0000,g\n0001,b\n0002,t\n

[rarebit]

Use " instead of '

[roopurt18]

You have to place \n inside of double quotes.

[JSHINER]

Thanks!