File Reading Problem

programguy28

Ok, I have some BIG files that I got off of Excel. They are Comma Seperated, AND one record per line (Convenient).

I am used to programming in Java where you can read a file one line at a time. There is also a function that will put data into an array with an optional delimiter (such as a comma). After reading the PHP manual about files, it seems that the entire file is read into an array.

This is my problem - These files are WAY too big to be put into an array. I am wanting to read one line at a time and then send it to a Mysql database.

Does anyone know of a PHP way of reading a file one line at a time?

justsomeone

yep. fgets() are you sure you read the manual?

Weedpacket

Or [man]fgetcsv[/man].

programguy28

Thanks for the help, did not know those existed.......

...and yes I am sure I read the manual.. not the whole thing mind you of course. Look, I am aware that there are people that do not bother looking anywhere for anything, but I am not one of them. I only post if something is unclear to me, or I need design help. If you can't help someone without making a smart-a** comment, then don't post a reply. :mad:

Thank you weedpacket - That is exactly what I was looking for man 🙂

bretticus

Look, I am aware that there are people that do not bother looking anywhere for anything, but I am not one of them.

Had you looked through a few more functions (particularly fgets), you would have noticed in plain English "fgets -- Gets line from file pointer." How obvious is that!? Which leads me to believe one of two things...

You are one of those people that is so impatient you did not take the time to notice all the links on the left in the PHP manual are related to the current command; I pressume you just looked at file(). That would explain your ingratitude and short temper.

or...

You lied and you're just pissed somebody called you on your LIE.

If you're too lazy to make an effort to really search for a solution (that was not that hard to find) expect someone to call you on your bull $hit.

programguy28

......wrong on both counts (saw fgets, did not notice fgetcsv - so back off bud)

What is it with people on this board? I am not some kid - I am 34 years old. I am a programmer (not some hobbyist). I am new to PHP. You need to get an attitude check. If you think someone is asking a "stupid" question, then don't frickin answer it, keep your comments to yourself.

PS - You stated:

That would explain your ingratitude and short temper.

You obviously did not read the part that says...Thank you.

bretticus

Hehe...

I do have to admit I'm more cranky at night. I responded the way I did, because I didn't think justsomeone's comment was terribly smart-a$$ed and at least he gave you an answer.

If you think someone is asking a "stupid" question, then don't frickin answer it, keep your comments to yourself.

I did not answer your question it was already answered. It was YOUR attitude I felt was "stupid." And this is a forum for posting, among other things, comments so deal with it!