Community Learn Tools Library Leisure
search
English
Home > List of blog posts > laravel基础（数据库、增、删、改、查、原生查询）
Blogger Information
Blog 15
fans 2
comment 0
visits 35333
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
laravel基础（数据库、增、删、改、查、原生查询）
w™下載一個妳
Original
969 people have browsed it

laravel基础

1.laravel数据库原生，增、删、改、查、和高级查询

1.1 laravel路由代码：

  1. <?php
  3. use App\Http\Controllers\Home;
  4. use Illuminate\Support\Facades\Route;
  6. /*
  7. |--------------------------------------------------------------------------
  8. | Web Routes
  9. |--------------------------------------------------------------------------
  10. |
  11. | Here is where you can register web routes for your application. These
  12. | routes are loaded by the RouteServiceProvider within a group which
  13. | contains the "web" middleware group. Now create something great!
  14. |
  15. */
  17. Route::get('/', function () {
  18.     //echo date('Y-m-d H:i:s');
  19.     return view('welcome');//视图，视图引擎blade
  20.     //return view('test');
  21. });
  23. /*Route::get('/article/p/aaa',function(){
  24.     return 'php.cn';
  25. });*/
  27. Route::get('/home/index','Home@index');
  28. Route::get('/admins/article/lists','admins\Article@lists');
  30. Route::get('/dbselect','Home@get');
  32. Route::get('/dbupdate','Home@test_updateadafd');
  34. Route::get('/dbinsert','Home@insert_mytest');
  36. Route::get('/dbdelete','Home@delete_asdf');
  38. Route::get('/dbfinds','Home@finds');

1.2 laravel控制器代码：

  1. <?php
  2. //1.命名空间：和目录对应
  3. //2.类名称和文件文件名称一致
  4. namespace App\Http\Controllers;
  5. use Illuminate\Support\Facades\DB;
  7. class Home extends Controller{
  8.     public function index(){
  9.         //return 'www.php.cn';
  10.         $time = date('Y-m-d H:i:s');
  11.         $res = DB::select('select * from article');
  12.         $lists = [];
  13.         foreach($res as $val){
  14.             $lists[] = (array)$val;
  15.         }
  16.         $data['result'] = $lists;
  17.         // echo '<pre>';
  18.         // print_r($data);
  20.         return view('test',$data);
  21.         // return view('test')->with('time',$time)->with('name','laravel应用程序');
  22.     }
  24.     //数据库查询[原生查询]
  25.    public function get(){
  26.      //select * from article
  27.      $res = DB::select('select * from article where id>3');
  28.      echo '<pre>';
  29.      print_r($res);
  30.    }
  32.    //数据库更新操作【原生更新】
  33.    public function test_updateadafd(){
  34.        $res = DB::update('update article set title="最污技术，我竟然秒懂" where id=3');
  35.        var_dump($res);
  36.    }
  38.    //新增数据[原生新增]
  39.    public function insert_mytest(){
  40.        $res = DB::insert('insert article(`id`,`title`)values(5,"excel鼠标上下失灵")');
  41.        var_dump($res);
  42.    }
  44.    //删除数据【原生删除】
  45.    public function delete_asdf(){
  46.       $res = DB::delete('delete from article where id=2');
  47.        var_dump($res);
  48.    }
  50.    //高级数据库查询方法【链式调用】
  51.    public function finds(){
  52.       $res = DB::table('article')->where('id',3)->first();
  53.       echo '<pre>';
  54.       print_r($res);
  55.    }
  57. }

1.2 laravel视图代码：

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6.     <link rel="stylesheet" type="text/css" href="/layui/css/layui.css">
  7.     <title>Document</title>
  8. </head>
  9. <body>
  10.    <table class="layui-table">
  11.        <thead>
  12.            <tr>
  13.                <td>ID</td>
  14.                <td>标题</td>
  15.            </tr>
  16.        </thead>
  17.        <tbody>
  18.            <?php foreach($result as $val){?>
  19.            <tr>
  20.                <td><?php echo $val['id']?></td>
  21.                <td><?php echo $val['title']?></td>
  22.            </tr>
  23.         <?php }?>
  24.        </tbody>
  25.    </table>
  26. </body>
  27. </html>
  30. <?php
  32. namespace App\Http\Controllers\admins;
  34. use App\Http\Controllers\Controller;
  35. use Illuminate\Http\Request;
  37. class Article extends Controller
  38. {
  39.    public function lists(){
  40.        echo '后台文章';
  41.    }
  42. }

2.数据库 增、删、改、查演练图片：

3.数据库创建、配置图：

3.学习总结：

通过这节课的学习，深刻了解到了laravel框架的强大，以及使用的实效性，跟着老师用laravel做了一遍，增，删，改，查，感觉效果很好，还学习了怎么利用laravel链接数据库，在使用数据库前将数据库配置、创建、以及对应的表先做好，再进行相关操作，自己还需要多加练习。

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：你的学习进度有点慢了
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post