phpquery5

	require 'phpQuery.php';
	$url = curl_init();
	curl_setopt($url, CURLOPT_URL, "http://theory.phphtml.net/exercises/advanced/php/parsing/zadachi-na-poetapnyj-parsing-i-metod-pauka/2/index1.php");
	curl_setopt($url, CURLOPT_RETURNTRANSFER, 1);
	curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
	$str = curl_exec($url);
	$pq = phpQuery::newDocument($str);
	$links = $pq->find('#menu a');

	foreach($links as $link){
	$siteLink = "http://theory.phphtml.net/exercises/advanced/php/parsing/zadachi-na-poetapnyj-parsing-i-metod-pauka/2/";

	$site = $siteLink.pq($link)->attr('href');
	$url = curl_init();
 	curl_setopt($url, CURLOPT_URL, $site);
	curl_setopt($url, CURLOPT_RETURNTRANSFER, 1);
	curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
	$pageLinks = curl_exec($url);
	$pq = phpQuery::newDocument($pageLinks);
    $pagelinks = $pq->find('#main a');


    foreach($pagelinks as $pagelink){
    $pageLink = "http://theory.phphtml.net/exercises/advanced/php/parsing/zadachi-na-poetapnyj-parsing-i-metod-pauka/2/folder/";

    $plink = $pageLink.pq($pagelink)->attr('href');
    $url = curl_init();
 	curl_setopt($url, CURLOPT_URL, $site);
	curl_setopt($url, CURLOPT_RETURNTRANSFER, 1);
	curl_setopt($url, CURLOPT_FOLLOWLOCATION, 1);
	$pagecontent = curl_exec($url);
	$pq = phpQuery::newDocument($pagecontent);
	$title = $pq->find('h1')->text();
    $content = $pq->find('#main p')->text();

   $host = 'localhost';
   $user = 'root';
   $password = '';
   $db_name = 'phpquery';
   $connect = mysqli_connect($host, $user, $password, $db_name) or die(mysqli_error($link));
   $query = "INSERT INTO page (id, title, content) VALUES (null, '".$title."', '".$content."')";
   $result = mysqli_query($connect, $query);


}
}