Output query array to file

TCovert

I need help with this. What I want to do is setup one button, that when pushed, it runs a set query behind the scenes, and outputs that array of data to a text file.

I have a form page setup to submit and start the query, I just don't know how to code the outputting of the result array.

eoghain

Just take all of the data in your array and put it into a string that you will understand. look at implode() if a simple delimited list will work. Then use fopen() to open up a file on the disk and append this string to that file. Don't forget to close the file.

TCovert

Need more assistance:
Can you help me out with an example? I want to output the returned array of records to a formatted file. I have experience in using fopen and fwrite. This will do what I want, I believe, I just don't know how to send the array of data to that file...let me know what you can help me with, thanks.

kidsleep

try this:




$query=mysql_query("select * from table") or die(mysql_error());

$row=mysql_fetch_row($query);

$FH=fopen("file.txt","w");
while(list($name,$val)=each($row))
{
$string="$name = $val\n\n";

fwrite($FH,$string);




}

fclose($FH);

echo("done");

this overwrites the file on each call of the script but you get the idea

TCovert

How would I make it so I have a button to push, and when it is pushed, it runs the pre-specified query?

TCovert

Nevermind my last question. Lets get back to that code you suggested. It works great, except for the fact that it only writes one record, instead of 4 as specified in the query string.

How do I fix this?

TCovert

Again, I need to be able to output the info on all records returned in the array into that export file. Also, I need to be able to specify the amount of characters outputted for a specified field. And I only want two or 3 of the fields to be outputted to the file.

I know this is a lot...but, I am stumped.

kidsleep



$query=mysql_query("select * from table") or die(mysql_error());

while($row=mysql_fetch_row($query))
{
$FH=fopen("file.txt","w");
while(list($name,$val)=each($row))
{
$string="$name = $val\n\n";

fwrite($FH,$string);




}

}
fclose($FH);

echo("done");

Hope this helps

TCovert

When I use that code, I get this error:

Warning: Variable passed to each() is not an array or object in /projects/sunarchive/htdocs_0_10/buildnews.php on line 23

The line in question is:

while(list($name,$val)=each($row))

Let me know what you think. Thanks.

kidsleep

have you tested $row to see if it contains anything?

before the first while loop, type this:

print(mysql_num_rows($query));

this will tell you if your query returned any rows.