Read a text file and transfer contents to mysql database
- by Jack Brown
I need a php script to read a .txt file.
The content of the text file are like this:
data.txt
145|Joe Blogs|17/03/1954
986|Jim Smith|12/01/1976
234|Paul Jones|19/07/1923
098|James Smith|12/09/1998
234|Carl Jones|01/01/1925
These would then get stored into a database like this
DataID |Name |DOB
234 |Carl Jones|01/01/1925
I would be so grateful if someone could give me script to achieve this.