<?php
$localObj = new Table("local");
$onlineObj = new Table("txonline");
$id = 358403;
while (1) {
echo $id, "\n";
$resultRs = $localObj->findAll("select * from tianyunzi.phome_ecms_keywords where id > '{$id}' order by id asc limit 100");
if (empty($resultRs)) {
exit("所有数据处理完毕\n");
}
foreach ($resultRs as $value) {
$id = $value["id"];
updateKeyword($value);
}
}
function updateKeyword($keywordArr)
{
global $onlineObj;
$keywordMysql = $onlineObj->findOne("select * from gckeyword.key_proword where keyword = '" . $keywordArr["title"] . "' limit 1");
if (empty($keywordMysql)) {
echo $keywordArr['title'] . " 不在当前词库中存在!\n";
return false;
}
//开始更新数据
$mainword = array_filter(explode("|", $keywordArr["mainword"]));
$mainword = getMysqlJson($mainword);
$f_word = array_filter(explode("|", $keywordArr["f_word"]));
if (empty($f_word)) {
$f_word = $keywordMysql["redword"];
} else {
$jihuaArr = $conn->findOne("select * from tianyunzi.baidu_jihua where name = '" . $jihua . "' limit 1");
if (empty($jihuaArr)) {
echo "============未知的计划" . $jihua . "==================\n";
continue;
}
$groupArr = $conn->findOne("select * from tianyunzi.baidu_group where groupname = '" . $group . "' limit 1");
if (empty($groupArr)) {
echo "==============未知的分组" . $group . "=================\n";
continue;
}
$keywordRs = $conn->findOne("select * from tianyunzi.baidu_keywords where keyword = '" . $keyword . "' and campaignId = '" . $jihuaArr["id"] . "' and adgroupId = '" . $groupArr["id"] . "' limit 1");
if (empty($keywordRs)) {
echo "=============未知的关键词" . $keyword . "==============\n";
continue;
}
updateKeyword($keywordRs["id"], $url);
}
function updateKeyword($keywordId, $url)
{
$data = array("header" => array("token" => "1f888ce6fb38730a14a6afe7437fc3b4", "username" => "郑州悉知", "password" => "GCWgcd7232275"), "body" => array("keywordTypes" => array()));
$data["body"]["keywordTypes"][] = array("keywordId" => $keywordId, "pcDestinationUrl" => $url);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://api.baidu.com/json/sms/service/KeywordService/updateWord");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));
//$data是每个接口的json字符串
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
//不加会报证书问题
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
//不加会报证书问题
while (1) {
$conn = new Table("local189");
$keywordArr = $conn->findAll("select * from tianyunzi.baidu_keywords where id > '{$id}' order by id asc limit 100");
if (empty($keywordArr)) {
echo "所有的关键词已经过完\n";
exit;
}
foreach ($keywordArr as $value) {
$id = $value["id"];
if (!strstr($value["pcDestinationUrl"], "gongchang.com")) {
continue;
}
if ($value["pcDestinationUrl"] == $value["newUrl"]) {
continue;
}
$res = updateKeyword($value["id"], $value["newUrl"]);
if ($res["header"]["desc"] == "success") {
echo $value["keyword"] . " 更新成功\n";
echo $value["newUrl"] . "\n";
} else {
echo "=======" . $value["keyword"] . " 更新失败=============\n";
}
}
$conn->close();
}
function getUrl($keywordArr)
{
$url = "http://product.gongchang.com/sp?wd=" . urlencode($keywordArr["keyword"]);
$url .= "#baidu&" . $keywordArr["campaignId"] . "&" . $keywordArr["adgroupId"] . "&" . $keywordArr["keywordId"];
return $url;
}
