Jump to content

soxxx85

New Members
  • Posts

    1
  • Joined

  • Last visited

soxxx85's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi, I have a problem deleting duplicate rows in a .csv file. I have posted on another forum, but with no useful help, the file is still saving the row of .csv even in I write in a duplicate mobile number. The record file is only 2000 lines long and performance is not an issue. Please help, as it is time-sensitive. Cheers <?php $filename = "input.csv"; $csv_output .= "\n";$title=$_GET[title];$fname=$_GET[fname]; $sname=$_GET[sname];$notes=$_GET[notes];$mobile=$_GET[mobile]; $string="$title,$fname,$sname,$mobile,$notes,$csv_output"; $file = fopen($filename, "c"); flock($file, LOCK_EX); $stat = fstat($file) if($stat['size'] == 0) { // file created for the first time fwrite($file, "Title,First Name,Last Name,MobileNumber,Notes\n$string"); flock($file, LOCK_UN); fclose($file); return; } while (($buffer = fgets($file, 2188)) !== false) { if(!stripos($buffer, $mobile) { $somecontent .= $buffer; } else { flock($file, LOCK_UN); fclose($file); return; } } // Otherwise fwrite() the line else { fwrite($file, $string); } flock($file, LOCK_UN);fclose($file); ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.