<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[code_carrier的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/code_carrier</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; code_carrier]]></copyright><item><title><![CDATA[删除数据表中重复数据]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/114870945</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/114870945</guid><author>code_carrier</author><pubDate>Tue, 16 Mar 2021 11:00:41 +0800</pubDate><description><![CDATA[前提条件： 表 cor_users , 关键字段 id username

现在的情况是： 表中已有几千条数据，由于一开始没注意username 不能重复，导致表中有好多重名(username)数据；

需求： 需要剔除重名的数据，重名数据需要保留一条（保留id最小的）

一般写法：

delete from cor_users where username in (
   select username from cor_users group by username having count...]]></description><category></category></item><item><title><![CDATA[支付宝tp5对接(2)]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/82964492</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/82964492</guid><author>code_carrier</author><pubDate>Mon, 08 Oct 2018 10:26:40 +0800</pubDate><description><![CDATA[
&amp;lt;?php
namespace alipay;
import('alipay/service/AlipayTradeService',PRO_PATH.'/application/extend/');
class Webpay
{
    public function pagepay($conf,$arr)
    {
        //支付宝提交（付款）
        import...]]></description><category></category></item><item><title><![CDATA[支付宝tp5对接(1)]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/82964162</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/82964162</guid><author>code_carrier</author><pubDate>Mon, 08 Oct 2018 10:24:49 +0800</pubDate><description><![CDATA[1.  https://openhome.alipay.com/platform/appDaily.htm?tab=info

进入沙箱应用，获取对应的appid,网关，设置好rsa2秘钥(应用公钥、支付宝公钥)，使用安卓系统的手机扫描下载测试的支付宝app;

2.选中对应的功能应用（我目前做的是电脑网站支付），下载好对应的demo代码包，解压好放在tp5 的extend目录下；

  结构如图...]]></description><category></category></item><item><title><![CDATA[php 字符集编码判断错误问题]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/82053083</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/82053083</guid><author>code_carrier</author><pubDate>Sat, 25 Aug 2018 17:05:59 +0800</pubDate><description><![CDATA[错误情况：我的电脑上php环境是自己配置的，另外一台电脑上php环境是wamp集成的,

通过 mb_internal_encoding();  获取内部字符编码，我的是 utf-8,

另外一台的是 ISO-8859-1 ;

所以出现我传的中文，计算长度时是1，另外一台是3；

解决方法有2种：

1. 在php.ini 里面配置   mbstring.internal_encoding =&quot;...]]></description><category></category></item><item><title><![CDATA[html中包含另一个html的方法]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/81556761</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/81556761</guid><author>code_carrier</author><pubDate>Fri, 10 Aug 2018 08:41:07 +0800</pubDate><description><![CDATA[其中第1种是我常用，其他的方法还未测试

下面代码是page.html里面的，page1和page2和page.html同级

1：

   &amp;lt;div id=&quot;page1&quot;&amp;gt;&amp;lt;/div&amp;gt;
    &amp;lt;div id=&quot;page2&quot;&amp;gt;&amp;lt;/div&amp;gt;
    &amp;lt;script&amp;gt;
          $(&quot;#page1&quot;).]]></description><category></category></item><item><title><![CDATA[php 使用文件函数生成静态html（不使用框架模板标签1）]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/81181653</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/81181653</guid><author>code_carrier</author><pubDate>Fri, 03 Aug 2018 11:40:56 +0800</pubDate><description><![CDATA[思路：

1. 创建一个函数create_fileinfo($classify)，可以生成所有的列表和详请页面需要用到的数据（比如形成有规律的链接参数）

2. 创建一个函数create_list_html($str)，可以生成静态的列表页面

3.创建一个函数create_descript_html($str)，可以生成静态的详请页面

4. 创建一个函数chtml($type,$str=&quot;&quot;)...]]></description><category></category></item><item><title><![CDATA[tp5自定义模板标签--无限极分类菜单（1）]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/81383738</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/81383738</guid><author>code_carrier</author><pubDate>Fri, 03 Aug 2018 11:10:36 +0800</pubDate><description><![CDATA[思路（这个属于伪模板标签，将就着用吧）：

1.自己先创建一个模板库


&amp;lt;?php
namespace app\common;
use think\template\TagLib;
use think\Db;
class DefindTab extends TagLib
{
   protected $tags = [
        // 标签定义： attr 属性列表 close 是否...]]></description><category></category></item><item><title><![CDATA[输出错误小结]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80846957</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80846957</guid><author>code_carrier</author><pubDate>Thu, 28 Jun 2018 18:03:38 +0800</pubDate><description><![CDATA[$content 1= &quot;亲爱的$username ：&amp;lt;br/&amp;gt;感谢您在我站注册了新帐号。&amp;lt;br/&amp;gt;请点击链接激活您的帐号。&amp;lt;br/&amp;gt;&quot;;$content2 = &quot;亲爱的$username   ：&amp;lt;br/&amp;gt;感谢您在我站注册了新帐号。&amp;lt;br/&amp;gt;请点击链接激活您的帐号。&amp;lt;br/&amp;gt;&quot;;$content 3= ]]></description><category></category></item><item><title><![CDATA[三元简洁写法和json_decode （php）]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80804260</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80804260</guid><author>code_carrier</author><pubDate>Mon, 25 Jun 2018 17:23:49 +0800</pubDate><description><![CDATA[return $re ? : ’error’;   (为真返回本身，假返回error)$str='{&quot;errcode&quot;:40164,&quot;errmsg&quot;:&quot;invalid ip 14.155.223.111, not in whitelist hint: [fc4_rA06231512]&quot;}';dump(json_decode($str,ture));array(2) {
  [&quot;errcode&quot;] ...]]></description><category></category></item><item><title><![CDATA[thinkphp里面的display 不会重定向]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80690794</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80690794</guid><author>code_carrier</author><pubDate>Thu, 14 Jun 2018 11:55:03 +0800</pubDate><description><![CDATA[在form表单提交页面的时候（既要显示，又可以修改提交） public function personInfo(){        $user=M(&quot;UserInfo&quot;);        if(empty($_POST)){                $list=$user-&amp;gt;where(array('uid'=&amp;gt;$_SESSION['uid']))-&amp;gt;find();    ...]]></description><category></category></item><item><title><![CDATA[mysql==》查看表字段信息的4种方法]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80668852</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80668852</guid><author>code_carrier</author><pubDate>Tue, 12 Jun 2018 17:50:58 +0800</pubDate><description><![CDATA[$re=mysql_query(&quot;show create table tp_wxtoken&quot;,$conn);  while ($row = mysql_fetch_assoc($re)) {       $arr[]=$row; }dump($arr);array(1) {
  [0] =&amp;gt; array(2) {
    [&quot;Table&quot;] =&amp;gt; string(10) &quot;tp_wxto...]]></description><category></category></item><item><title><![CDATA[tp框架获取token和票据（不使用数据库）]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80624402</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80624402</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 16:05:11 +0800</pubDate><description><![CDATA[function token_ticket($ticket=''){    $info=file('Upload/token_ticket_cache.txt');    $arr=explode('=&amp;gt;',$info[0]);//'token=&amp;gt;ticket=&amp;gt;time'    if(time() &amp;gt; (int)$arr[2]){        $token_url = ...]]></description><category></category></item><item><title><![CDATA[tp框架获取票据（基于‘’tp框架下获取AccessToken‘’）]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80624362</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80624362</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 15:58:30 +0800</pubDate><description><![CDATA[// 获取JSSDK票据function getJsApiTicket(){    $info = M('WxToken')-&amp;gt;find(1);    if ($info['ticket_time'] &amp;lt; time()) {        $token=getAccessToken();        if($token==='error') return 'error';      ...]]></description><category></category></item><item><title><![CDATA[tp框架下获取AccessToken]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80624189</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80624189</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 15:46:38 +0800</pubDate><description><![CDATA[DROP TABLE IF EXISTS `tp_wx_token`;CREATE TABLE `tp_wx_token` (  `id` int(4) NOT NULL AUTO_INCREMENT,  `appid` varchar(100) DEFAULT NULL,  `secret` varchar(100) DEFAULT NULL,  `access_token` varchar(5...]]></description><category></category></item><item><title><![CDATA[判断是否为微信端和安卓端]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80623886</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80623886</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 15:30:37 +0800</pubDate><description><![CDATA[function is_weixin() {         if (strpos($_SERVER['HTTP_USER_AGENT'], 'MicroMessenger') !== false)   return true;         else return false;     }function is_Android() {         if (strpos($_SERVER['...]]></description><category></category></item><item><title><![CDATA[在tp框架下，使用iframe框架时，退出跳转的写法]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80622029</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80622029</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 15:24:55 +0800</pubDate><description><![CDATA[    1.这是iframe 框架&amp;lt;\frameset rows=&quot;50px,*,50px&quot; frameborder=&quot;1&quot; border=&quot;0&quot; noresize=&quot;noresize&quot;&amp;gt;  &amp;lt;\frame name=&quot;top&quot; src=&quot;{:U('User/top')}&quot;/&amp;gt;  &amp;lt;\frameset cols=&amp]]></description><category></category></item><item><title><![CDATA[tp框架下单表/多表搜索分页功能]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80583182</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80583182</guid><author>code_carrier</author><pubDate>Fri, 08 Jun 2018 15:20:34 +0800</pubDate><description><![CDATA[$.ajax({            url: &quot;{:U('Index/checkpage')}&quot;,type: 'post',dataType: 'json',            data: {'keyword':&quot;&quot;,'page_now':2,&quot;page_number&quot;:5},            success: function (d) {                consol...]]></description><category></category></item><item><title><![CDATA[当客户端的时间和服务器的时间相差太多会出现404错误]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80599197</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80599197</guid><author>code_carrier</author><pubDate>Wed, 06 Jun 2018 18:29:39 +0800</pubDate><description><![CDATA[出错情况是：  我的本机时间是12：30分； 但是北京时间是10：30分；我在本地测试本地的代码，在注册账户验证短信的时候（使用阿里大于），出现了404错误，解决办法：前台传时间给后台对比if(empty($nowtime)||abs(time()-$nowtime)&amp;gt;30*60) $this-&amp;gt;ajaxReturn(['status'=&amp;gt;'error','msg'=&amp;gt;&quot;时...]]></description><category></category></item><item><title><![CDATA[（tp）页面跳转参数值为具体地址时，需要替换‘/’才能正常传]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80599117</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80599117</guid><author>code_carrier</author><pubDate>Wed, 06 Jun 2018 18:21:50 +0800</pubDate><description><![CDATA[例如这样的路径： http://www.abcd.com/upload/user/dhfjs3434fe.jpg；$this-&amp;gt;redirect('Index/wxBind',array('bind'=&amp;gt;'no','openid'=&amp;gt;$obj-&amp;gt;openid,'headimg'=&amp;gt;str_replace('/','[]',$userobj-&amp;gt;headimgurl...]]></description><category></category></item><item><title><![CDATA[tp框架中ajax里面写多个php变量有问题]]></title><link>https://blog.youkuaiyun.com/code_carrier/article/details/80599063</link><guid>https://blog.youkuaiyun.com/code_carrier/article/details/80599063</guid><author>code_carrier</author><pubDate>Wed, 06 Jun 2018 18:15:28 +0800</pubDate><description><![CDATA[$.ajax({ url: &quot;{:U('Index/wxBinding')}&quot;, type: 'post',dataType: 'json', data: {'tel':tel,'password':password,'openid':&quot;{$openid}&quot;,'headimg':&quot;{$headimg}&quot;}, success: function (d) { if (d.status ==='yes'...]]></description><category></category></item></channel></rss>