inserting the data thru php in a text file

suchi_s · 02-01-2005, 03:42 AM

insert data in a text file through php
how ?
code?

keefaz · 02-01-2005, 05:53 AM

Could you ellaborate with insert data ?

The basic code to write in a text file could be :

PHP Code:



$file = "/path/to/file"; 
$fd = fopen($file, "a"); // a for append, append text to file 
if(!$fd) { die("Could not open $file to write in"); } 
fwrite($fd, "something"); 
fclose($fd);

suchi_s · 02-01-2005, 06:28 AM

but how to update the particular record in a file through file or a particular field in a record

keefaz · 02-01-2005, 06:44 AM

That depends on how you format your file, is it csv or is it like "field = value" ?

suchi_s · 02-01-2005, 10:27 PM

file is tab seperated..

keefaz · 02-02-2005, 03:28 AM

So I think the function fgetcsv() will be usefull here. Say you have a file :

Code:

one     two     three
cat     dog     bird
man     woman   child

And you want to update "bird" (which is on the 3rd field column) and replace it
with "falcon"

PHP Code:



// your tab separated file 
$file = "/path/to/file"; 
// a temp file 
$tmp = tempnam("/tmp", "tmpfile"); 
 
// open tab separated file 
$fd = fopen($file, "r"); 
if(!$fd) { 
    echo "Could not open $file in read only mode\n"; 
    exit(1); 
} 
 
// open tmp file to write in 
$fw = fopen($tmp, "w"); 
if(!$fw) { 
    echo "Could not open the temp file in write mode\n"; 
    exit(1); 
} 
while (($line = fgetcsv($fd, 1000, "\t")) !== FALSE) { 
    if($line[2] == "bird") { $line[2] = "falcon"; } 
    $text = implode("\t", $line)."\n"; 
    fwrite($fw, $text); 
} 
 
fclose($fd); 
fclose($fw); 
 
// now just copy temp file to tab separated file (need write permission) 
copy($tmp, $file) or die("Could not copy tmp to $file");  
unlink($tmp);