hemaprasad05 · July 6, 2023 06:17 · Mar 14, 2017 · Mar 13, 2017 · Mar 13, 2017 · Mar 13, 2017
diff --git a/docker-compose.yml b/docker-compose.yml
@@ -21,6 +21,7 @@ services:
             MYSQL_ROOT_PASSWORD: test
         volumes:
             - ./dump:/docker-entrypoint-initdb.d
+            - persistent:/var/lib/mysql
         networks:
             - default
     phpmyadmin:
@@ -33,5 +34,5 @@ services:
             MYSQL_USER: user
             MYSQL_PASSWORD: test
             MYSQL_ROOT_PASSWORD: test
-        volumes:
-            - /sessions
+volumes:
+    persistent:
diff --git a/index.php b/index.php
@@ -17,7 +17,7 @@
 
     <?php
 
-    $conn = mysqli_connect('db', 'user', 'merde', "myDb");
+    $conn = mysqli_connect('db', 'user', 'test', "myDb");
 
 
     $query = 'SELECT * From Person';

diff --git a/index.php b/index.php
@@ -17,8 +17,6 @@
 
     <?php
 
-    // Connexion et sélection de la base
-    //$conn = mysqli_connect('172.19.0.2', 'user', 'merde', "myDb");
     $conn = mysqli_connect('db', 'user', 'merde', "myDb");
 
 
@@ -38,7 +36,6 @@
     }
     echo '</table>';
 
-    /* Libération du jeu de résultats */
     $result->close();
 
     mysqli_close($conn);

diff --git a/README.md b/README.md
@@ -1,10 +0,0 @@
-Create this directories structure:
-.
-- docker-compose.yml
-- Dockerfile
-- dump
-  - myDb.sql
-- sessions
-- www
-  - index.php
-

diff --git a/README.txt b/README.txt
@@ -0,0 +1,11 @@
+Create this directories structure:
+.
+├── docker-compose.yml
+├── Dockerfile
+├── dump
+│   └── myDb.sql
+├── sessions
+└── www
+    └── index.php
+
+
diff --git a/README.md b/README.md
@@ -1,10 +1,10 @@
 Create this directories structure:
 .
-├── docker-compose.yml
-├── Dockerfile
-├── dump
-│   └── myDb.sql
-├── sessions
-└── www
-    └── index.php
+- docker-compose.yml
+- Dockerfile
+- dump
+  - myDb.sql
+- sessions
+- www
+  - index.php
 
diff --git a/README.md b/README.md
@@ -7,3 +7,4 @@ Create this directories structure:
 ├── sessions
 └── www
     └── index.php
+
diff --git a/README.md b/README.md
@@ -0,0 +1,9 @@
+Create this directories structure:
+.
+├── docker-compose.yml
+├── Dockerfile
+├── dump
+│   └── myDb.sql
+├── sessions
+└── www
+    └── index.php
diff --git a/index.php b/index.php
@@ -0,0 +1,49 @@
+<!-- put in ./www directory -->
+
+<html>
+ <head>
+  <title>Hello...</title>
+
+  <meta charset="utf-8"> 
+
+  <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
+  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
+  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
+
+</head>
+<body>
+    <div class="container">
+    <?php echo "<h1>Hi! I'm happy</h1>"; ?>
+
+    <?php
+
+    // Connexion et sélection de la base
+    //$conn = mysqli_connect('172.19.0.2', 'user', 'merde', "myDb");
+    $conn = mysqli_connect('db', 'user', 'merde', "myDb");
+
+
+    $query = 'SELECT * From Person';
+    $result = mysqli_query($conn, $query);
+
+    echo '<table class="table table-striped">';
+    echo '<thead><tr><th></th><th>id</th><th>name</th></tr></thead>';
+    while($value = $result->fetch_array(MYSQLI_ASSOC)){
+        echo '<tr>';
+        echo '<td><a href="#"><span class="glyphicon glyphicon-search"></span></a></td>';
+        foreach($value as $element){
+            echo '<td>' . $element . '</td>';
+        }
+
+        echo '</tr>';
+    }
+    echo '</table>';
+
+    /* Libération du jeu de résultats */
+    $result->close();
+
+    mysqli_close($conn);
+
+    ?>
+    </div>
+</body>
+</html>
diff --git a/Dockerfile b/Dockerfile
@@ -0,0 +1,2 @@
+FROM php:7.1.2-apache 
+RUN docker-php-ext-install mysqli
diff --git a/myDb.sql b/myDb.sql
@@ -0,0 +1,26 @@
+-- put in ./dump directory 
+
+SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00: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 */;
+/*!40101 SET NAMES utf8mb4 */;
+
+
+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, 'William'),
+(2, 'Marc'),
+(3, 'John');
+
+/*!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 */;
diff --git a/docker-compose.yml b/docker-compose.yml
@@ -0,0 +1,37 @@
+version: "2"
+services:
+    www:
+        build: .
+        ports: 
+            - "8001:80"
+        volumes:
+            - ./www:/var/www/html/
+        links:
+            - db
+        networks:
+            - default
+    db:
+        image: mysql
+        ports: 
+            - "3306:3306"
+        environment:
+            MYSQL_DATABASE: myDb
+            MYSQL_USER: user
+            MYSQL_PASSWORD: test
+            MYSQL_ROOT_PASSWORD: test
+        volumes:
+            - ./dump:/docker-entrypoint-initdb.d
+        networks:
+            - default
+    phpmyadmin:
+        image: phpmyadmin/phpmyadmin
+        links: 
+            - db:db
+        ports:
+            - 8000:80
+        environment:
+            MYSQL_USER: user
+            MYSQL_PASSWORD: test
+            MYSQL_ROOT_PASSWORD: test
+        volumes:
+            - /sessions
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		FROM php:7.1.2-apache
		RUN docker-php-ext-install mysqli