<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[fb_fb的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/fb_fb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; fb_fb]]></copyright><item><title><![CDATA[andt design pro 5.0 react （ts） +ueditor富文本]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/127565174</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/127565174</guid><author>fb_fb</author><pubDate>Fri, 28 Oct 2022 09:56:44 +0800</pubDate><description><![CDATA[如果是前后端分离部署，图片请求地址修改。1 ueditor 文件夹放到 public文件下。3 项目头部里引入 js文件。ueditor文件下载地址。]]></description><category></category></item><item><title><![CDATA[Mysql引起索引失效的原因总结]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/113396236</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/113396236</guid><author>fb_fb</author><pubDate>Fri, 29 Jan 2021 16:47:29 +0800</pubDate><description><![CDATA[1、对单字段建了索引，where条件多字段。

2、建立联合索引，where条件单字段。与上面情况正好相反。（最左原则）

例如 索引 a.b.c。条件 ab，ac，a，都会生效，bc不会生效

3、对索引列运算，运算包括（+、-、*、/、！、&lt;&gt;、%、like'%_'（%放在前面）、or、in、exist等），导致索引失效。

4、类型错误，如字段类型为varchar，where条件用number。

5、对索引应用内部函数，这种情况下应该建立基于函数的索引。

6、查询表的效率要比应用索..]]></description><category></category></item><item><title><![CDATA[腾讯云 即时通讯IM 接口]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/109742969</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/109742969</guid><author>fb_fb</author><pubDate>Tue, 17 Nov 2020 14:57:16 +0800</pubDate><description><![CDATA[&lt;?php

namespace app\miniapi\controller;

use app\miniapi\service\TenImService;
use think\Request;

/**
* 腾讯云 即时通讯IM 接口
* Class Im
* @package app\miniapi\controller
*/
class Im extends Root
{
  protected $tenIm;

  public function __construct(Re...]]></description><category></category></item><item><title><![CDATA[mysql 递归查询函数，无限极 分裂]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/109742616</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/109742616</guid><author>fb_fb</author><pubDate>Tue, 17 Nov 2020 14:50:38 +0800</pubDate><description><![CDATA[DELIMITER $$
USE `yoshop_pro`$$ ##库名
DROP FUNCTION IF EXISTS `getParents`$$
CREATE DEFINER=`root`@`%` FUNCTION `getParents`(self_Id VARCHAR(40))
RETURNS VARCHAR(1000) CHARSET utf8 ##定义返回值类型 varchar(4000)
BEGIN          ##函数开始
  DECLARE s...]]></description><category></category></item><item><title><![CDATA[redis  list 秒杀]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/107956335</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/107956335</guid><author>fb_fb</author><pubDate>Wed, 12 Aug 2020 14:17:02 +0800</pubDate><description><![CDATA[&lt;?php

class Test {

    private static $instance = null;
    private static $conn=null;

    // 用单列模式 实例化Redis
    public static function Redis()
    {
        if (self::$instance == null) {
            $redis=new \Redis();
            $redis-&gt;conne]]></description><category></category></item><item><title><![CDATA[redis 命令集合]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/107952151</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/107952151</guid><author>fb_fb</author><pubDate>Wed, 12 Aug 2020 14:14:42 +0800</pubDate><description><![CDATA[字符串  string
set name 'fb' 设置一个Key 为name 值为 fb的一个字符串
get name 获得 key name的值
getrange name 0 -1        字符串分段
getset name new_cxx       设置值，返回旧值
mset key1 key2            批量设置
mget key1 key2            批量获取
setnx key value           不存在就插入（not exists）
setex k]]></description><category></category></item><item><title><![CDATA[杂货铺 获取用户ip 生成订单号  curl请求]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/107950486</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/107950486</guid><author>fb_fb</author><pubDate>Wed, 12 Aug 2020 10:36:29 +0800</pubDate><description><![CDATA[/**
* 获取用户ip
* @return string
/
function get_client_ip() {
$ip = SERVER[′REMOTEADDR′];if(isset(_SERVER['REMOTE_ADDR'];
    if (isset(S​ERVER[′REMOTEA​DDR′];if(isset(_SERVER[‘HTTP_CLIENT_IP’]) &amp;&amp; preg_match(’/^([0-9]{1,3}.){3}[0-9]{1,3}$/’, $_SERVER]]></description><category></category></item><item><title><![CDATA[PHP   按二维数组的某个键值排序]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/106054767</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/106054767</guid><author>fb_fb</author><pubDate>Wed, 29 Jul 2020 17:01:55 +0800</pubDate><description><![CDATA[array_keys($array) //返回所有键名 



array_values($array) //返回所有键值 



$result=array_reverse($input); //将数组颠倒，不保留键名 

$result_keyed=array_reverse($input,true); //将数组颠倒，保留键名 



array_keys($array,"blue"); //返回值为blue的键名 
...]]></description><category></category></item><item><title><![CDATA[数据表关系 一对多 只查出一条数据]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/107669535</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/107669535</guid><author>fb_fb</author><pubDate>Wed, 29 Jul 2020 16:56:22 +0800</pubDate><description><![CDATA[一对多 查询 出 第一条
商品表goods  商品sku表  goods_sku 为1=&gt;n
SELECT
g.goods_id,
g.goods_name,
g.create_time,
sku.goods_id AS bId,
sku.goods_price,
g.goods_status
FROM
yoshop_goods g
LEFT JOIN ( SELECT goods_id, goods_price  FROM yoshop_goods_sku GROUP BY goods_id ) s]]></description><category></category></item><item><title><![CDATA[基于海豚PHP框架 七牛云（插件），合成小程序分享图 并上传到七牛云]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/106074086</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/106074086</guid><author>fb_fb</author><pubDate>Tue, 12 May 2020 13:13:49 +0800</pubDate><description><![CDATA[&lt;?php
// +----------------------------------------------------------------------
// | 海豚PHP框架 [ DolphinPHP ]
// +----------------------------------------------------------------------
// | 版权所有 2016~2017 河源市卓锐科技有限公司 [ http://www.zrthink.com ]
// +-----.]]></description><category></category></item><item><title><![CDATA[获取当月第一天及最后一天]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/106054602</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/106054602</guid><author>fb_fb</author><pubDate>Mon, 11 May 2020 15:06:16 +0800</pubDate><description><![CDATA[//1普通方式

 $BeginDate=date('Y-m-01', strtotime(date("Y-m-d")));
 echo $BeginDate;
 echo "&lt;br/&gt;";
 echo date('Y-m-d', strtotime("$BeginDate +1 month -1 day"));
 echo "&lt;br/&gt;";
 
 //2使用函数及数组来获取当月第一天及最后一天,比较实用
 function getMonth($da...]]></description><category></category></item><item><title><![CDATA[Tp5 微信退款]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/105771225</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/105771225</guid><author>fb_fb</author><pubDate>Sun, 26 Apr 2020 16:12:33 +0800</pubDate><description><![CDATA[&lt;?php

namespace app\common\controller;

/*
 * 微信退款
 */

use think\Log;
use think\Db;
use think\Cache;

class WeixinPay {

    protected $mchid;
    protected $appid;
    protected $apiKey;
    pu...]]></description><category></category></item><item><title><![CDATA[根据自己的经纬度获取附近的商家]]></title><link>https://blog.youkuaiyun.com/fb_fb/article/details/105581766</link><guid>https://blog.youkuaiyun.com/fb_fb/article/details/105581766</guid><author>fb_fb</author><pubDate>Fri, 17 Apr 2020 15:40:05 +0800</pubDate><description><![CDATA[$latitude='维度 ';
$longitude=‘经度’;
data=self::where(data = self::where(data=self::where(where)
-&gt;field(“id,hotel_cover,hotel_name,hotel_title,hotel_price,hotel_special_services,
hotel_restaurant_ser...]]></description><category></category></item></channel></rss>