You need to escape the call to FIND_IN_SET() using quotes: $query = DB::table(‘tags_value’) ->whereRaw(‘FIND_IN_SET(“css”, Tags)’) ->get(); But unless it’s a fixed value, you should always parameterize the column for which you search in FIND_IN_SET: $searchvalue=”css”; $query = DB::table(‘tags_value’) ->whereRaw(‘FIND_IN_SET(?, Tags)’, [$searchvalue]) ->get();
I recently did this. My solution was to set the session value when a user logs in. Then I had a small class checking if the session ID stored is the same as the current user who is logged in. If the user logs in from somewhere else the session ID in the DB will … Read more
Update 2022 For those who prefer Vite, there’s a tool called Laravel Vite which is a project based on PHP package, Vite plugin and preset, you could install it as follows : npx @preset/cli apply laravel:vite This removes the default config in the Laravel fresh project. For further details please check the different section in … Read more
The problem is you generated a new APP_KEY, then if you try to decrypt the old encrypted data it will show the DecryptException: The MAC is invalid. If you want to decrypt the old data you need to restore your old APP_KEY. After realizing that, now, adding a new problem there, if you stored new … Read more
A NotFoundHttpException exception in Laravel always means that it was not able to find a router for a particular URL. And in your case this is probably a problem in your web server configuration, virtual host (site) configuratio, or .htaccess configuration. Your public/.htaccess should look like this: <IfModule mod_rewrite.c> <IfModule mod_negotiation.c> Options -MultiViews </IfModule> RewriteEngine … Read more
Error 403 /broadcasting/auth with Laravel version > 5.3 & Pusher, you need to change your code in resources/assets/js/bootstrap.js with window.Echo = new Echo({ broadcaster: ‘pusher’, key: ‘your key’, cluster: ‘your cluster’, encrypted: true, auth: { headers: { Authorization: ‘Bearer ‘ + YourTokenLogin }, }, }); And in app/Providers/BroadcastServiceProvider.php, replace Broadcast::routes() with Broadcast::routes([‘middleware’ => [‘auth:api’]]); or … Read more
Try to change the folder permissions for the storage folder using the terminal: chmod -R 777 storage More info on this matter can be found here.
I found a good solution on Laracast and added some customization to the mix. The Code /** * Test first_name validation rules * * @return void */ public function test_valid_first_name() { $this->assertTrue($this->validateField(‘first_name’, ‘jon’)); $this->assertTrue($this->validateField(‘first_name’, ‘jo’)); $this->assertFalse($this->validateField(‘first_name’, ‘j’)); $this->assertFalse($this->validateField(‘first_name’, ”)); $this->assertFalse($this->validateField(‘first_name’, ‘1’)); $this->assertFalse($this->validateField(‘first_name’, ‘jon1’)); } /** * Check a field and value against validation rule * … Read more
Seems like your Laravel app is accesible via an Apache HTTP alias, because your URL looks like: http://localhost/laravel/. If this is the case and assuming that http://localhost/laravel is pointing to your public directory, then follow these steps: Try to navigate to your expected route prepend it with /index.php/, in your case: http://localhost/laravel/index.php/users. If it works … Read more
Check if model got saved save() will return a boolean, saved or not saved. So you can either do: $saved = $myModel->save(); if(!$saved){ App::abort(500, ‘Error’); } Or directly save in the if: if(!$myModel->save()){ App::abort(500, ‘Error’); } Note that it doesn’t make sense to call save() two times in a row like in your example. And … Read more