Developer Solution

Get All MySql user list using command

Get link
Facebook
X
Pinterest
Email
Other Apps

April 01, 2024

Login using Below command

mysql -u root -p

After login type below command to know complete mysql User List

SELECT User, Host FROM mysql.user;

Mysql

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Replace Array Value using key in laravel

March 13, 2024

below code is example for change or replace the value of array using key. $parameter = [10, 20]; i have to change 20 to 69 then below is the code $a2 = [ "1" => 69 ]; $parameters = array_replace ( $parameters , $a2 ); Final result will be $parameter = [10, 69];

Group by Provider ID of Logged in User in Laravel

March 16, 2024

To adjust the query to accommodate transactions where the status_id is either 1 or 6, you can use the whereIn method provided by Laravel's Query Builder. This method allows you to specify an array of values that the status_id column must match. Here's how you can modify the getTransactionAggregates method in your controller to include this logic: namespace App\Http\Controllers; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; class TransactionController extends Controller { public function getTransactionAggregates($user_id, Request $request) { $startDate = $request->query('startDate'); $endDate = $request->query('endDate'); $transactionAggregates = DB::table('reports') ->where('reports.user_id', $user_id) ->join('providers', 'reports.provider_id', '=', 'providers.id') ->whereBetween('reports.created_at...

Name Validation in Laravel

March 22, 2024

Alphabetic and Spaces Names often contain spaces (e.g., first and last names). To allow alphabetic characters and spaces: $request->validate([ 'name' => 'required|regex:/^[a-zA-Z\s]*$/', ]); Including Dashes and Apostrophes Some names might include dashes or apostrophes. You can adjust the regular expression to allow these: $request->validate([ 'name' => 'required|regex:/^[a-zA-Z\s\'\-]*$/', ]);