Laravel 7 - Real Programmer

In Laravel

Laravel 7 Ckeditor Image Upload Example

June 22, 2020 2 Mins Read

Step 1: Install the laravel project using the command line. composer create-project –prefer-dist laravel/laravel laravel7Ckeditor Step 2: Open project in code and use vs code terminal. cd laravel7Ckeditor Step 3: find .env file in root directory setup database configuration. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database_name DB_USERNAME=database_username DB_PASSWORD=database_password Step 4: Route Open routes/web.php file. Route::get(‘/’, ‘CkeditorController@index’); Route::post(‘ckeditor/upload’, ‘CkeditorController@upload’)->name(‘ckeditor.upload’); Step 5: Controller Create CkeditorController Controller. php artisan make:controller CkeditorController Open app/Http/Controllers/CkeditorController.php file. <?php namespace App\Http\Controllers; use Illuminate\Http\Request; class CkeditorController…

In Laravel

Drag and Drop file upload using Dropzone in Laravel

June 20, 2020 2 Mins Read

https://youtu.be/vfuAPIYSYvc Step 1: Install the laravel project using the command line. composer create-project –prefer-dist laravel/laravel laravelDragDrop Step 2: Open project in code and use vs code terminal. cd laravelDragDrop Step 3: find .env file in root directory setup database configuration. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database_name DB_USERNAME=database_username DB_PASSWORD=database_password Step 4: Route Open routes/web.php file. Define 2 routes Route::get(‘image’, ‘DropzoneController@dropzone’); Route::post(‘dropzone/store’, ‘DropzoneController@dropzoneStore’)->name(‘dropzone.store’); Step 5: Controller Create DropzoneController Controller. php artisan make:controller DropzoneController Open app/Http/Controllers/DropzoneController.php file. <?php namespace App\Http\Controllers;…

In Laravel

Make Autocomplete search using jQuery UI in Laravel

June 19, 2020 4 Mins Read

https://www.youtube.com/watch?v=Xs_ohuTsdx8&ab_channel=Realprogrammer Step 1: Install the laravel project using the command line. composer create-project –prefer-dist laravel/laravel laravel7autocomplete Step 2: Open project in code and use vs code terminal. cd laravel7autocomplete Step 3: find .env file in root directory setup database configuration. DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database_name DB_USERNAME=database_username DB_PASSWORD=database_password Step 4: run Migration command php artisan make:migration create_category_table Now, navigate to database/migration/ directory from the project root.Find a PHP file which ends with create_category_table and open it. Define…

In Laravel

Removing html tags in Laravel blade

June 13, 2020 2 Mins Read

<?php $str = ‘Established in year 2007, Galaxy Computer is Wholesale Trader and Service Provider of <strong style=”color: #444444; font-family: arial;…

In Laravel

Laravel how to delete database record after created 7 days

June 2, 2020 1 Min Read

use Illuminate\Support\Carbon; $stale_posts = Test::where(‘updated_at’, ‘<‘, Carbon::now()->subDays(7))->get(); foreach ($stale_posts as $post) { $post->delete(); }

In Laravel

How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?

June 1, 2020 1 Min Read

In folder config => database.php make sure mysql strict is false, like this ‘mysql’ => [ ‘driver’ => ‘mysql’, ‘url’ => env(‘DATABASE_URL’), ‘host’ => env(‘DB_HOST’, ‘127.0.0.1’), ‘port’ => env(‘DB_PORT’, ‘3306’), ‘database’ => env(‘DB_DATABASE’, ‘forge’), ‘username’ => env(‘DB_USERNAME’, ‘forge’), ‘password’ => env(‘DB_PASSWORD’, ”), ‘unix_socket’ => env(‘DB_SOCKET’, ”), ‘charset’ => ‘utf8mb4’, ‘collation’ => ‘utf8mb4_unicode_ci’, ‘prefix’ => ”, ‘prefix_indexes’ => true, ‘strict’ => false, ‘engine’ => null, ‘options’ => extension_loaded(‘pdo_mysql’) ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env(‘MYSQL_ATTR_SSL_CA’), ]) : [], ], if strict is true, make it…

In Laravel

Load Blade assets with https in Laravel

May 31, 2020 1 Min Read

Here is my configuration to make HTTPS working with assets. To enable this in production add REDIRECT_HTTPS=true in the .env file. REDIRECT_HTTPS=true <?php namespace App\Providers; use Illuminate\Support\ServiceProvider; use Illuminate\Support\Facades\Schema; class AppServiceProvider extends ServiceProvider { /** * Bootstrap any application services. * * @return void */ public function boot() { if(env(‘REDIRECT_HTTPS’)) { \URL::forceScheme(‘https’); } Schema::defaultStringLength(191); } /** * Register any application services. * * @return void */ public function register() { // } }

In Laravel

How to Create Multiple Where Clause Query Using Laravel Eloquent?

May 29, 2020 1 Min Read

Conditions using Array: $users = User::where([ ‘column1’ => value1, ‘column2’ => value2, ‘column3’ => value3 ])->get();

In Laravel

Laravel Select join and subquery Example

May 25, 2020 1 Min Read

$data = DB::table(“productTesting”) ->select(“productTesting.*”,”categories.*”) ->join(DB::raw(“(SELECT categories.id, GROUP_CONCAT(categories.name) as categoriesName FROM categories GROUP BY categories.id ) as categories”),function($join){ $join->on(“categories.id”,”=”,”productTesting.categoryId”); }) ->groupBy(“productTesting.id”) ->get(); dd($data);

In Laravel

Laravel 7 Dynamically Add or Remove input fields using JQuery

May 20, 2020 4 Mins Read

Hey, Real Programmer, I will share with you how to add or remove dynamically input fields using jQuery with laravel validation.some times we need this type of functionality in our web application.like some module has the same information with different values, in this case, we should do this using add or remove input fields dynamically using jQuery in our HTML form. I created “tagslist” table and it’s model. I created a simple form and there…