programmerq/Dockerfile

	version: "3.7"
	services:
	web:
	build: .
	ports:
	- "80:80"
	- "443:443"
	db:
	image: 'mysql:5.6'
	environment:
	MYSQL_DATABASE: 'testuni'
	MYSQL_USER: 'user'
	MYSQL_PASSWORD: 'password'
	MYSQL_ROOT_PASSWORD: 'adminpassword'
	volumes:
	- ./unicode.sql:/docker-entrypoint-initdb.d/unicode.sql
	command: '--character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci'
	FROM php:apache
	RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

	COPY --chown=www-data:www-data . /var/www/html/
	<?php header('Content-Type: text/html; charset=utf-8');

	$mysqli = new mysqli('db', 'user', 'password', 'testuni');
	printf("Initial character set: %s\n", $mysqli->character_set_name());

	/* change character set to utf8mb4 */
	if (!$mysqli->set_charset("utf8mb4")) {
	printf("Error loading character set utf8mb4: %s\n", $mysqli->error);
	exit();
	} else {
	printf("Current character set: %s\n", $mysqli->character_set_name());
	}
	$sql = "SELECT value from `u` where id=1;";
	if (!$result = $mysqli->query($sql)) {
	// Oh no! The query failed.
	echo "Sorry, the website is experiencing problems.";
	exit;
	}
	if ($result->num_rows === 0) {
	echo "We could not find a match for ID 1, sorry about that. Please try again.";
	exit;
	}

	echo 'smart quote: “<br />';
	echo 'db ' . $result->fetch_assoc()['value'];
	#!/bin/bash -xe

	docker-compose up --build -d 2>&1

	echo 'running: mysql -uroot -padminpassword testuni -e status'
	docker-compose exec db mysql -uroot -padminpassword testuni -e status
	echo
	echo

	echo "running: db mysql -uroot -padminpassword testuni -e 'select * from u;'"
	docker-compose exec db mysql -uroot -padminpassword testuni -e 'select * from u;'
	The Docker Engine you're using is running in swarm mode.

	Compose does not use swarm mode to deploy services to multiple nodes in a swarm. All containers will be scheduled on the current node.

	To deploy your application across the swarm, use `docker stack deploy`.

	Building web
	Step 1/3 : FROM php:apache
	---> dfe3bb4436a9
	Step 2/3 : RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli
	---> Using cache
	---> 43689afbabfc
	Step 3/3 : COPY --chown=www-data:www-data . /var/www/html/
	---> a68c9d218ca8

	Successfully built a68c9d218ca8
	Successfully tagged phpuni_web:latest
	Recreating phpuni_web_1 ...
	phpuni_db_1 is up-to-date
	[1A[2K Recreating phpuni_web_1 ... [32mdone[0m [1Brunning: mysql -uroot -padminpassword testuni -e status
	Warning: Using a password on the command line interface can be insecure.
	--------------
	mysql Ver 14.14 Distrib 5.6.45, for Linux (x86_64) using EditLine wrapper

	Connection id: 23
	Current database: testuni
	Current user: root@localhost
	SSL: Not in use
	Current pager: stdout
	Using outfile: ''
	Using delimiter: ;
	Server version: 5.6.45 MySQL Community Server (GPL)
	Protocol version: 10
	Connection: Localhost via UNIX socket
	Server characterset: utf8mb4
	Db characterset: utf8mb4
	Client characterset: latin1
	Conn. characterset: latin1
	UNIX socket: /var/run/mysqld/mysqld.sock
	Uptime: 17 min 39 sec

	Threads: 1 Questions: 71 Slow queries: 0 Opens: 68 Flush tables: 1 Open tables: 61 Queries per second avg: 0.067
	--------------



	running: db mysql -uroot -padminpassword testuni -e 'select * from u;'
	Warning: Using a password on the command line interface can be insecure.
	+----+------------------+
	\| id \| value \|
	+----+------------------+
	\| 1 \| smart quote: “ \|
	+----+------------------+
	#!/bin/bash -x

	docker-compose up --build -d 2>&1

	echo "running: curl -v http://localhost/ 2>&1"
	curl -v http://localhost/ 2>&1
	echo
	echo

	echo "running: php index.php"
	docker-compose exec web php index.php
	DROP DATABASE IF EXISTS testuni;
	CREATE DATABASE `testuni` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
	USE `testuni`;

	CREATE TABLE `u` (
	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


	INSERT INTO `u` VALUES(1, 'smart quote: “');