I am trying to load a .csv file into a table in a DB.
The issue isn't with the DB itself, but rather with the process of gathering the data from the .csv file.
<form NAME='choose' METHOD='post' ENCTYPE="multipart/form-data" ACTION="<?=$PHP_SELF?>">
<INPUT TYPE=FILE NAME="pin_file">
<input type="submit" name="display" value="DISPLAY RECORDS">
</form>
When I run this, it gives me the BROWSE button. I click on the browse button and select the file that I want to read:
C:\phpdev\www\two-bit-site.com\product\test.csv
When I click on submit, it is supposed to read that file, but the file read routine gives me this error:
Warning: fopen($pin_file): failed to open stream: No such file or directory
So I printed out the value of the $pin_file variable that should contain the filename to be read, and it is this:
pin file is /tmp/phpmglRRd
Any Idea why? this isn't something I normally have to deal with, and it is a major stumbling block in this script..
Any help would be greatly appreciated.
doug
