Laravel5.1 database connection, database creation, model creation, and controller creation methods, laravel5.1model

Laravel5.1 database connection, database creation, model creation, and controller creation methods, laravel5.1model

This example describes how to connect to a Laravel5.1 database, create a database, create a model, and create a controller. We will share this with you for your reference. The details are as follows:

Laravel can create databases manually, for example, 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 the file to a. env file)

Open the file:

Find:

DB_HOST = 127.0.0.1 // The Connection address does not use localhostDB_DATABASE = homestead // Database Name (which must be created in advance) DB_USERNAME = root // login name DB_PASSWORD = // Password

Here I have changed it to my local environment.

Ii. Create a data table

Cmd creation:

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

Then run:

php artisan make:migration create_articles_table --create=articles

Will get the created file: D: \ laravel-v5.1.11 \ database \ migrations

If a database error occurs at this time, check whether the database connection is correct. I planted it here for one morning (I modified phpmyadmin and entered the password casually, however, it turns out to be empty, so that you cannot enter the password when you connect to the database, but phpmyadmin does)

Open the newly created file and add the following fields:

Public function up () {Schema: create ('articles', function (Blueprint $ table) {$ table-> increments ('id '); // primary key auto-increment $ table-> string ('title'); $ table-> text ('intro'); $ table-> text ('content '); $ table-> timestamp ('hhed _ at'); $ table-> timestamps (); // two automatically created fields: created_at and updated_at });}

Then execute:

php artisan migrate

The table is automatically created.

3. Create modal

Run:

php artisan make:model Article

The Article. php file is created under the app directory. How to use this model?

Iv. Controller

Manually created here. (Feeling very nonsense, personal feeling phpmyadmin or navicat can create a database), in D: \ laravel-v5.1.11 \ app \ Http \ Controllers \ Articles created ArtilcesController. php controller (I am using the Controller method below the sub-file. For specific operations, see the previous article ).

Code:

Namespace App \ Http \ Controllers \ Articles; use Illuminate \ Http \ Request; use App \ Http \ Requests; use App \ Http \ Controllers \ Controller; use App \ Article; // This must be available and model is introduced. Otherwise, the database data class ArticlesController extends Controller {public function index () {// $ articles = Article: with ('category ') cannot be obtained ') -> latest ()-> paginate (15); $ articles = Article: all (); // obtain all data // print_r ($ articles ); $ name = array (0 => array ("name" => "123"),); return view ('articles. index', compact ('articles '); // ing }}