Example #1
0
 //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) {
Example #2
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) {