配置修改:
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 */;
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 */;