PHP
MHSLZ1
我有一壶酒,足以慰风尘。尽倾江海里,赠饮天下人
展开
-
YII2框架 根据同一字段不同值进行正倒序排序ORDERBY
公司有一个老项目是用YII2框架的,新收到一个需求根据状态来进行正序 倒序排序。 ->orderBy('status ASC' ) ->addOrderBy('(case when status = 0 then play_time end) ASC') ->addOrderBy('(case when status = 1 then play_time end) DESC')就是先根据状态排序,排序后再按原创 2022-01-17 15:05:45 · 899 阅读 · 0 评论 -
YII2使用时出现The file or directory to be published does not exist
公司有一个老项目是YII2的。因为要装markdown编辑器,好不容易找到一个合适的装上后。一直报上述错误。主要是找不到 bower/editor.md因为新版本拉下来会是在 bower-asset/editor.md。网上各种升级fxp/composer-asset-plugin, 可实际情况是fxp/composer-asset-plugin 这个插件照旧不更新了。特别是composer 升级到2.0+后,这个插件根本没法用了。我试过各种回退composer版本,升级插件,...原创 2021-11-03 17:48:20 · 680 阅读 · 0 评论 -
PHP如何通过依赖注入实现IOC
前言好的设计会提高程序的可复用性和可维护性,也间接的提高了开发人员的生产力。今天,我们就来说一下在很多框架中都使用的依赖注入。概念要搞清楚什么是依赖注入如何依赖注入,首先我们要明确一些概念。IOC (Inversion of Control) 控制反转:遵循依赖倒置原则的一种代码设计方案,依赖的创建 (控制) 由主动变为被动 (反转)。DI (Dependency Injection) 依赖注入:控制反转的一种具体实现方法。通过参数的方式从外部传入依赖,将依赖的创建由主动变为被动 (转载 2020-10-28 00:46:34 · 192 阅读 · 0 评论 -
wampserver3.17 mysql 服务没启动,橙色不变绿的问题
很久没动过这个wampserver的环境了,最近电脑坏了一次,全部格了一遍,因此重新安装这些环境系统。下了一个3.17的wampserver,中间缺了好几个dll,但是我没在意。缺了就去下载补上不就好了嘛!反正它报缺少哪一个我就下哪一个,看起来流程一切正常。最后却发现wampserver 一直是橙色的。一开始以为tomcat 冲突,80,3306端口被占用,系统环境变量问题,配置问题,找了一圈,怎么都没办法弄。最后决定重装这个软件,我目前认为是装wampserver的时候,由..原创 2020-07-13 11:15:57 · 1458 阅读 · 0 评论 -
laravel 不使用匿名函数 实现where or 和count sum等功能
laravel查询构建器 功能非常强大,想要多功能,多参数查询问题的时候,之前一直没特别好的方法。每次只能使用匿名函数,增加到where 里面,或者使用原生的写法。今天记录一种,以后可以常用的查询语句。 $condition=[]; array_push($condition,['created_time','>',$start]); array_push($condition,['created_time','<',$end]);.原创 2020-06-15 17:04:17 · 402 阅读 · 0 评论 -
PHP银行卡账号格式验证
public function checkbank($no=""){ if(empty($no)) return false; $arr_no = str_split($no); $last_n = $arr_no[count($arr_no)-1]; krsort($arr_no); $i = 1; $total = 0; foreach ($arr_no as $n){ if($i%2==0){ $ix = $n*2; if($ix>=10){ $nx = .转载 2020-06-09 16:56:37 · 545 阅读 · 0 评论 -
leetcode House Robber 房子抢劫犯
You are a professional robber planning to rob houses along a street. Each house has a certain amount of money stashed, the only constraint stopping you from robbing each of them is that adjacent house...原创 2019-12-31 14:42:03 · 191 阅读 · 0 评论 -
leetcode Move Zeroes
Given an arraynums, write a function to move all0's to the end of it while maintaining the relative order of the non-zero elements.Example:Input: [0,1,0,3,12]Output: [1,3,12,0,0]Note:You m...原创 2019-12-30 17:36:57 · 109 阅读 · 0 评论 -
leetcode Maximum Subarray 加最大的子序串
Given an integer arraynums, find the contiguous subarray(containing at least one number) which has the largest sum and return its sum.Example:Input: [-2,1,-3,4,-1,2,1,-5,4],Output: 6Explanati...原创 2019-07-26 16:20:30 · 116 阅读 · 0 评论 -
leetcode 获取平方根 sqrt($x)
Implementint sqrt(int x).Compute and return the square root ofx, wherexis guaranteed to be a non-negative integer.Since the return typeis an integer, the decimal digits are truncated and only...原创 2019-07-30 15:56:30 · 307 阅读 · 0 评论 -
leetcode 数组加int
989.Add to Array-Form of IntegerEasy14127FavoriteShareFor a non-negative integerX, thearray-form ofXis an array of its digits in left to right order. For example, ifX = 1231, then the arr...原创 2019-07-24 17:55:35 · 197 阅读 · 0 评论 -
leetcode 66. Plus One 加一 数字相加
Given anon-emptyarray of digitsrepresenting a non-negative integer, plus one to the integer.The digits are stored such that the most significant digit is at the head of the list, and each element...原创 2019-07-24 17:11:05 · 130 阅读 · 0 评论 -
leetcode 二进制加法
Given two binary strings, return their sum (also a binary string).The input strings are bothnon-emptyand contains only characters1or0.Example 1:Input: a = "11", b = "1"Output: "100"Exam...原创 2019-07-24 15:34:15 · 216 阅读 · 0 评论 -
leetcode Implement strStr() 字符串是否存在
Return the index of the first occurrence of needle in haystack, or-1if needle is not part of haystack.Example 1:Input: haystack = "hello", needle = "ll"Output: 2Example 2:Input: haystack...原创 2019-07-15 16:09:50 · 146 阅读 · 0 评论 -
leetcode Remove Duplicates from Sorted Array 数组去重
Given a sorted arraynums, remove the duplicatesin-placesuch that each element appear onlyonceand return the new length.Do not allocate extra space for another array, you must do this bymodifyi...原创 2019-06-04 17:32:50 · 111 阅读 · 0 评论 -
leetcode Merge Sorted Array 合并有序数组
Given two sorted integer arraysnums1andnums2, mergenums2intonums1as one sorted array.Note:The number of elements initialized innums1andnums2aremandnrespectively. You may assume tha...原创 2019-06-04 16:14:31 · 121 阅读 · 0 评论 -
leetcode 二叉树最深深度
Given a binary tree, find its maximum depth.The maximum depth is the number of nodes along the longest path from the root node down to the farthest leaf node.Note:A leaf is a node with no childre...原创 2019-08-16 14:37:52 · 141 阅读 · 0 评论 -
leetcode Merge Two Sorted Lists 合并有序列表
Merge two sorted linked lists and return it as a new list. The new list should be made by splicing together the nodes of the first two lists.Example:Input: 1->2->4, 1->3->4Output: 1-...原创 2019-06-04 14:34:05 · 121 阅读 · 0 评论 -
leetcode 爬楼梯 Climbing Stairs
You are climbing a stair case. It takesnsteps to reach to the top.Each time you can either climb 1 or 2 steps. In how many distinct ways can you climb to the top?Note:Givennwill be a positive...原创 2019-07-31 18:12:30 · 155 阅读 · 0 评论 -
leetcode 二叉树是否平衡 Balanced Binary Tree
Given a binary tree, determine if it is height-balanced.For this problem, a height-balanced binary tree is defined as:a binary tree in which the depth of the two subtrees ofeverynode never diff...原创 2019-08-18 16:33:34 · 99 阅读 · 0 评论 -
PHP判断用户名中是否存在敏感词
$username = I('username'); $names=M('mgc')->field('mgc')->select(); //取数据库中存在的敏感词库 $hei = array_column($names, 'mgc'); $blacklist="/".implode("|",$hei)."/i"; ...原创 2018-03-01 20:34:25 · 2673 阅读 · 0 评论 -
leetcode 杨辉三角取某一行
Given a non-negativeindexkwherek≤33, return thekthindex row of the Pascal's triangle.Note that the row index starts from0.In Pascal's triangle, each number is the sum of the two numbers ...原创 2019-09-03 16:28:48 · 308 阅读 · 0 评论 -
leetcode 输出 杨辉三角形 或者 帕斯卡三角形
Given a non-negative integernumRows, generate the firstnumRowsof Pascal's triangle.In Pascal's triangle, each number is the sum of the two numbers directly above it.Example:Input: 5Output:...原创 2019-09-03 16:01:42 · 241 阅读 · 0 评论 -
leetcode 不存在的数字 Missing Number
Given an array containingndistinct numbers taken from0, 1, 2, ..., n, find the one that is missing from the array.Example 1:Input: [3,0,1]Output: 2Example 2:Input: [9,6,4,2,3,5,7,0,1]O...原创 2019-09-03 11:28:43 · 1383 阅读 · 0 评论 -
leetcode 数组中唯一值 Single Number
Given anon-emptyarray of integers, every element appearstwiceexcept for one. Find that single one.Note:Your algorithm should have a linear runtime complexity. Could you implement it without us...原创 2019-09-03 11:05:25 · 163 阅读 · 0 评论 -
leetcode 二叉树最低深度
Given a binary tree, find its minimum depth.The minimum depth is the number of nodes along the shortest path from the root node down to the nearest leaf node.Note:A leaf is a node with no childre...原创 2019-08-16 14:29:30 · 104 阅读 · 0 评论 -
leetcode Symmetric Tree 镜面对称二叉树
Given a binary tree, check whether it is a mirror of itself (ie, symmetric around its center).For example, this binary tree[1,2,2,3,4,4,3]is symmetric: 1 / \ 2 2 / \ / \3 4 4 3...原创 2019-08-20 17:47:19 · 184 阅读 · 0 评论 -
leetcode Remove Duplicates from Sorted List
Given a sorted linked list, delete all duplicates such that each element appear onlyonce.Example 1:Input: 1->1->2Output: 1->2Example 2:Input: 1->1->2->3->3Output: 1-...原创 2019-08-20 16:54:11 · 102 阅读 · 0 评论 -
leetcode Count and Say
The count-and-say sequence is the sequence of integers with the first five terms as following:1. 12. 113. 214. 12115. 1112211is read off as"one 1"or11.11is read off ...原创 2019-08-14 16:27:56 · 150 阅读 · 0 评论 -
leetcode Valid Parentheses 检查大小括号问题
Given a string containing just the characters'(',')','{','}','['and']', determine if the input string is valid.An input string is valid if:Open brackets must be closed by the same type of b...原创 2019-06-03 17:45:57 · 173 阅读 · 0 评论 -
Leetcode Roman to Integer 罗马数字转整形问题
Roman numerals are represented by seven different symbols:I,V,X,L,C,DandM.Symbol ValueI 1V 5X 10L 50C 100D ...原创 2019-06-03 16:36:32 · 144 阅读 · 0 评论 -
laravel5.5mysql事务报错 Type error: Too few arguments to function
DB::transaction(function () { DB::table('users')->update(['votes' => 1]); DB::table('posts')->delete();});上面这是laravel5.5官方的方法,但是我不知道为什么我这边会不断报错。后来我就直接改了另外一种事务手动回滚。 DB::beginTransact...原创 2018-04-13 17:10:09 · 8512 阅读 · 0 评论 -
PHP 中的正则关系
概述正则表达式是一种描述字符串结果的语法规则,是一个特定的格式化模式,可以匹配、替换、截取匹配的字符串。常用的语言基本上都有正则表达式,如JavaScript、java等。其实,只有了解一种语言的正则使用,其他语言的正则使用起来,就相对简单些。文本主要围绕解决下面问题展开。有哪些常用的转义字符什么是限定符与定位符什么是单词定位符特殊字符有哪些什么是逆向引用以及怎样使用逆向引用匹配模式php中怎样使...转载 2018-04-22 16:30:15 · 276 阅读 · 0 评论 -
laravel获取路由参数和路由群组参数
假设我们设置了一个路由参数:/*** 定义路由参数名称分别为: param1,param2*/Route::get('/{param1}/{param2}', 'TestController@index');现在我们访问 http://test.dev/1/2在 TestController 中:/*** 路由参数获取方法** @param Illuminate\Http\Reques...转载 2018-04-10 15:50:57 · 1077 阅读 · 0 评论 -
laravel 跨域请求以及put,delete方式请求跨域
项目中用到了接口,外部调用的时候老是请求不到,本地请求却没问题,查了下说是因为跨域的问题。 根据网上所说解决方法如下:1、 建立中间件Cors.php 命令:php artisan make:middleware Cors 在/app/Http/Middleware/ 目录下会出现一个Cors.php 文件。2、 在handle 方法中加入如下内容: ...原创 2018-03-26 17:44:43 · 3012 阅读 · 0 评论 -
laraverl 创建命令行
1.创建工程:composer create-project --prefer-dist laravel/laravel blog 2.命令必须在laravel项目根目下下执行,否则 “Could not open input file: artisan”3.显示Lavarel版本 php artisan --version4.列出所有命令php artisan list 5.创建app/Mod...转载 2018-03-26 11:06:18 · 335 阅读 · 0 评论 -
windows 下的composer 可能遇到(Loading composer repositories with package information)
最容易遇到下面这个问题Loading composer repositories with package informationUpdating dependencies (including require-dev)在dos界面下输入composer install,然后就会卡在界面完全不动。这主要是由于中国长城的威力。composer config -g repo.pa...原创 2018-03-24 11:11:04 · 30080 阅读 · 2 评论 -
(转的)TP5整合 WorkerMan 以及 GatewayWorker
TP5整合GatewayWorker12345678910Windows版安装a)使用composer create-project topthink/think testTG,来安装thinkphp5.b)进入thinkphp5的目录,此处为testTG,使用composer require workerman/gateway-worker-for-win 安装Windows版本的gatewa...转载 2018-02-15 16:03:56 · 2177 阅读 · 2 评论 -
php随机生成汉字
本方法是通过生成GB2312编码的汉字后,再转码为UTF-8编码。之所以这样做是因为UTF-8的常用汉字太过分散,随机生成会出现大量生僻字,而使用GB2312编码的好处在于其收录的大部分汉字为常用汉字,具体参考下面的介绍。GB2312-80 字符编码介绍 GB 2312-80 是中国国家标准简体中文字符集,全称《信息交换用汉字编码字符集·基本集》,由中国国家标准总局发布,1981年5月1日实施。...转载 2018-03-01 20:11:49 · 944 阅读 · 0 评论 -
MD5问题
自己学艺不精,特地留下MD5 ture 和false 的区别,很少考虑到这块。原创 2018-01-18 11:44:28 · 316 阅读 · 0 评论