Path: C:\
<?php
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y");
$host = "192.168.0.203";
$db2 = "Auxiliar";
$user2 = "sa";
$password2 = "";
$connectionOptions2 = array("Database" => $db2, "UID" => $user2, "PWD" => $password2);
$conn2 = sqlsrv_connect( $host, $connectionOptions2 );
if (!$conn2){echo "ATENÇÃO!! FALHA NA CONEXÃO BANCO OMNILINK Auxiliar!";}
$tsql = "SELECT nome, pis, cpf FROM tMotoristas where ativo='1' ORDER BY nome ASC";
$row2= sqlsrv_query($conn2, $tsql);
if( $row2 === false )
{ if( ($errors = sqlsrv_errors() ) != null)
{ foreach( $errors as $error )
{
echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
echo "código: ".$error[ 'code']."<br />";
echo "mensagem: ".$error[ 'message']."<br />";
}
echo 'ATENÇÃO!! FALHA NA consulta ao BANCO OMNILINK Auxiliar!';
exit();
}
}
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<title>Comprovante Jornada</title>
<link rel="icon" type="image/png" href="img/favicon.ico">
<link href="css/estilo.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/redmond/jquery-ui-1.10.1.custom.css" />
<script src="js/jquery-1.9.1.js" type="text/javascript"></script>
<script src="js/jquery-ui.js" type="text/javascript"></script>
<script type="text/javascript">
function showCarga()
{
document.getElementById('carga').style.display="block";
}
function hideCarga()
{
document.getElementById('carga').style.display="none";
}
$(function() {
var dates = $( "#from" ).datepicker({
altField: '#dia_from', defaultDate: null, setDate:null,
showOtherMonths: true,
maxDate: "0d",
minDate: "-1y",
dayNamesMin: ['D','S','T','Q','Q','S','S','D'],
dayNamesShort: ['Dom','Seg','Ter','Qua','Qui','Sex','Sáb','Dom'],
dayNames: ['Domingo','Segunda','Terça','Quarta','Quinta','Sexta','Sábado'],
monthNamesShort: ['Jan','Fev','Mar','Abr','Mai','Jun','Jul','Ago','Set','Out','Nov','Dez'],
monthNames: ['Janeiro','Fevereiro','Março','Abril','Maio','Junho','Julho','Agosto','Setembro','Outubro','Novembro','Dezembro'],
dateFormat: 'dd/mm/yy',
nextText: 'Próximo',
prevText: 'Anterior',
onSelect: function( selectedDate ) {
var option = this.id == "from" ? "minDate" : "maxDate",
instance = $( this ).data( "datepicker" ),
date = $.datepicker.parseDate(
instance.settings.dateFormat ||
$.datepicker._defaults.dateFormat,
selectedDate, instance.settings );
dates.not( this ).datepicker( "option", option, date );
}
});
$("input[type=submit]").click(function(e){
$('#carga').show();
e.preventDefault();
var di = $("#from").val();
var cpf = $("#cpf").val();
$.post(
"consulta.php",
{ di: di, cpf:cpf },
function(data){
$("#resultados").html(data);
}
);
});
});
</script>
</head>
<body>
<div id="geral">
<div id="cabecalho" align="center" >
<h1><img src="img/logo.png"></h1>
</div>
<div id="corpo">
<table width="100%" align="center" cellspacing="0" bgcolor="#E9E9E9">
<form id="form" name="form" method="post" action="consulta.php" enctype="multipart/form-data">
<tr>
<td colspan="3" align="center" >
<h2 align="center">COMPROVANTE DIÁRIO DE JORNADA</h2>
</td>
<tr>
<td colspan="3" align="center">
<p>Escolha o Motoristas:
<select id="cpf" name="cpf" style="height: 20px; width:330px;">
<?php
while ($row = sqlsrv_fetch_array($row2, SQLSRV_FETCH_ASSOC))
{
?>
<option value="<?php echo $row [ "cpf" ]; ?>">
<?php echo utf8_encode($row [ "nome" ]) ; ?>
</option>
<?php
}
?>
</select>
</p>
</td>
</tr>
</tr>
<tr>
<td align="center" valign="middle" width="40%" >
<div id="from">
<input type="hidden" name="dia_from" required id="dia_from" value="<?php echo $dateadded;?>" class="form-control">
</div>
</td>
</tr>
<tr>
<td align="center" valign="middle" width="20%">
<input type="submit" name="Data" id="Data" class="button2" value="Visualizar" />
<div align="center" class="loading" id="carga" >
<img class="imgloading" src="img/tempo.gif" style="height:30; width:240">
</div>
</td>
</tr>
</form>
</table>
</div>
<div id="resultados"></div>
</div>
</body>