Skip to content

Instantly share code, notes, and snippets.

@empirefx
Last active July 27, 2019 23:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save empirefx/8527705981f94b069f5366dc06582678 to your computer and use it in GitHub Desktop.
Save empirefx/8527705981f94b069f5366dc06582678 to your computer and use it in GitHub Desktop.
Docker apache php mssql
FROM php:7.0-apache
COPY src/ /var/www/html/
# Add Microsoft repo for Microsoft ODBC Driver 13 for Linux
RUN apt-get update && apt-get install -y \
apt-transport-https \
gnupg \
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
&& curl https://packages.microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list \
&& apt-get update
# Install Dependencies
RUN ACCEPT_EULA=Y apt-get install -y \
unixodbc \
unixodbc-dev \
libgss3 \
odbcinst \
msodbcsql17 \
locales \
&& echo "en_US.UTF-8 UTF-8" > /etc/locale.gen && locale-gen
# Install pdo_sqlsrv and sqlsrv from PECL. Replace pdo_sqlsrv-4.1.8preview with preferred version.
RUN pecl install pdo_sqlsrv-5.3.0 sqlsrv-5.3.0 \
&& docker-php-ext-enable pdo_sqlsrv sqlsrv
<?php
//Test
$hostname='localhost,1433';
$dbname='DB';
$username='sa';
$password='pwd';
$dbDB = new PDO("sqlsrv:Server=$hostname;Database=$database", $username, $password);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment