<?php

require 'C:\OSPanel\vendor\autoload.php';

//require_once('link.php');
    $host = 'localhost'; // адрес сервера
    $database = 'mysite'; // имя базы данных
    $user = 'root'; // имя пользователя
    $password = ''; // пароль

// подключаемся к серверу
$link = mysqli_connect($host, $user, $password, $database)
or die("Ошибка " . mysqli_error($link));

$baseurl = 'http://code.mu/exercises/advanced/php/parsing/poetapnyj-parsing-i-metod-pauka/1/';
$str ='http://code.mu/exercises/advanced/php/parsing/poetapnyj-parsing-i-metod-pauka/1/';

function getCurl($url){
    $curl = curl_init();
    curl_setopt($curl,CURLOPT_URL, $url);
    curl_setopt($curl,CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($curl,CURLOPT_FOLLOWLOCATION, 1);
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 0);
    $result = curl_exec($curl);
    return $result;
}

function addContent($link,$url,$title,$content){
    $query="SELECT title FROM codemu WHERE title='".$title."'";
    $result= mysqli_query($link,$query);
    $data = mysqli_fetch_assoc($result);
    if(empty($data)){
        $query="INSERT INTO codemu SET url='".$url."', title='".$title."', data=NOW(), content='".$content."'";
        mysqli_query($link,$query)or die(mysqli_error($link));
    } else return;

}




$curl = getCurl($str);
$pq = phpQuery::newDocument($curl);
$urls = $pq->find('#menu li a');
foreach($urls as $elem){
    $url = pq($elem)->attr('href');
    $url = $baseurl.$url;
    $curl2 = getCurl($url);
    $pq = phpQuery::newDocument($curl2);
    $title = $pq->find('title')->text();
    $pq->find('h1')->remove();
    $content = $pq->find('#content')->html();
    addContent($link,$url,$title,$content);
}
?>