404

D7net

:/ var / www / html / crsys / adm / vendor / api /

Filename : atualizaDatalistObra.php

back

<?php
include_once "ConectaApi.php";

header('Content-Type: text/html; charset=utf-8');
if(isset($_GET['empr_id'])) {
$empr_id = $_GET['empr_id'];
$vend_id = $_GET['vend_id'];
}
// Consulta atualizada
$query= "SELECT o.id id_obra,
                o.nome nome_obra
            FROM gre_obras o where o.empr_id ={$empr_id} and o.vend_id ={$vend_id} and o.sit_id = 1 and o.nome <> '' order by o.nome";
         
$result = mysqli_query($link, $query) or die(mysqli_error());

$options = "";

while ($row = $result->fetch_assoc()) {
    $id = htmlspecialchars($row['id_obra']);
   
    $nome = htmlspecialchars($row['nome_obra']);
    $options .= "<option value='{$nome}' data-id='{$id}' ></option>";
   
}
//var_dump($options);
echo $options;