Writing to .txt file

[graham23s]

Hi Guys,

 

what i was trying to do is loop a load of data from mysql and write it to a .txt file i have:

 

<?php
     $host = "localhost";       
     $user = "root"; 
     $pass = ""; 
     $data = "test"; 

     // Connect and select the database //
     $conn = mysql_connect($host, $user, $pass) or die(mysql_error()); 
       $db = mysql_select_db($data, $conn) or die(mysql_error()); 
       
     // select
     $q = "SELECT * FROM `syla_emails`";
     $r = mysql_query($q);
     
     while ($a = mysql_fetch_array($r))
     {
     
      // vars
      $email = $a['EMAIL'];
       
      $ourFileName = "testFile.txt";
      
      $ourFileHandle = fopen($ourFileName, 'w') or die ("can't open file");
      
      fwrite($ourFileHandle, $email);
      
      fclose($ourFileHandle);
      
      
     }
?>

 

so far but it only seems to write 1 email to file!

 

any help would be great

 

cheers

 

Graham

[rhodesa]

you need to open/close the file outside of the loop...

 

<?php
     $host = "localhost";       
     $user = "root"; 
     $pass = ""; 
     $data = "test"; 

     // Connect and select the database //
     $conn = mysql_connect($host, $user, $pass) or die(mysql_error()); 
       $db = mysql_select_db($data, $conn) or die(mysql_error()); 
       
     // select
     $q = "SELECT * FROM `syla_emails`";
     $r = mysql_query($q);
     
     $ourFileName = "testFile.txt";
      
     $ourFileHandle = fopen($ourFileName, 'w') or die ("can't open file");

     while ($a = mysql_fetch_array($r))
     {
      // vars
      $email = $a['EMAIL'];
      fwrite($ourFileHandle, $email);
     }
     fclose($ourFileHandle);
?>

[graham23s]

ah thanks mate

 

1 more thing! how would i start a new line after each email? i did:

 

<?php
     $host = "localhost";       
     $user = "root"; 
     $pass = ""; 
     $data = "test"; 

     // Connect and select the database //
     $conn = mysql_connect($host, $user, $pass) or die(mysql_error()); 
       $db = mysql_select_db($data, $conn) or die(mysql_error()); 
       
     // select
     $q = "SELECT * FROM `syla_emails`";
     $r = mysql_query($q);
     
     $ourFileName = "testFile.txt";
      
     $ourFileHandle = fopen($ourFileName, 'w') or die ("can't open file");

     while ($a = mysql_fetch_array($r))
     {
      // vars
      $email = $a['EMAIL'];
      
      // string to write
      $string = "E-MAIL: [ $email ]\n";
      
      fwrite($ourFileHandle, $string);
     }
     
     fclose($ourFileHandle);
?>

 

but it doesn't recognise the \n for some reason!

 

thanks mate

 

Graham

[wildteen88]

You may want to use \r\n instead.

[rhodesa]

You may want to use \r\n instead.

 

yeah, if you are opening it in notepad on a windows machine, you will probably need the \r\n