Match code in link with code with one in file and extract line

Peuplarchie

Good day you all,
I work on a email confirmation system, I'm stuck on the part of matching the code in the confirmation link with the one in the file so I can find which line to move from the pending file to the confirmed file.

the lines in the file looks like that :

name, email, code
name, email, code

and the link look like :
http://mysite.com/confirmed.php?code=123456

How can I look for the line in the file that match the code in the link

Thanks!

dagon

Have you considered a data base? It would be a thousand times easier.

Peuplarchie

I can't use db.
Somebody gave me a code but don't move the right line.
here is my code :


 <?PHP
if(isset($_GET['code'] , $_GET['user'])) {
   $row = move_line($_GET['code'], $_GET['user']) ;
   print_r($row);
}

function move_line($code, $user) {
   $lines = file('savedinfo.txt');
   $found_line = "";




   foreach($lines as $k=>$line) {
      $columns = explode(', ', $line);




  if(trim($columns[3]) == $code && trim($columns[0]) == $user ){
     $found_line = $line;
     unset($lines[$k]);
     break;
  }
   }




   if(!empty($found_line)) {
      $f = fopen('savedinfo.txt', 'w+');
      foreach($lines as $k=>$line) {
         fwrite($f, $line);
      }
      fclose($f);






  $f = fopen('members.txt', 'a');
  fwrite($f, $line);
  fclose($f);
   }
}

?>

dagon

have you tried SQLite, no db server required, it would do the above in a single line.

BuzzPHP

The code looks correct apart from this:

$f = fopen('members.txt', 'a');
fwrite($f, $line);
fclose($f);

It should be:

      

$f = fopen('members.txt', 'a');
fwrite($f, $found_line);
fclose($f);

ie: You should be saving the found line in the new members file.