Hi Everybody..

I have to upload .txt file in mysql table. This data is to be displayed by using mysql qureries. I have use upload .txt file by code shown below


$destinationdir = "/var/www//html/telephone/uploadfiles/";
 $destinationfile = $destinationdir . $_FILES['myfile']['name'];
 if(move_uploaded_file($_FILES['myfile']['tmp_name'],$destinationfile))
 {
  $bloadquery="load data local infile '$destinationfile' into table billtable fields terminated by '|' enclosed by '' lines terminated by '\\r\\n'";

   if(execute_query($bloadquery))
   {
      header("Location: uploadsuccess.php");
      exit;
      }
.......
......
}


This code working well for uploadding 150000 (approx) lines means file of size in 50 kb but it fails for for uploading file having size 12 mb or more than 12 mb.

So please suggest me what should i change so that full file having more than 12 mb can be upladed
Thanks

Your php.ini file controls the max upload. By default it is set to 2mb.

You need to edit this variable in your php.ini file

upload_max_filesize


http://mynameissteve.com

Oh Thanx sir ...!
I am realy thankfull for your this help...And would like to credit to you to reslove my problem....

Thanx once agian...
Bye..

there's a possibility your host will not allow you to upload a file of over 5MB or so. i would check first, mine for example limits at 3MB.

www.crmpicco.co.uk
www.ie7.com