Laravel find string in table and columns

 This code will iterate to all tables and columns$excludedColumns = array("created_at", "updated_at", "deleted_at","order","key");$tables = DB::select('SHOW TABLES');foreach ($tables as $table) { $tableName = data_get($table,'Tables_in_XXXX',''); $columns = Schema::getColumnListing($tableName); foreach ($columns as $column) { if (!in_array($column, $excludedColumns)) { ...

Read More

Laravel Cache on Redis

Deleting laravel cache when redis is applied Assuming the Laravel cache used redis$roles = Cache::store('redis')->rememberForever( "roles-123456", function () { return Role::where('team_id', 12345) ->get(); });Cache can only be cleared byCache::store('redis')->forget("roles-123456...

Read More

Laravel Rule Validations

Laravel validations$errorMessage = "NFL Competition already exist for year $this->year and with the selected competition type.";return [    'name' => 'string',    'abbreviation' => 'required|max:10',    'year' => 'required|digits:4|integer|min:1900|max:' . (date('Y') + 1),    'competition_type_id' => ['required', 'string', new IsCompositeUnique('basketball_competitions',...

Read More

Laravel Nova ReadOnly Problems

 On Laravel Nova,   when creating record field with readonly and default values are not submitted.  This is the correct way to work around it.Text::make("Field Name", 'field_name') ->withMeta( [ 'extraAttributes' => ['readonly' => true], 'value' => $this->field_name ?? 'Default Value' ]),&nb...

Read More

PHP Regex Sample Code

A regular expression (shortened as regex or regexp or rational expression) is a sequence of characters that specifies a search pattern in the text.A good testing site is https://infoheap.com/php-preg_match-online/ Examples of regex for passwordPHP Version/^(?=.*\\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[a-zA-Z])(?=\S*[\W]).{8,}$/Must have special characters(?=\S*[\W])Must have a number(?=.*\\d)Must...

Read More

Installing Laravel Command

<pre><code> composer global require laravel/installerecho 'export PATH="$HOME/.composer/vendor/bin:$PATH"' >> ~/.zshrc source ~/.zshrc</code></pre&...

Read More

Laravel Blade versioning for CSS or JS files

It will be a good idea to create css and js versioning for easy loading and somehow for changes to take effect. You can add these code in your blade layout for your laravel project ...

Read More