connection.php

<?php

require __DIR__ . '/vendor/autoload.php';
use Dotenv\Dotenv;
$path = dirname(__FILE__);



$dotenv = Dotenv::createImmutable($path);
$dotenv->load();

$connection = new mysqli($_ENV["HOST"], $_ENV["USER"], $_ENV["PASSWORD"], $_ENV["DB"]) OR DIE("error");
if($connection->connect_errno){
    echo "error" . $connection->connect_errno . " - " . $connection->connect_error; 
}

// $result = $connection->query("INSERT INTO usuarios (name,  password , user_email, date_of_birth) VALUES ('Teste','teste123', 'teste@gmail.com', '2000-01-01')");

// $result2 = $connection->query("SELECT * FROM usuarios");

// while($row = mysqli_fetch_assoc($result2)){
//     echo $row["name"] . "<br>";
//     // print_r($row);
// }
// $result.foreach($categorias as $categoria){}
// var_dump($_ENV["HOST"]);

?>