404

D7net
:/ var / www / html / rosario / adm / vendor / api /
Filename : ler_ct_marca_ant.php
back
<?php
/*
define('HOST','localhost:3308');
define('USER', 'root');
define('PASS', '');
define('DBNAME', 'rosario');
*/

//define('HOST', 'crsys.ml:3306');
define('HOST', '159.65.100.255');

define('USER', 'carlos');
define('PASS', 'Crm8751M@');
define('DBNAME', 'rosario');

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



if (!$link) {

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

}



// seleciona o banco devcodes
$forn_id = $_POST['forn_id'];
$opcao = $_POST['opcao'];

//$sub_tipo_id = $_POST['sub_tipo_id'];
$db_selected = mysqli_select_db( $link,DBNAME);
if (!$db_selected) {

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

}
 $stringForn = "";
if($opcao == 'S') {
        $query = "select fm.marca_id,
                        m.nome
                  from  ct_fornecedor_marca fm
                  inner join ro_marca m
                  on m.id = fm.marca_id
                  where fm.forn_id = {$forn_id}
                    and fm.marca_id <> 0  
                    order by m.nome";

$result = mysqli_query($link, $query) or die(mysqli_error());

  
//    $stringForn .= "<option data-id='T' id='T' value='TODAS...'></option>";
$stringForn .= "<option value=''>Selecione..</option>";   
$stringForn .= "<option value='T'>TODAS</option>";
    while ($row = mysqli_fetch_array($result))
    {    
         $stringForn .= "<option value='$row[0]'>$row[1]</option>";
    }
	echo $stringForn;
}else{ 
    $query = "select fm.marca_id,
                        m.nome
                  from  ct_fornecedor_marca fm
                  inner join ro_marca m
                  on m.id = fm.marca_id
                  where fm.marca_id <> 0  
                   and fm.forn_id = {$forn_id}
                    order by m.nome";
$result = mysqli_query($link, $query) or die(mysqli_error());                   
     $stringMarcaForn = "";
        $stringMarcaForn =  "<thead><tr><th align='center'><font color='blue'><b>Codigo</b></font></th><th align='center'><font color='blue'><b>Nome Marca</b><th align='center'><font color='blue'><b>Exc</b></font></th></font></th></tr></thead>";

        while ($row = mysqli_fetch_array($result))
        {    
                $stringMarcaForn .= "<tr><td>" . $row[0].  "</td><td>" .$row[1] .  "</td><td align='center'> <input type='checkbox'   name='marca[" .$row[0] . "]'".  " checked onclick='removeLinha(this)'></td></td></tr>";
                    //$stringAux .= "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</tr>";
        }
	echo $stringMarcaForn;
}
?>