function insert_database($products, $model, $name, $shundian_price, $con) { // 查看tb_product表中已有的商品数据nid $sql = "SELECT nid FROM `tb_product`"; $retval = mysql_query($sql, $con); if (!$retval) { die("Could not connect: " . mysql_error() . " on line " . __LINE__ . "<br>\n\r"); } $product_ids = []; while ($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { $product_ids[] = $row['nid']; } // print_r($product_ids); $data_string = ''; foreach ($products as $item) { if (!in_array($item->nid, $product_ids)) { $item->shopLink = 'https:' . $item->shopLink; $item->detail_url = 'https:' . $item->detail_url; $rate = get_rateinfo($item->shopLink, $item->detail_url); // print_r($rate); // echo "\n\r";die(); // $des = $rate[1][0]; // $des_com_aver = $rate[2][0]; // // // $attitude = $rate[3][0]; // $attitude_com_aver = $rate[4][0]; // // $quatity = $rate[5][0]; // $quatity_com_aver = $rate[6][0]; $des = $rate[1][0]; $des_com_aver = $item->shopcard->description[2] / 100.0; $des_com_aver .= '%'; if ($item->shopcard->description[1]) { $des_com_aver = '高于 ' . $des_com_aver; } else { $des_com_aver = '低于 ' . $des_com_aver; } $attitude = $rate[2][0]; $attitude_com_aver = $item->shopcard->service[2] / 100.0; $attitude_com_aver .= '%'; if ($item->shopcard->service[1] > 0) { $attitude_com_aver = '高于 ' . $attitude_com_aver; } else { $attitude_com_aver = '低于 ' . $attitude_com_aver; } $quatity = $rate[3][0]; $quatity_com_aver = $item->shopcard->delivery[2] / 100.0; $quatity_com_aver .= '%'; if ($item->shopcard->delivery[1]) { $quatity_com_aver = '高于 ' . $quatity_com_aver; } else { $quatity_com_aver = '低于 ' . $quatity_com_aver; } $credit = $item->shopcard->sellerCredit; $view_sales = intval($item->view_sales); if (!empty($item->comment_count)) { $comment_count = $item->comment_count; } else { $comment_count = 0; } // 拼接product数据 $data_string .= "(NULL, '{$item->nid}', '{$item->category}', '{$model}', '{$name}', '{$shundian_price}', '{$item->nick}', '{$item->view_price}', '{$view_sales}', '{$comment_count}', '0', '{$credit}', '{$des}', '{$des_com_aver}', '{$attitude}', '{$attitude_com_aver}', '{$quatity}', '{$quatity_com_aver}', '1', '{$item->shopLink}'),"; } } // echo '<br><br>' . $data_string;//die(); //4294967295 // 如果有数据则插入到数据库中tb_product表 if ($data_string) { // 去掉最后位置的, $data_string = substr($data_string, 0, -1); $sql = "INSERT INTO `tb_product` (`id`, `nid`, `category`, `model`, `name`, `shundian_price`, `merchant_name`, `merchant_price`, `view_sales`, `reviews_count`, `is_coalition`, `credit`, `des`, `des_com_aver`, `attitude`, `attitude_com_aver`, `quatity`, `quatity_com_aver`, `good`, `shop_link`) VALUES {$data_string}"; // echo "<br>\n\r" . $sql."<br>\n\r"; $retval = mysql_query($sql, $con); if (!$retval) { // 插入出错的数据status设置为0 $sql = "UPDATE `tb_product_list` SET `status` = '0' WHERE `model` = '{$model}'and `name` = '{$name}'"; $retval = mysql_query($sql, $con); if (!$retval) { print_r('Could not connect: ' . mysql_error() . " on line " . __LINE__ . "<br>\n\r"); } die('Could not enter data: ' . mysql_error() . " on line " . __LINE__ . "<br>\n\r"); } echo "Enter data successfully.<br>"; } }
<?php /** * Created by PhpStorm. * User: TopSage * Date: 2015/12/11 * Time: 11:25 */ $url = "https://store.taobao.com/shop/view_shop.htm?user_number_id=1134618424"; $ref = "https://detail.tmall.com/item.htm?id=43160516597&ad_id=&am_id=&cm_id=140105335569ed55e27b&pm_id=&_u=b88mh8r71af&abbucket=5"; $rate = get_rateinfo($url, $ref); print_r($rate); echo $rate[2][0]; /** * 返回描述相符、服务态度、物流服务分数 */ function get_rateinfo($shopLink, $referer) { $ch = curl_init(); // 设置浏览器的特定header curl_setopt($ch, CURLOPT_HTTPHEADER, array("Connection: keep-alive", "Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "Upgrade-Insecure-Requests: 1", "DNT:1", "Accept-Language: zh-CN,zh;q=0.8,en-GB;q=0.6,en;q=0.4,en-US;q=0.2", "Cookie:cna=ecujDgxJEU8CAdrwlTLMuyK+; thw=cn; miid=7140089985405878683; _m_user_unitinfo_=center; uc2=wuf=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DyuLwEC5VzXl67TX71pM-Pt5ijrzvVp76FosboF3-bRXW_TIMHJDVmk32CWs6e7ra1SuZudckIhHttgRUS5bN_0MaK1Kv-zHpfr0mjFVBPh-Crtxj19HCnfLT8x4uC3p5%26wd%3D%26eqid%3Db1f8688b001197fa000000035668de3b; uc3=nk2=AmkbKafOx9I%3D&id2=UU8PbnneKzSx&vt3=F8dAScPiH8lvv%2FHL%2BUQ%3D&lg2=UIHiLt3xD8xYTw%3D%3D; lgc=axianzia; tracknick=axianzia; mt=np=&ci=3_1; _cc_=U%2BGCWk%2F7og%3D%3D; tg=0; v=0; uc1=cookie14=UoWzUGNqTOEvsA%3D%3D; cookie2=1ced5c4d4b6a7b1add0410eb06484e62; t=441f8ce4777a72bb7ea38953b39d0d4c; swfstore=120797; linezing_session=hMm9a7tS3qYHsL73Sj1tw2F3_1449797234940pw2h_2; _tb_token_=e335ee7876383; _m_h5_tk=aba0e734db020aa34adfd0514ecfd3c6_1449808809939; _m_h5_tk_enc=6c30d6dfe9563ec6b0df80acad26be4f; x=e%3D1%26p%3D*%26s%3D0%26c%3D0%26f%3D0%26g%3D0%26t%3D0%26__ll%3D-1%26_ato%3D0; l=AhgYtVan25wZHmxPB3HCKeCpaEiqAXyL; isg=E58CA9133C4A05BE6936C3EA5438AFC6")); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36'); // 在HTTP请求头中"Referer: "的内容。 curl_setopt($ch, CURLOPT_REFERER, "https:{$referer}"); curl_setopt($ch, CURLOPT_ENCODING, "gzip, deflate, sdch"); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_URL, $shopLink); curl_setopt($ch, CURLOPT_TIMEOUT, 120); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //302redirect curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);