How pass Dynamic variable from url in Laravel

Question

I need to fetch the data from database and display it view . This is my web.php

Route::get('/businesscard/{name}',  function ($name) {
    
    
//$username= App\users::where('username', $name);


$username=DB::table('users')->select('*')
                     ->where('username', '=', $name)
                    // ->groupBy('status')
                     ->get();
   
    return view('auth.pro')->with(['username' => $username]);
   
   
   
     return array(
       'name' => $name
       );
       
       
       
});

If the user enters domain.com/businesscard/username I need to fetch the data for the username and display it in view .It is working.But I need to remove businesscard .User need to enter domain.com/username. I have tried the below code.

Route::get('/{name}',  function ($name) {
    
    
//$username= App\users::where('username', $name);


$username=DB::table('users')->select('*')
                     ->where('username', '=', $name)
                    // ->groupBy('status')
                     ->get();
   
    return view('auth.pro')->with(['username' => $username]);
   
   
   
     return array(
       'name' => $name
       );
       
       
       
});

If there is data it is working .but other pages are not working like login and register .Users are entering their username in registration .

/{name} That means, /login, /register wont work. — STA
– STA, Commented Jul 12, 2020 at 10:59
check my answer it will helpful for you. If it's helpful then give a upvote and accept my answer.Thanks — Senthurkumaran
– Senthurkumaran, Commented Jul 12, 2020 at 11:08

Danny Van Der Sluijs · Accepted Answer · 2020-07-12 17:17:32Z

1

The order of your route matters. See order of route declarations in laravel package

So the /{name} should be registered as the last route to avoid matching for other routes.

edited Jul 12, 2020 at 17:17

answered Jul 12, 2020 at 11:17

Danny Van Der Sluijs

3113 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Revathi Over a year ago

Thanks .I have changed the route order . It is working .

Danny Van Der Sluijs Over a year ago

Please also mark it as the answer for others to find it.

Senthurkumaran · Accepted Answer · 2020-07-12 11:05:00Z

0

/{name} it means / with any value. If you try /login or /register.Then your logic is confused with this so that other pages are not working. Best way to develop as you expect like first one.

Another thing in your code there is two return second one is not doing anything. After the first one it return to view so second one unused. remove that return as well.

answered Jul 12, 2020 at 11:05

Senthurkumaran

1,8882 gold badges22 silver badges33 bronze badges

Collectives™ on Stack Overflow

How pass Dynamic variable from url in Laravel

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related