404

D7net
:/ var / www / html / rosario / adm / vendor / api /
Filename : busca_filial_rem_ant.php
back
<?php

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

define('HOST', 'crsys.ml: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());

}

/*
$json = array();
*/
$filial_id = $_POST['qtde'];
$query = "SELECT f.id gre_filial_id,
                       f.nome filial_nome
                from ro_filial f
	        WHERE f.id < 999 
                and f.situacao_id = 1
                and f.id  <> ". $filial_id;
   $result = mysqli_query($link, $query) or die(mysqli_error());
    $stringFili = "";
   //   $stringFili .= $stringFil =  "<tr><td style='width:0%' align='center' ></td><td style='width:50%' align='center' ><b>Filial</b></td></td><td align='center' ><b>Selecione</b></td></tr>";
           
    while ($row = mysqli_fetch_assoc($result))
    {    
//    $stringFili .= "<tr><td> <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><label  name='tbl[". $row['filial_nome']."][nome]' id='nome' type='text'>".$row['filial_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>";  
     $stringFili .= "<tr><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 align='center' ><input name='tbl[". $row['gre_filial_id']."][simnao]' id='simnao' type='checkbox' checked title='Em Branco Não Baixa'  ></td></tr>";         
    }
	echo $stringFili;