CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

08 May, 2024

Rule::array() and whereJsonOverlaps() for MySQL in Laravel 11.7

 Programing Coderfunda     May 08, 2024     No comments   

---



This week, the Laravel team released v11.7, with a Rule::array() validation method, a whereJsonOverlaps() method for MySQL, a Slack OpenID provider for Laravel Socialite, and more.


Introduce the Rule::array() Method




Jakub Potocký contributed the Rule::array() method used to validate multiple array keys using the array validation rule. This method enables using this rule with arrays and collections without having the concatenate dynamic values:
use Illuminate\Validation\Rule;

// Before
['array:' . MyBackedEnum::VALUE->value . ',' . MyBackedEnum::VALUE_2->value];

// After examples
Rule::array('key_1', 'key_2', 'key_3');
Rule::array(['key_1', 'key_2', 'key_3']);
Rule::array(collect(['key_1', 'key_2', 'key_3']));
Rule::array([UnitEnum::key_1, UnitEnum::key_2, UnitEnum::key_3]);
Rule::array([BackedEnum::key_1, BackedEnum::key_2, BackedEnum::key_3]);



See Pull Request #51250 for full details.


Stringable Support in blank() and filled() Helpers




Stefan R. contributed support for Stringable values in the blank() and filled() helpers:
// true
filled(str('FooBar '));

// true
blank(str(' '));



Add "whereJsonOverlaps()" for MySQL




Benjamin Ayles contributed support for MySQL's json_overlaps feature that compares two JSON documents:
User::whereJsonOverlaps('languages', ['en', 'fr'])->exists();
User::whereJsonDoesntOverlap('languages', ['en', 'fr'])->exists();



See Pull Request #51288 for more details and discussion.


Add PasswordResetLinkSent Event




Matt Jones contributed a new event called PasswordResetLinkSent which fires when a password reset link is sent. See Pull Request #51253 for more details.


Laravel Socialite Provider for Slack OpenID




Maarten Paauw contributed a separate Slack OpenID provider for Laravel Socialite. See Pull Request #704 for details and links to the Slack documentation.


Release notes




You can see the complete list of new features and updates below and the diff between 11.6.0 and 11.7.0 on GitHub. The following release notes are directly from the changelog:


v11.7.0






* [11.x] Fix SesV2Transport to use correct EmailTags argument by @Tietew in
https://github.com/laravel/framework/pull/51265 />

* [11.x] Add Databases nightly workflow by @Jubeki in
https://github.com/laravel/framework/pull/51218 />

* [11.x] update "min" and "max" rule comments by @browner12 in
https://github.com/laravel/framework/pull/51274 />

* [11.x] Fix namespace and improvement PSR in ClassMakeCommandTest.php by @saMahmoudzadeh in
https://github.com/laravel/framework/pull/51280 />

* [11.x] improvement test coverage for view components. by @saMahmoudzadeh in
https://github.com/laravel/framework/pull/51271 />

* [11.x] Introduce method Rule::array() by @Jacobs63 in
https://github.com/laravel/framework/pull/51250 />

* [11.x] Fix docblock for collection pluck methods by @SanderMuller in
https://github.com/laravel/framework/pull/51295 />

* [11.x] Add tests for handling non-baked enum and empty string requests by @hrant1020 in
https://github.com/laravel/framework/pull/51289 />

* blank and filled now support stringable by @lava83 in
https://github.com/laravel/framework/pull/51300 />

* [11.x] Fix ratio validation for high ratio images by @ahmedbally in
https://github.com/laravel/framework/pull/51296 />

* [11.x] Add int|float support to e method by @trippo in
https://github.com/laravel/framework/pull/51314 />

* [11.x] Add release notes by @driesvints in
https://github.com/laravel/framework/pull/51310 />

* [11.x] Stringable is also an interface of symfony by @lava83 in
https://github.com/laravel/framework/pull/51309 />

* [11.x] Add some tests and improvement test coverage for Str::camel by @saMahmoudzadeh in
https://github.com/laravel/framework/pull/51308 />

* [11.x] Using the ?? Operator (Null Coalescing Operator) by @saMahmoudzadeh in
https://github.com/laravel/framework/pull/51305 />

* [11.x] Add ability to override the default loading cached Routes for application by @ahmedabdel3al in
https://github.com/laravel/framework/pull/51292 />

* [11.x] Add ->whereJsonOverlaps() for mysql by @parkourben99 in
https://github.com/laravel/framework/pull/51288 />

* [11.x] Add InteractsWithInput methods to ValidatedInput by @aydinfatih in
https://github.com/laravel/framework/pull/51316 />

* [11.x] Adding PasswordResetLinkSent event by @Muffinman in
https://github.com/laravel/framework/pull/51253 />






The post Rule::array() and whereJsonOverlaps() for MySQL in Laravel 11.7 appeared first on Laravel News.


Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • Spatie Laravel Flash Package Freek Van der Herten of Spatie released a lightweight package to flash messages in your Laravel apps: This is a lightweight package to send fla… Read More
  • Laravel Vouchers Laravel Vouchers is a package by Marcel Pociot that allows users to redeem vouchers that are bound to models: This package can associate vouche… Read More
  • Laravel Postal Code Validation Postal code validation for multiple countries can always be a pain, but thanks to the Laravel Postal Code Validation package by Choraimy Kroonst… Read More
  • Laravel Personal Data Export Freek Van der Herten released a Spatie package called Laravel Personal Data Export last week to help you create zip files containing personal … Read More
  • GitDown Parsing Markdown in PHP GitDown is a simple package for parsing (GitHub-flavored) Markdown in PHP by Caleb Porzio. It works by sending the provided markdown to a publ… Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Spring boot app (error: method getFirst()) failed to run at local machine, but can run on server
    The Spring boot app can run on the online server. Now, we want to replicate the same app at the local machine but the Spring boot jar file f...
  • Log activity in a Laravel app with Spatie/Laravel-Activitylog
      Requirements This package needs PHP 8.1+ and Laravel 9.0 or higher. The latest version of this package needs PHP 8.2+ and Laravel 8 or hig...
  • Vue3 :style backgroundImage not working with require
    I'm trying to migrate a Vue 2 project to Vue 3. In Vue 2 I used v-bind style as follow: In Vue 3 this doesn't work... I tried a...
  • Laravel auth login with phone or email
          <?php     Laravel auth login with phone or email     <? php     namespace App \ Http \ Controllers \ Auth ;         use ...
  • Enabling authentication in swagger
    I created a asp.net core empty project running on .net6. I am coming across an issue when I am trying to enable authentication in swagger. S...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh - 9/21/2024
  • pyspark XPath Query Returns Lists Omitting Missing Values Instead of Including None - 9/20/2024
  • SQL REPL from within Python/Sqlalchemy/Psychopg2 - 9/20/2024
  • MySql Explain with Tobias Petry - 9/20/2024
  • How to combine information from different devices into one common abstract virtual disk? [closed] - 9/20/2024

Laravel News

  • Sublime Text Releases Update With Support for Right Sidebar - 5/22/2025
  • Enhance Email Validation with Laravel's Fluent Email Rule Object - 5/18/2025
  • Locale-aware Number Parsing in Laravel 12.15 - 5/21/2025
  • Handle Fluent Values as Arrays with Laravel's array() Method - 5/18/2025
  • Chargebee Starter Kit for Billing in Laravel - 5/20/2025

Copyright © 2025 CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda