Path: C:\
<!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>Destinatários</title>
<link href="../TransWar-serviços/images/favicon.ico" rel="icon" type="image/png">
<link href="../TransWar-serviços/css/style5.css" rel="stylesheet" type="text/css" />
<link href="../TransWar-serviços/css/estilo.css" rel="stylesheet" type="text/css" />
<script src='../TransWar-serviços/js/jquery-2.1.3.min.js'></script>
</head>
<?php
$host = "192.168.0.201";
$db = "dtbtransporte";
$user = "bi";
$password = "BI@Consult@";
$connectionOptions = array("Database" => $db, "UID" => $user, "PWD" => $password,"CharacterSet" => "UTF-8");
$conn = sqlsrv_connect( $host, $connectionOptions);
if (!$conn){echo "ATENÇÃO!! FALHA NA CONEXÃO BANCO DE DADOS!";}
date_default_timezone_set('America/Sao_Paulo');
$hoje = date("d/m/Y -- G:i");
$dateadd = date("Y-m-d");
if (isset($_POST['op'])) {$inicial=$_POST['op'];}else{$inicial="nada";}
if ($inicial == "Update")
{ $altera = sqlsrv_query($conn, "UPDATE tbdDestEmail SET
Nome = '" . $_POST ['Nome'] . "' ,
Email = '" . $_POST ['Email'] . "'
WHERE id_Dest='" .$_POST ['id']."'" );
if(sqlsrv_rows_affected($altera) != 0){
echo "
<script type=\"text/javascript\">
alert(\"Alterado com Sucesso.\");
</script>
";
}
else{
echo "
<script type=\"text/javascript\">
alert(\"Alteração NÃO teve Sucesso.\");
</script>
";
}
}
else if ($inicial=="Delete")
{
$deleta = sqlsrv_query( $conn, "DELETE FROM tbdDestEmail WHERE id_Dest='" .$_POST ['id']."'" );
}
else if ($inicial=="Incluir")
{ $inclui = sqlsrv_query( $conn, "INSERT INTO [dbo].[tbdDestEmail] ([Nome],[Email],[Alerta])VALUES (
'" . $_POST ['Nome'] . "' ,
'" . $_POST ['Email'] . "' ,
'3'
)" );
if(sqlsrv_rows_affected($inclui) != 0)
{ echo "<script type=\"text/javascript\">alert(\"Destinatário Incluído com Sucesso.\");</script>"; }
else
{ echo "<script type=\"text/javascript\">alert(\"ERRO na Inclusão!!!\");</script>";}
}
$query = "SELECT id_Dest
,Nome
,Email
,Alerta
,convert(varchar(17),Ultimo,113) as Ultimo
FROM tbdDestEmail
ORDER BY Nome ASC";
$consulta = sqlsrv_query( $conn, $query, array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$num = sqlsrv_num_rows($consulta); $z=0;
if ( $num > 0 )
{ while ($rows = sqlsrv_fetch_array($consulta, SQLSRV_FETCH_ASSOC))
{ if ($rows["Alerta"]=='3')
{
$z++;
$id[$z] = $rows["id_Dest"];
$nome[$z] = trim($rows["Nome"]);
$email[$z] = trim($rows["Email"]);
$alerta[$z] = $rows["Alerta"];
$ultimo[$z] = $rows["Ultimo"];
}
}
}
?>
<body style="background-color:#DCDCDC;">
<table align="center" border="0" cellpadding="1" cellspacing="0" width="80%">
<tr>
<td>
<table align="center" width="100%" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center" width="30%">
<img src="../images/logo03.png" width="100%" height="85" border="0" />
</td>
<td align="center" width="50%">
<span style='font-size: 20px;color:white;border-radius:4px;background-color:#337ab7;padding:.2em .6em .3em'> DESTINATÁRIOS PARA RESUMO </span>
</td>
<td align="center" width="20%">
<form method="post" action="index.php">
<input value="Voltar" type="submit" class="button2" />
</form>
</td>
</tr>
</table>
<table bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top">
<table width="100%" align="center" cellpadding="1" cellspacing="1" bgcolor="#F3F3F3">
<col width="35%" />
<col width="35%" />
<col width="16%" />
<col width="7%" />
<col width="7%" />
<thead>
<tr bgcolor="#BDC3C7">
<th align="center" height="31" colspan="5">
<font style='color:red;' size="4"><?php echo $hoje; ?></font>
</th>
</tr>
<tr height="31" bgcolor="#337ab7" >
<th align="center"><b>N O M E</b></th>
<th align="center"><b>E M A I L</b></th>
<th align="center"><b>ÚLTIMO EMAIL</b></th>
<th colspan="2" align="center"><b>AÇÃO</b></th>
</tr>
</thead>
<tbody>
<?php
for ($q=1; $q <= $z; $q++)
{
?>
<tr>
<form method="post">
<input name="op" type="hidden" value="Update" />
<input name="id" type="hidden" value="<?php echo $id[$q]; ?>" />
<td align="left"><input name="Nome" required type="text" value="<?php echo $nome[$q]; ?>" size="50%" maxlength="50" /></td>
<td align="left"><input name="Email" required type="email" value="<?php echo $email[$q]; ?>" size="50%" maxlength="50" /></td>
<td align="center" style="border:1px solid black;border-radius:3px;"><?php echo $ultimo[$q];?></td>
<td align="center"><input value="Alterar" type="submit" class='btn-alterar' /></td>
</form>
<td align="center">
<form method="post">
<input name="id" type="hidden" value="<?php
echo $id[$q]; ?>" />
<input name="op" type="hidden" value="Delete" />
<input value="Excluir" type="submit" class='btn-excluir' onclick="return confirm('Certeza que precisa Excluir este Destinatário?');" />
</form>
</td>
</tr>
<?php } ?>
<tr><td> </td></tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
</tbody>
</table>
<form method="post">
<input name="op" type="hidden" value="Incluir" />
<table width="100%" align="center" cellpadding="1" cellspacing="1" bgcolor="#F3F3F3">
<col width="35%" />
<col width="35%" />
<col width="30%" />
<thead>
<tr>
<th align="center" height="31" bgcolor="#BDC3C7" colspan="3"><font color="red" size="4">Inclusão de Novo Destinatário.</font>
</th>
</tr>
<tr height="31" bgcolor="#337ab7" color="white">
<th align="center"><b>N O M E</b></th>
<th align="center"><b>E M A I L</b></th>
<th align="center"><b>AÇÃO</b></th>
</tr>
</thead>
<tr>
<td align="left"><input name="Nome" type="text" size="50%" maxlength="50" value='' required /></td>
<td align="left"><input name="Email" type="email" size="50%" maxlength="50" value='' required/></td>
<td align="center">
<input value="Incluir" type="submit" class='btn-incluir' autofocus/>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
<p width="80%" class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados.</p>
</html>