<?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;
}
}
}