laravel5 入门

laravel new common-system
php artisan make:auth

make:auth??view,controller,route

??.env ?????

DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=common_system_laravelDB_USERNAME=rootDB_PASSWORD=

migrate ??db

php artisan migrate

??

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 1000 bytes (SQL: alter table users add unique
users_email_unique(email))

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 1000 bytes

$table->string(‘email’, 30)->unique();

mix
for windows:

npm install –no-bin-links

for linux:

npm install

获取最近一次执行的sql

DB::enableQueryLog();

$users = $this->user->search("david");var_dump($users->toArray());$queries = DB::getQueryLog();var_dump($queries);$last_query = end($queries);var_dump($last_query);echo $last_query['query'];

array (size=3)  'query' => string 'select * from `users` where `user_id` like ? order by `user_id` desc' (length=68)  'bindings' =>     array (size=1)      0 => string '%david%' (length=7)  'time' => float 13

使用DebugBar
https://github.com/barryvdh/laravel-debugbar
但是，如果是ajax请求，debugbar不会输出ajax的sql

use Barryvdh\Debugbar\Facade as Debugbar;Debugbar::error('my test!', 'my_label');

發送email
1. 安裝guzzle 庫
composer require guzzlehttp/guzzle

1. 修改.env配置

MAIL_DRIVER=smtpMAIL_HOST=smtp.gmail.comMAIL_PORT=587MAIL_USERNAME=xxxMAIL_PASSWORD=xxxMAIL_ENCRYPTION=tlsMAIL_FROM_ADDRESS=xxxMAIL_FROM_NAME=系統管理員

1. 創建mailable
   php artisan make:mail NewAccount

/**     * Build the message.     *     * @return $this     */    public function build()    {        return $this->view('emails.newaccount');    }

1. 发送示例

public function testSendMail()    {        echo "start send mail<br>";        // Send mail...        $toEmail = "[e-mail]";        Mail::to($toEmail, 'davidhuang')->send(new NewAccount());        echo "end send mail<br>";    }