<?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';
<?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/';
<?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++) {