Read csv file from input and populate text field

[Adolfsen]

I have a html form that contains several text field´s. One of those fields are postal number (or zip code) and next to that a city field text.

What I want is after user input in postal number, a script to read input and loop search for that input in a csv file that I have (wich contains two columns: postal number and city). When the script finds that row, loop ends och take the second value in that array and puts it in the text field named city. If there is no match nothing should happen and user have to input city himself or maybe some error message.

Some of my code: (the php code is something put together from different tutorials but my skills in php is minimal so i really do need help)

<form ....

...

<tr>
    <td>
    Postnummer<br />
      <label>
        <input type="text" name="Postnummer" id="postnummer" size="5"/>
      </label>
    </td>
    <?PHP

	$file_handle = fopen("../assets/csv/postnr.csv", "r");

	while (!feof($file_handle) ) {

	$line_of_text = fgetcsv($file_handle, 1024);

		if(value_from_input_field == line_of_text[1]) {

		// send column 2 data to input filed

		} else {

		// do nothing or print mismatch

		}
    }

	fclose($file_handle);

?>
<td>
Ort<br />
  <label>
    <input type="text" name="Ort" id="ort" size="22" />
  </label>
</td>
  </tr>

...

</form>

Any help is very appreciated!

[big_nerd]

Adolfsen,

I highly recommend AGAINST using CSV in this fashion, especially since the number of Canadian Postal Codes is over 1M, and has 7.2M TOTAL possible postal codes.

The US Zip codes is still very very high, and even more so with the 5+4 zip codes.

This Function Below will find the text input ($text_input) and return an array with the tnire line of the CSV file. Keep in mind #0 is the first one in the list, as PHP starts with 0, not 1.

<?php
$sCSVFile = 'Book1.csv'; // Name of file.
$fp = fopen($sCSVFile,'rt'); // Open file.
while(($aCSV = fgetcsv($fp,10000)) !== False) // Whilst we can get something from the file.    

      {                                       // 10000 is the number of lines PHP is to read
        if (aCSV[0] == $text_input) {
          $pCode = $aCSV; // Store the last thing just read into an array.      

        }
      }
print_r($pCode); // Print the array.
?>

I would highly recommend you use a database, in fact you can purchase Zip/Postal Code databases complete if you would like.

This way you could query the database (MySQL perhaps?) for the Zip/Postal Code and have the city returned.

This function will be extremely slow and is very inefficient.

[Adolfsen]

thanks big.nerd!

I will try the code asap.

I would also like to use a database but unfortunately thats not possible. It is worth mentioning that it is for Swedish postal numbers. The total number of postal numbers is about 15 thousand. Mayby thats still too many?

Again, many thanks for the reply!