404

D7net
:/ var / www / html / crsys_ant /
Filename : buscar_orcamento.php
back
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

header('Content-Type: application/json; charset=utf-8');

define('HOST', 'localhost');
define('PORT', '3308');
define('USER', 'root');
define('PASS', '');
define('DBNAME', 'crsys');

try {
    $pdo = new PDO(
        "mysql:host=" . HOST . ";port=" . PORT . ";dbname=" . DBNAME . ";charset=utf8",
        USER,
        PASS,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
        ]
    );
} catch (PDOException $e) {
    echo json_encode(['erro' => $e->getMessage()]);
    exit;
}

$busca = $_GET['q'] ?? '';

//echo('busca '.$busca);
if (mb_strlen($busca) < 2) {
    echo json_encode([]);
    exit;
}

$sql = "
    SELECT orca_id, num_revisao,nome_cliente AS nome, obra, 
	       status_id,
	       stat.nome AS nome_stat,
           cr.cor AS cor_cr
    FROM gre_cab_orcamento
	INNER JOIN gre_status stat ON stat.id = status_id
    INNER JOIN adms_cors cr ON cr.id = stat.cor_id
    WHERE status_id < 8
	   and (nome_cliente LIKE :busca
       OR obra LIKE :busca)
	order by obra, orca_id, num_revisao   
    LIMIT 20
";

$stmt = $pdo->prepare($sql);
$stmt->bindValue(':busca', "%{$busca}%", PDO::PARAM_STR);
$stmt->execute();

echo json_encode($stmt->fetchAll());