Take content from a list of a website and save to the PHP database

Question

I want to enter the site below, save all html in a variable, clear html and save the content I want in the database Mysql via PHP 7.

The site is: http://guildstats.eu/bosses?monsterName=&world=Ferobra&rook=0

At first I "saved the HTML of the page" in a variable, as code below:

$mundo = 'ferobra';
$url = 'http://guildstats.eu/bosses?monsterName=&world=' . $mundo . '&rook=0' . $mundo;

function curl_get_contents($url)
{
  $ch = curl_init();
  curl_setopt($ch, CURLOPT_URL, $url);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
  $data = curl_exec($ch);
  curl_close($ch);
  return $data;
}

$pagina = curl_get_contents($url);

My difficulty now is cleaning the HTML, save this in arrays and then popular the database.

Can someone help me?

Answer 1

From what I understand you want to save only part of the html in the right bank? Well you can try to make a bank explode by passing the beginning of the html you want and then take the index of this html and play in the Bank

$html = explode("começo_do_html_a_salvar", "$pagina")

After you blow up at the end of HTML to get only HTML

$htmlToSave = explode("final_do_html_A_salvar" , $html[0]);

Then you just save at the bank by passing $htmlToSave[0]

Answer 2

There is a technique for what you are wanting to do, it is an interesting subject, the name of the technique is Web scraping, with that name you can find many explanations on the internet of how to do this,I particularly recommend you use the method

preg_match_all();

it works together with regular expression (Regex).