StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Took me a while to figure out, but this is what I've ended up with.<br> This simply returns some html constructed in a view from a database query based on a single value (userid) passed into a controller method via jQuery ajax.<br> Eg: The user uses Bootstrap Typeahead to select a user, then (via ajax) gets the user's details from the database and displays then.</p> <h2>The AJAX:</h2> <pre><code>var details = '<?php echo URL::to('details'); ?>'; $.ajax( { url: details, type: 'GET', dataType: 'html', data: {id: selected}, }).done( function(data) { $('#details').html(data); } ); </code></pre> <h2>The Controller:</h2> <pre><code>public function Details() { $id = Input::get('id'); $user = DB::table('Users')->where('UserID', $id)->get(); $data = array('user' => $user); return View::make('details', $data); } </code></pre> <h2>The View:</h2> <pre><code>@foreach($user as $person) <label class="key">User ID</label> <label class="data">{{ $person->UserID }}</label> <label class="key">Person</label> <label class="data">{{ $person->FullName, $person->Email, $person->WebSite }}</label> @endforeach </code></pre> <h2>Notes:</h2> <ul> <li>All my views are blade templates.</li> <li>My details view cannot inherit from another template (no extends('master')), this stops the view from working (no idea why).</li> <li>I'll only ever be returning 1 record, I use @foreach to access the array and turn each element into an object (there may be a better way of doing this).</li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload