<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[luke024的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/luke024</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; luke024]]></copyright><item><title><![CDATA[mysql 三种批量插入数据的方式]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/146020407</link><guid>https://blog.youkuaiyun.com/luke024/article/details/146020407</guid><author>luke024</author><pubDate>Tue, 04 Mar 2025 16:56:41 +0800</pubDate><description><![CDATA[- code 为唯一索引键，乐观锁式更新，当新数据的时间戳大于老数据，新数据覆盖老数据，反之，旧数据覆盖新数据。-- code 为唯一索引键，无则新增，有则先删后增。-- code 为唯一索引键，无则新增，有则更新。ELSE '旧数据' END,ELSE '旧数据' END;]]></description><category></category></item><item><title><![CDATA[curl本地接口超时的问题]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/84398918</link><guid>https://blog.youkuaiyun.com/luke024/article/details/84398918</guid><author>luke024</author><pubDate>Fri, 23 Nov 2018 16:37:52 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/yicixing7/article/details/77323706

https://www.cnblogs.com/yueminghai/p/6494762.html

E:\phpStudy\php\php-7.1.24-nts\php-cgi.exe -b 127.0.0.1:9000 -c E:\phpStudy\php\php-7.1.24-...]]></description><category></category></item><item><title><![CDATA[网站开发——搭建博客（三）]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/84207719</link><guid>https://blog.youkuaiyun.com/luke024/article/details/84207719</guid><author>luke024</author><pubDate>Mon, 19 Nov 2018 01:10:32 +0800</pubDate><description><![CDATA[1.在对应目录拉取git服务器的代码

git clone git地址

2.引入laavel的包管理

composer install



可能会报如上错误，可以通过php -i | grep php.ini 查看我们源码编译后php默认的配置文件位置在哪里，然后调整自己所需的扩展就好

3.在nginx.conf里设置好站点后，访问页面，报错状态码为500或者白屏；

查找conf/fa...]]></description><category></category></item><item><title><![CDATA[网站开发——安装composer和git（二）]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/84203968</link><guid>https://blog.youkuaiyun.com/luke024/article/details/84203968</guid><author>luke024</author><pubDate>Mon, 19 Nov 2018 00:41:11 +0800</pubDate><description><![CDATA[Composer是php的一个包管理器，使用Composer能极大的提高我们的代码效率。当我们需要使用优雅的laraverl框架时我们一定不能绕过Composer当然Composer不是只为laravel服务的，他是为整个php服务的。(Composer需要php5.3.2以上才能运行)

下载Composer包

curl -sS https://getcomposer.org/installe...]]></description><category></category></item><item><title><![CDATA[网站开发——PHP基本环境搭建（一）]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/84203680</link><guid>https://blog.youkuaiyun.com/luke024/article/details/84203680</guid><author>luke024</author><pubDate>Sun, 18 Nov 2018 19:54:07 +0800</pubDate><description><![CDATA[开发环境为：linux ubuntu 16.04



1.获取软件源列表，输入sudo apt-get install 安装软件

2.创建/soft文件,并给所有权；

sudo mkdir /soft

sudo chmod -R 777 soft

3.下载并安装lnmp1.5集成环境

wget http://soft.vpser.net/lnmp/lnmp1.5.tar.gz -cO ...]]></description><category></category></item><item><title><![CDATA[linux学习资料]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/83997842</link><guid>https://blog.youkuaiyun.com/luke024/article/details/83997842</guid><author>luke024</author><pubDate>Mon, 12 Nov 2018 20:09:35 +0800</pubDate><description><![CDATA[linux就该这么学笔记：https://www.linuxprobe.com/

tcp/ip详解笔记：http://www.cnblogs.com/fengzanfeng/articles/1339347.html]]></description><category></category></item><item><title><![CDATA[Linux安装swoole扩展和redis扩展]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/83958750</link><guid>https://blog.youkuaiyun.com/luke024/article/details/83958750</guid><author>luke024</author><pubDate>Sun, 11 Nov 2018 15:13:30 +0800</pubDate><description><![CDATA[1、安装swoole
cd /usr/local/src

sudo wget https://github.com/swoole/swoole-src/archive/v1.9.1-stable.tar.gz

sudo tar zxvf v1.9.1-stable.tar.gz

cd swoole-src-1.9.1-stable

sudo /usr/local/php/bin/phpiz...]]></description><category></category></item><item><title><![CDATA[本地Navicat连不上Linux虚拟机MySQL数据库问题]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/81873252</link><guid>https://blog.youkuaiyun.com/luke024/article/details/81873252</guid><author>luke024</author><pubDate>Mon, 20 Aug 2018 16:23:47 +0800</pubDate><description><![CDATA[mysql -u root -p
输入数据库root 密码执行以下命令
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
exit;
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

然后关闭防火墙

ufw disable

然后就可以...]]></description><category></category></item><item><title><![CDATA[lnmp重置mysql数据库root密码]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/81872585</link><guid>https://blog.youkuaiyun.com/luke024/article/details/81872585</guid><author>luke024</author><pubDate>Mon, 20 Aug 2018 15:54:33 +0800</pubDate><description><![CDATA[（一）.通过命令修改，具体如下：

a、停止MySQL服务
执行：/etc/init.d/mysql stop
b、跳过验证启动MySQL
/usr/local/mysql/bin/mysqld_safe –skip-grant-tables &amp;gt;/dev/null 2&amp;gt;&amp;amp;1 &amp;amp;
然后：
mysql mysql -uroot　//登陆
mysql&amp;gt; update m...]]></description><category></category></item><item><title><![CDATA[PhpStudy 升级 MySQL 版本到5.7]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/80152757</link><guid>https://blog.youkuaiyun.com/luke024/article/details/80152757</guid><author>luke024</author><pubDate>Mon, 30 Apr 2018 22:21:08 +0800</pubDate><description><![CDATA[https://www.cnblogs.com/laowenBlog/p/7124728.html]]></description><category></category></item><item><title><![CDATA[laravel 在nginx服务器上除了首页其余都是404的问题]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/80081335</link><guid>https://blog.youkuaiyun.com/luke024/article/details/80081335</guid><author>luke024</author><pubDate>Wed, 25 Apr 2018 16:23:23 +0800</pubDate><description><![CDATA[nginx对应站点的.conf配置文件添加如下代码

location / {  
	try_files $uri $uri/ /index.php$is_args$query_string; #语法: try_files file1 [file2 ... filen] fallback  
	}
 

nginx接到请求后先判断是否是静态资源文件或目录，如果不是默认处理是指向404,需要改成返回...]]></description><category></category></item><item><title><![CDATA[phpstorm编辑软件下载及网络注册的地址]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/79959758</link><guid>https://blog.youkuaiyun.com/luke024/article/details/79959758</guid><author>luke024</author><pubDate>Mon, 16 Apr 2018 14:03:15 +0800</pubDate><description><![CDATA[下载链接：https://download.jetbrains.8686c.com/webide/PhpStorm-2018.1.exe网络注册码：http://idea.iteblog.com/key.php]]></description><category></category></item><item><title><![CDATA[phpredis常用操作]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/79533232</link><guid>https://blog.youkuaiyun.com/luke024/article/details/79533232</guid><author>luke024</author><pubDate>Mon, 12 Mar 2018 21:25:23 +0800</pubDate><description><![CDATA[Redis::__construct描述：创建一个Redis客户端范例：$redis = new Redis();connect, open描述：实例连接到一个Redis.参数：host: string        port: int返回值：BOOL 成功返回：TRUE;失败返回：FALSE范例：$redis-&amp;gt;connect('127.0.0.1′, 6379);get描述：获取有关指定...]]></description><category></category></item><item><title><![CDATA[ajax文件上传]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/79267396</link><guid>https://blog.youkuaiyun.com/luke024/article/details/79267396</guid><author>luke024</author><pubDate>Tue, 06 Feb 2018 09:56:34 +0800</pubDate><description><![CDATA[$("#file").change(function(){
    $(".icon-gou").css('display','none');
    var file_path =$("#file").val();
    var pos=file_path.lastIndexOf("\\");
    var file_name=file_path.substring(pos+1);]]></description><category></category></item><item><title><![CDATA[php--xdebug设置 ---phpstorm 断点调试]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/78028573</link><guid>https://blog.youkuaiyun.com/luke024/article/details/78028573</guid><author>luke024</author><pubDate>Tue, 19 Sep 2017 12:18:28 +0800</pubDate><description><![CDATA[配置好了之后 可以使用 ide的断点调试


Xdebug在PHP中的安装配置涉及php.ini配置文件的修改。


1  首先需要下载Xdebug，根据安装的PHP版本，选择合适的Xdebug版本，


2  安装Xdebug
将下载的php_xdebug-2.1.0-5.3-vc6.dll复制到PHP安装目录下的ext目录，ext目录专门用来存放PHP扩展库DLL文件。]]></description><category></category></item><item><title><![CDATA[帮助方法 Array]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/76907305</link><guid>https://blog.youkuaiyun.com/luke024/article/details/76907305</guid><author>luke024</author><pubDate>Tue, 08 Aug 2017 15:12:06 +0800</pubDate><description><![CDATA[帮助方法
简介
Laravel 包含了多中“帮手” PHP 函数，很多方法都在框架中进行了使用，如果你发现他们很方便，你也可以在自己的应用中使用。
方法名单
数组
array_add()
array_add 方法用来在数组中添加键值对，它仅会在数组中不存在所给定的键时才会添加：
$array = array_add(['name' => 'Desk'], 'price', 100);]]></description><category></category></item><item><title><![CDATA[数组分组  二维数组中，将某个键值相同的合并到一个数组]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/76613209</link><guid>https://blog.youkuaiyun.com/luke024/article/details/76613209</guid><author>luke024</author><pubDate>Thu, 03 Aug 2017 10:53:19 +0800</pubDate><description><![CDATA[PHP 数组分组  二维数组中，将某个键值相同的合并到一个数组中，下面是示例代码。



//原数组
$arr    =   array
(
    0 => array
        (
            'initial' => 'A',
            'typename' => '奥迪'
        ),
    1 => array
    ]]></description><category></category></item><item><title><![CDATA[mysql直接导出查询数据到excel]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/76528630</link><guid>https://blog.youkuaiyun.com/luke024/article/details/76528630</guid><author>luke024</author><pubDate>Tue, 01 Aug 2017 14:57:39 +0800</pubDate><description><![CDATA[在电脑环境变量中加上mysql变量，在cmd命令行中敲入表名，用户名和密码，然后需要执行的sql语句，导出到的文件地址
mysql test -uroot -proot  -e "select * from user where 1 order by id desc limit 0,20" > E:/type.xls]]></description><category></category></item><item><title><![CDATA[VertrigoServ设置多项目，不同端口打开]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/76146269</link><guid>https://blog.youkuaiyun.com/luke024/article/details/76146269</guid><author>luke024</author><pubDate>Wed, 26 Jul 2017 14:25:01 +0800</pubDate><description><![CDATA[1.在httpd.conf中设置端口并添加如下代码
Listen 80
Listen 8088


NameVirtualHost *:80

ServerName cs.sm
DocumentRoot "E:\hoytai\newSfabric\public"


NameVirtualHost *:8088

ServerName localhost:8088
Do]]></description><category></category></item><item><title><![CDATA[利用artisan新建表及填充数据]]></title><link>https://blog.youkuaiyun.com/luke024/article/details/71171507</link><guid>https://blog.youkuaiyun.com/luke024/article/details/71171507</guid><author>luke024</author><pubDate>Thu, 04 May 2017 16:00:39 +0800</pubDate><description><![CDATA[1.php artisan make:migration creat_procedures_table //创建一个新的迁移文件
2.添加字段


3.php artisan migrate //执行迁移，在数据库中生成表procedures
4.php artisan make:model Procedure //在app目录下生成Procedure模型
5.php artisan ]]></description><category></category></item></channel></rss>