MySQL/PHP Load Data

[rakennedy75]

Is there something wrong with this .... ?

$query = "load data infile '/myPath/myTextFile.txt' into table myTable"; 
$result = mysql_query($query, $conn);
!$result ? print"could not load data" : print"loaded";

I can load data like this using load data infile, perfectly using MySQL directly but what i want to do is to load the data through php like I am trying to do above. Is this not the way to approach it. Any help would be great, thanks for your time.

[ZibingsCoder]

I'm not sure if this is supported by PHP's MySQL extension. You might want to try loading the file using PHP, then running the file contents through a mysql_query() call.

[rakennedy75]

ok, forgive the ignorance, but i am not sure what you mean. I know the phpMyAdmin app allows you to upload a sql file and load it with a load data infile and it works.

I want to duplicate this function to some degree but i don't need the upload feature. I actully want the path hardcoded for my purposes.

How would I load the file using php?

Thanks for the response and I appreciate your time.