how to add the sql query in laravel page code example
Example 1: how to get data from a table in laravel
use Illuminate\Support\Facades\DB;
class UserController extends Controller
{
public function index()
{
$users = DB::table('users')->select('id','name','email')->get();
return view('some-view')->with('users', $users);
}
}
Example 2: DB::table('users')->get();
DB::table('users')->where('name', Input::get('name'))->get();