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

Importing a dataset on a external webpage into mySQL

New Here ,
Dec 14, 2010 Dec 14, 2010

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

TOPICS
Server side applications
392
Translate
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
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.

Translate
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