Hi. I am wondering if it is possible to input a textfile to a database using a php script. Usually this is a command line thing but unfortunately for me, I do not have access to do it that way, i have to use a script.
I'd love a little help. -Craig
Mr.Craig, Hope that this query will quench your desire.
load data infile 'C:/Program Files/Apache Group/Apache/htdocs/myphpworks/todb.txt' into table class fields terminated by '\t'; For more details, you can refer http://www.mysql.com/doc/L/O/LOAD_DATA.html regards, Indrajit.
