控制器,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