PHPBuilder - file processing; text and dat file creation



RSS Twitter
Tips Tricks And Hacks

file processing; text and dat file creation

by: koree monteloyola
|
January 24, 2005

1. connect and execute your mysql query


$sql = "SELECT * FROM auth";
$res = mysql_query($sql);
$num = mysql_num_rows($res);

2. set the filepointer($fp) and specify the path and filename of the file to be created. In this part, fopen() requires 3 arguments but mostly you would only use 2 arguments: filename and directive. The directive sets the kind of processing to be done on the file. In this case "w", means write (only). If the file doesn't exists, it would attempt to create the file on the directory that you've specified, in this case it would be in the drive c-> "C:/" .


	$txtFile="C:/fileProcessing.txt";
	$fp = fopen($txtFile,"w");

3. by looping through the fetch command you can retrieve the data from your mysql database and save it in a single variable ($str) separated by the escape characters "\r\n"

\r = carriage return \n = new line

"\r\n" = windows newline


	for($i=0;$i<$num;$i++){
		$row = mysql_fetch_array($res,MYSQL_BOTH);
		$name =$row['name'];
		$pass =$row[pass]."\r\n";
		$str .=$name.",".$pass;
	}

4. after storing the string into the $str variable, you could execute the fwrite() function, this line would write the string into your text file (fileProcessing.txt).

The fclose() would close the file pointer



	fwrite($fp,$str);
	fclose($fp);


5. Having this code would open a dialog box to save the text file (fileProcessing.txt) as "testing.DAT" in a location you desired


header("Content-type: text/htm");
header("Content-Disposition:attachment;filename=testing.DAT");
readfile($txtFile);

complete code


<?php
$conn = mysql_pconnect("localhost","root","password");
mysql_select_db("databaseName");
$sql = "SELECT * FROM auth";
$res = mysql_query($sql);
$num = mysql_num_rows($res);
if($num> 0){
	$txtFile="C:fileProcessing.txt";
	$fp = fopen($txtFile,"w");
	for($i=0;$i<$num;$i++){
		$row = mysql_fetch_array($res,MYSQL_BOTH);
		$name =$row['name'];
		$pass =$row[pass]."\r\n";
		$str .=$name.",".$pass;
		//.chr(13);
	}
	//echo $str;
	fwrite($fp,$str);
	fclose($fp);
	header("Content-type: text/htm");
header("Content-Disposition:attachment;filename=testing.DAT");
    readfile($txtFile);
}
?>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
koree monteloyola

Comment:



Comment:

(Maximum characters: 1200). You have characters left.