Laravel5 でSqlserver　PDOで接続

・環境
　XAMPP
　MS　SQLdriverをインストール済み
　Laravel5　php7

・プロジェクトをXAMPP￥HTDOCに配置済み

・WEB.APP　Route::get(‘/’,’co_hinmtaController@index’);Route::get(‘/pdo’,’co_hinmtaController@pdo’);　
・Controller
    public function index(){        $datas = \App\co_hinmtas::all();        //dd($datas->toArray());                return view(‘co_hinmta’, [‘datas’ => $datas]);        //return view(‘co_hinmta’)->with(‘datas’, $datas);    }    public function pdo(){        return view(‘pdo’);    }
・co_hinmta
    <ul> <?php foreach ($datas as $post):?>      <?php $cd= mb_convert_encoding($post[“CD”], “UTF-8”, “AUTO”);            $na = mb_convert_encoding($post[“NA”], “UTF-8”, “AUTO”);      ?>      <li><?php print $cd.’:’.$na; ?></li>    <?php endforeach; ?>     </ul>
・PDO
    <?php     try    {        $dbh = DB::connection()->getPdo();        $sql = “select hkbn,cd,na from co_hinmta WHERE HKBN = :hkbn “;        $stmt = $dbh->prepare($sql);        $data = array();        $data[‘:hkbn’] = 22;        $stmt->execute($data);        $dbh=null;    }    catch (Exception $e)    {    print ‘障害が発生しております’;    exit();    }         $rec=$stmt->fetch(PDO::FETCH_ASSOC);?>     <ul>        <?php         while($rec==true)        {            print ‘<li>’.$rec[‘cd’].’:’.$rec[‘na’].'</li>’;            $rec=$stmt->fetch(PDO::FETCH_ASSOC);        }        ?>     </ul>