crawl static html data and add in mysql

Discussion in 'PHP' started by vinpkl, Nov 16, 2009.

  1. #1
    hi

    i m working on a site which has more than 1500 static html article pages. i need to add those articles data to mysql.

    one way i know is to manually copy and paste.

    is there any other solution.

    vineet
     
    vinpkl, Nov 16, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    if its merely copying html content and inserting into mysql, then write a script which will read the file and insert / update the content in mysql.
     
    mastermunj, Nov 16, 2009 IP
  3. vinpkl

    vinpkl Active Member

    Messages:
    899
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    58
    #3
    hi mastermunj

    can you provide litle idea which function will be used to read the file.

    any reference.

    vineet

     
    vinpkl, Nov 16, 2009 IP
  4. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    mastermunj, Nov 16, 2009 IP
  5. vinpkl

    vinpkl Active Member

    Messages:
    899
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    58
    #5
    thanks mastermunj

    i will read it and work on it.

    just a last clarification that it will fetch everything that is on that page in text format including the menus etc.

    vineet

     
    Last edited: Nov 16, 2009
    vinpkl, Nov 16, 2009 IP
  6. innovatewebs

    innovatewebs Well-Known Member

    Messages:
    194
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #6
    i will code that script please let me know your minimum cost to code it.
     
    innovatewebs, Nov 17, 2009 IP