Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

 

Step: 1

Update your /app/Providers/AppServiceProvider.php to contain:

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}

Step: 2
in AppServiceProvider didn't work. Then editing the database.php file in config folder. Just edit 
/config/database.php
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
to
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
 

Step: 3
set the default database engine to 'InnoDB' on /config/database.php
'mysql' => [
    ...,
    ...,
    'engine' => 'InnoDB',
 ]

Auth Example Laravel 9

 

Step 1 – Install the Laravel 9 Project

Before creating this project, ensure you have the Laravel environment on your computer. Now open the windows terminal and run this command.

composer create-project laravel/laravel auth

Once Laravel is installed, then we will go to the next step

Step 2 – Configured Database

Use your database user name and password to the project

Step 3 – Creating Login and Registration Form

For the Authentication system, we need to know what is required to create a complete system. For this project, we need the login and registration form with some staff. In this Laravel auth project, we will use bootstrap to create a user’s login and registration form.

We need to run this command to add laravel login and registration to your project. Laravel has good optimization; you don’t have to do it manually. Laravel will do that for you. Now run this command.

composer requires laravel/ui

php artisan ui bootstrap –auth

After running this commends in our Laravel project, it will generate some controllers in your auth project directory. It will create a folder called Auth under app\Http\Controllers\Auththere you can find all stuff for your authentication system.

Here you can find

• ConfirmPasswordController.php
• ForgotPasswordController.php
• LoginController.php
• RegisterController.php
• ResetPasswordController.php
• VerificationController.php

Here you can modify it as per your project requested.

Also, it will make some views in your resource directory. It’s in the resources\views\auth folder.

Step 4 – Configure Bootstrap in Laravel 9

Now we will add Bootstrap 5 CDN to our project. For that, we have to go to the file resources\views\layouts\app.blade.php add these 2 lines

After that, it will look like this

Our view is ready. Now we have to go to the next step.

Step 5 – Run and Test the Project

Before we run the project, we need to migrate the database in our project. For that, we have to run this commend

php artisan migrate

Now we can run our project. For that, we have to run this commend

php artisan serve

Once the project runs, we can see the Login And Register button on our home page’s top right side.

Consolation

Finally, we created this project with laravel auth. Laravel authentication is very high. So don’t worry about the login security. Happy coding!!!

**************************

Thanks for https://linuxhint.com/laravel-9-auth-example/

Laravel Framework 9.x - Available commands

Usage:

  command [options] [arguments]

Options:

  -h, --help            Display help for the given command. When no command is given display help for the list command

  -q, --quiet           Do not output any message

  -V, --version         Display this application version

      --ansi|--no-ansi  Force (or disable --no-ansi) ANSI output

  -n, --no-interaction  Do not ask any interactive question

      --env[=ENV]       The environment the command should run under

  -v|vv|vvv, --verbose  Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Available commands:

  about                  Display basic information about your application

  clear-compiled         Remove the compiled class file

  completion             Dump the shell completion script

  db                     Start a new database CLI session

  docs                   Access the Laravel documentation

  down                   Put the application into maintenance / demo mode

  env                    Display the current framework environment

  help                   Display help for a command

  inspire                Display an inspiring quote

  list                   List commands

  migrate                Run the database migrations

  optimize               Cache the framework bootstrap files

  serve                  Serve the application on the PHP development server

  test                   Run the application tests

  tinker                 Interact with your application

  up                     Bring the application out of maintenance mode

 auth

  auth:clear-resets      Flush expired password reset tokens

 cache

  cache:clear            Flush the application cache

  cache:forget           Remove an item from the cache

  cache:table            Create a migration for the cache database table

 config

  config:cache           Create a cache file for faster configuration loading

  config:clear           Remove the configuration cache file

 db

  db:monitor             Monitor the number of connections on the specified database

  db:seed                Seed the database with records

  db:show                Display information about the given database

  db:table               Display information about the given database table

  db:wipe                Drop all tables, views, and types

 env

  env:decrypt            Decrypt an environment file

  env:encrypt            Encrypt an environment file

 event

  event:cache            Discover and cache the application's events and listeners

  event:clear            Clear all cached events and listeners

  event:generate         Generate the missing events and listeners based on registration

  event:list             List the application's events and listeners

 key

  key:generate           Set the application key

 make

  make:cast              Create a new custom Eloquent cast class

  make:channel           Create a new channel class

  make:command           Create a new Artisan command

  make:component         Create a new view component class

  make:controller        Create a new controller class

  make:event             Create a new event class

  make:exception         Create a new custom exception class

  make:factory           Create a new model factory

  make:job               Create a new job class

  make:listener          Create a new event listener class

  make:mail              Create a new email class

  make:middleware        Create a new middleware class

  make:migration         Create a new migration file

  make:model             Create a new Eloquent model class

  make:notification      Create a new notification class

  make:observer          Create a new observer class

  make:policy            Create a new policy class

  make:provider          Create a new service provider class

  make:request           Create a new form request class

  make:resource          Create a new resource

  make:rule              Create a new validation rule

  make:scope             Create a new scope class

  make:seeder            Create a new seeder class

  make:test              Create a new test class

 migrate

  migrate:fresh          Drop all tables and re-run all migrations

  migrate:install        Create the migration repository

  migrate:refresh        Reset and re-run all migrations

  migrate:reset          Rollback all database migrations

  migrate:rollback       Rollback the last database migration

  migrate:status         Show the status of each migration

 model

  model:prune            Prune models that are no longer needed

  model:show             Show information about an Eloquent model

 notifications

  notifications:table    Create a migration for the notifications table

 optimize

  optimize:clear         Remove the cached bootstrap files

 package

  package:discover       Rebuild the cached package manifest

 queue

  queue:batches-table    Create a migration for the batches database table

  queue:clear            Delete all of the jobs from the specified queue

  queue:failed           List all of the failed queue jobs

  queue:failed-table     Create a migration for the failed queue jobs database table

  queue:flush            Flush all of the failed queue jobs

  queue:forget           Delete a failed queue job

  queue:listen           Listen to a given queue

  queue:monitor          Monitor the size of the specified queues

  queue:prune-batches    Prune stale entries from the batches database

  queue:prune-failed     Prune stale entries from the failed jobs table

  queue:restart          Restart queue worker daemons after their current job

  queue:retry            Retry a failed queue job

  queue:retry-batch      Retry the failed jobs for a batch

  queue:table            Create a migration for the queue jobs database table

  queue:work             Start processing jobs on the queue as a daemon

 route

  route:cache            Create a route cache file for faster route registration

  route:clear            Remove the route cache file

  route:list             List all registered routes

 sail

  sail:install           Install Laravel Sail's default Docker Compose file

  sail:publish           Publish the Laravel Sail Docker files

 sanctum

  sanctum:prune-expired  Prune tokens expired for more than specified number of hours.

 schedule

  schedule:clear-cache   Delete the cached mutex files created by scheduler

  schedule:list          List the scheduled commands

  schedule:run           Run the scheduled commands

  schedule:test          Run a scheduled command

  schedule:work          Start the schedule worker

 schema

  schema:dump            Dump the given database schema

 session

  session:table          Create a migration for the session database table

 storage

  storage:link           Create the symbolic links configured for the application

 stub

  stub:publish           Publish all stubs that are available for customization

 vendor

  vendor:publish         Publish any publishable assets from vendor packages

 view

  view:cache             Compile all of the application's Blade templates

  view:clear             Clear all compiled view files

Laravel 9 Update /Features

 

For more Details Click Here

How to embed Google Forms on any Website ?

Google Forms are one of the most famous online platform developed and supported by Google. One can create and customize the created forms and can perform various tasks from review to automatic certificate generator. One can also embed it on a website so that anyone visiting the website can submit or view the form. This article will describe the method to embed a Google Form to any website.

Step 1: 

Create a Google Form that has to be embedded. The How to Create and Customize Google Forms? article has the steps needed to create and customize Google Forms as per the requirements.

Step 2:

After the form has been created, click on the Send button as shown in the image below.

Step 3: 

Select the embed option from the available options of sending. This would show an <iframe> link that has to be copied.

Step 4: 

Add this <iframe> link in the HTML source code of the page where the form has to be embedded. This will automatically display the form and allow it to be filled on the page itself. The example below illustrates how the form has to be embedded.

Example:

• HTML

<!DOCTYPE html> <html>    <body>     <h1 style="color: green;">         GeeksforGeeks     </h1>        <p>         How to embed Google Forms          on any website?     </p>           <!-- Specify the <iframe> given by the         the Google Forms embed page -->     <iframe src="Your Copied Form Source"          width="550" height="600"          frameborder="0" marginheight="0"         marginwidth="0">         Loading…     </iframe> </body>    </html>

Thank you:

https://www.geeksforgeeks.org/how-to-embed-google-forms-on-any-website/