Beyarz · March 14, 2024 10:52 · gardenboi · Jan 20, 2024
diff --git a/README.txt b/README.txt
 Create a directory with the following structure:
 ├── docker-compose.yml
 ├── Dockerfile
 ├── dump
 │   └── myDb.sql
 └── www
    └── index.php
diff --git a/docker-compose.yml b/docker-compose.yml
 version: "3"
 services:
    www:
        build: .
        ports:
            - "8001:80"
        volumes:
            - ./www:/var/www/html/
        links:
            - db
        networks:
            - default
    db:
        image: mysql:8.0.16
        command: ['--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci','--default-authentication-plugin=mysql_native_password']
        ports:
            - "3306:3306"
        environment:
            MYSQL_DATABASE: myDb
            MYSQL_USER: user
            MYSQL_PASSWORD: test
            MYSQL_ROOT_PASSWORD: test
        volumes:
            - ./dump:/docker-entrypoint-initdb.d
            - persistent:/var/lib/mysql
        networks:
            - default
    phpmyadmin:
        image: phpmyadmin/phpmyadmin:4.8
        links:
            - db:db
        ports:
            - 8000:80
        environment:
            MYSQL_USER: user
            MYSQL_PASSWORD: test
            MYSQL_ROOT_PASSWORD: test
 volumes:
    persistent:
diff --git a/Dockerfile b/Dockerfile
 FROM php:7.2.6-apache
 RUN docker-php-ext-install mysqli
diff --git a/index.php b/index.php
 <?php
 $conn = mysqli_connect('db', 'user', 'test', 'myDb', 3306);
 mysqli_set_charset($conn, "utf8");
 $query = 'SELECT * From Person';
 $result = mysqli_query($conn, $query);
 ?>

 <!DOCTYPE html>
 <html lang="en">

 <head>
  <meta charset="utf-8">
  <title>Demo</title>
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <link href="https://fonts.googleapis.com/css?family=Nunito:200,600" rel="stylesheet">
  <style>body{font-family:Nunito,sans-serif;min-height:90vh;align-items:center;justify-content:center;display:flex}</style>
 </head>

 <body>
  <p>
    <?php
    while ($value = $result->fetch_array(MYSQLI_ASSOC)) {
      foreach ($value as $element) {
        echo ' - ' . $element;
      }
    }
    $result->close();
    mysqli_close($conn);
    ?>
    -
  </p>
 </body>

 </html>
diff --git a/myDb.sql b/myDb.sql
 CREATE DATABASE IF NOT EXISTS myDb;
 USE myDb;
 SET
  SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 SET
  time_zone = "+01:00";
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 CREATE TABLE `Person` (
    `id` int(11) NOT NULL,
    `name` varchar(20) NOT NULL
  ) ENGINE = InnoDB DEFAULT CHARSET = latin1;
 INSERT INTO
  `Person` (`id`, `name`)
 VALUES
  (1, 'Conf'),
  (2, 'Nipsu'),
  (3, 'Beyar');
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
	Create a directory with the following structure:
	├── docker-compose.yml
	├── Dockerfile
	├── dump
	│ └── myDb.sql
	└── www
	└── index.php
	version: "3"
	services:
	www:
	build: .
	ports:
	- "8001:80"
	volumes:
	- ./www:/var/www/html/
	links:
	- db
	networks:
	- default
	db:
	image: mysql:8.0.16
	command: ['--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci','--default-authentication-plugin=mysql_native_password']
	ports:
	- "3306:3306"
	environment:
	MYSQL_DATABASE: myDb
	MYSQL_USER: user
	MYSQL_PASSWORD: test
	MYSQL_ROOT_PASSWORD: test
	volumes:
	- ./dump:/docker-entrypoint-initdb.d
	- persistent:/var/lib/mysql
	networks:
	- default
	phpmyadmin:
	image: phpmyadmin/phpmyadmin:4.8
	links:
	- db:db
	ports:
	- 8000:80
	environment:
	MYSQL_USER: user
	MYSQL_PASSWORD: test
	MYSQL_ROOT_PASSWORD: test
	volumes:
	persistent:
	<?php
	$conn = mysqli_connect('db', 'user', 'test', 'myDb', 3306);
	mysqli_set_charset($conn, "utf8");
	$query = 'SELECT * From Person';
	$result = mysqli_query($conn, $query);
	?>

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="utf-8">
	<title>Demo</title>
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<link href="https://fonts.googleapis.com/css?family=Nunito:200,600" rel="stylesheet">
	<style>body{font-family:Nunito,sans-serif;min-height:90vh;align-items:center;justify-content:center;display:flex}</style>
	</head>

	<body>
	<p>
	<?php
	while ($value = $result->fetch_array(MYSQLI_ASSOC)) {
	foreach ($value as $element) {
	echo ' - ' . $element;
	}
	}
	$result->close();
	mysqli_close($conn);
	?>
	-
	</p>
	</body>

	</html>
	CREATE DATABASE IF NOT EXISTS myDb;
	USE myDb;
	SET
	SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
	SET
	time_zone = "+01:00";
	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
	CREATE TABLE `Person` (
	`id` int(11) NOT NULL,
	`name` varchar(20) NOT NULL
	) ENGINE = InnoDB DEFAULT CHARSET = latin1;
	INSERT INTO
	`Person` (`id`, `name`)
	VALUES
	(1, 'Conf'),
	(2, 'Nipsu'),
	(3, 'Beyar');
	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;