Hey there.. hope you are facing the same problem as I am facing to update the DB from phpMyAdmin.. and no ssh access from Cpanel to run the migration command on the terminal. And you are in the right place.. here is the solution to get the dump query from the Laravel migration file. Command: […]
How to get Column Name from a table in Laravel and PHP
Hey! what’s up? I am working on a SAAS application for my current company and facing the issue of sending emails, actually bad emails, those comply with the RFC. So that means basic email validation is not working from the Laravel side and we are processing emails to ‘example@gmail’ like email addresses (yes RFC allow […]
Run raw insert query or SQL file in Laravel seeder
Hi there, hope you are not in trouble with your application email sending feature. I am using mailtrap.io for email testing on the development server. It is good, but one problem is all email are going mailtrap’s Demo inbox, not to users individual email. And my client wants to check all email templates and functionality […]
Recently I am working on a project that need to access some external API. And it’s a Laravel project, so I am looking for some package that can save my time and meet the deadline too. I am using GuzzleHttp package for accessing external API and its really easy Installation: composer require guzzlehttp/guzzle:~6.0 Uses: […]
Very easy (পানির লাহান) 🙂 STEP – 1: First we have to ad a meta tag (name=”_token”) in header <meta name=”_token” content=”{{ csrf_token() }}” /> STEP – 2: Then add below jQuery snippet before the </body> tag. Basically here we setting up the csrf token globally for ajax request. And after this we don’t need to […]
Here I am trying to list all Laravel PHP Artisan commands one by one for my reference and your too. – To create and update table by migration php artisan make:migration Create_Table_Name -> create a new table php artisan make:migration Update_Table_Name_Column_Name -> update table php artisan make:migration Add_Column_Name_Table_Name -> add a new column to a table […]
We often need to define global variables/constants for our application, like Status, Conditions, Countries (we can put all countries in table as it will be along array/object), also weekdays, weekends and e.t.c. vary on projects. Status (Active, Inactive) and Conditions (Ok, Good, Better, Best) or Grade (F, C, D, A, A-, A+), so like these […]
We often need to debug large queries in Laravel. And laravel have built-in functions almost for everything. Here is a simple query in laravel for example. $data = User::where(‘status’, 1) ->select(‘name’, ‘username’, ‘email’, ‘password’) ->get(); but we want to see the sql query. So we have to use toSql() in the place of get() […]
