hi.. could any one send me the php code for reading the data from file and then stores in Mysql database, the data in file could be seperated as space or comma.. thankx
to read data from file, use these codes
$open_file=fopen("file.txt","r"); flock($open_file, LOCK_SH); while(! feof ($open_file)) $data=fread($open_file,100000); fclose($open_file);
look here http://www.mysql.com/doc/en/LOAD_DATA.html