Mysql control help

[lucashii]

I am currently using phpmyadmin to upload .txt files into the db using sql which look something like this

LOAD DATA INFILE 'data.txt' INTO TABLE tmp LINES TERMINATED BY '\r\n';

INSERT INTO data
SELECT
SUBSTR(str,1,6),
SUBSTR(str,7,20),

FROM tmp;
Now is there a way to write some coding to run this command in web browser using php so that I don't need to manually go into phpmyadmin to type all of these into the sql?

Any help would be appreciated~Thanks~~

[big_nerd]

lucashii,

I am normally not one to merely direct to do some reading, but essentially you are asking someone to do the coding for you.

I recommendhttp://www.tizag.com/phpT/files.php, and http://www-128.ibm.com/developerworks/opensource/library/os-php-readfiles/.

This is how I learned how to open and manipulate files.

I would bring the file in, and use PHP to parse the data you wish to put into the database.

You can go here: http://www.tizag.com/phpT/fileupload.php for a tutorial on uploading files so you can upload the .txt file to the server, parse it, and delete it (if you wish).

If you come up with some code and need a little refining, feel free to post it and I (and others im sure) will be glad to help you fix it up.

big.nerd

[lucashii]

Thanks big.nerd, I guess I did not make my post clearly though

I need some guidance on how to be able to control mysql with php so I could directly insert sql into the database. The sql coding i supplied on my first post could only be placed directly into phpmyadmin to get my text file data into the db.

I have already done the upload part~Thanks~

[Roger_Ramjet]

Load Data Infile is a mysql function so your php code runs it same as it would a select query etc.