Thursday, August 26, 2021

XAMPP - MySQL shutdown unexpectedly

 


SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.





STOP ! Please do NOT delete the ibdata1 file!

Deleting this file is like playing Russian roulette with your databases. It could work and establish everything, but also, probably could leave every database you have.

Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:

  1. Rename the folder mysql/data to mysql/data_old (you can use any name)

  2. Create a new folder mysql/data

  3. Copy the content that resides in mysql/backup to the new mysql/data folder

  4. Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)

  5. Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder

  6. Start MySQL from XAMPP control panel

And, voilĂ !


Laravel with App Engine Standard Class 'Facade\Ignition\IgnitionServiceProvider' not found [SOLVED]

 

Laravel with App Engine Standard Class 'Facade\Ignition\IgnitionServiceProvider' not found [SOLVED]




composer remove --dev facade/ignition helped in my case  



ErrorException (E_NOTICE) Undefined index: name laravel 7


I think I had the exact same error the other day, and for me, the solution was to downgrade the composer with:

composer self-update --1


#laravel #error


Laravel 8 CRUD Application Tutorial for Beginners

 

Laravel 8 CRUD Application Tutorial for Beginners

 

In this tutorial, I would like to show you a laravel 8 crud operation example. We will implement a laravel 8 crud application for beginners. I will give you a simple example of how to create crud in laravel 8. you will learn crud operation in laravel 8.

So, let's follow a few steps to create an example of laravel 8 crud application tutorial.

Laravel 8 was just released yesterday, Laravel 8 gives several new features and LTS support. So if you are new to laravel then this tutorial will help you create insert update delete application in laravel 8.

You just need to follow a few steps and you will get basic crud stuff using controller, model, route, bootstrap 4 and blade..

In this tutorial, you will learn very basic crud operation with laravel new version 6. I am going to show you step by step from scratch, so I will better understand if you are new to laravel.


tep 1 : Install Laravel 8

first of all we need to get fresh Laravel 8 version application using bellow command, So open your terminal OR command prompt and run bellow command:

composer create-project --prefer-dist laravel/laravel blog



Step 2: Database Configuration

In second step, we will make database configuration for example database name, username, password etc for our crud application of laravel 8. So let's open .env file and fill all details like as bellow:

.env

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name(blog)

DB_USERNAME=here database username(root)

DB_PASSWORD=here database password(root)


Step 3: Create Migration

we are going to create crud application for product. so we have to create migration for "products" table using Laravel 8 php artisan command, so first fire bellow command:

php artisan make:migration create_products_table --create=products


After this command you will find one file in following path "database/migrations" and you have to put bellow code in your migration file for create products table.

<?php

 use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

 class CreateProductsTable extends Migration

{

   /**

    * Run the migrations.

    *

    * @return void

    */

   public function up()

   {

       Schema::create('products', function (Blueprint $table) {

           $table->id();

           $table->string('name');

           $table->text('detail');

           $table->timestamps();

       });

   }

    /**

    * Reverse the migrations.

    *

    * @return void

    */

   public function down()

   {

       Schema::dropIfExists('products');

   }

}

Now you have to run this migration by following command:

php artisan migrate

Step 4: Add Resource Route

Here, we need to add resource route for product crud application. so open your "routes/web.php" file and add following route.

routes/web.php

use App\Http\Controllers\ProductController;

 Route::resource('products', ProductController::class);

Step 5: Add Controller and Model

In this step, now we should create new controller as ProductController. So run bellow command and create new controller. bellow controller for create resource controller.

php artisan make:controller ProductController --resource --model=Product

After bellow command you will find new file in this path "app/Http/Controllers/ProductController.php".

In this controller will create seven methods by default as bellow methods:

1)index()

2)create()

3)store()

4)show()

5)edit()

6)update()

7)destroy()

So, let's copy bellow code and put on ProductController.php file.

app/Http/Controllers/ProductController.php

<?php

 namespace App\Http\Controllers;

 

use App\Models\Product;

use Illuminate\Http\Request;

 class ProductController extends Controller

{

   /**

    * Display a listing of the resource.

    *

    * @return \Illuminate\Http\Response

    */

   public function index()

   {

       $products = Product::latest()->paginate(5);

  

       return view('products.index',compact('products'))

           ->with('i', (request()->input('page', 1) - 1) * 5);

   }

   

   /**

    * Show the form for creating a new resource.

    *

    * @return \Illuminate\Http\Response

    */

   public function create()

   {

       return view('products.create');

   }

  

   /**

    * Store a newly created resource in storage.

    *

    * @param  \Illuminate\Http\Request  $request

    * @return \Illuminate\Http\Response

    */

   public function store(Request $request)

   {

       $request->validate([

           'name' => 'required',

           'detail' => 'required',

       ]);

  

       Product::create($request->all());

   

       return redirect()->route('products.index')

                       ->with('success','Product created successfully.');

   }

   

   /**

    * Display the specified resource.

    *

    * @param  \App\Product  $product

    * @return \Illuminate\Http\Response

    */

   public function show(Product $product)

   {

       return view('products.show',compact('product'));

   }

   

   /**

    * Show the form for editing the specified resource.

    *

    * @param  \App\Product  $product

    * @return \Illuminate\Http\Response

    */

   public function edit(Product $product)

   {

       return view('products.edit',compact('product'));

   }

  

   /**

    * Update the specified resource in storage.

    *

    * @param  \Illuminate\Http\Request  $request

    * @param  \App\Product  $product

    * @return \Illuminate\Http\Response

    */

   public function update(Request $request, Product $product)

   {

       $request->validate([

           'name' => 'required',

           'detail' => 'required',

       ]);

  

       $product->update($request->all());

  

       return redirect()->route('products.index')

                       ->with('success','Product updated successfully');

   }

  

   /**

    * Remove the specified resource from storage.

    *

    * @param  \App\Product  $product

    * @return \Illuminate\Http\Response

    */

   public function destroy(Product $product)

   {

       $product->delete();

  

       return redirect()->route('products.index')

                       ->with('success','Product deleted successfully');

   }

}

Ok, so after run bellow command you will find "app/Models/Product.php" and put bellow content in Product.php file:

app/Models/Product.php

<?php

 namespace App\Models;

 use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

 class Product extends Model

{

   use HasFactory;

    protected $fillable = [

       'name', 'detail'

   ];

}

Step 6: Add Blade Files

In last step. In this step we have to create just blade files. So mainly we have to create layout file and then create new folder "products" then create blade files of crud app. So finally you have to create following bellow blade file:

1) layout.blade.php

2) index.blade.php

3) create.blade.php

4) edit.blade.php

5) show.blade.php

So let's just create following file and put bellow code.

resources/views/products/layout.blade.php

<!DOCTYPE html>

<html>

<head>

   <title>Laravel 8 CRUD Application - ItSolutionStuff.com</title>

   <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet">

</head>

<body>

 <div class="container">

   @yield('content')

</div>

 

</body>

</html>

resources/views/products/index.blade.php

@extends('products.layout')

@section('content')

   <div class="row">

       <div class="col-lg-12 margin-tb">

           <div class="pull-left">

               <h2>Laravel 8 CRUD Example from scratch - ItSolutionStuff.com</h2>

           </div>

           <div class="pull-right">

               <a class="btn btn-success" href="{{ route('products.create') }}"> Create New Product</a>

           </div>

       </div>

   </div>

 

   @if ($message = Session::get('success'))

       <div class="alert alert-success">

           <p>{{ $message }}</p>

       </div>

   @endif

 

   <table class="table table-bordered">

       <tr>

           <th>No</th>

           <th>Name</th>

           <th>Details</th>

           <th width="280px">Action</th>

       </tr>

       @foreach ($products as $product)

       <tr>

           <td>{{ ++$i }}</td>

           <td>{{ $product->name }}</td>

           <td>{{ $product->detail }}</td>

           <td>

               <form action="{{ route('products.destroy',$product->id) }}" method="POST">

 

                   <a class="btn btn-info" href="{{ route('products.show',$product->id) }}">Show</a>

  

                   <a class="btn btn-primary" href="{{ route('products.edit',$product->id) }}">Edit</a>

 

                   @csrf

                   @method('DELETE')

    

                   <button type="submit" class="btn btn-danger">Delete</button>

               </form>

           </td>

       </tr>

       @endforeach

   </table>

    {!! $products->links() !!}

    

@endsection

resources/views/products/create.blade.php

@extends('products.layout')

 @section('content')

<div class="row">

   <div class="col-lg-12 margin-tb">

       <div class="pull-left">

           <h2>Add New Product</h2>

       </div>

       <div class="pull-right">

           <a class="btn btn-primary" href="{{ route('products.index') }}"> Back</a>

       </div>

   </div>

</div>

 

@if ($errors->any())

   <div class="alert alert-danger">

       <strong>Whoops!</strong> There were some problems with your input.<br><br>

       <ul>

           @foreach ($errors->all() as $error)

               <li>{{ $error }}</li>

           @endforeach

       </ul>

   </div>

@endif

 

<form action="{{ route('products.store') }}" method="POST">

   @csrf

     <div class="row">

       <div class="col-xs-12 col-sm-12 col-md-12">

           <div class="form-group">

               <strong>Name:</strong>

               <input type="text" name="name" class="form-control" placeholder="Name">

           </div>

       </div>

       <div class="col-xs-12 col-sm-12 col-md-12">

           <div class="form-group">

               <strong>Detail:</strong>

               <textarea class="form-control" style="height:150px" name="detail" placeholder="Detail"></textarea>

           </div>

       </div>

       <div class="col-xs-12 col-sm-12 col-md-12 text-center">

               <button type="submit" class="btn btn-primary">Submit</button>

       </div>

   </div>

 

</form>

@endsection

resources/views/products/edit.blade.php

@extends('products.layout')

 

@section('content')

   <div class="row">

       <div class="col-lg-12 margin-tb">

           <div class="pull-left">

               <h2>Edit Product</h2>

           </div>

           <div class="pull-right">

               <a class="btn btn-primary" href="{{ route('products.index') }}"> Back</a>

           </div>

       </div>

   </div>

 

   @if ($errors->any())

       <div class="alert alert-danger">

           <strong>Whoops!</strong> There were some problems with your input.<br><br>

           <ul>

               @foreach ($errors->all() as $error)

                   <li>{{ $error }}</li>

               @endforeach

           </ul>

       </div>

   @endif

    <form action="{{ route('products.update',$product->id) }}" method="POST">

       @csrf

       @method('PUT')

 

        <div class="row">

           <div class="col-xs-12 col-sm-12 col-md-12">

               <div class="form-group">

                   <strong>Name:</strong>

                   <input type="text" name="name" value="{{ $product->name }}" class="form-control" placeholder="Name">

               </div>

           </div>

           <div class="col-xs-12 col-sm-12 col-md-12">

               <div class="form-group">

                   <strong>Detail:</strong>

                   <textarea class="form-control" style="height:150px" name="detail" placeholder="Detail">{{ $product->detail }}</textarea>

               </div>

           </div>

           <div class="col-xs-12 col-sm-12 col-md-12 text-center">

             <button type="submit" class="btn btn-primary">Submit</button>

           </div>

       </div>

 

   </form>

@endsection

resources/views/products/show.blade.php

@extends('products.layout')

 @section('content')

   <div class="row">

       <div class="col-lg-12 margin-tb">

           <div class="pull-left">

               <h2> Show Product</h2>

           </div>

           <div class="pull-right">

               <a class="btn btn-primary" href="{{ route('products.index') }}"> Back</a>

           </div>

       </div>

   </div>

 

   <div class="row">

       <div class="col-xs-12 col-sm-12 col-md-12">

           <div class="form-group">

               <strong>Name:</strong>

               {{ $product->name }}

           </div>

       </div>

       <div class="col-xs-12 col-sm-12 col-md-12">

           <div class="form-group">

               <strong>Details:</strong>

               {{ $product->detail }}

           </div>

       </div>

   </div>

@endsection

Now we are ready to run our crud application example with laravel 8 so run bellow command for quick run:

php artisan serve


http://localhost:8000/products



How to Host a Laravel Project on Hostinger’s hPanel: A Step-by-Step Guide

How to Host a Laravel Project on Hostinger’s hPanel: A Step-by-Step Guide If you're looking to host a Laravel project on Hostinger’s hPa...