How to use cURL to fetch specific data from a website and then save it my database using php

by

Using cURL:

$ch = curl_init();
curl_setopt( $ch, CURLOPT_URL, 'http://www.something.com');
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true);

$content = curl_exec($ch);

Then you can load the element into a DOM Object and parse the dom for the specific data. You could also try and parse the data using search strings, but using regex on HTML is highly frowned upon.

$dom = new DOMDocument();
$dom->loadHTML( $content );

// Parse the dom for your desired content

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. While loop inserts three times
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  4. regarding installation of php in windows
  5. save user images in MYSQL database by which method? [closed]
  6. Row count with PDO
  7. Best way to INSERT many values in mysqli?
  8. How to view query error in PDO PHP
  9. php/mysql with multiple queries
  10. Resetting array pointer in PDO results
  11. Notice: Array to string conversion in
  12. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  13. Find total number of results in mySQL query with offset+limit
  14. How to efficiently find the closest locations nearby a given location
  15. PDO::PARAM for type decimal?
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. (mysql, php) How to get auto_increment field value before inserting data?
  18. How to execute raw queries with Laravel 5.1?
  19. Can’t find FULLTEXT index matching the column list (indexes is set)
  20. What is the type this string? a:1:{s:2:”en”;}
  21. Extension mysqli is missing, phpmyadmin doesn’t work
  22. PHP to store images in MySQL or not?
  23. UTF-8 character encoding battles json_encode() [duplicate]
  24. How to get MySql 8 to run with laravel? [duplicate]
  25. recursive function to get all the child categories
  26. Store html entities in database? Or convert when retrieved?
  27. avoiding MySQL injections with the Zend_Db class
  28. How to create a database-driven multi-level navigation menu using Laravel
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment