Output data to text file

[mycow]

I have made a simple script that checks two tables for some conditions and outputs on the browser the results. The code is like this

<?php do { ?>
<?php echo $row_Recordset1['a1']; ?>;<?php echo $row_Recordset1['w1']; ?>;br />
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

I want that output to be able to save it as a text file and if possible to be able to change the encoding of the file as i use UTF-8 and the file need to be ANSI.

 

Thank you for any help.

[ILMV]

Sorry... but your code looks really bad, it doesn't even look as if the HTML is correct.

 

<?php do {
     echo ($row_Recordset1['a1'] .';'. $row_Recordset1['w1'] .'<br />');
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

 

If anything that is more understandable.

 

Look here for the code to write to a text file... http://www.tizag.com/phpT/filewrite.php

[mycow]

the code i have outputs something like

 

000000;10.0.0.0;10;27 and so on...

The code works fine

[abdfahim]

yes .. your code may work fine but there is no point of putting php tag for each line. Anyway, I think the following will work

<?php
$forwrite="";
while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)){
     $forwrite .= $row_Recordset1['a1'].";".$row_Recordset1['w1']."<br />";
}
$filename = "myfile.txt";
if (!$handle = fopen($filename, 'w')) {
      echo "Cannot open file ($filename)";
      exit;
}
if (fwrite($handle, $forwrite) === FALSE) {
      echo "Cannot write to file ($filename)";
      exit;
}
fclose($handle);
?>

[ILMV]

Fine, I am not saying it doesn't do what you expect, but you have a broken <br /> tag in there, and you are opening and closing PHP tags (<?php & ?>) far too many times really.

 

Have you tried using the code to create your text file?

[mycow]

the tags were open due to some changes i did ... i had other stuff in there and forgot the erase the tags

[abdfahim]

@ILMV .. your question was for me? Anyway .. yup, my code should write a text file.

 

@mycow .. use "\n" or "\r\n" instead of "<br>" if you want a line break in your text file.

[mycow]

@abdbuet works fine thank you but in some cases it gives me a space. I have allready one in there and look bad with the second. Do you have anything in mind?

 

Thank you again.

[robb73]

@mycow .. use "\n" or "\r\n" instead of "<br>" if you want a line break in your text file.

 

Personally I'd use PHP_EOL

[abdfahim]

well, if you dont put a second space in your code, the only alternative i can think is the data from the data base has that extra space. try trimming everytime you get anything from database, like below ....

 

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)){
     $forwrite .= trim($row_Recordset1['a1']).";".trim($row_Recordset1['w1'])."<br />";
}

[ILMV]

@abdbuet No my question wasn't pointing at you, I posted that one at the same time you posted

[abdfahim]

@ILMV .. yup, I guessed so .. that's y i asked the question []