Help for import data from txt file

medvirus · 10-08-2010, 08:05 PM

hi
Friend,
i have a one txt file , which data i have to extract and put in mysql database with php
sow you here and i m showing u a how i put data in mysql

TXt file data

Code:

                                                                     
                                                                     
                                                                     
                                             


============================================================
============================================================

25-09-2010 8:41:39 pm Sat ABC(+919800000000)
Rat gai ne savar padi gai.

Wah wah

rat gai ne savar padi gai.

Wah wah.

Daya- Acp game te hoy tamara to mathe taal padi gai....

25-09-2010 8:57:27 pm Sat ABC(+919800000000))
GOLU: Gandhiji K sir par Baal Q Nai the?

Teacher: Intelligent admi ki nishani Hai..

GOLU:Tabhi Ladkiyo k itne Lambe Baal hote Hai..

25-09-2010 9:41:51 pm Sat ABC(+919800000000)
SARDAR became TRAIN DRIVER.

The 1st Train Driven by him was 5 Hrs late

Why?


Coz he stopd at evry Fatak & ask.
"MUMBAI javu hoy to sidhu j javanu ne.,?

25-09-2010 11:44:27 pm Sat ABC(+919800000000)
Kon kahe 6 k ame radta ta...

Aeto ame ansuo thi ankho dhota ta

i have to make 7 table in database like

HTML Code:

<table><tr>
<td>id</td>
<td>date</td>
<td>month</td>
<td>year</td>
<td>time</td>
<td>sender</td>
<td>number</td>
<td>sms</td>
</tr>
><tr>
<td>1</td>
<td>25</td>
<td>9</td>
<td>2010</td>
<td>8:41</td>
<td>ABC</td>
<td>9800000000</td>
<td> Rat gai ne savar padi gai.Wah wahrat gai ne savar padi gai.Wah wah.Daya- Acp game te hoy tamara to  </td>
</tr>
><tr>
<td>2</td>
<td>25</td>
<td>9</td>
<td>2010</td>
<td>8:57</td>
<td>ABC</td>
<td>9800000000</td>
<td> GOLU: Gandhiji K sir par Baal Q Nai the? 
Teacher: Intelligent admi ki nishani Hai..
GOLU:Tabhi Ladkiyo k itne Lambe Baal hote Hai..</td>
</tr>
</TABLE>

etc ....like many message i have in file

so can you do this ..