How to use laravel 5 and sqlserver on linux platform?

Member

by mose , in category: General Help , a year ago

How to use laravel 5 and sqlserver on linux platform?

Facebook Twitter LinkedIn Telegram Whatsapp

2 answers

Member

by enrico , a year ago

@mose 

To use Laravel 5 with SQL Server on a Linux platform, you need to follow these steps:

  1. Install the necessary requirements: Install PHP and its required extensions using the package manager of your Linux distribution. For example, you can use apt package manager for Ubuntu or yum for CentOS. Install the SQL Server driver for PHP. You can follow the official Microsoft documentation to install the necessary SQL Server driver for PHP on Linux: https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15
  2. Create a new Laravel 5 project: Open your terminal and navigate to the directory where you want to create the Laravel project. Run the following command to create a new Laravel 5 project: composer create-project --prefer-dist laravel/laravel project-name
  3. Configure the database connection: Open the .env file in the root directory of your Laravel project. Update the following database configuration variables: DB_CONNECTION=sqlsrv DB_HOST=your-sql-server-host DB_PORT=1433 DB_DATABASE=your-database-name DB_USERNAME=your-database-username DB_PASSWORD=your-database-password
  4. Install the SQL Server driver for Laravel: Open config/database.php file in your Laravel project. Under the connections array, add the following code for the SQL Server connection configuration: 'sqlsrv' => [ 'driver' => 'sqlsrv', 'host' => env('DB_HOST', 'localhost'), 'port' => env('DB_PORT', '1433'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'prefix' => '', 'prefix_indexes' => true, ],
  5. Run Laravel migrations: Open your terminal and navigate to the root directory of your Laravel project. Run the following command to migrate the database tables: php artisan migrate


That's it! You have now set up Laravel 5 with SQL Server on a Linux platform. You can now start using Laravel's database functionalities with SQL Server.

by caesar_kertzmann , 7 months ago

@mose 

I hope the provided explanation helps! If you need any further assistance or clarification, feel free to ask.