Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 2279 | Replies: 6
 |
•
•
Join Date: May 2007
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Anyone know how to read the second line from a csv file using PHP? I need the read the second line from the csv file and import into mysql
•
•
Join Date: May 2007
Location: USA
Posts: 3,176
Reputation: 
Rep Power: 15
Solved Threads: 314
Here's a tutorial that should get you there:
http://www.goodphptutorials.com/track/62
http://www.goodphptutorials.com/track/62
•
•
Join Date: May 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Is there mentioned how to read second row onwards or any particular row onwards from csv file? I try look at that wrbsite but couldn't find it.
•
•
Join Date: May 2007
Location: USA
Posts: 3,176
Reputation:
Rep Power: 15
Solved Threads: 314
•
•
•
•
Originally Posted by redcoder07 
Is there mentioned how to read second row onwards or any particular row onwards from csv file? I try look at that wrbsite but couldn't find it.
Right in the middle of the table of contents there is a link to the section "Working with CSV".
•
•
Join Date: May 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Yeah, thats the one i searched for, but couldn't get the answer
•
•
Join Date: May 2007
Location: USA
Posts: 3,176
Reputation:
Rep Power: 15
Solved Threads: 314
This code opens and reads a line into $line until there are no more lines:
file_get() can be used as well, to load each line into an array, if you prefer to work with it like that.
php Syntax (Toggle Plain Text)
file_get() can be used as well, to load each line into an array, if you prefer to work with it like that.
Last edited by Ezzaral : Jul 23rd, 2007 at 2:08 pm.
•
•
Join Date: May 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Alright, i got you now. meaning i can do some skipping code to replace
echo $line; // do whatever you need here
with some code that read the string is not equal to the column name in the csv file and proceed to insert.
Thanks for your help. Really appreciated
echo $line; // do whatever you need here
with some code that read the string is not equal to the column name in the csv file and proceed to insert.
Thanks for your help. Really appreciated
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
