Connection problem between DockerCompose and PHP, MySQL, nginx

I have a problem connecting to the MySQL container.

docker,compose.yml

version: '2'
services:
mysql :
image: mysql:latest
environment:
MYSQL_ROOT_PASSWORD: JoeyW#1999
MYSQL_DATABASE: wiput
MYSQL_USER: web
MYSQL_PASSWORD: Web#1234
volumes:
- ./mysql:/var/lib/mysql
networks:
- code-network
php:
image: wiput1999/php:latest
volumes:
- ./code :/code
networks:
- code-network
nginx:
image: nginx:latest
ports:
- "80:80"
- "443:443 "
volumes:
- ./code:/code
- ./site.conf:/etc/nginx/conf.d/default.conf
- /etc/letsencrypt:/etc/ letsencrypt
networks:
- code-network
networks:
code-network:
driver: bridge


PHP test script:

<?php
$servername = "localhost";
$username = "root";
$password = "JoeyW#1999";
try {
$cOnn= new PDO("mysql:host=$servername;dbname=wiput", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO ::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e)
{
echo "Connection failed: " . $e-> getMessage();
}
?>


This script responds to me:

Connection failed: SQLSTATE[HY000] [ 2002] No such file or directory


What’s wrong with my code? Because I think this should be fine

If anyone has a better solution, thank you for your help.

Solution:

Change $servername=”localhost “; to $servername = “mysql”;. Your mysql service is not on localhost of your web server container. You should use the name of the service