Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- bob schmuckatelli
- jane doe
- id Fname Lname addr something
- 214 jack frost 444 snow rd data data
- $file = fopen('names.txt','r'); //change to whatever name it is
- $firstname = ''; $lastname = ''; $index = -1; $id = -1;
- $tab = ' '; //change this to the delimiter, of course
- while ($line = fgets($file)) {
- $index = strrpos($line, $tab);
- $firstname = substr($line, 0, $index);
- $lastname = substr($line, $index + strlen($tab));
- $id = $sql->query("SELECT id FROM db_name WHERE Fname='" . $firstname . "' AND Lname='" . $lastname . "'");//query the firstname/lastname. Change db_name to whatever and I'm assuming you don't need to sanitize.
- //do something with the id?
- }
- fclose($file);
- id fname lname addr age
- N michael jordan N N
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement