简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > List of blog posts > laravel数据库原生查询、更新、新增、删除
Blogger Information
Blog 14
fans 0
comment 1
visits 12857
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数据库原生查询、更新、新增、删除
王珂
Original
1472 people have browsed it

laravel数据库原生查询、更新、新增、删除

home.php

  1. <?php
  2. // 命名空间：和目录对应
  3. // 类名称和文件名称一致
  4. namespace App\Http\Controllers;
  5. use Illuminate\Support\Facades\DB;
  7. class Home extends Controller {
  8.     public function index(){
  9.         $time = date('Y-m-d H:i:s');
  10.         $data = [];
  11.         $data['time'] = $time;
  12.         $data['name'] = 'laravel中文';
  14.         //第一种方法，数组当做参数
  15.         //return view('test',$data);
  16.         //第二种方法，with
  17.         return view('test')->with('time',$time)->with('name','with链式调用');
  18.     }
  19.     //数据库查询（原生查询）
  20.     //::静态方法，->需要new
  21.     //DB::select查询的结果第一层是数组，第二层是对象，get()将结果转为两维数组，getall()未转。
  22.     public function get(){
  23.         //select * from article
  24.         echo '<pre>';
  25.         $res = DB::select('select * from article');
  26.         //print_r($res);
  27.         $lists = [];
  28.         foreach($res as $val){
  29.             $lists[] = (array)$val;
  30.         }
  31.         $data['result']=$lists;
  32.         //print_r($data);
  34.         return view('dbselect',$data);
  35.     }
  36.     public function getall(){
  37.         //select * from article
  38.         echo '<pre>';
  39.         $res = DB::select('select * from article');
  40.         //print_r($res);
  41.         $data['result']=$res;
  42.         print_r($data);    
  43.         return view('dbselect1',$data);
  44.     }
  45.     //数据库更新（原生更新）
  46.     public function test_updateadafd(){
  47.         //select * from article
  48.         echo '<pre>';
  49.         $res = DB::update('update article set title="999" where id =2');
  50.         var_dump($res);
  51.     }
  52.     //新增（原生）
  53.     public function insert_mytest(){
  54.         $res = DB::insert('insert article(`id`,`title`) values(5,"5款简洁的layui后台管理模板推荐")');
  55.         var_dump($res);
  56.     }
  57.     //删除（原生）
  58.     public function delete_asdf(){
  59.         $res = DB::delete('delete from article where id=5');
  60.         var_dump($res);
  61.     }
  62.     //高级数据库查询方法
  63.     public function finds(){
  64.         $res = DB::table('article')->where('id',3)->first();
  65.         echo '<pre>';
  66.         print_r($res);
  67.     }
  69. }

web.php

  1. <?php
  3. use Illuminate\Support\Facades\Route;
  6. Route::get('/', function () {
  7.     //echo date('Y-m-d H:i:s');
  8.     //return view('welcome');
  9.     return view('test');
  10. });
  12. Route::get('/article/p/aaa', 'Home@index');
  13. Route::get('/admin/article/lists', 'Admin\Article@lists');
  14. Route::get('/dbselect', 'Home@get');
  15. Route::get('/dbselect1', 'Home@getall');
  16. Route::get('/dbupdate', 'Home@test_updateadafd');
  17. Route::get('/dbinsert', 'Home@insert_mytest');
  18. Route::get('/dbdelete', 'Home@delete_asdf');
  19. Route::get('/dbfinds', 'Home@finds');

test.blade.php

  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>my test</title>
  5. </head>
  6. <body>
  7. <h3><?php echo $name;?></h3>
  8. php中文网
  9. <div><?php echo $time;?></div>
  10. </body>
  11. </html>

dbselect.blade.php

  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>my test</title>
  5. <link rel="stylesheet" type="text/css" href="/layui/css/layui.css">
  6. </head>
  7. <body>
  8.     <table class="layui-table">
  9.         <thead>
  10.         <tr>
  11.             <th>ID</td>
  12.             <th>标题</td>
  13.         </tr>
  14.         </thead>
  15.         <tbody>
  16.         <?php foreach($result as $val){?>
  17.         <tr>
  18.             <th><?php echo $val['id']?></td>
  19.             <th><?php echo $val['title']?></td>
  20.         </tr>
  21.         <?php }?>
  22.         </tbody>
  23.     </table>
  24. </body>
  25. </html>

dbselect1.blade.php

  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>my test</title>
  5. <link rel="stylesheet" type="text/css" href="/layui/css/layui.css">
  6. </head>
  7. <body>
  8.     <table class="layui-table">
  9.         <thead>
  10.         <tr>
  11.             <th>ID</td>
  12.             <th>标题</td>
  13.         </tr>
  14.         </thead>
  15.         <tbody>
  16.         <?php foreach($result as $val){?>
  17.         <tr>
  18.             <th><?php echo $val->id?></td>
  19.             <th><?php echo $val->title?></td>
  20.         </tr>
  21.         <?php }?>
  22.         </tbody>
  23.     </table>
  24. </body>
  25. </html>
Correction status：Uncorrected

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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！