[php]transferring data from text file to Mysql Table
Posted: Thu Jul 09, 2009 2:47 am
I've a example text file below. I need to pass this data to mysql.
and can anyone help with this.
I figure out the way of connecting database,
and the thing I am suffering with is transferring below data to mysql
ignore dots
Phone......MCO Accessory.........VPS Bluetooth.........VPC Bluetooth (FACTORS)
White..... .T950....................off.....................off (CHOICES)
White......C300....................on.....................off (CHOICES)
White......T950....................on.....................off (CHOICES)
White......T950....................off.....................on (CHOICES)
White......C300....................off.....................off (CHOICES)
White..... .C300....................on.....................on (CHOICES)
White..... .C300....................off.....................on (CHOICES)
White..... .T950....................on......................on (CHOICES)
and can anyone help with this.
I figure out the way of connecting database,
and the thing I am suffering with is transferring below data to mysql
ignore dots
Phone......MCO Accessory.........VPS Bluetooth.........VPC Bluetooth (FACTORS)
White..... .T950....................off.....................off (CHOICES)
White......C300....................on.....................off (CHOICES)
White......T950....................on.....................off (CHOICES)
White......T950....................off.....................on (CHOICES)
White......C300....................off.....................off (CHOICES)
White..... .C300....................on.....................on (CHOICES)
White..... .C300....................off.....................on (CHOICES)
White..... .T950....................on......................on (CHOICES)