Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Importing a dataset on a external webpage into mySQL

New Here ,
Dec 14, 2010 Dec 14, 2010

Copy link to clipboard

Copied

So far, I imported only csv files , is this possible?

TOPICS
Server side applications

Views

389
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 14, 2010 Dec 14, 2010

Copy link to clipboard

Copied

LATEST

It's not impossible, but neither is it particularly easy. You would need to retrieve the web page's contents using file_get_contents(), and then use PHP string functions with regular expressions to extract the data and build a SQL query.

It's a lot easier if you can get an XML feed of the data. You can then use SimpleXML to extract the data and insert it into your database.

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines