List opção editar
Pessoal,
O arquivo a baixo e uma opção de editar o BD, os campos [ ] consegui fazer a opção funcionar corretamente, porem a opção list, não consegui poderia me orientar?
segue
<?php
@ini_set('display_errors', '1');
error_reporting(E_ALL);
//$id = $_GET["id"];
mysql_connect("localhost", "Login", "SENHA") or die (mysql_error());
mysql_select_db("BANCO DE DADOS")or die (mysql_error());
$resultado = mysql_query("select * FROM base WHERE id = '{$_GET['id']}'") or die (mysql_error());
$dados = mysql_fetch_array($resultado) or die (mysql_error());
mysql_close();
?>
<html>
<head>
<title>KPI Tracking - Editar</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="css/style.css">
<style type="text/css">
.teste {
font-size: 9px;
}
</style>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12">
<div class="col-xs-10 col-md-10">
<form class="form-inline" name="form1" method="post" action="EnviaDados.php" onsubmit="return validaForm()" >
<table class="table table-striped table table-bordered" >
<tr>
<td align="center"><a href="painel.php"><img src="imagens/voltar.png" width="64" height="64" alt="Voltar" longdesc="painel.php"></a></td>
<td align="center" valign="middle"><p><strong>KPI Tracking</strong></p></td>
</tr>
<tr>
<td width="19%">Consultor:</td>
<td width="81%"><span class="teste">.
<select class="form-control" name="quem" id="quem">
<option value= "" selected="selected" > Selecione </option>
<option value= " ANGELINA DE FATIMA MASCARELLO RIZZI " > ANGELINA DE FATIMA MASCARELLO RIZZI </option>
<option value= " ANTONIO CARVALHO DE ALBUQUERQUE NETO " > ANTONIO CARVALHO DE ALBUQUERQUE NETO </option>
<option value= " ANTONIO CESAR FIGUEIREDO BARBOSA JUNIOR " > ANTONIO CESAR FIGUEIREDO BARBOSA JUNIOR </option>
<option value= " ARLA MILENA LOPES DA SILVA RAMOS " > ARLA MILENA LOPES DA SILVA RAMOS </option>
<option value= " ATENDIMENTO RCA / PROCP " > ATENDIMENTO RCA / PROCP </option>
<option value= " BRUNO NUNES ABILIO " > BRUNO NUNES ABILIO </option>
<option value= " CESAR AUGUSTO TEIXEIRA BARRETO " > CESAR AUGUSTO TEIXEIRA BARRETO </option>
<option value= " CLAUDIO HENRIQUE VARELA " > CLAUDIO HENRIQUE VARELA </option>
<option value= " CLAUSIO BOTTIN " > CLAUSIO BOTTIN </option>
<option value= " DANIEL DOS SANTOS ALBUQUERQUE " > DANIEL DOS SANTOS ALBUQUERQUE </option>
<option value= " DEMETRIUS VENCESLAU DA SILVA " > DEMETRIUS VENCESLAU DA SILVA </option>
<option value= " DIEGO MESQUITA SOUZA " > DIEGO MESQUITA SOUZA </option>
<option value= " DIEGO RODRIGO ROSSI " > DIEGO RODRIGO ROSSI </option>
<option value= " EDER APARECIDO DOS SANTOS " > EDER APARECIDO DOS SANTOS </option>
<option value= " ELOIZA ELIZABETE DE ARAUJO BULHOES " > ELOIZA ELIZABETE DE ARAUJO BULHOES </option>
<option value= " EVANDRO FERREIRA LIMA " > EVANDRO FERREIRA LIMA </option>
<option value= " FABIO ROBERTO GONCALVES CAMARGO " > FABIO ROBERTO GONCALVES CAMARGO </option>
<option value= " FELIPE DOS SANTOS PEDROSO " > FELIPE DOS SANTOS PEDROSO </option>
<option value= " FLAVIA GONCALVES LIVRAMENTO " > FLAVIA GONCALVES LIVRAMENTO </option>
<option value= " FLAVIO RODRIGO GONCALVES RAMALHO " > FLAVIO RODRIGO GONCALVES RAMALHO </option>
<option value= " FRANCISCO MANZI NETO " > FRANCISCO MANZI NETO </option>
<option value= " GABRIEL DE ANDRADE " > GABRIEL DE ANDRADE </option>
<option value= " GILBERTO LOPES BERALDO " > GILBERTO LOPES BERALDO </option>
<option value= " GISLAINE DIAS GONÇALVES " > GISLAINE DIAS GONÇALVES </option>
<option value= " GRAZIELA CARINA DA SILVA LIMA " > GRAZIELA CARINA DA SILVA LIMA </option>
<option value= " HUGO LEONARDO JOSE SALES BRASILEIRO DA SILVA " > HUGO LEONARDO JOSE SALES BRASILEIRO DA SILVA </option>
<option value= " JOSE HELDER GONCALVES ALMEIDA " > JOSE HELDER GONCALVES ALMEIDA </option>
<option value= " JOSE JURACIR MOURA JUNIOR " > JOSE JURACIR MOURA JUNIOR </option>
<option value= " JULIANA TENORIO DE OLIVEIRA GOMES " > JULIANA TENORIO DE OLIVEIRA GOMES </option>
<option value= " LUCIANO DA COSTA TEIXEIRA " > LUCIANO DA COSTA TEIXEIRA </option>
<option value= " MARCELA PONTES DE CARVALHO SILVA " > MARCELA PONTES DE CARVALHO SILVA </option>
<option value= " MARCOS ANTONIO REIS OLIVEIRA " > MARCOS ANTONIO REIS OLIVEIRA </option>
<option value= " MARIA APARECIDA ARPINI SIMOES " > MARIA APARECIDA ARPINI SIMOES </option>
<option value= " MARILSA BAUCH KAMURA " > MARILSA BAUCH KAMURA </option>
<option value= " MAYCON CEZAR GALVAO DOS SANTOS " > MAYCON CEZAR GALVAO DOS SANTOS </option>
<option value= " MONICA LYSAKOWSKI GOMES " > MONICA LYSAKOWSKI GOMES </option>
<option value= " RICARDO ALEXANDRE DE SOUZA " > RICARDO ALEXANDRE DE SOUZA </option>
<option value= " RODRIGO EVANGELISTA DA SILVA " > RODRIGO EVANGELISTA DA SILVA </option>
<option value= " ROGERIO GAVIOLLI " > ROGERIO GAVIOLLI </option> </select>
</span></td>
</tr>
<tr>
<td>Cod. Loja:</td>
<td><input name="codloja" type="text" id="codloja" size="20" maxlength="100" value="<?php echo $dados["codloja"];?>"></td>
</tr>
<tr>
<td>QTD Check Out</td>
<td><span class="teste">
<select class="form-control" name="qcheck" id="qcheck">
<option value="" selected="selected">Selecione.</option>
<option value= " 01 " > 01 </option>
<option value= " 02 " > 02 </option>
<option value= " 03 " > 03 </option>
<option value= " 04 " > 04 </option>
<option value= " 05 " > 05 </option>
<option value= " 06 " > 06 </option>
<option value= " 07 " > 07 </option>
<option value= " 08 " > 08 </option>
<option value= " 09 " > 09 </option>
<option value= " 10 " > 10 </option>
<option value= " 11 " > 11 </option>
<option value= " 12 " > 12 </option>
<option value= " 13 " > 13 </option>
<option value= " 14 " > 14 </option>
<option value= " 15 " > 15 </option>
<option value= " 16 " > 16 </option>
<option value= " 17 " > 17 </option>
<option value= " 18 " > 18 </option>
<option value= " 19 " > 19 </option>
<option value= " 20 " > 20 </option>
<option value= " 21 " > 21 </option>
<option value= " 22 " > 22 </option>
<option value= " 23 " > 23 </option>
<option value= " 24 " > 24 </option>
<option value= " 25 " > 25 </option>
<option value= " 26 " > 26 </option>
<option value= " 27 " > 27 </option>
<option value= " 28 " > 28 </option>
<option value= " 29 " > 29 </option>
<option value= " 30 " > 30 </option>
<option value= " 31 " > 31 </option>
<option value= " 32 " > 32 </option>
<option value= " 33 " > 33 </option>
<option value= " 34 " > 34 </option>
<option value= " 35 " > 35 </option>
<option value= " 36 " > 36 </option>
<option value= " 37 " > 37 </option>
<option value= " 38 " > 38 </option>
<option value= " 39 " > 39 </option>
<option value= " 40 " > 40 </option>
</select>
</span></td>
</tr>
<tr>
<td>Atendimento Merchandising:</td>
<td><span class="teste">
<select class="form-control" name="atendmerch" id="atendmerch">
<option value="" selected="selected">Selecione o Promotor.</option>
<option value="Sim"> Sim </option>
<option value="Não"> Não </option>
</select>
</span></td>
</tr>
<tr>
<td>Nome Promotor:</td>
<td><input name="npromotor" type="text" id="npromotor" size="40" maxlength="100" value="<?php echo $dados["npromotor"];?>"></td>
</tr>
<tr>
<td>Qta. lojas do Promotor:</td>
<td><span class="teste">
<select class="form-control" name="qlpromotor" id="qlpromotor">
<option value="" selected="selected">Selecione.</option>
<option value= " 01 " > 01 </option>
<option value= " 02 " > 02 </option>
<option value= " 03 " > 03 </option>
<option value= " 04 " > 04 </option>
<option value= " 05 " > 05 </option>
<option value= " 06 " > 06 </option>
<option value= " 07 " > 07 </option>
<option value= " 08 " > 08 </option>
<option value= " 09 " > 09 </option>
<option value= " 10 " > 10 </option>
<option value= " 11 " > 11 </option>
<option value= " 12 " > 12 </option>
<option value= " 13 " > 13 </option>
<option value= " 14 " > 14 </option>
<option value= " 15 " > 15 </option>
<option value= " 16 " > 16 </option>
<option value= " 17 " > 17 </option>
<option value= " 18 " > 18 </option>
<option value= " 19 " > 19 </option>
<option value= " 20 " > 20 </option>
</select>
</span></td>
</tr>
<tr>
<td><p>Nome Supervisor:</p></td>
<td><input name="nsupervisor" type="text" id="nsupervisor" size="40" maxlength="100" value="<?php echo $dados["nsupervisor"];?>"></td>
</tr>
<tr>
<td>Higiene Oral Unificada?</td>
<td><span class="teste">
<select class="form-control" name="oralunificada" id="oralunificada">
<option value="" selected="selected">Selecione.</option>
<option value="Sim"> Sim </option>
<option value="Não"> Não </option>
</select>
</span></td>
</tr>
<tr>
<td>Sabonete Unificada?</td>
<td><span class="teste">
<select class="form-control" name="sunificada" id="sunificada">
<option value="" selected="selected">Selecione.</option>
<option value= " Sim " > Sim </option>
<option value= " Não " > Não </option>
</select>
</span></td>
</tr>
<tr>
<td>Ponto Extra adicional?</td>
<td><span class="teste">
<select class="form-control" name="peadicional" id="peadicional">
<option value="" selected="selected">Selecione.</option>
<option value= " Sim " > Sim </option>
<option value= " Não " > Não </option>
</select>
</span></td>
</tr>
<tr>
<td>Possui Regimie de higiene oral?</td>
<td><span class="teste">
<select class="form-control" name="rhigiene" id="rhigiene">
<option value="" selected="selected">Selecione.</option>
<option value= " Sim " > Sim </option>
<option value= " Não " > Não </option>
</select>
</span></td>
</tr>
<tr>
<td colspan="2" align="center">Participação em Gondola (Percentual)</td>
</tr>
<tr>
<td>Creme Dental:</td>
<td><input name="pcreme" type="text" id="pcreme" size="15" maxlength="100" value="<?php echo $dados["pcreme"];?>"></td>
</tr>
<tr>
<td>Escovas Dentais:</td>
<td><input name="percescovas" type="text" id="percescovas" size="15" maxlength="100" value="<?php echo $dados["percescovas"];?>"></td>
</tr>
<tr>
<td>Enxaguantes:</td>
<td><input name="percenxaguantes" type="text" id="percenxaguantes" size="15" maxlength="100" value="<?php echo $dados["percenxaguantes"];?>"></td>
</tr>
<tr>
<td>Sabonete Barra:</td>
<td><input name="percsaboneteb" type="text" id="percsaboneteb" size="15" maxlength="100" value="<?php echo $dados["percsaboneteb"];?>"></td>
</tr>
<tr>
<td>Sabonete Liquido:</td>
<td><input name="psabonetel" type="text" id="psabonetel" size="15" maxlength="100" value="<?php echo $dados["psabonetel"];?>"></td>
</tr>
<tr>
<td colspan="2" align="center">
<button type="submit" class="btn btn-primary">Enviar</button>
<button type="reset" class="btn btn-primary">Limpar</button></td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
</body>
</html>Discussão (1)
Carregando comentários...