Import - Export Excel & CSV File

Author Tuantq

---

How to clone project

• Clone the repository: git clone https://github.com/tqt97/import-excel-to-db-in-laravel
• Go to the folder application using cd command on your cmd or terminal cd import-excel-to-db-in-laravel
• Run composer install on your cmd or terminal
• Copy .env.example file to .env on the root folder. You can type copy .env.example .env if using command prompt Windows or cp .env.example .env if using terminal, Ubuntu
• Open your .env file and change the database name (DB_DATABASE) to whatever you have, username (DB_USERNAME) and password (DB_PASSWORD) field correspond to your configuration.
• Run php artisan key:generate
• Run php artisan migrate:fresh --seed
• Run npm run dev
• Run php artisan serve
• Go to http://127.0.0.1:8000
• You can see the application running.

---

Aliases in cmd/command

alias pa='php artisan $1'
alias pas='php artisan serve'
alias pam='php artisan make:model $1'
alias pac='php artisan make:controller $1'
alias pamm='php artisan make:migration $1'
alias pamg='php artisan migrate'
alias pamgfs='php artisan migrate:fresh --seed'
alias pao='php artisan optimize:clear'
alias pak='php artisan key:generate'
alias nrd='npm run dev'
alias nrb='npm run build'
alias ci='composer install'
alias c='composer $1'
alias envc='cp .env.example .env'
alias par='php artisan make:request $1'
alias pammdl='php artisan make:middleware $1'
alias cl='clear'
alias pamsrc='php artisan make:resource $1'

About Laravel

Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as:

• Simple, fast routing engine.
• Powerful dependency injection container.
• Multiple back-ends for session and cache storage.
• Expressive, intuitive database ORM.
• Database agnostic schema migrations.
• Robust background job processing.
• Real-time event broadcasting.

Laravel is accessible, powerful, and provides tools required for large, robust applications.