$_GET isset with laravel?

posted 11 years ago

I'm working with Laravel. Trying to work out the best conversion for below. Would I use query builder or eloquent and where should I integrate the code (view, controller, model), here is how I would perform normally:

HTML - GET records with /sweden or /stockholm - (.htaccess urls)

    <a href="retailers/country/sweden">Sweden</a>
    <a href="retailers/city/stockholm">Stockholm</a>

PHP - Grab the the data connected with those records

    if (isset($_GET['country']) || isset($_GET['city'])) 
    {	
    $country = $_GET['country'];
    $store = $_GET['city'];
    $stmt = $db->prepare("SELECT * from table WHERE country = ? or city = ?");
    $stmt->execute(array($country, $city));
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) :

    //output stuff

    endwhile
    
    } else { //do something else }

Here is how my current Laravel pattern looks:

Model:

    class DataListings extends Eloquent {
    	public $table ='database';
    }

Controller:

	public function data() {
	return View::make('data')
	->with('table', DataListings::all())
	}

Here is my view and how I am presuming I would put this together and this is where I am getting confused. What goes where, does the if (isset() go in my controller, model or here in the view? do I use query builder or elequent? If I could get an example on how to convert the above, it would be great.

    @if 
    
    @foreach($table as $data) // this here is my while :
    {{ $data->country }}, etc etc
    @endforeach
    
    @else
    //do something else
    @endif

Thanks

Last updated 2 years ago.

chademiller

replied 11 years ago

I don't think you will necessarily need to use If(isset)

For the inputs use Input::get('country") and Input::get('city')

Here is a good starting point for the Eloquent ORM

[Guide to using Eloquent ORM] (http://scotch.io/tutorials/php/a-guide-to-using-eloquent-orm-in-laravel)

Last updated 2 years ago.

panoplr

replied 11 years ago

The issue I have is each country and city relates to various fields in my table. I would love an example integrated from my above template.

Last updated 2 years ago.

mandersondesign

replied 11 years ago

Here is an example.

public function data() {
  if(Input::has("country") || Input::has('city')) {   
    $country = Input::get('country');
    $city = Input::get('city');

    $records = DataListings::where("country", "=", $country)
          ->orWhere("city","=",$city)
          ->get();

    return View::make('data')->with('table', $records)
  }
}

Last updated 2 years ago.

panoplr

replied 11 years ago

Thanks for your help. Here is my current setup now, however I am getting a blank page with no response, what am I doing wrong?

Here is my controllers for data.index:

public function retailers() {
$listings = DB::table('data_listings')
->orderBy('country', 'asc')
->groupBy('country')
->get();

return View::make('data.index')
->with('data_listings', $listings)
}

This is what I am using in your above example (data.show)

public function postRetailers() {
if(Input::has("country") || Input::has('city')) {   
$country = Input::get('country');
$city = Input::get('city');

$records = DataListings::where("country", "=", $country)
->orWhere("city","=",$city)
->get();

return View::make('data.show')
->with('data_listings', $records);
  }
}

Here are the two routes:

// Retailers
Route::get('/retailers', array(
	'as' => 'retailers', 
	'uses' => 'SiteController@retailers')
);

Route::get('/retailers/{country}', array(
	'as' => 'find-retailers', 
	'uses' => 'SiteController@postRetailers')
);

Here is data.index view:

@foreach($retailers_listings as $value)
<a  href="{{ URL::to('retailers/' . $value->country) }}">
{{ $value->country }}
</a>
@endforeach

Here is data.show view:

 @foreach($data_listings as $store)
{{ $store->address }}  // etc etc
@endforeach

When I click a link in data.index, it should route to data.show and show give me the fields with in the table that have $country or $city (however only focusing on $country right now). Any suggestions? Is it because we are using input:: and there is no form it's just URL get?

Last updated 2 years ago.

Moderators