Laravel5.1 database connection, create database, create model and create controller method, laravel5.1model

This article describes the Laravel5.1 database connection, create database, create model and methods to create controllers. Share it with everyone for your reference, the details are as follows:

Foreword: Laravel creates a database, which can actually be created manually, such as the ancient phpmyadmin.

1. Database connection:

In the root directory (there is a .env file under laravel5.1, if not, there will be a .env.example and then modify this file into a .env file)

Open file:

Found:

DB_HOST=127.0.0.1 //連接地址不使用localhost
DB_DATABASE=homestead //數(shù)據(jù)庫(kù)名稱(chēng)（需要預(yù)先創(chuàng)建）
DB_USERNAME=root //登錄名
DB_PASSWORD= //密碼

I have modified this to match my local environment.

2. Data table creation

cmd created:

Cut to the storage directory of laravel 5.1 (project directory)

Then run:

php artisan make:migration create_articles_table --create=articles

You will get the created file: D:laravel-v5.1.11databasemigrations

If there is an error about the database at this time, please check whether the database connection is correct. I was stuck here all morning (my phpmyadmin was modified by me, and the password was entered casually, but it turned out to be empty, so it was difficult to connect to the database. I can’t get in if I just enter the password, but phpmyadmin can)

Open the newly created file and add fields:

public function up() { 
  Schema::create('articles', function (Blueprint $table) { $table->increments('id');// 主鍵 自增
   $table->string('title'); 
$table->text('intro'); 
$table->text('content');
$table->timestamp('published_at');
 $table->timestamps(); // 自動(dòng)創(chuàng)建的兩個(gè)字段：created_at 和 updated_at });
}

Then execute:

php artisan migrate

The table will be automatically created

3. Create modal

Execution:

php artisan make:model Article

The Article.php file will be created under the app directory. I don’t know exactly how to use this model, I will update it later

4. Controller

I created it manually here. (It feels very nonsense. I personally feel that phpmyadmin or navicat can create a database). I created the ArtilcesController.php controller under D:laravel-v5.1.11appHttpControllersArticles (I use the controller method under the sub-file. See the previous article for specific operations. ).

Code:

namespace App\Http\Controllers\Articles;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers\Controller;
use App\Article;//這個(gè)必須有，引入model，不然無(wú)法獲取數(shù)據(jù)庫(kù)數(shù)據(jù)
class ArticlesController extends Controller{
  public function index(){
    // $articles = Article::with('category')->latest()->paginate(15);
    $articles = Article::all();//獲取所有數(shù)據(jù)
    //print_r($articles);
     $name = array(
       0=>array(
         "name"=>"123"
       ),
     );
    return view('articles.index', compact('articles'));//映射
  }
}

Readers who are interested in more information about Laravel can check out the special topics on this site: "Introduction and Advanced Tutorial on Laravel Framework", "Summary of PHP Excellent Development Framework", "Basic Tutorial on Getting Started with Smarty Templates", "php Date and Time" Usage Summary", "php object-oriented programming introductory tutorial", "php string (string) usage summary", "php mysql database operation introductory tutorial" and "php common database operation skills summary"

I hope this article will be helpful to everyone’s PHP program design based on the Laravel framework.

Articles you may be interested in:

• Introduction to Laravel 5 framework learning routes, controllers and views
• ThinkPHP, ZF2, Yaf, Laravel framework routing competition
• Laravel 4 Basic Tutorial: Views, Namespaces, and Routing
• Learn the road to Laravel with me
• Laravel framework routing configuration summary and setup tips
• Laravel Detailed explanation of usage examples of Trait
• Laravel’s method of implementing automatic dependency injection of constructors
• Making APP interface (API) based on laravel
• Experience of learning PHP framework Laravel
• Get the previous and next data in Laravel
• Laravel routing setting and sub-routing setting example analysis