Reputation: 708
I want to generate Dynamic sitemap
for my laravel project. I had already searched in so many sites for an answer. some of them describes it using composer. I didn't get how to do that. and in some other sites they wrote codes to get urls from db in loops. In my project db I didn't saved any urls. my project is a site for doctor and patients.
so is there any one knows how to write php / laravel codes for dynamic sitemap generation
.?
Edit
I'm a newbie to laravel so i'm just unfamiliar with this composer. can anyone please tell me if i download the laravel-sitemap-master.zip from github where i can extract it and saves in my project directory? it will be so much helpful if anyone please answer this.
Upvotes: 5
Views: 27992
Reputation: 5159
Suppose you want your website's sitemap.xml
file to include links to all doctors and patients you have in the database, you can do so like this:
in routes.php file..
Route::get("sitemap.xml", array(
"as" => "sitemap",
"uses" => "HomeController@sitemap", // or any other controller you want to use
));
in HomeController.php file (if you decided to use HomeController)..
public function sitemap()
{
$doctors = Doctor::remember(59) // chach this query for 59 minutes
->select(["id", "updated_at"])
// you may want to add where clauses here according to your needs
->orderBy("id", "desc")
->take(50000) // each Sitemap file must have no more than 50,000 URLs and must be no larger than 10MB
->get();
$patients = Patient::remember(59) // chach this query for 59 minutes
->select(["id", "updated_at"])
// you may want to add where clauses here according to your needs
->orderBy("id", "desc")
->take(50000) // each Sitemap file must have no more than 50,000 URLs and must be no larger than 10MB
->get();
$content = View::make('sitemap', ['doctors' => $doctors, 'patients' => $patients]);
return Response::make($content)->header('Content-Type', 'text/xml;charset=utf-8');
}
in views/sitemap.blade.php file..
<?php echo '<?xml version="1.0" encoding="UTF-8"?>' ?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
@foreach($doctors as $doctor)
<url>
<loc>{{ URL::route("doctors.show", [$doctor->id]) }}</loc>
<lastmod>{{ gmdate(DateTime::W3C, strtotime($doctor->updated_at)) }}</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>
@endforeach
@foreach($patients as $patient)
<url>
<loc>{{ URL::route("patients.show", [$patient->id]) }}</loc>
<lastmod>{{ gmdate(DateTime::W3C, strtotime($patient->updated_at)) }}</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>
@endforeach
</urlset>
Upvotes: 7
Reputation: 9416
Add this line to your routes.php
Route::get('/sitemap', function()
{
return Response::view('sitemap')->header('Content-Type', 'application/xml');
});
Create new file app\Http\Middleware\sitemap.php
<?php namespace App\Http\Middleware;
use Closure;
use Carbon\Carbon;
use Illuminate\Contracts\Auth\Guard;
class sitemap {
/**
* The Guard implementation.
*
* @var Guard
*/
protected $auth;
public function __construct(Guard $auth)
{
$this->auth = $auth;
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
*
* @return mixed
*/
public function handle($request, Closure $next)
{
if ( !$request->is("sitemap") && $request->fullUrl() != '' && $this->auth->guest() )
{
$aSiteMap = \Cache::get('sitemap', []);
$changefreq = 'always';
if ( !empty( $aSiteMap[$request->fullUrl()]['added'] ) ) {
$aDateDiff = Carbon::createFromTimestamp( $aSiteMap[$request->fullUrl()]['added'] )->diff( Carbon::now() );
if ( $aDateDiff->y > 0 ) {
$changefreq = 'yearly';
} else if ( $aDateDiff->m > 0) {
$changefreq = 'monthly';
} else if ( $aDateDiff->d > 6 ) {
$changefreq = 'weekly';
} else if ( $aDateDiff->d > 0 && $aDateDiff->d < 7 ) {
$changefreq = 'daily';
} else if ( $aDateDiff->h > 0 ) {
$changefreq = 'hourly';
} else {
$changefreq = 'always';
}
}
$aSiteMap[$request->fullUrl()] = [
'added' => time(),
'lastmod' => Carbon::now()->toIso8601String(),
'priority' => 1 - substr_count($request->getPathInfo(), '/') / 10,
'changefreq' => $changefreq
];
\Cache::put('sitemap', $aSiteMap, 2880);
}
return $next($request);
}
}
And create new view file resources\views\sitemap.blade.php
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
xmlns:image="http://www.google.com/schemas/sitemap-image/1.1"
xmlns:video="http://www.google.com/schemas/sitemap-video/1.1">
@foreach( Cache::get('sitemap') as $url => $params )
<url>
<loc>{{$url}}</loc>
<lastmod>{{$params['lastmod']}}</lastmod>
<changefreq>{{$params['changefreq']}}</changefreq>
<priority>{{$params['priority']}}</priority>
</url>
@endforeach
</urlset>
Add an entry to protected $middleware array in the file app\Http\Kernel.php
'sitemap' => 'App\Http\Middleware\sitemap'
Upvotes: 19
Reputation: 6393
check https://github.com/RoumenDamianoff/laravel-sitemap
A simple sitemap generator for Laravel 4.
Route::get('sitemap', function(){
// create new sitemap object
$sitemap = App::make("sitemap");
// set cache (key (string), duration in minutes (Carbon|Datetime|int), turn on/off (boolean))
// by default cache is disabled
$sitemap->setCache('laravel.sitemap', 3600);
// check if there is cached sitemap and build new only if is not
if (!$sitemap->isCached())
{
// add item to the sitemap (url, date, priority, freq)
$sitemap->add(URL::to('/'), '2012-08-25T20:10:00+02:00', '1.0', 'daily');
$sitemap->add(URL::to('page'), '2012-08-26T12:30:00+02:00', '0.9', 'monthly');
// get all posts from db
$posts = DB::table('posts')->orderBy('created_at', 'desc')->get();
// add every post to the sitemap
foreach ($posts as $post)
{
$sitemap->add($post->slug, $post->modified, $post->priority, $post->freq);
}
}
// show your sitemap (options: 'xml' (default), 'html', 'txt', 'ror-rss', 'ror-rdf')
return $sitemap->render('xml');
});
i have used it. works great!
to clear the confusion, let's take an example.
let's say i have a blog table with id
, title
, blog
i have the route as, Route::get('blog/{blog}',['as' => 'blog.show', 'uses' => 'Blog@show'];
first i will fetch the content, by $blogs = DB::table('blog')->get();
$blogs
will contain the results.
i will just loop,
foreach($blogs as $i)
{
$sitemap->add(route('blog.show',[$i->title]), '2014-11-11', '1.0','daily');
}
all my blogs are added in the sitemap.
Upvotes: 4