Level 21
@shiva Can you show the example URLs you want to generate?
Mar 29, 2015
10
Level 5
Getting url data to show in the url bar
I'm using Laravel 4 and I'm trying to get the url bar to display the text url that is saved in the database instead of using the id.
This is my routes.php
Route::get('/{id}', function($id = 1){
if(is_numeric($id))
{
$page = Menu::find($id);
$action = 'content';
return App::make('HomeController')->$action($id);
} else {
$column = 'url';
$url = Seo::where($column, '=', $id)->get();
$action = 'show';
return App::make('HomeController')->$action($url[0]->id);
}
});
I'm also using a pivot table to link the menu to the seo.
Seo model
<?php
class Seo extends \Eloquent {
protected $fillable = array('url', 'meta_title', 'meta_description', 'keywords');
protected $guarded = array('id');
protected $table = 'seo';
public static $rules = array(
'title' => '',
'content' => '',
'image' => ''
);
public function menu(){
return $this->belongsToMany('Menu', 'menu_seo', 'seo_id', 'menu_id');
}
}
Menu model
<?php
class Menu extends \Eloquent {
protected $fillable = array('title', 'menu_id', 'image');
protected $guarded = array('id');
protected $table = 'menus';
public static $rules = array(
);
public function seo(){
return $this->belongsToMany('Seo', 'menu_seo', 'menu_id', 'seo_id');
}
}
Level 5
The about us would be about-us.html
Level 5
I have added some stuff to my routes.php function
Route::get('/{id}', function($id = 1){
if(is_numeric($id))
{
echo "hi";
$page = Menu::find($id);
$action = 'content';
return App::make('HomeController')->$action($id);
} else {
echo "bye";
$column = 'url';
$seo_url = Seo::where($column, '=', $id)->get();
foreach($seo_url as $seo){ //Added
$url_id = $seo->id; //Added
$url = $seo->url; //Added
}
$action = 'content';
$test = $url; //Added
return App::make('HomeController')->$action($test);
}
});
And I get this error
No query results for model [Menu].
I'm not sure how to get passed this error. I've tried adding
$menu = Menu::where('id', $id)->firstOrFail();
@foreach($menu->seo as $seo)
{{ $seo->url }}
@endforeach
and I still got the same error.
Level 21
@shiva Not sure of you are asking for this, URL bar will show the current url. So if you want like, be on some url but show some other url in url bar that cannot be done. you have to make a route for that. and redirect there.
Level 5
@SachinAgarwal - It would be the current url. At the moment if I click on the about us link I get taken to
http://localhost/site/31
but I want it to show
http://localhost/site/about-us.html
I want this to be done dynamically.
Level 21
@Shiva This is not possible. You cannot change the URL displayed in the browser. Not only would it be a horrible security practice, it would be a violation of trust to the people visiting your site.
On other hand, you do not need to show the .html part, and create a route for about us page
Route::get('/about-us',function(){
});
Level 5
@SachinAgarwal - I won't be able to get the route done dynamically then. Also if I had to have it like this
http://localhost/site/31
Then it isn't seo friendly
Level 21
@Shiva you can do one thing,
Redirect the site/31 to site/about-us
Level 5
@SachinAgarwal - But that wouldn't be user friendly. For example if I had to go and give this to a user and that person ended up deleting about us and then they went and re added the about us the id would be different and then an error would happen.
Level 21
Please or to participate in this conversation.