lavavel连接数据库的增删改查操作

配置修改：
1.  .env中进行配置：
---------------
APP_ENV=local
APP_DEBUG=true
APP_KEY=FPg9LRkHTj5j14ig7ETzQhG29r5sEWNR


DB_HOST=127.0.0.1
DB_DATABASE=laravel_demo
DB_USERNAME=root
DB_PASSWORD=root


CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync


REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379


MAIL_DRIVER=smtp
MAIL_HOST=mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
------------------------
2.在控制器中引入model和db就想下面一下
-----------------------
/*当进行数据库操作的时候需要引用下面的两个类*/
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Eloquent\Model;
3.下面是方法进行数据库的操作
<?php


namespace App\Http\Controllers;


use Illuminate\Http\Request;
use App\Http\Requests;
/*当进行数据库操作的时候需要引用下面的两个类*/
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Eloquent\Model;


class HomeController extends Controller
{
    //
public function getIndex()  
{  
return "this is getIndex";  
}  
public function getAdd()
{
       $res =  DB::table('test')->insert([
   ['id'=>null,'proname'=>'Laravel','age'=>34],
   ['id'=>null,'proname'=>'Academy','age'=>11],
   ['id'=>null,'proname'=>'LaravelAcademy','age'=>23]
]);
       var_dump($res);
}
public function getShow(){ 
$users = DB::table('test')->get();
        //dd($users);
        echo "<pre/>";
        var_dump($users);
}
public function getDel(){ 
$deleted = DB::table('test')->where('id', '>', 2)->delete();
var_dump($deleted);
}
public function getUpdate(){ 
$affected = DB::table('test')->where('proname','少林寺')->update(['proname'=>'张杰']);
var_dump($affected);
}
}
4.数据库sql：
# Host: localhost  (Version: 5.5.40)
# Date: 2016-07-26 17:41:52
# Generator: MySQL-Front 5.3  (Build 4.120)


/*!40101 SET NAMES utf8 */;


#
# Structure for table "test"
#


DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `proname` varchar(50) NOT NULL,
  `age` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


#
# Data for table "test"
#


/*!40000 ALTER TABLE `test` DISABLE KEYS */;
INSERT INTO `test` VALUES (1,'张杰',35),(2,'Academy',11),(29,'Laravel',34),(30,'Academy',11),(31,'LaravelAcademy',23),(32,'Laravel',34),(33,'Academy',11),(34,'LaravelAcademy',23),(35,'Laravel',34),(36,'Academy',11),(37,'LaravelAcademy',23);
/*!40000 ALTER TABLE `test` ENABLE KEYS */;