$header[] = "Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";
$header[] = "Accept-Language: zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3";
//$header[] = "Accept-Encoding: gzip, deflate";
$header[] = "Cookie:_qqq_uuid_=ZTgyMGRjYWY4Mzc0MzNhY2QyNzMwZTZlMzhiODEwNTYwZDYzMTBhNg==|1446285620|252f0fb776fe7e6b89d7f74e45fe83ff1f277107; bdfmapping=1446285648; Hm_lvt_2670efbdd59c7e3ed3749b458cafaa37=1446285671";
$header[] = "Connection: keep-alive";
curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
curl_setopt($curl, CURLOPT_URL, $url);
//设置请求地址
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
//是否输出 1 or true 是不输出 0 or false输出
$html = curl_exec($curl);
//执行curl操作
curl_close($curl);
//echo $html;
#w将获取的结果，通过phpquery ,生成一个对象。
phpquery::newDocumentHTML($html, 'utf-8');
//echo pq("title")->html();
#获取段子内容
#这需要改进。
#获取段子列表。最外面那个。
$articles = pq(".article");
#id位于id属性中，
#存储数据.二维数组。每一个数组代表一个段子。
$datas = array();
$sql = "INSERT INTO `qsbk`(`id`, `content`, `addtime`, `code`) VALUES ";
foreach ($articles as $article) {
$data = array();
#获取段子的唯一code
$data['code'] = pq($article)->attr("id");
#获取段子的内容
$data['content'] = pq($article)->find(".content")->text();
function add_qsbk()
{
if (isset($_GET['add_qsbk']) && $_GET['add_qsbk'] == 1) {
$url = "http://www.qiushibaike.com/textnew";
$curl = curl_init();
//开启curl
$header[] = "Host:www.qiushibaike.com";
$header[] = "User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64; rv:41.0) Gecko/20100101 Firefox/41.0";
$header[] = "Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";
$header[] = "Accept-Language: zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3";
//$header[] = "Accept-Encoding: gzip, deflate";
$header[] = "Cookie:_qqq_uuid_=ZTgyMGRjYWY4Mzc0MzNhY2QyNzMwZTZlMzhiODEwNTYwZDYzMTBhNg==|1446285620|252f0fb776fe7e6b89d7f74e45fe83ff1f277107; bdfmapping=1446285648; Hm_lvt_2670efbdd59c7e3ed3749b458cafaa37=1446285671";
$header[] = "Connection: keep-alive";
curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
curl_setopt($curl, CURLOPT_URL, $url);
//设置请求地址
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
//是否输出 1 or true 是不输出 0 or false输出
$html = curl_exec($curl);
//执行curl操作
curl_close($curl);
$rs = phpquery::newDocumentHTML($html, 'utf-8');
#获取段子列表。最外面那个。
$articles = pq(".article");
#id位于id属性中，
#存储数据.二维数组。每一个数组代表一个段子。
$datas = array();
$sql = "INSERT INTO `wp_weibo`(`id`, `content`, `addtime`) VALUES ";
foreach ($articles as $article) {
// var_dump($article);
$data = array();
#获取段子的唯一code
// $data['code'] = pq($article)->attr("id");
#获取段子的内容
$data['content'] = pq($article)->find(".content")->text();
$data['content'] .= "(来自糗事百科)";
// echo $data['code'];
// echo $data['content'];
// echo "<br>";
#添加到数组中去
$datas[] = $data;
$time = time();
$sql .= "(null,'" . $data['content'] . "',{$time})";
$sql .= ",";
}
#截取最后一个,
$sql = trim($sql, ',');
global $wpdb;
// echo $sql;
echo $wpdb->query($sql);
// echo 222;
die;
/*$content = "";
//存储手机号码
$data = array(
'content'=>$content,
'addtime'=>time()
);
#执行数据库插入操作。
#先查询一次，如果内容存在，且是今天。
$rs1 = $wpdb->get_results("select content from wp_weibo where content like '%糗事百科%'");
if($rs1){
}else{
$rs = $wpdb->insert( 'wp_weibo', $data);
}*/
} else {
return;
}
}
