need help inserting a CSV into mySQL via PHP page.

[news]

I'm building an e-commerce site, where the owner needs to be able to
upload a CSV file of product that gets inserted into mySQL.
Unfortunately, I think my Web host may have some functions turned off.
Is there some other ways I can try to do the following?

First, I'm using a form to upload a file. That works, but it sets the
file permissions to 600, and the PHP command "exec()" is disabled so I
can't chmod it as part of the script.

But that's OK I guess. I can still FTP the file up and change the
permissions to even 777 if need be. The real problem comes when trying
to do the insert:

$sql = "LOAD DATA INFILE
'/home/myaccount/public_html/data/item_test.csv' INTO TABLE
`tbl_temp_produpload` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES
TERMINATED BY '\r\n'";
$result = @mysql_query($sql, $dbh) or $error_msg .= "<div
align=\"center\" class=\"tah12RedBold\">".mysql_error()."</div>";

I'm getting no error message, but it's not inserting either.
I can use phpMyAdmin to manually insert the file off my local PC, but I
just can't get it to do it from the file on the server.

Is there another way to do this? (No I can't give phpMyAdmin access to
the user.)

Thanks for any suggestions!
Liam

[Daniel Tryba]

ne**@celticbear.com wrote:

First, I'm using a form to upload a file. That works, but it sets the
file permissions to 600, and the PHP command "exec()" is disabled so I
can't chmod it as part of the script.

chmod is a PHP function.

[news]

Daniel Tryba wrote:

ne**@celticbear.com wrote:

First, I'm using a form to upload a file. That works, but it sets the file permissions to 600, and the PHP command "exec()" is disabled so I can't chmod it as part of the script.

chmod is a PHP function.

http://us3.php.net/manual/en/function.chmod.php
Huh. Lookeedere. Had no idea. Thanks!

OK, well, I still have the most important problem of not being able to
use the mySQL command: "LOAD DATA INFILE".
Any workarounds or tips on that?

Thanks!
Liam

[news]

[e-mail] wrote:

Daniel Tryba wrote:

chmod is a PHP function.

http://us3.php.net/manual/en/function.chmod.php
Huh. Lookeedere. Had no idea. Thanks!

Drat, got my hopes up:

Warning: chmod(): Permission denied in
/home/iestud/public_html/gto/admin/upload.php on line 22

Oh well, I can still FTP the file up and chmod it using the FTP
program.
Thanks

[News Me]

ne**@celticbear.com wrote:

I'm building an e-commerce site, where the owner needs to be able to
upload a CSV file of product that gets inserted into mySQL.
Unfortunately, I think my Web host may have some functions turned off.
Is there some other ways I can try to do the following?

First, I'm using a form to upload a file. That works, but it sets the
file permissions to 600, and the PHP command "exec()" is disabled so I
can't chmod it as part of the script.

But that's OK I guess. I can still FTP the file up and change the
permissions to even 777 if need be. The real problem comes when trying
to do the insert:

$sql = "LOAD DATA INFILE
'/home/myaccount/public_html/data/item_test.csv' INTO TABLE
`tbl_temp_produpload` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES
TERMINATED BY '\r\n'";
$result = @mysql_query($sql, $dbh) or $error_msg .= "<div
align=\"center\" class=\"tah12RedBold\">".mysql_error()."</div>";

I'm getting no error message, but it's not inserting either.
I can use phpMyAdmin to manually insert the file off my local PC, but I
just can't get it to do it from the file on the server.

Is there another way to do this? (No I can't give phpMyAdmin access to
the user.)

Thanks for any suggestions!
Liam

Why use PHP? mysqlimport (included with MySQL) can handle that for you.

NM

--
convert UPPERCASE NUMBER to a numeral to reply

[News Me]

News Me wrote:

Why use PHP? mysqlimport (included with MySQL) can handle that for you.

NM

I should have actually read the ENTIRE post. NEVER MIND...

--
convert UPPERCASE NUMBER to a numeral to reply

[News Me]

ne**@celticbear.com wrote:

[snip]

$sql = "LOAD DATA INFILE
'/home/myaccount/public_html/data/item_test.csv' INTO TABLE
`tbl_temp_produpload` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES
TERMINATED BY '\r\n'";
$result = @mysql_query($sql, $dbh) or $error_msg .= "<div
align=\"center\" class=\"tah12RedBold\">".mysql_error()."</div>";

[snip]

What is the '@' in front of mysql_query() for?

NM

--
convert UPPERCASE NUMBER to a numeral to reply

[News Me]

ne**@celticbear.com wrote:

I'm getting no error message, but it's not inserting either.
I can use phpMyAdmin to manually insert the file off my local PC, but I
just can't get it to do it from the file on the server.

There may be errors in the web server's (apache?) error log.

--
convert UPPERCASE NUMBER to a numeral to reply

[Geoff Berrow]

I noticed that Message-ID: <11*************@corp.supernews.com> from
News Me contained the following:

$result = @mysql_query($sql, $dbh) or $error_msg .= "<div
align=\"center\" class=\"tah12RedBold\">".mysql_error()."</div>";

[snip]

What is the '@' in front of mysql_query() for?

Is that a rhetorical question?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/