insert text with no specific format into database table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i have text file and a table created with

create table word(
id int not null auto_increment primary key,
word varchar(50),
definition text
)

the text contain list of words but not really in specific format

word, some text definition
word, some text definition, some text definition, etc


i want to read the file line by line,
take the first word before comma (,) and insert into the word column in the
database
whatever after follow the first comma(,) will be inserted into the
definition column in the word table database.

i am not sure how to read the file line by line in php.
and how to separate the line of  text into two. divided by the 1st comma (,)
..
my idea is using the explode(',' $text) function. but this one will separate
everything between a comma(,) into an array.
i wan't to know if there is another better way to do it..


any idea?
thank you!

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux