Home Backend Development PHP Tutorial [Laravel] Laravel's basic database operation part

[Laravel] Laravel's basic database operation part

Jul 29, 2016 am 08:53 AM
laravel

[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>
Copy after login

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 thinkphp

laravel thinkphp

[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

laravel thinkphp

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.

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Laravel - Artisan Commands Laravel - Artisan Commands Aug 27, 2024 am 10:51 AM

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 - Pagination Customizations Aug 27, 2024 am 10:51 AM

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

How to get the return code when email sending fails in Laravel? How to get the return code when email sending fails in Laravel? Apr 01, 2025 pm 02:45 PM

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 is not executed: What should I do if the task is not running after schedule: run command? Laravel schedule task is not executed: What should I do if the task is not running after schedule: run command? Mar 31, 2025 pm 11:24 PM

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

In Laravel, how to deal with the situation where verification codes are failed to be sent by email? In Laravel, how to deal with the situation where verification codes are failed to be sent by email? Mar 31, 2025 pm 11:48 PM

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

How to implement the custom table function of clicking to add data in dcat admin? How to implement the custom table function of clicking to add data in dcat admin? Apr 01, 2025 am 07:09 AM

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

Laravel Redis connection sharing: Why does the select method affect other connections? Laravel Redis connection sharing: Why does the select method affect other connections? Apr 01, 2025 am 07:45 AM

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 Aug 27, 2024 am 10:51 AM

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.

See all articles