{"id":921,"date":"2021-03-10T17:43:56","date_gmt":"2021-03-10T09:43:56","guid":{"rendered":"http:\/\/www.tra56.com\/?p=921"},"modified":"2021-03-10T17:43:56","modified_gmt":"2021-03-10T09:43:56","slug":"921","status":"publish","type":"post","link":"https:\/\/www.tra56.com\/921.html","title":{"rendered":"PHP\u4f7f\u7528redis\u5b9e\u73b0\u7edf\u8ba1\u7f13\u5b58mysql\u538b\u529b\u7684\u65b9\u6cd5"},"content":{"rendered":"<p>\u8fd9\u7bc7\u6587\u7ae0\u4e3b\u8981\u4ecb\u7ecd\u4e86PHP\u4f7f\u7528redis\u5b9e\u73b0\u7edf\u8ba1\u7f13\u5b58mysql\u538b\u529b\u7684\u65b9\u6cd5,\u6d89\u53caPHP\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u53ca\u4f7f\u7528Redis\u7edf\u8ba1\u7684\u76f8\u5173\u6280\u5de7<\/p>\n<pre class=\"brush:php;toolbar:false\">&lt;?php\r\n&nbsp;&nbsp;header(&quot;Content-Type:text\/html;charset=utf-8&quot;);\r\n&nbsp;&nbsp;include&nbsp;&#39;lib\/mysql.class.php&#39;;\r\n&nbsp;&nbsp;$mysql_obj&nbsp;=&nbsp;mysql::getConn();\r\n&nbsp;&nbsp;\/\/redis&nbsp;\r\n&nbsp;&nbsp;$redis&nbsp;=&nbsp;new&nbsp;Redis();\r\n&nbsp;&nbsp;$redis-&gt;pconnect(&#39;127.0.0.1&#39;,&nbsp;6379);\r\n&nbsp;&nbsp;if(isset($_SERVER[&#39;HTTP_REFERER&#39;])){\r\n&nbsp;&nbsp;&nbsp;&nbsp;$url_md5&nbsp;=&nbsp;md5($_SERVER[&#39;HTTP_REFERER&#39;]);\r\n&nbsp;&nbsp;}\r\n&nbsp;&nbsp;$adve_key&nbsp;=&nbsp;&#39;adve&#39;;&nbsp;\r\n&nbsp;&nbsp;$adve_key_exists&nbsp;=&nbsp;&#39;adve_exists&#39;;\r\n&nbsp;&nbsp;if(!$redis-&gt;exists($adve_key_exists)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;$list&nbsp;=&nbsp;$mysql_obj-&gt;fetch_array(&quot;select&nbsp;*&nbsp;from&nbsp;user_online_adve&quot;);\r\n&nbsp;&nbsp;&nbsp;&nbsp;if($list){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($list&nbsp;as&nbsp;$key&nbsp;=&gt;&nbsp;$value)&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$url_hash&nbsp;=&nbsp;md5($value[&#39;adve_url&#39;]);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$adve_hash_key&nbsp;=&nbsp;$adve_key.&quot;:&quot;.$url_hash;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$id&nbsp;=&nbsp;$value[&#39;id&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_hash_key,$id);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_key_exists,true);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/$redis-&gt;hmset($adve_hash_key,&nbsp;array(&#39;id&#39;&nbsp;=&gt;$id));\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/print_r($redis-&gt;get($adve_hash_key));\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;}\r\n&nbsp;&nbsp;$adve_new_key&nbsp;=&nbsp;$adve_key.&#39;:&#39;.$url_md5;\r\n&nbsp;&nbsp;if($redis-&gt;exists($adve_new_key)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$adve_plus&nbsp;=&nbsp;$adve_new_key.&quot;:plus&quot;&nbsp;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(!$redis-&gt;exists($adve_plus)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_plus,1);&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;incr($adve_plus);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$num&nbsp;=&nbsp;$redis-&gt;get($adve_plus);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($num&nbsp;&gt;10){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$id&nbsp;=&nbsp;$redis-&gt;get($adve_new_key);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/&nbsp;insert&nbsp;to&nbsp;sql;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$mysql_obj-&gt;query(&quot;update&nbsp;user_online_adve&nbsp;set&nbsp;adve_num=adve_num+$num&nbsp;where&nbsp;id=$id&quot;);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_plus,1);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;}\r\n&nbsp;&nbsp;header(&#39;HTTP\/1.0&nbsp;301&nbsp;Moved&nbsp;Permanently&#39;);\r\n&nbsp;&nbsp;header(&#39;Location:&nbsp;https:\/\/itunes.apple.com\/cn\/app\/san-guo-zhi15-ba-wangno-da-lu\/id694974270?mt=8&#39;);\r\n\/*\r\n&nbsp;&nbsp;if(){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$adve_plus&nbsp;=&nbsp;$adve_key.&quot;:plus&quot;&nbsp;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($redis-&gt;exists($adve_plus)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;incr($adve_plus);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_plus,1);&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;$redis-&gt;get($adve_plus);\r\n&nbsp;&nbsp;}\r\n&nbsp;&nbsp;foreach&nbsp;($list&nbsp;as&nbsp;$key&nbsp;=&gt;&nbsp;$value)&nbsp;{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$url_hash&nbsp;=&nbsp;md5($value[&#39;adve_url&#39;]);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$id&nbsp;=&nbsp;$value[&#39;id&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$adve_num&nbsp;=&nbsp;$value[&#39;adve_num&#39;];\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$adve_plus&nbsp;=&nbsp;$adve_key.&quot;:plus&quot;&nbsp;;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if($redis-&gt;exists($adve_plus)){\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;incr($adve_plus);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}else{\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$redis-&gt;set($adve_plus,1);&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;$redis-&gt;get($adve_plus);\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/if($redis-&gt;)\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/$redis-&gt;hmset($adve_key,&nbsp;array(&#39;id&#39;&nbsp;=&gt;$id,&nbsp;&#39;adve_num&#39;=&gt;$adve_num));\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\/\/print_r($redis-&gt;hmget(&quot;adve:$url_hash&quot;,&nbsp;array(&#39;adve_num&#39;)));\r\n&nbsp;&nbsp;}\r\n&nbsp;&nbsp;&nbsp;&nbsp;print_r($list);\r\n*\/<\/pre>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u7bc7\u6587\u7ae0\u4e3b\u8981\u4ecb\u7ecd\u4e86PHP\u4f7f\u7528redis\u5b9e\u73b0\u7edf\u8ba1\u7f13\u5b58mysql\u538b\u529b\u7684\u65b9\u6cd5,\u6d89\u53caPHP\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u53ca\u4f7f\u7528R [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[26,72,70],"class_list":["post-921","post","type-post","status-publish","format-standard","hentry","category-php","tag-php"],"_links":{"self":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/921"}],"collection":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/comments?post=921"}],"version-history":[{"count":1,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/921\/revisions"}],"predecessor-version":[{"id":922,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/921\/revisions\/922"}],"wp:attachment":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/media?parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/categories?post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/tags?post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}