Laravel呼叫方法

說明:https://stackoverflow.com/questions/28573860/laravel-requestall-should-not-be-called-statically/28574081

輔助方法:https://docs.laravel-dojo.com/laravel/5.2/helpers

1. static方法

use Request;

public static function test(Request $request)
{ 
    $data= Request::all();
}

2.  一般方法

use Illuminate\Http\Request;

public static function test(Request $request)
{
   $age = \Request::input('age');
   $data = $request->all();
}

3.輔助方法

use Illuminate\Http\Request;

public static function test(Request $request)
{
    $data= request()->all();
}

mysql常用指令

Mysql需要啟動服務

cd到mysql bin底下有mysql執行檔的地方

1.安裝
mysqld install

2.啟動服務
net start mysql

3.停止服務
net stop mysql

4.mysql 遠端連線  -u:mysql account   -h:ip   -P:port
mysql -uroot -p -hlocalhost -P33600

進入 mysql> 底下下指令

1.顯示DB
show databases;

2.使用databases mydatabase
use mydatabase;

3.查詢 task 底下的tabel mytable
select * from mytable;

4.顯示資料庫中的所有table
 show tables from mytable;

5.顯示資料表的結構
desc mytable;

6.顯示狀態
status;

cmder 在windows下 中文問題

參考網址:http://www.rehack.cn/techshare/devtools/842.html

1.
在cmder的資料夾底下 cmder/config/user-aliases
追加以下代碼

l=ls --show-control-chars
la=ls -aF --show-control-chars
ll=ls -alF --show-control-chars
ls=ls --show-control-chars -F


2.
Settings > Startup > Environment
追加
set LANG=zh_CN.utf-8

3.

修改cmder資料夾底下 vendor/clink.lua文件

把20行set_prompt_filter這個函數調整成

function set_prompt_filter()

    -- get_cwd() is differently encoded than the clink.prompt.value, so everything other than

    -- pure ASCII will get garbled. So try to parse the current directory from the original prompt

    -- and only if that doesn't work, use get_cwd() directly.

    -- The matching relies on the default prompt which ends in X:\PATH\PATH>

    -- (no network path possible here!)

    local old_prompt = clink.prompt.value

    local cwd = old_prompt:match('.*(.:[^>]*)>')

    if cwd == nil then cwd = clink.get_cwd() end

    

    -- environment systems like pythons virtualenv change the PROMPT and usually

    -- set some variable. But the variables are differently named and we would never

    -- get them all, so try to parse the env name out of the PROMPT.

    -- envs are usually put in round or square parentheses and before the old prompt

    local env = old_prompt:match('.*%(([^%)]+)%).+:')

    -- also check for square brackets

    if env == nil then env = old_prompt:match('.*%[([^%]]+)%].+:') end

    

    -- build our own prompt

    -- orig: $E[1;32;40m$P$S{git}{hg}$S$_$E[1;30;40m{lamb}$S$E[0m

    -- color codes: "\x1b[1;37;40m"

    local cmder_prompt = "\x1b[1;32;40m{cwd} {git}{hg} \n\x1b[1;30;40m{lamb} \x1b[0m"

    cmder_prompt = string.gsub(cmder_prompt, "{cwd}", cwd)

    if env == nil then

        lambda = "λ"

    else

        lambda = "("..env..") λ"

    end

    clink.prompt.value = string.gsub(cmder_prompt, "{lamb}", lambda)

end