Steps to be followed for installing Microsoft ODBC Driver v17, v18 For PHP For Sql Server on Ubuntu 20.04, 22.04

How to use these Modules

The code samples are available here

SQLSRV and PDO_SQLSRV drivers

• v5.10.0 supports PHP ^7.4.0 to ~8.1.0
• v5.11.1 supports PHP ~8.1.0 to ~8.2.0

Add Aptfile File

Aptfile file is mandatory, create a file called Aptfile in your project root folder and

• copy the content from v5.10.0 or download the file from v5.10.0
• copy the content from v5.11.1 or download the file from v5.11.1

to your project root folder.

Add Environment Variable For Extension Repositories

It must be set,

5.11.1 for PHP Driver for SQL Server

• Ubuntu 22.04
  • PHP 8.1

  $ heroku config:set HEROKU_PHP_PLATFORM_REPOSITORIES="https://github.com/heroku-softtrends/mssql-server-drivers-for-php/raw/main/5.11.1/ubuntu/22.04/php/8.1/nts/packages.json" -a <heroku_app_name>
  

  • PHP 8.2

  $ heroku config:set HEROKU_PHP_PLATFORM_REPOSITORIES="https://github.com/heroku-softtrends/mssql-server-drivers-for-php/raw/main/5.11.1/ubuntu/22.04/php/8.2/nts/packages.json" -a <heroku_app_name>
  

5.10.0 for PHP Driver for SQL Server

• Ubuntu 20.04
  • PHP 8.1

  $ heroku config:set HEROKU_PHP_PLATFORM_REPOSITORIES="https://github.com/heroku-softtrends/mssql-server-drivers-for-php/raw/main/5.10.0/ubuntu/20.04/php/8.1/nts/packages.json" -a <heroku_app_name>
  

  • PHP 8.0

  $ heroku config:set HEROKU_PHP_PLATFORM_REPOSITORIES="https://github.com/heroku-softtrends/mssql-server-drivers-for-php/raw/main/5.10.0/ubuntu/20.04/php/8.0/nts/packages.json" -a <heroku_app_name>
  

  • PHP 7.4

  $ heroku config:set HEROKU_PHP_PLATFORM_REPOSITORIES="https://github.com/heroku-softtrends/mssql-server-drivers-for-php/raw/main/5.10.0/ubuntu/20.04/php/7.4/nts/packages.json" -a <heroku_app_name>
  

Update your composer.json file

Add required dependencies(SQLSRV and PDO_SQLSRV drivers) to composer.json file

Drivers 5.11.1

• PHP 8.1

{
  "require": {
    "php": "~8.1.0",
    "ext-sqlsrv": "^5.11",
    "ext-pdo_sqlsrv": "^5.11"
  }
}

• PHP 8.2

{
  "require": {
    "php": "~8.2.0",
    "ext-sqlsrv": "^5.11",
    "ext-pdo_sqlsrv": "^5.11"
  }
}

Drivers 5.10.0

• PHP 8.1

{
  "require": {
    "php": "~8.1.0",
    "ext-sqlsrv": "^5.10",
    "ext-pdo_sqlsrv": "^5.10"
  }
}

• PHP 8.0

{
  "require": {
    "php": "~8.0.0",
    "ext-sqlsrv": "^5.10",
    "ext-pdo_sqlsrv": "^5.10"
  }
}

• PHP 7.4

{
  "require": {
    "php": "~7.4.0",
    "ext-sqlsrv": "^5.10",
    "ext-pdo_sqlsrv": "^5.10"
  }
}

After adding new dependencies to composer.json file, must be updated by running:

$ composer update --ignore-platform-reqs

Finally the composer.lock file will look like,

Drivers 5.11.1

• PHP 8.1

{
  "platform": {
    "php": "~8.1.0",
    "ext-pdo_sqlsrv": "^5.11",
    "ext-sqlsrv": "^5.11"
  }
}

• PHP 8.2

{
  "platform": {
    "php": "~8.2.0",
    "ext-sqlsrv": "^5.11",
    "ext-pdo_sqlsrv": "^5.11"
  }
}

Drivers 5.10.0

• PHP 8.1

{
  "platform": {
    "php": "~8.1.0",
    "ext-pdo_sqlsrv": "^5.10",
    "ext-sqlsrv": "^5.10"
  }
}

• PHP 8.0

{
  "platform": {
    "php": "~8.0.0",
    "ext-sqlsrv": "^5.10",
    "ext-pdo_sqlsrv": "^5.9"
  }
}

• PHP 7.4

{
  "platform": {
    "php": "~7.4.0",
    "ext-sqlsrv": "^5.10",
    "ext-pdo_sqlsrv": "^5.10"
  }
}

Add Buildpacks

• The first buildpak: https://github.com/heroku/heroku-buildpack-apt.git
• The second buildpack: https://github.com/heroku/heroku-buildpack-php.git
• The last buildpack: https://github.com/heroku-softtrends/heroku-php-sqlsrv-buildpack.git

Now deploy

$ git init
$ heroku git:remote -a <app_name>
$ git add --all
$ git commit -m "First commit"
$ git push heroku master

Finally, check that everything is working

$ heroku open -a <heroku_app_name>

References

Getting started with php

Heroku platform dependencies installation

Heroku php buildpack

SQLSRV and PDO_SQLSRV drivers for PHP 8.0+ releases