<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Guanjs2016的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Guanjs2016</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Guanjs2016]]></copyright><item><title><![CDATA[Sequel Pro 连接 mysql 8.3 失败]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/141608149</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/141608149</guid><author>Guanjs2016</author><pubDate>Tue, 27 Aug 2024 17:24:49 +0800</pubDate><description><![CDATA[这是 MySQL 早期版本使用的插件，通常与大多数客户端兼容。可使用test build版本，可以将用户的认证插件更改为。如果连接上后打开异常，]]></description><category></category></item><item><title><![CDATA[python 时间戳与日期]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/107335303</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/107335303</guid><author>Guanjs2016</author><pubDate>Tue, 14 Jul 2020 11:59:12 +0800</pubDate><description><![CDATA[import time



""" 时间间隔是以秒为单位的浮点小数。1594696515.2807229 """

now = time.time()



""" 从返回浮点数的时间戳方式向时间元组转换 time.struct_time(tm_year=2020, tm_mon=7, tm_mday=14, tm_hour=11, tm_min=16, tm_sec=20, tm_wday=1, tm_yday=196, tm_isdst=0)"""

localtime = time.localt..]]></description><category></category></item><item><title><![CDATA[php 安装ssh2拓展]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/82151901</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/82151901</guid><author>Guanjs2016</author><pubDate>Tue, 28 Aug 2018 18:16:51 +0800</pubDate><description><![CDATA[最近公司项目用到sftp服务，php ssh2_connect()函数一直报错，后来查阅相关资料了解到是ssh2拓展没装的原因，唉，公司测试环境太乱，搞了整整一天 晕。。。

1. 首先要安装 libssh2

wget --no-check-certificate https://www.libssh2.org/download/libssh2-1.2.tar.gz  （https方式记得加上-...]]></description><category></category></item><item><title><![CDATA[php单独获取多维数组某个键值的集合]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/80364035</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/80364035</guid><author>Guanjs2016</author><pubDate>Fri, 18 May 2018 15:45:32 +0800</pubDate><description><![CDATA[数组示例：$user = array(        0 =&amp;gt; array(             'id' =&amp;gt; 1,             'name' =&amp;gt; '张三',             'sex' =&amp;gt; '男',        ),        1 =&amp;gt; array(             'id' =&amp;gt; 2,             'n...]]></description><category></category></item><item><title><![CDATA[mysql  in 多个字段的用法]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/80237490</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/80237490</guid><author>Guanjs2016</author><pubDate>Tue, 08 May 2018 12:23:52 +0800</pubDate><description><![CDATA[1. 基本用法select * from user where user_id in (600,601,602);2. 多个字段同时使用select * from user where (user_id,type) in ((568,6),(569,6),(600,8));3. 多表同时多个字段使用select * from user where (legal_id,type) not in (s...]]></description><category></category></item><item><title><![CDATA[discuz 用户被禁止登陆可能的原因]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/80228482</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/80228482</guid><author>Guanjs2016</author><pubDate>Mon, 07 May 2018 17:13:57 +0800</pubDate><description><![CDATA[        最近有用户登陆遇到如下报错提示“抱歉，您的 IP 地址不在允许范围内，或您的账号被禁用，无法访问本站点”，一时知道什么原因，一番查找后发现有这样的解决方案：1. 检查数据表pre_common_setting 搜索ipaccess 是否设置了允许访问的ip 如果有将其置空2. 检查数据表pre_common_usergroup，是否将 allowvisit设置了为0（禁止访问）,1...]]></description><category></category></item><item><title><![CDATA[nginx启动、关闭、重启]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79457802</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79457802</guid><author>Guanjs2016</author><pubDate>Tue, 06 Mar 2018 15:07:16 +0800</pubDate><description><![CDATA[启动nginx/usr/work/tool/nginx/sbin/nginx重启nginx/usr/work/tool/nginx/sbin/nginx -s reload关闭nginx/usr/work/tool/nginx/sbin/nginx -s stop信号方式：关闭　　查询nginx主进程号    ps -ef | grep nginx　　平滑停止   kill -QUIT 主进程号　...]]></description><category></category></item><item><title><![CDATA[php-fpm启动，重启，终止操作方法]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79448646</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79448646</guid><author>Guanjs2016</author><pubDate>Mon, 05 Mar 2018 18:13:42 +0800</pubDate><description><![CDATA[启动php-fpm/usr/work/php/sbin/php-fpmphp5.3.3以后的版本不在支持这种方式，需要以信号方式控制INT, TERM 立刻终止QUIT 平滑终止USR1 重新打开日志文件USR2 平滑重载所有worker进程并重新载入配置和二进制模块php-fpm master进程可以理解以下信号先查看php-fpm的master进程号kill -USR2 10856    就直...]]></description><category></category></item><item><title><![CDATA[nginx+php+mysql 环境搭建]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79131869</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79131869</guid><author>Guanjs2016</author><pubDate>Tue, 13 Feb 2018 17:42:29 +0800</pubDate><description><![CDATA[准备工作：当前操作目录为  /usr/worka. 正式开始前，编译环境gcc g++ 开发库之类的需要提前装好。# yum install gcc gcc-c++b.  安装PCRE库ftp://ftp.csx.cam.ac.uk/pub/software/programming/pcre/pcre-8.39.tar.gz 下载最新的 PCRE 源码包，使用下面命令下载编译和安装 PCRE 包：...]]></description><category></category></item><item><title><![CDATA[linux基本操作之 用户管理]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79290641</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79290641</guid><author>Guanjs2016</author><pubDate>Fri, 09 Feb 2018 17:24:48 +0800</pubDate><description><![CDATA[1. 创建用户useradd -d /usr/work work2. 设置密码passwd work 3. 用户赋予root权限1）修改 /etc/sudoers 文件，找到下面一行，把前面的注释（#）去掉## Allows people in group wheel to run all commands%wheel  ALL=(ALL)       ALL然后修改用户，使其属于root组（wh...]]></description><category></category></item><item><title><![CDATA[解决linux 命令终端提示符显示-bash-4.2问题]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79129986</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79129986</guid><author>Guanjs2016</author><pubDate>Mon, 22 Jan 2018 15:59:04 +0800</pubDate><description><![CDATA[1. 新建用户时自定义了用户的家目录，之后切换到该用户下就出现了这样问题


经了解原来是缺少了几个配置文件引起的

1. /etc/skel/.bashrc
2. /etc/skel/.bash_profile
以上这些文件是每个用户都必备的文件。 将这些文件重新拷贝一份到当前用户的家目录下即可]]></description><category></category></item><item><title><![CDATA[linux-查看系统版本或者内核版本]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79127472</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79127472</guid><author>Guanjs2016</author><pubDate>Mon, 22 Jan 2018 12:19:35 +0800</pubDate><description><![CDATA[1. 查看内核版本 uname

-a或--all：显示全部的信息；
-m或--machine：显示电脑类型；
-n或-nodename：显示在网络上的主机名称；
-r或--release：显示操作系统的发行编号；
-s或--sysname：显示操作系统名称；
-v：显示操作系统的版本；
-p或--processor：输出处理器类型或"unknown"；
-i或--hardware-platf]]></description><category></category></item><item><title><![CDATA[php数组排序-自定义排序usort]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/79024617</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/79024617</guid><author>Guanjs2016</author><pubDate>Wed, 10 Jan 2018 16:44:29 +0800</pubDate><description><![CDATA[1. 一维数组排序


function func_sort($a,$b){
        if($a == $b){
            return 0;
        }
        return $a>$b ? -1 : 1;
}


$arr = [1,3,7,6,8];
usort($arr,'func_sort');
var_dump($arr)]]></description><category></category></item><item><title><![CDATA[git常用操作]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/78656657</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/78656657</guid><author>Guanjs2016</author><pubDate>Tue, 28 Nov 2017 20:05:10 +0800</pubDate><description><![CDATA[1. 初始化git仓库
git init
2. git分支管理
1）创建分支(dev为分支名 )   git branch dev 
2）创建并切换到该分支         git checkout -b dev
3）查看分支                           git branch
4)  删除分支                           git bran]]></description><category></category></item><item><title><![CDATA[yii CDbCriteria数据库操作详解]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/72158701</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/72158701</guid><author>Guanjs2016</author><pubDate>Mon, 15 May 2017 16:12:37 +0800</pubDate><description><![CDATA[yii CDbCriteria数据库操作详解




Yii的Active Recorder包装了很多。


CDbCriteria包含了where,order,limit,IN/not IN,like等常用短句，使用起来非常方便

示例如下：
//函数方式
$criteria = new CDbCriteria;  $criteria->addCondition("id=]]></description><category></category></item><item><title><![CDATA[yii数据库常用操作]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/72153081</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/72153081</guid><author>Guanjs2016</author><pubDate>Mon, 15 May 2017 15:33:12 +0800</pubDate><description><![CDATA[一 、Active Record
1.创建记录
要向数据表中插入新行，我们要创建一个相应
 AR 类的实例，设置其与表的列相关的属性，然后调用 save() 方法完成插入：


$post=new Post;
$post->title='sample post';
$post->content='content for the sample post';
$post->create_t]]></description><category></category></item><item><title><![CDATA[PHPStorm使用教程]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/65446391</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/65446391</guid><author>Guanjs2016</author><pubDate>Thu, 23 Mar 2017 17:32:27 +0800</pubDate><description><![CDATA[PHPStorm使用心得(一)



全局搜索（command + shift + F）


显示类中的方法 （command + 7）

函数追踪 （command +鼠标点击）

单行注释/取消（command + /）

输入行号跳到某一行（command + l）

列出打开的文件（command + e）

删除当前行（command + x）

复]]></description><category></category></item><item><title><![CDATA[Discuz!X数据库函数操作命令大全]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/59532230</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/59532230</guid><author>Guanjs2016</author><pubDate>Thu, 02 Mar 2017 15:51:12 +0800</pubDate><description><![CDATA[Discuz!X数据库函数操作命令大全











函数

功能



DB::table($tablename)

获取正确带前缀的表名，转换数据库句柄



DB::delete($tablename, 条件,条数限制)

删除表中的数据



DB::insert($tablename, 数据(数组),是否返回插入ID,是]]></description><category></category></item><item><title><![CDATA[discuz 中displayorder 字段的含义]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/54970836</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/54970836</guid><author>Guanjs2016</author><pubDate>Fri, 10 Feb 2017 15:19:48 +0800</pubDate><description><![CDATA[forum_thread的displayorder字段解释


displayorder 4  多版块置顶功能可让一个主题在任意多个版块 
只在指定的板块显示主题
需要在后台-内容-主题-板块/群组指定来进行操作


以下三种置顶可以在版主管理的浮动窗口操作 
displayorder 3 全局置顶 
全部专区，每个板块都可已看的到




displayorder ]]></description><category></category></item><item><title><![CDATA[php 字符串处理总结]]></title><link>https://blog.youkuaiyun.com/Guanjs2016/article/details/54913973</link><guid>https://blog.youkuaiyun.com/Guanjs2016/article/details/54913973</guid><author>Guanjs2016</author><pubDate>Tue, 07 Feb 2017 21:08:03 +0800</pubDate><description><![CDATA[1.字符串替换函数
>str_replace($search,$replace,$str,[int $times]);
$search：查找的目标
$replace: 替换值
$str: 被查找的字符串
$times: 替换的次数
>substr_replace($str,$replace,$start,$length)
将$str 中从$start开始长度为$length的子串替换]]></description><category></category></item></channel></rss>