Import url information into mysql with php

Discussion in 'Programming/Scripts' started by amocco, Jun 18, 2010.

  1. amocco

    amocco New Member

    Hi

    I have a little problem . Could you help me to import all informations from url :

    ftp://tgftp.nws.noaa.gov/data/observations/metar/cycles/00Z.TXT

    into mysql table .

    for example :

    2010/06/17 23:55
    KFDW 172355Z AUTO 00000KT 10SM CLR 33/17 A2996 RMK AO1

    1er row : 2010/06/17 23:55
    2 : KFDW
    3 : 172355Z
    4: AUTO 00000KT 10SM CLR 33/17 A2996 RMK AO1

    thanks
     
  2. BorderAmigos

    BorderAmigos New Member

    Create your database. Create tables with columns for what you refer to as rows.

    In PHP then: Open the site url like a file. Read the data into an array. Parse the array writing the desired values to the database.

    Study intensely at php.net and mysql.com to learn the programming to do all this.

    Or hire someone to do it.
     

Share This Page