SQL connection with PHP does not find the Drivers

Question

I have the following PHP:

<?php

class Conexao
{
   private static $connection;

   private function __construct(){}

   public static function getConnection() {

       $pdoConfig  = DB_DRIVER . ":". "Server=" . DB_HOST . ";";
       $pdoConfig .= "Database=".DB_NAME.";";

       try {
           if(!isset($connection)){
               $connection =  new PDO($pdoConfig, DB_USER, DB_PASSWORD);
               $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
           }
           return $connection;
       } catch (PDOException $e) {
           $mensagem = "Drivers disponiveis: " . implode(",", PDO::getAvailableDrivers());
           $mensagem .= "\nErro: " . $e->getMessage();
           throw new Exception($mensagem);
       }
   }
}
   define('DB_HOST'        , "dblinx");
   define('DB_USER'        , "maicon.friedel");
   define('DB_PASSWORD'    , "Mf2681");
   define('DB_NAME'        , "Linx");
   define('DB_DRIVER'      , "sqlsrv");

   try{

       $Conexao    = Conexao::getConnection();
       $query      = $Conexao->query("SELECT nome, preco, quantidade FROM produto");
       $produtos   = $query->fetchAll();

   }catch(Exception $e){
       echo $e->getMessage();
       exit;
   }

?>
<table border=1>
   <tr>
       <td>Nome</td>
       <td>Preço</td>
       <td>Quantidade</td>
   </tr>
   <?php
       foreach($produtos as $produto) {
   ?>
       <tr>
           <td><?php echo $produto['nome']; ?></td>
           <td>R$ <?php echo $produto['preco']; ?></td>
           <td><?php echo $produto['quantidade']; ?></td>
       </tr>
   <?php
       }
   ?>
</table>

But this always comes up:

And as you can see, I’ve put the right drivers, version 7.2 PHP, drivers for the right version:

Answer 1

Well let’s get started, you need:

Install a driver on your pc, and in your php, but you have already installed it in php, correct?

View this ODBC and install: https://www.microsoft.com/en-us/download/details.aspx?id=55642

If you have more questions you can look at the https://www.dirceuresende.com/blog/como-conectar-no-sql-server-utilizando-o-php-xampp-e-o-driver-pdo-no-windows/

Answer 2

The Microsoft website explains what is required for connecting to SQL Server.

Probably missing you include the extensions in your php.ini

The file gets in the same way as your dlls.

The step by step is for SQL Server 2017, but just adapt the version you are using.

Follow reference to check step by step:

https://docs.microsoft.com/pt-br/sql/connect/php/loading-the-php-sql-driver?view=sql-server-2017