Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $title = 'Парсер URL последних постов в группе';
- /* */
- include_once DIR.'/template/header.php';
- // Доступ к БД
- $host = 'localhost';
- $db = 'ыфваыфваыфавыфваыфав'; // имя базы
- $charset = 'utf8';
- $user = 'фываыфваыфва'; // имя юзера
- $pass = 'фыавфывафываыф'; // пароль юзера
- // Подключение к БД PDO
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = array(
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
- );
- try {
- $pdo = new PDO($dsn, $user, $pass, $opt);
- }
- catch( PDOException $Exception ) {
- //echo $Exception->getMessage();
- //echo $Exception->getCode();
- if(!empty($Exception->getCode())){
- die('Ошибка соединения с БД');
- }
- }
- $st = $pdo->prepare(' SELECT COUNT(*) FROM `title` ');
- $st->execute();
- $WaitIndex = $st->fetchAll();
- //echo "<pre>РЕЗ "; var_dump($WaitIndex); echo "</pre>";
- if(isset($_POST['add'])) {
- $text = trim($_POST['text']);
- $zam = str_replace("\n", "~", $text);
- $zam = preg_replace('/\~[^а-яёa-z0-9~]{1,}\~/ism', '~~', $zam);
- $firstBlock = preg_split('/[=]{3,}/', $zam, -1, PREG_SPLIT_NO_EMPTY);
- // Цикл статей по =================
- for ($i = 0; $i < count($firstBlock); $i++) {
- $txt = trim($firstBlock[$i]);
- $zed = explode('~~', $txt);
- if($i === 0){
- $add = 1;
- $LastId = 0;
- }
- if($add === 1 && strlen($zed[0] < 320)){
- $header = trim($zed[0]);
- $b=$pdo->prepare(" INSERT INTO `title` SET `header`=:header");
- $b->bindParam(":header",$header);
- $b->execute();
- $AddId = $pdo->lastInsertId();
- $LastId = $AddId;
- echo "LastId = $LastId<br>";
- unset($zed[0]);
- $add = 0;
- }
- $chunk = array_chunk($zed, 2);
- // Цикл внутри одной статьи по её частям
- for ($j = 0; $j < count($chunk); $j++) {
- $subheader = trim($chunk[$j][0]);
- $subtxt = trim($chunk[$j][1]);
- $long = strlen($chunk[$j][1]);
- if($LastId !== 0){
- $b=$pdo->prepare(" INSERT INTO `block` SET `tid`=:tid, `strlen`=:strlen, `subhead`=:subhead, `text`=:text ");
- $b->bindParam(":tid",$LastId);
- $b->bindParam(":strlen",$long);
- $b->bindParam(":subhead",$subheader);
- $b->bindParam(":text",$subtxt);
- $b->execute();
- }
- }
- //echo "<pre>ЧАНК "; var_dump($chunk); echo "</pre>";
- //echo "<pre>ZED "; var_dump($zed); echo "</pre>";
- //echo "<pre>ЧАСТЬ2 "; var_dump($v2); echo "</pre>";
- }
- //echo "<pre>"; var_dump($zam); echo "</pre>";
- }
- ?>
- <form action="" method="POST">
- <!--
- Сколько последних постов из группы парсить:<br>
- <input type="number" name="numpost" placeholder="3" size="3" class="form-control tools_form"><br> -->
- <br>
- <textarea name="text" cols="50" rows="10" class="form-control tools_form"></textarea><br>
- <button type="submit" name="add" class="btn btn-success">Добавить</button>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement