控制器,rawSQL,Model
controller.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
class MyController extends Controller
{
public function hello()
{
$articles = DB::select(‘select * from posts‘);
return View(‘myview‘,[‘d1‘=>$articles]);
}
}
1 <?php 2 3 namespace App\Http\Controllers; 4 5 use Illuminate\Http\Request; 6 7 use App\Http\Requests; 8 use DB; 9 10 class MyController extends Controller 11 { 12 public function hello() 13 { 14 15 $articles = DB::select(‘select * from posts‘); 16 17 return View(‘myview‘,[‘d1‘=>$articles]); 18 } 19 }
*.blade.php
@extends(‘layouts.app‘)
@section(‘content‘)
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1">
<div class="panel panel-default">
<div class="panel-heading">{{ count($d1) }}</div>
<div class="panel-body">
this is my view!
</div>
@for($i = 0; $i < count($d1); $i++)
<p>{{ $d1[$i]->content }}</p>
@endfor
</div>
</div>
</div>
</div>
@endsection
原文:http://www.cnblogs.com/sweng/p/6341307.html