Public Repository

Last pushed: 8 months ago
Short Description
PHP Development Environment for SQL Server
Full Description

PHP Development Environment for SQL Server

This image provides an integrated development environment for PHP with connectivity to a remote SQL Server database. Learn more about SQL Server on Linux. To report issues or provide feedback, please file an issue in the SQL Server in Docker GitHub Repository.

Dockerfile

The following components are included:

  • Ubuntu 16.04 OS layer.
  • Pre-configured PHP7.0 runtime environment.
  • sqlsrv and pdo_sqlservr for SQL Server.
  • A working PHP to SQL Server code sample.
  • SQL Server command-line utilities (sqlcmd and bcp).
  • Command-line text editor tools (nano and vim).

Usage

To run an interactive bash session in this container simply run:

docker run -it lbosqmsft/mssql-php-msphpsql

The following optional environment variables can be provided to create the code sample:

  • $DB_HOST: The IP address or hostname where the SQL Server instance is running.
  • $DB_USERNAME: The database user in the SQL Server instance.
  • $DB_PASSWORD: The database user's password in the SQL Server instance.

    Note: If you are running SQL Server in a Docker container as well, you can obtain the container's IP address using docker inspect <containerID>.

After passing the above environment variables Within the container, you can run the following commands:

  • php connect.php: Execute the code sample to connect to SQL Server. The connect.php file will already have the database parameters.
  • sqlcmd -S $DB_HOST -U $DB_USERNAME -P $DB_PASSWORD: This will run the command-line client for SQL Server where you can execute T-SQL statements against it.

User Feedback


  • For issues with or questions about this image, please contact us through a GitHub issue.

Further Reading


Docker Pull Command
Owner
lbosqmsft

Comments (0)