Blank consultation

Question

I’m starting in the world of programming and at first I have a problem when I run the query locally the query shows me the return normally but when I try to query through a simple application:

<?php
/**
 * 
 * @var string $dsn  : driver de conexão : endereco do servidor : nome do banco
 * @var string $user : usuario do banco
 * @var string $pass : senha do usuario 
 */
$dsn = 'odbc:driver={SQL Server};server=IP_DO_SERVIDOR;database=TESTE';
$user = 'xxxxxxx';
$pass = 'xxxxxxx';

try 
{
    $pdo = new PDO($dsn,$user,$pass);
}
catch(PDOException $exeption)
{
   die("Erro: $exeption");
}

// Definindo o mode de erros da classe
//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$select = "SELECT * FROM FIN_TITULO WHERE EMPRESA = 1 AND REVENDA = 1 AND TITULO = 435376";

$result = $pdo->exec($select);

var_dump($result);

the var_dump returns the value 0, that is, no affected line, I do not know what to do, it would perhaps be the user’s permission because the direct query through SQL management works normally?

Answer 1

Try it this way:

$result = $pdo->query($select);

or

$select = "SELECT * FROM FIN_TITULO WHERE EMPRESA = 1 AND REVENDA = 1 AND TITULO = 435376";
$statement = $pdo->prepare($select);
$statement->execute();

// Verifica e gera array assoc
if($statement->rowCount()) {
    $stt = $statement->fetch(PDO::FETCH_ASSOC);
    print_r($stt);
}

Opa worked, just did not understand why the result of my consultation initial had no return - Guilherme Arantes

When using PDO::EXEC the returned result is not a PDOStatement, and yes an entire of the affected lines.

When using PDO::QUERY the returned result is a PDOStatement.

Sources: 1 2