KOKINIO - MANAGER

Edit File: Estado.php

<?php namespace App; use Illuminate\Database\Eloquent\Model; use DB; class Estado extends Model { // protected $table = 'estado'; public $incrementing = false; public $timestamps = false; public function estados($pais = 'Mexico'){ $sql = "SELECT e.id, e.estado FROM estado e JOIN pais p ON p.id = e.pais_id WHERE pais = '$pais' ORDER BY e.estado"; $query = DB::select(DB::raw($sql)); if(count($query) != null){ return $query; } } }