reembolso

// php file for implement's HTML code reembolso.php
<fieldset>
    <legend><h3>Pedido de Reensolso da Assistencia Medica</h3></legend>
    <!--<form action="#" method="get">-->
        <label for="nome">Nome do Funcionario</labe>
        <!--<select>-->
            <?php
@include ("../connection/Connection.php");
    $con=Connection::getConnection();
    $sql = "SELECT * FROM funcionario";
    $consulta = $con->query($sql);
            while($linha = $consulta->fetch(PDO::FETCH_ASSOC)){ ?>

            <?= $linha['nome_funcionario']; } ?>
        <!--</select>-->
    <!--</form>-->
</fieldset>


//classe de conexao Connection.php

<?php
//include ("config.php");

class Connection
{

    public static function getConnection()
    {
//      $host="localhost";
//      $dbname="dmsincm";
//      $senha = "";
//      $user = "root";
        echo "<h1>Hi Welcome</h1>";
        include("config.php");
        try
        {
            $con = new PDO("mysql:host=localhost;dbname=funcionario", $user,$senha);
//          echo "Connected";
            $sql = "SELECT * FROM dadosfuncionario";
            $consulta = $con->query($sql);
            echo "<select>";
            while($linha = $consulta->fetch(PDO::FETCH_ASSOC)){
                echo "<option value=".$linha['nome'].">".$linha['nome']."</option>";
                        }
            echo "</select>";
        }
        catch(PDOException $e)
        {
            echo "Error connecting database" . $e->getMessage();
        }
        //return $con;
    }
}
?>

//Variaveis de Conexao   config.php
<?php

$host="localhost";
$dbname="dmsincm";
$senha = "";
$user = "root";
/*
define('host', 'localhost');
define('dbname','dmsincm');
define('user','root');
define('senha','');
*/
?>