App\Modules\Demos\Controllers\Demos::database PHP Method

database() public method

public database ( )
    public function database()
    {
        $content = '';
        //
        $query = DB::table('users')->where('username', 'admin');
        $sql = $query->toSql();
        $user = $query->first();
        $content .= '<pre>' . var_export($sql, true) . '</pre>';
        $content .= '<pre>' . var_export($user, true) . '</pre>';
        //
        $user = User::find(1);
        $content .= '<pre>' . var_export($user->toArray(), true) . '</pre>';
        //
        $users = User::all();
        $content .= '<pre>' . var_export($users->toArray(), true) . '</pre>';
        //
        $users = User::where('username', '!=', 'admin')->orderBy('username', 'desc')->get();
        $content .= '<pre>' . var_export($users->toArray(), true) . '</pre>';
        return View::make('Default')->shares('title', __d('demos', 'Database API'))->with('content', $content);
    }