<?php

try
{
    $server  = "127.0.0.1";
    $database = "allbus_develop";
    $username = "dev_allbus";
    $password = "bus";

    $connectionString = "sqlsrv:server=$server;Database=$database";
    $dbh = new PDO($connectionString, $username, $password);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


    $sql = "SELECT * FROM vehicles_model_vehicle WHERE chassis = :val";
    $stmt = $dbh->prepare($sql);

    //$stmt->setAttribute(PDO::SQLSRV_ATTR_ENCODING, PDO::SQLSRV_ENCODING_SYSTEM);
    $stmt->bindValue(":val", 'à', PDO::PARAM_STR);

    if($stmt->execute())
    {
      $table = $stmt->fetchAll(PDO::FETCH_ASSOC);

      var_dump($table);
    }
    else
    {
      print_r($stmt->errorInfo());
    }

    $stmt = null;
}
catch (PDOException $ex)
{
    echo "Database::DataTable: " . $ex->getCode() . " - " . $ex->getMessage();
}