Level 122
your problem is elsewhere, not in the code you show.
Can you show more code
Dec 25, 2018
10
Level 2
Query failed getting error laravel 5.6
hi i want to run the query "SELECT * FROM users WHERE author = 'mubeen' AND name LIKE '%$veriable%' i am getting error like Object of class Symfony\Component\HttpFoundation\ParameterBag could not be converted to string.. Please help me
$query = $request->query;
$users = User::where([
['author', 'superAdmin'],
['name' ,'LIKE',"%$query%"],
])->orderBy('created_at','desc')->paginate(4);
Level 2
Level 2
<form action="{{route('user.search')}}" method="post">
@csrf
<input class="form-control search-top col-md-4 d-inline" type="text"
placeholder="Search By UserName" name="query" required>
<button type="submit" class="btn btn-sm btn-primary">Search</button>
</form>
Level 122
Assuming the error happens after you press submit thenit wont be the form. Show the full controller method and the view you show with results.
Level 2
@snapey this is my view here the form is going to submit with POST request
<div class="box_general">
<div class="header_box">
<h2 class="d-inline-block col-md-2">Users list</h2>
<form action="{{route('user.search')}}" method="POST">
@csrf
<input type="text" name="query" class="form-control" placeholder="Search By
UserName" required>
<button type="submit" class="btn btn-sm btn-primary">Search</button>
</form>
</div>
And here is my route
//user search by status route
Route::post('/results','usersController@searchingResults')->name('user.search');
and here is my controller method
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;
use Spatie\Permission\Traits\HasRoles;
use Auth;
use \App\superAdmin;
use DB;
use Illuminate\Support\Facades\Input;
use session;
class usersController extends Controller
{
use HasRoles;
//searching results method
public function searchingResults(Request $request)
{
$query = $request->query;
dd($query);
$users = User::where([
['author','=','mubeen'],
['name' ,'LIKE','%'.$query.'%'],
])->orderBy('created_at','desc')->paginate(4);
$roles = Role::where(
'author' , 'superAdmin'
)->get();
return view('BackEnd.users.searchResults',compact('users','query'));
}
Level 2
if i dd($request->query) i get
ParameterBag {#63 ▼
#parameters: []
}
Level 122
rename your input field to something other than query. I suspect you are conflicting with another request property
Level 2
@SNAPEY - i changed it is still not working
Level 2
@snapey i changed the name it works but i am not getting searching results even if i put the same name as in db ..i think this is due to wildcard please tell me the solution
Level 122
show your query now you have changed the search term.
Please or to participate in this conversation.