So, I have a large CSV file (Name_data_all.txt) with about 2.4 million names in it formatted like this:
,,Roughdawg4,xLukk,blackangel887462,Semnas,HUTCHY007,MrUnknown625,maxijodi,jeromepotel
However, the way the data was inserted into the CSV file, it's all on one continuous line
What I need to do is insert them all into a database table but the problem is that when I try and read in the file I get this error:
Allowed memory size of 134217728 bytes exhausted
Now I know I can use fseek() and fgets(); but I cannot figure out how to do so, I was thinking of just partially extracting data, inserting, and then grabbing next chunk and so on...
I know this form of extraction works and outputs each name into unique array indexes but again, memory problems if I do more than ~600k:
$handle = fopen("Name_data_all.txt", "r");
$data = fgetcsv($handle, 6000000, ",");
$pos1 = fgets($handle);
fclose($handle);