<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[longzai89757的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/longzai89757</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; longzai89757]]></copyright><item><title><![CDATA[索引优化基本]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/102739874</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/102739874</guid><author>longzai89757</author><pubDate>Fri, 25 Oct 2019 11:33:08 +0800</pubDate><description><![CDATA[普通索引：最基本的索引。
	
	
	组合索引：多个字段上建立的索引，能够加速复合查询条件的检索。
	
	
	唯一索引：与普通索引类似，但索引列的值必须唯一，允许有空值。
	
	
	组合唯一索引：列值的组合必须唯一。
	
	
	主键索引：特殊的唯一索引，用于唯一标识数据表中的某一条记录，不允许有空值，一般用primary key约束。
	
	
	全文索引：用于海量文本的查询，MySQL5.6之后...]]></description><category></category></item><item><title><![CDATA[http强制转https]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/100924926</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/100924926</guid><author>longzai89757</author><pubDate>Tue, 17 Sep 2019 14:13:05 +0800</pubDate><description><![CDATA[记录一次http转https的事故

查文档说是老版本加一句rewrite ^(.*)$ https://$host$1 permanent;就可以，然而

在listen 443;情况下加了这句，没有效果，看了各种资料，发觉，其实应该是还是要解析http一次，但是在解析http时候加一句rewrite ^(.*)$ https://$host$1 permanent;

就可以了，于是有了下文...]]></description><category></category></item><item><title><![CDATA[linux下mysql导入数据库]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/100924827</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/100924827</guid><author>longzai89757</author><pubDate>Tue, 17 Sep 2019 14:10:43 +0800</pubDate><description><![CDATA[查看mysql状态 service mysqld status



进入mysql运行目录 cd /alidata/server/mysql-5.6.21/bin

进入mysql mysql -uroot -ppwd

导入数据库：

首先：mysql&gt;create databasetest;

方法1、mysql -uroot -ppwd &lt; /usr/test.sql...]]></description><category></category></item><item><title><![CDATA[linux环境配置常用命令]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/100924727</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/100924727</guid><author>longzai89757</author><pubDate>Tue, 17 Sep 2019 14:07:54 +0800</pubDate><description><![CDATA[查找PHP安装路径 find / -name "php.ini"

查看mysql状态 service mysqld status

查看nginx的路径 ps -ef|grep nginx

进入mysql数据库 mysql -uroot -ppwd



改变文件权限 chmod 777 -R www

打包项目 tar -cvf dirname.tar *

进入项目文件地址 cd /...]]></description><category></category></item><item><title><![CDATA[js外引文件添加随机字符串后缀]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/100924656</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/100924656</guid><author>longzai89757</author><pubDate>Tue, 17 Sep 2019 14:05:07 +0800</pubDate><description><![CDATA[var jsArr = ['js/test.js','js/test1.js'];

        createJs(jsArr);

        function createJs(link) {

            var len = link.length ,n=0;

            start();

            function st...]]></description><category></category></item><item><title><![CDATA[js调用摄像头解析二维码]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/100924099</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/100924099</guid><author>longzai89757</author><pubDate>Tue, 17 Sep 2019 13:54:07 +0800</pubDate><description><![CDATA[因为需求做一个扫码功能，发觉网上的资料不是不能用就是不完善，遂借鉴各种资料把这个功能搞出来了。

注意要点：

 1、需要https验证通过才可以，

  2、仅支持安卓端，iOS理论上也没问题的但是就是摄像头是前置摄像头没办法改，如果谁研究出来了，求告知

逻辑流程：网上给出了各种借助照相机的办法，方法很多，我觉得最合适我的属于，js获取摄像头设备，然后获取打开摄像头，获取视频流，...]]></description><category></category></item><item><title><![CDATA[layui全选，取消全选]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/94450471</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/94450471</guid><author>longzai89757</author><pubDate>Tue, 02 Jul 2019 16:05:54 +0800</pubDate><description><![CDATA[form.on('checkbox(checkall)', function(data){

$('.layui-card-body input[type=checkbox]').prop("checked",data.elem.checked);

form.render('checkbox');

});

var allch...]]></description><category></category></item><item><title><![CDATA[记一次重启服务器技术事故]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/94450253</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/94450253</guid><author>longzai89757</author><pubDate>Tue, 02 Jul 2019 16:04:48 +0800</pubDate><description><![CDATA[线索Cues
			
			
			笔记Notes
			
		
			重启服务器之后,项目出现故障
			
			
			1、检查mysql连接

			2、检查数据表是否出错

			3、检查redis是否重启

			4、检查xunsearch是否启动

			5、检查session是否需要更新
			
		
			总结Summary
			
		
			1、不能着急;

		...]]></description><category></category></item><item><title><![CDATA[ajax的保险机制]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88712694</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88712694</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 13:19:04 +0800</pubDate><description><![CDATA[第一种方式  

var ajax_check = false,error_num = 0;

 settiming();

 function settiming(){

 ajax_check = true;

 $.ajax({

 url: "/index.php/index/index/getInfo",

 typ...]]></description><category></category></item><item><title><![CDATA[php使用递归输出为null解决]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88712490</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88712490</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 13:06:53 +0800</pubDate><description><![CDATA[/**

* 获取 面包屑 栏目

*/

function getNavBread($id,$nav_name='')

{

$one=Db::name('user_rule')-&gt;where("id",$id)-&gt;find();

if($one['pid']!=5){

if(!$nav_name){

$h...]]></description><category></category></item><item><title><![CDATA[替换数组指定键名、键值]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88712458</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88712458</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 13:04:45 +0800</pubDate><description><![CDATA[$param = $this-&gt;request-&gt;param();

json_decode(str_replace("id","s_t_id",json_encode($param)),true);
]]></description><category></category></item><item><title><![CDATA[文本框先发生改变的文本框改变事件]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88711486</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88711486</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 12:02:48 +0800</pubDate><description><![CDATA[$('.line_num').bind('input propertychange', function() {

 var num = $(this).val();

 $(this).parents('.layui-form-item').find('.num_con').val(num);

 });





o...]]></description><category></category></item><item><title><![CDATA[获取最近七天所有日期、汉字星期]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88711442</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88711442</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 12:01:06 +0800</pubDate><description><![CDATA[/**

 * 获取最近七天所有日期

 */

 public function get_weeks($time = '', $format='Y-m-d'){

 $time = $time != '' ? $time : time();

 //组合数据

 $date = [];

 for ($i=0; $i&lt;7; $i++){...]]></description><category></category></item><item><title><![CDATA[tp5同一个实例里面多次新增数据]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/88711405</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/88711405</guid><author>longzai89757</author><pubDate>Thu, 21 Mar 2019 11:59:55 +0800</pubDate><description><![CDATA[官网给出的方法是

注意不要在同一个实例里面多次新增数据，如果确实需要多次新增，那么可以用下面的方式：

$user = new User;

$user-&gt;name = 'thinkphp';

$user-&gt;email = 'thinkphp@qq.com';

$user-&gt;save();

$user-&gt;name = 'onethink';

$user-&gt;e...]]></description><category></category></item><item><title><![CDATA[tp3.2版本路由设置]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/86572026</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/86572026</guid><author>longzai89757</author><pubDate>Mon, 21 Jan 2019 12:06:40 +0800</pubDate><description><![CDATA[tp3.2版本路由需要设置两个地方，第一个config.php配置URL_ROUTER_ON开启，URL_ROUTE_RULES路由转换；

第二个tp框架自带的functions中的u函数。

配置设置：

    'DEFAULT_MODULE'     =&amp;gt; 'Home', //默认模块

    'URL_MODEL'          =&amp;gt; '2',    //URL模式

...]]></description><category></category></item><item><title><![CDATA[关于ajax传递二维数组的一些测试和验证]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/82757986</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/82757986</guid><author>longzai89757</author><pubDate>Tue, 18 Sep 2018 15:05:37 +0800</pubDate><description><![CDATA[var data = [];

             $('.choose_Tab tbody .active').each(function(i){

                 var tmp = {};

                 tmp['proid'] = $(this).attr('data-id');

                 tmp['num'] = $...]]></description><category></category></item><item><title><![CDATA[分享一些时间处理函数]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/82754942</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/82754942</guid><author>longzai89757</author><pubDate>Tue, 18 Sep 2018 11:30:06 +0800</pubDate><description><![CDATA[&amp;lt;?php

class Time

{

    /**

     * 返回今日开始和结束的时间戳

     *

     * @return array

     */

    public static function today()

    {

        return [

            mktime(0, 0, 0, date('m'), date(...]]></description><category></category></item><item><title><![CDATA[本周一的时间戳]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/82754678</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/82754678</guid><author>longzai89757</author><pubDate>Tue, 18 Sep 2018 11:27:43 +0800</pubDate><description><![CDATA[本周一的时间戳

strtotime('this week Monday',time())；

date(&quot;Y-m-d&quot;, strtotime(date('o-WW')));

strtotime('monday');//下周一时间戳

其他常用的：


	strtotime('today'); //今天
	
	
	strtotime('next monday'); //下个周一
	
	
	str...]]></description><category></category></item><item><title><![CDATA[linux下mysql启动不了]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/80827782</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/80827782</guid><author>longzai89757</author><pubDate>Wed, 27 Jun 2018 13:23:26 +0800</pubDate><description><![CDATA[1、在linux云服务器遇到一个mysql问题，开始页面显示Can't create/write to file，登录ssh发现mysql没有启动，  于是重启，出现下图错误，The server quit without updating PID file大概意思是pid写入不进去，找到mysql日志 看到报错是/www/wdlinux/mysql-5.5.58/bin/mysqld: Can'...]]></description><category></category></item><item><title><![CDATA[tp验证器多项验证+正则]]></title><link>https://blog.youkuaiyun.com/longzai89757/article/details/80827755</link><guid>https://blog.youkuaiyun.com/longzai89757/article/details/80827755</guid><author>longzai89757</author><pubDate>Wed, 27 Jun 2018 13:20:59 +0800</pubDate><description><![CDATA[&amp;lt;?phpnamespace app\index\validate;use think\Validate;class Comments extends Validate{    protected $regex = [ 'zip' =&amp;gt; '/^1[3|4|5|8][0-9]{9}$/'];    protected $rule = [        'name' =&amp;gt; 'requ...]]></description><category></category></item></channel></rss>