404

D7net
:/ var / www / html / rosario / adm / vendor_ant / api /
Filename : busca_filial_rem.php
back
<?php

session_start();
//header('Content-Type: application/json');

define('HOST', '159.65.100.255:3306');
define('USER', 'carlos');
define('PASS', 'Crm8751M@');
define('DBNAME', 'rosario');

/*
define('HOST','localhost:3308');
define('USER', 'root');
define('PASS', '');
define('DBNAME', 'rosario');
*/

//ini_set('display_errors',1);

//ini_set('display_startup_erros',1);

//error_reporting(E_ALL);




// conecta ao banco de dados

$link = mysqli_connect(HOST, USER, PASS);



if (!$link) {

    die('Não conseguiu conectar: ' . mysql_error());

}



// seleciona o banco devcodes

$db_selected = mysqli_select_db( $link,DBNAME);



if (!$db_selected) {

    die ('Não pode selecionar o banco '.DBNAME.' : ' . mysql_error());

}
$filial_id = $_POST['qtde'];
$stringFil = "";
$query = "SELECT f.id gre_filial_id,
                       f.nome filial_nome,
                       m.nome mun_nome
                from ro_filial f
                inner join ro_municipios m
                  on m.id = f.ro_municipio_id
                where f.id < 999   
                and f.id  <> $filial_id";
   $result = mysqli_query($link, $query) or die(mysqli_error());
   $cont = mysqli_num_rows($result) % 2;
   $col = 0;
   $stringFil = "<tr>";
 while ($row = mysqli_fetch_assoc($result))
    {
     if($col == 0){  
        $stringFil .= "<td  > <input class='form-control col-md-2' name='tbl[" . $row['gre_filial_id']."]"."[id]' id='id' type='hidden'  value='". $row['gre_filial_id']."'  ></td>	
                    <td style='width:70%><label style='width:70% name='tbl[". $row['filial_nome']."][nome]' id='nome' type='text'>".$row['filial_nome']."</td>
                    <td style='width:70%><label style='width:70% name='tbl[". $row['mun_nome']."][mun_nome]' id='mun_nome' type='text'>".$row['mun_nome']."</td>    
                    <td align='center' ><input name='tbl[". $row['gre_filial_id']."][simnao]' id='simnao' type='checkbox' checked title='Em Branco Não Baixa'  ></td><td></td>";         
        $col = 1; 
     }else{
        $stringFil .= "<td style='width:0%'> <input class='form-control' name='tbl[" . $row['gre_filial_id']."]"."[id]' id='id' type='hidden'  value='". $row['gre_filial_id']."'  style='background-color:#F0FFF0;'></td>	
                    <td style='width:70%><label style='width:70% name='tbl[". $row['filial_nome']."][nome]' id='nome' type='text'>".$row['filial_nome']."</td>
                        <td style='width:70%><label style='width:70% name='tbl[". $row['mun_nome']."][mun_nome]' id='mun_nome' type='text'>".$row['mun_nome']."</td>    
                    <td align='center' ><input name='tbl[". $row['gre_filial_id']."][simnao]' id='simnao' type='checkbox' checked title='Em Branco Não Baixa'  ></td></tr><tr>";         
         $col = 0; 
     }
    }
if ($cont == 1) {
        $stringFil .= "</tr>"; 
    
} 
echo $stringFil;
 ?>