laravel5 入门

1 全局安裝 composer global require "laravel/installer"

2 創建項目

composer create-project --prefer-dist laravel/laravel common-system

laravel new common-system php artisan make:auth

make:auth view,controller,route

.env

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=common_system_laravel DB_USERNAME=root DB_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 '