【laravel】CRUD数据库操作基础记录

来源：互联网发布：如何联系淘宝客服介入编辑：程序博客网时间：2024/06/07 16:16

//获取数据库名称，检测数据库是否连接成功Route::get('/dbname', function(){   $name = DB::connection()->getDatabaseName();   echo $name;});//增 InsertRoute::get('db/insert', function(){   $data = array('what\'s your name?','myname is Tom!');   $posts = DB::insert('insert into demo1(title,body) values(?,?)',$data);   dd($posts);});//查 Select idRoute::get('db/select/id',function(){    $data = array(1);    $posts = DB::select('SELECT * FROM demo1 WHERE id = ?',$data);    dd($posts);});//查 Select all 返回结果数组Route::get('db/select/all',function(){    $posts = DB::select('SELECT * FROM demo1');    dd($posts);});//改 update 返回 0或1Route::get('db/update',function(){    $data = array('更新下',2);    $posts = DB::update('UPDATE demo1 set body = ? WHERE id = ?',$data);    dd($posts);});//删 ,返回0或1 Route::get('db/delete',function(){    $data = array(3);    $posts = DB::delete('DELETE FROM demo1 WHERE id = ?',$data);    dd($posts);});

0 0