Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(E_ALL | E_STRICT);
- ini_set('display_errors', 'On');
- require_once 'simple_html_dom.php'; // библиотека для парсинга
- require_once 'safemysql.class.php';
- require($_SERVER['DOCUMENT_ROOT'].'/wp-load.php');
- $host="localhost";/*Имя сервера*/
- $user="mihanspk_test9";/*Имя пользователя*/
- $password="qwerty3412";/*Пароль пользователя*/
- $db="mihanspk_test9";/*Имя базы данных*/
- mysql_connect($host, $user, $password); /*Подключение к серверу*/
- mysql_select_db($db) or die("Нет соединения с БД".mysql_error());
- $file = 'ssilki.txt';
- // Открываем файл для получения существующего содержимого
- $current = file_get_contents($file);
- ?>
- <form action="" class="" method="post">
- <textarea name="text_url" style="width:50%; height:400px;"><?=$current;?></textarea><br/>
- <input type="submit" value="pars!"/>
- </form>
- <?php
- if(isset($_POST['text_url']))
- {
- $zapros_full=$_POST['text_url'];
- $zapross = explode("\r\n", $_POST['text_url']);
- $current = $zapros_full;
- // Пишем содержимое обратно в файл
- file_put_contents($file, $current);
- foreach($zapross as $zapross_iteam)
- {
- echo "<h2>";
- echo $zapross_iteam;
- echo "</h2>";
- $html = file_get_html($zapross_iteam);
- if($html->find('table.building-pages', 0))
- {
- echo "<h2>SALE</h2>";
- foreach ($html->find('table.building-pages', 0)->find('tbody tr') as $Sales)
- {
- $address=$Sales->find('.address a', 0)->plaintext;
- $price=$Sales->find('.price', 0)->plaintext;
- $Beds=$Sales->find('td', 2)->plaintext;
- $Baths=$Sales->find('td', 3)->plaintext;
- $ft=$Sales->find('td', 4)->plaintext;
- if($address)
- {
- $result2 = "INSERT INTO Sales(address,price,Beds,Baths,ft,page) VALUES ('$address','$price','$Beds','$Baths','$ft','$zapross_iteam')";
- mysql_query($result2);
- echo $address; echo $price; echo $Beds; echo $address; echo $Baths; echo $ft; echo "<br/>";
- }
- }
- }
- if($html->find('table.building-pages', 1))
- {
- echo "<h2>RENTAL</h2>";
- foreach ($html->find('table.building-pages', 1)->find('tbody tr') as $Sales)
- {
- $address=$Sales->find('.address a', 0)->plaintext;
- $price=$Sales->find('.price', 0)->plaintext;
- $Beds=$Sales->find('td', 2)->plaintext;
- $Baths=$Sales->find('td', 3)->plaintext;
- $ft=$Sales->find('td', 4)->plaintext;
- if($address){
- $result2 = "INSERT INTO Rentals(address,price,Beds,Baths,ft,page) VALUES ('$address','$price','$Beds','$Baths','$ft','$zapross_iteam')";
- mysql_query($result2);
- echo $address; echo $price; echo $Beds; echo $address; echo $Baths; echo $ft; echo "<br/>";
- }
- }
- }
- $html->clear();
- unset($html);
- sleep(rand(1,3)); //Ну вдруг и правда бан
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement