//echo "99-99-".$row['id']; $last = ''; if (count($row) > 0) { $last = $row['pubDate']; //echo "pubDate = ".$last; } //пробегаемся по массиву, и те которые позже закидываем в БД вместе с текстом из источника $new = 0; for ($i = 0; $i < count($aqrrOfNews); $i++) { if ($last == '' or $last < $aqrrOfNews[$i]['pubDate']) { $new++; //записываем новость в БД echo "<br />записываем в бд новость - " . $aqrrOfNews[$i]['title'] . "<br />"; //вытаскиваем текс новости с сайта //$aqrrOfNews[$i]['plainText'] = grabbNewsToBD($aqrrOfNews[$i]['link']); $t = grabbNewsToBD($aqrrOfNews[$i]['link']); $aqrrOfNews[$i]['plainText'] = $t['plaintext']; $aqrrOfNews[$i]['innertext'] = $t['innertext']; $aqrrOfNews[$i]['title'] = mysql_real_escape_string($aqrrOfNews[$i]['title']); $aqrrOfNews[$i]['link'] = mysql_real_escape_string($aqrrOfNews[$i]['link']); $aqrrOfNews[$i]['pubDate'] = mysql_real_escape_string($aqrrOfNews[$i]['pubDate']); $aqrrOfNews[$i]['img'] = mysql_real_escape_string($aqrrOfNews[$i]['img']); $aqrrOfNews[$i]['description'] = mysql_real_escape_string($aqrrOfNews[$i]['description']); $aqrrOfNews[$i]['plainText'] = mysql_real_escape_string($aqrrOfNews[$i]['plainText']); $aqrrOfNews[$i]['innertext'] = mysql_real_escape_string($aqrrOfNews[$i]['innertext']); $query = "INSERT INTO {$db_news}.News_foreign (title,fromN,link,description,pubDate,img,plainText,tegText,speech) VALUES ('" . $aqrrOfNews[$i]['title'] . "','" . $_GET['from'] . "','" . $aqrrOfNews[$i]['link'] . "','" . $aqrrOfNews[$i]['description'] . "','" . $aqrrOfNews[$i]['pubDate'] . "','" . $aqrrOfNews[$i]['img'] . "','" . $aqrrOfNews[$i]['plainText'] . "','" . $aqrrOfNews[$i]['innertext'] . "','')"; //echo $query; $result = mysql_query($query); } } if ($new == 0) {
if(count($row)>0){ $last = $row['pubDate']; //echo "pubDate = ".$last; } */ //пробегаемся по массиву, и те которые позже закидываем в БД вместе с текстом из источника echo "\n\n"; $new = 0; for ($i = 0; $i < count($aqrrOfNews); $i++) { //if(($last =='') or ($last < $aqrrOfNews[$i]['pubDate'])){ $new++; //записываем новость в БД echo "\n<br />записываем в бд новость из " . $aqrrOfNews[$i]['fromN'] . " - " . $aqrrOfNews[$i]['title'] . "<br />"; //вытаскиваем текс новости с сайта //$aqrrOfNews[$i]['plainText'] = grabbNewsToBD($aqrrOfNews[$i]['link']); $t = grabbNewsToBD($aqrrOfNews[$i]['link'], $aqrrOfNews[$i]['fromN']); $aqrrOfNews[$i]['plainText'] = $t['plaintext']; $aqrrOfNews[$i]['innertext'] = $t['innertext']; $aqrrOfNews[$i]['title'] = mysql_real_escape_string($aqrrOfNews[$i]['title']); $aqrrOfNews[$i]['link'] = mysql_real_escape_string($aqrrOfNews[$i]['link']); $aqrrOfNews[$i]['pubDate'] = mysql_real_escape_string($aqrrOfNews[$i]['pubDate']); $aqrrOfNews[$i]['img'] = mysql_real_escape_string($aqrrOfNews[$i]['img']); $aqrrOfNews[$i]['description'] = mysql_real_escape_string($aqrrOfNews[$i]['description']); $aqrrOfNews[$i]['plainText'] = mysql_real_escape_string($aqrrOfNews[$i]['plainText']); $aqrrOfNews[$i]['innertext'] = mysql_real_escape_string($aqrrOfNews[$i]['innertext']); $query = "INSERT INTO {$db_news}.News_foreign (title,fromN,link,description,pubDate,img,plainText,tegText,speech) VALUES ('" . $aqrrOfNews[$i]['title'] . "','" . $aqrrOfNews[$i]['fromN'] . "','" . $aqrrOfNews[$i]['link'] . "','" . $aqrrOfNews[$i]['description'] . "','" . $aqrrOfNews[$i]['pubDate'] . "','" . $aqrrOfNews[$i]['img'] . "','" . $aqrrOfNews[$i]['plainText'] . "','" . $aqrrOfNews[$i]['innertext'] . "','')"; //echo $query; $result = mysql_query($query); //} } if ($new == 0) {