[Laravel] Laravel's basic database operation part
[laravel] Laravel's database configuration
Find the .env file under the program directory structure
Configure basic database connection information
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=blog
DB_USERNAME=root
DB_PASSWORD=root
You need to restart the service after modifying the .env file
[laravel] Getting started with laravel's database
Import the DB database operation class in the controller, use DB
Use the static method select of the DB class to query the database, DB: :select(), parameter: sql statement, parameter value array
For example: $user=DB::select("select * from article where id=?",array("1"));
obtain an array , each result in the array is a StdClass object
<?<span>php namespace App\Http\Controllers\Index; </span><span>use</span><span> App\Http\Controllers\Controller; </span><span>use</span><span> DB; </span><span>class</span> IndexController <span>extends</span><span> Controller{ </span><span>public</span><span>function</span><span> index(){ </span><span>$data</span>=<span>array</span><span>(); </span><span>$data</span>['title']="Index控制器"<span>; </span><span>//</span><span> 第一种</span><span>$user</span>=DB::select("select * from article where id=?",<span>array</span>("1"<span>)); </span><span>foreach</span> (<span>$user</span><span>as</span><span>$v</span><span>) { </span><span>echo</span><span>$v</span>-><span>title; } </span><span>//</span><span> 第二种</span><span>$users</span>=DB::table("article")-><span>get(); </span><span>foreach</span> (<span>$user</span><span>as</span><span>$v</span><span>) { </span><span>echo</span><span>$v</span>-><span>title; } </span><span>return</span> view("index.index",<span>$data</span><span>); } }</span>
Use the query constructor
Use DB::table() to get the query constructor object, parameters: table name
Call the get() method of the Builder object , get array data
For example: $users=DB::table("article")->get();
The query constructor is called in a chain. There are other methods, you can check the document
[ laravel] Database migration
Use Artisan command to create migration, make:migration name – create table name
For example: php artisan make:migration create_users_table --create=users
This command will create a migration under the database/migrations directory File
Open the generated migration file and create the fields in the up method. The database structure constructor Schema will be used here
Run the migration command and use the command php artisan migrate to automatically create the table in the database
[laravel] Eloquent model
Use the Eloquent model to create a mapping model ORM for the table, use the Artisan command make:model model name
For example: php artisan make:model User
Generate a User in the app directory. php model file
The above introduces the basic database operation part of [Laravel] Laravel, including laravel content. I hope it will be helpful to friends who are interested in PHP tutorials.

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Laravel - Artisan Commands - Laravel 5.7 comes with new way of treating and testing new commands. It includes a new feature of testing artisan commands and the demonstration is mentioned below ?

Laravel - Pagination Customizations - Laravel includes a feature of pagination which helps a user or a developer to include a pagination feature. Laravel paginator is integrated with the query builder and Eloquent ORM. The paginate method automatical

Method for obtaining the return code when Laravel email sending fails. When using Laravel to develop applications, you often encounter situations where you need to send verification codes. And in reality...

Laravel schedule task run unresponsive troubleshooting When using Laravel's schedule task scheduling, many developers will encounter this problem: schedule:run...

The method of handling Laravel's email failure to send verification code is to use Laravel...

How to implement the table function of custom click to add data in dcatadmin (laravel-admin) When using dcat...

The impact of sharing of Redis connections in Laravel framework and select methods When using Laravel framework and Redis, developers may encounter a problem: through configuration...

Laravel - Dump Server - Laravel dump server comes with the version of Laravel 5.7. The previous versions do not include any dump server. Dump server will be a development dependency in laravel/laravel composer file.
