[PHP] loading data into mysql from txt file from php

[Clif Wieden]

I have a project where the admin uploads a new data file and it needs to
be loaded into a mysql database. What's the best way to do this? The
data file is tab-delimted but could be reformatted.

Right now the file is uploaded and after copy($new_file, $file_loc)
would like to refresh the db.

unix box running php4 and mysql 3.22 and of course apache

Thanks in advance,
clif


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] cgi execution w/php failing

[Clif Wieden]

Hi,

I've read through the archives and still must be missing something. I
need to execute a cgi script from php. This seems fairly trivial, but I
can't get it to work.

the cgi script is clean -- executes from the command line without issue
and is 755
from php the follwing is used:


chdir("../../cgibin");
if(is_executable("some.cgi"))
virtual("some.cgi");
else
echo "Not executable";



some.cgi is found and is executable but the following occurs when
attemping to execute via virtual():

Warning: Unable to include 'some.cgi' - request execution failed in
[path to php page]

Any help would be greatly appreciated,
clif



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]