Пример #1
0
<?php

header("Content-type: text/html; charset=utf-8");
$connect = mysqli_connect("localhost", "root", "root") or die("链接数据库失败!");
mysqli_select_db($connect, "me_media") or die(mysqli_errno($connect));
mysqli_query($connect, "SET NAMES 'utf8'");
$sg = new sogouwx();
$information = $sg->get_baijia();
// foreach ($information as $key) {
//     $q = mysqli_query($connect,"SELECT `id` FROM `information` WHERE `name`='{$key['name']}' LIMIT 1");
//     if(!mysqli_fetch_row($q)){
//         mysqli_query($connect,"INSERT INTO `information` (`name`,`baijia_num`,`baidu_num`) VALUES('{$key['name']}','{$key['baijia']}','{$key['baidu_num']}')");
//     }
// }
// echo "<pre>";
// print_r($information);
// echo "</pre>";
for ($i = 0; $i < count($information); $i++) {
    $q = mysqli_query($connect, "SELECT * FROM `information` WHERE `name`='{$information[$i]['name']}' LIMIT 1");
    $row = mysqli_fetch_array($q);
    if (!$row) {
        mysqli_query($connect, "INSERT INTO `information` (`name`,`baijia_num`,`baidu_num`) VALUES('{$information[$i]['name']}','{$information[$i]['baijia']}','{$information[$i]['baidu_num']}')");
    } else {
        mysqli_query($connect, "UPDATE `information` set `baidu_pnum`='{$row['baidu_num']}',`baijia_pnum`='{$row['baijia_num']}' where `name`='{$information[$i]['name']}'");
        mysqli_query($connect, "UPDATE `information` set `baidu_num`='{$information[$i]['baidu_num']}',`baijia_num`='{$information[$i]['baijia']}' where `name`='{$information[$i]['name']}'");
    }
}
class sogouwx
{
    private $userAgent = 'Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Firefox/31.0';
    private $baijiaURL = 'http://baijia.baidu.com/?tn=listauthor';
Пример #2
0
<?php

require 'comon.php';
require_once 'Snoopy.class.php';
$sg = new sogouwx();
for (;;) {
    $time = date("Hi");
    $sql = mysqli_query($connect, "SELECT * FROM `wx_pinfo` WHERE `updates`=1 AND `ntime`<={$time};");
    while ($row = mysqli_fetch_assoc($sql)) {
        if ($row) {
            if ($row['ntime'] > 2400) {
                $ntime = 0 + $row['numbers'] * 100;
            } else {
                $ntime = $row['ntime'] + $row['numbers'] * 100;
            }
            $newsql = mysqli_query($connect, "SELECT `wzurl` FROM `wx_article` WHERE `uid`='{$row['id']}' order by `ctime` desc;");
            $newrow = mysqli_fetch_row($newsql);
            $openid = $sg->get_openid($row['gname'], $row['gnumber']);
            $articles = $sg->list_article($openid, $newrow[0]);
            for ($i = 0; $i < count($articles); $i++) {
                mysqli_query($connect, "INSERT INTO `wx_article` (`uid`,`wzurl`,`imgurl`,`wztitle`,`description`,`ctime`,`gtime`,`numbers`,`days`,`uctime`,`ntime`) VALUES('{$row['id']}','{$articles[$i]['url']}','{$articles[$i]['imgurl']}','{$articles[$i]['title']}','{$articles[$i]['description']}','{$articles[$i]['ctime']}','{$row['gtime']}','{$row['numbers']}','{$row['days']}','" . time() . "','{$row['gtime']}')");
            }
            mysqli_query($connect, "UPDATE `wx_reads`.`wx_pinfo` SET `ntime`='{$ntime}' WHERE (`id`='{$row['id']}');");
        }
    }
    sleep(1);
}
class sogouwx
{
    private $userAgent = 'Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Firefox/31.0';
    private $UserURL = 'http://weixin.sogou.com/';
Пример #3
0
<?php

header("Content-type: text/html; charset=utf-8");
require_once 'Snoopy.class.php';
require_once 'comon.php';
?>
<form method="GET" action="getinfo.php">
    微信名:<input type=text name='name' value='头条新闻' />
    微信号:<input type=text name='weixin' value='newsxinwen' />
    账号类型:<input type=text name='type' value='新闻' />
    <input type=hidden name="level" value="first" />
    <input type=submit name='submit' value='搜索' />
</form>
<?php 
if ($_GET['level'] == "first") {
    $sg = new sogouwx();
    $wxname = trim($_GET['name']);
    $weixin = trim($_GET['weixin']);
    $type = trim($_GET['type']);
    $sql = mysqli_query($connect, "SELECT * FROM `wx_pinfo` WHERE `gnumber`='{$weixin}';");
    $row = mysqli_fetch_array($sql);
    if ($row) {
        echo "该公众号已经收录,文章会定期更新.";
    } else {
        $openid = $sg->get_openid($wxname, $weixin);
        if (!$openid) {
            die("没有找到微信号,请使用搜狗搜索微信公众号确认微信号是否正确.");
        }
        $articles = $sg->list_article($openid);
        mysqli_query($connect, "INSERT INTO `wx_pinfo` (`gname`,`gnumber`,`tid`) VALUES('{$wxname}','{$weixin}','{$type}')");
        for ($i = 0; $i < count($articles); $i++) {