<?
header('Content-type: text/html; charset=windows-1251');
include ('phpQuery-onefile.php');
$link = mysql_connect('localhost', 'root','');
mysql_select_db('open');
mysql_query("SET CHARACTER SET 'cp1251'");
$num_top_cat = 66; // идентификатор категории
function print_arr($arr)
{
echo "<pre>" . print_r($arr, true) . "</pre>";
}
$url = 'https://сайт.ру';
$file = file_get_contents($url);
$doc = phpQuery::newDocument($file);
foreach ($doc->find('.selection-placeholder .body-col2-itemsline-item') as $article)
{
$article = pq($article);
$article->find('.body-col2-itemsline-itemname u')->append(';;;');
$article->find('.body-col2-itemsline-firm .firm')->append(';;;');
$article->find('.body-col2-itemsline-itemprice')->append(';;;');
$article->find('.body-col2-itemsline-itemdescr')->append(';;;');
$article->find('.unit')->remove();
$article->find('.nbsp')->remove();
$article->find('i')->remove();
// title
$title = $article->find('.body-col2-itemsline-itemname u')->html();
$title_arr = explode(";;;", $title);
//print_r($title_arr);
//img
$img = $article->find('.body-col2-itemsline-itemimage img')->attr('src');
$img_arr = explode(" ", $img);
// производитель
$firm = $article->find('.body-col2-itemsline-firm .firm')->html();
$firm = mb_strtolower(iconv("windows-1251", "utf-8", $firm));
$healthy = array(
"888","abac","ada","ae&t","ballu","bessey","billy goat"
);
$yummy = array(
12,13,14,15,16,17,18
);
$newphrase = str_replace($healthy, $yummy, $firm);
$firm_arr = explode(";;;", $newphrase);
// цена
$price = $article->find('.body-col2-itemsline-itemprice')->html();
$price_arr = explode(";;;", $price);
// описание
$ds = $article->find('.body-col2-itemsline-itemdescr')->html();
$ds_arr = explode(";;;", $ds);
mysql_query("INSERT INTO `oc_product` (`model`,`image`,`price`,`manufacturer_id`)
VALUES ('$title_arr[0]','$img_arr[0]','$price_arr[0]','$firm_arr[0]')");
}
|
