Jump to content

LuizH.M

Members
  • Content count

    8
  • Joined

  • Last visited

Community Reputation

0 Comum

About LuizH.M

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. LuizH.M

    Filtrar por data

    eu sei fazer a consulta via botão mas eu queria um filtro que conforme eu fosse colocando as datas ele já iria filtrando, confirmei que no banco está no formato data Agradeço a ajuda
  2. LuizH.M

    Filtrar por data

    Tó com dificuldade para fazer um filtro que aconteça a medida que eu vou colocando as datas no input Agradeço desde já vlw <?php include_once('conexao.php'); $sql = sprintf("SELECT * FROM caixa ORDER BY 'data' "); $dados = mysqli_query($con,$sql) or die(mysqli_error()); $resul = mysqli_query($con, "SELECT sum(dinheiro) FROM caixa"); function between(){ if(!empty($data0) and empty($data1)){ $data0 = $_GET['data0']; $data1 = $_GET['data1']; $sql = mysqli_query("SELECT metodo,dinheiro,data FROM caixa WHERE data BETWEEN '$data0' and '$data1'"); $dados0 = mysqli_query($con,$sql) or die(mysqli_error()); while($linha = mysqli_fetch_array($dados0)) { ?> <tr> <td><?php echo $linha['metodo']?></td> <td><?php echo "R$ ". $linha['dinheiro']?></td> <td width="120"><?php echo date('d/m/Y', strtotime($linha['data']))?></td> </tr> <?php } ?> <?php } } ?> <!DOCTYPE html> <html lang="PT-BR"> <head> <title></title> <!-- META--> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <style> *{ margin:0px; padding:0px; } table,th,td{ border:none } table{ width:100%; display:table; } table th{ text-align:center!important; } table td{ text-align:left!important; } table.bordered>thead>tr,table.bordered>tbody>tr{ border-bottom:1px solid #d0d0d0; } table.striped>tbody>tr:nth-child(odd){ background-color:#f2f2f2; } table.striped>tbody>tr>td{ border-radius:0; }table.highlight>tbody>tr{ transition:background-color .25s ease; } table.highlight>tbody>tr:hover{ background-color:#f2f2f2; } table.centered thead tr th,table.centered tbody tr td{ text-align:center; } .title{ text-align:center!important; padding:15px 5px; font-family:'times new roman'; font-size:20px; } thead{ border-bottom:1px solid #d0d0d0; } td,th{ padding:15px 5px; display:table-cell; } .delete { -moz-box-shadow: 0px 1px 0px 0px #fff6af; -webkit-box-shadow: 0px 1px 0px 0px #fff6af; box-shadow: 0px 1px 0px 0px #fff6af; background:-webkit-gradient(linear, left top, left bottom, color-stop(0.05, #ffec64), color-stop(1, #ffab23)); background:-moz-linear-gradient(top, #ffec64 5%, #ffab23 100%); background:-webkit-linear-gradient(top, #ffec64 5%, #ffab23 100%); background:-o-linear-gradient(top, #ffec64 5%, #ffab23 100%); background:-ms-linear-gradient(top, #ffec64 5%, #ffab23 100%); background:linear-gradient(to bottom, #ffec64 5%, #ffab23 100%); filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffec64', endColorstr='#ffab23',GradientType=0); background-color:#ffec64; -moz-border-radius:6px; -webkit-border-radius:6px; border-radius:6px; border:1px solid #ffaa22; display:inline-block; cursor:pointer; color:#333333; font-family:Arial; font-size:12px; font-weight:bold; padding:6px 15px; text-decoration:none; text-shadow:0px 1px 0px #ffee66; } .delete:hover { background:-webkit-gradient(linear, left top, left bottom, color-stop(0.05, #ffab23), color-stop(1, #ffec64)); background:-moz-linear-gradient(top, #ffab23 5%, #ffec64 100%); background:-webkit-linear-gradient(top, #ffab23 5%, #ffec64 100%); background:-o-linear-gradient(top, #ffab23 5%, #ffec64 100%); background:-ms-linear-gradient(top, #ffab23 5%, #ffec64 100%); background:linear-gradient(to bottom, #ffab23 5%, #ffec64 100%); filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffab23', endColorstr='#ffec64',GradientType=0); background-color:#ffab23; } .delete:active { position:relative; top:1px; } @media screen and (max-width: 750px){ footer{ position:absolute; top:1200px; } } </style> </head> <body> <table class="bordered striped highlight"> <p class="title">Caixa da Igreja</p> <p>Pesquise por Data : &nbsp&nbsp <input type="date" name="data0" required>&nbsp Até &nbsp&nbsp<input type="date" name="data1" required> <?php while($linha = mysqli_fetch_array($dados)) { ?> <tr> <td><?php echo $linha['metodo']?></td> <td><?php echo "R$ ". $linha['dinheiro']?></td> <td width="120"><?php echo date('d/m/Y', strtotime($linha['data']))?></td> </tr> <?php } ?> </br> </table></p> <div id="total"> <?php while($result = mysqli_fetch_array($resul)){ echo "Total R$: ".$result['sum(dinheiro)'].'<br/>'; }?> </div> </br> </body> </html>
  3. LuizH.M

    Menu responsivo

    Será que você tem um código para exemplo ?
  4. LuizH.M

    Menu responsivo

    então jovem o menu desaparece , mas como eu faço pra ele aparecer quando click no botão ?
  5. LuizH.M

    Menu responsivo

    Então gente eu to com um menu mas não consigo deixar ele responsivo, eu sei q existe varios outros menus responsivo na internet mas meu site ja ta pronto so falta a parte do menu conto com a ajuda de vcs HTML <!-- Barra de Menu --> <div class="container"> <nav class="menu"> <ul> <li><a href="index.php">Home</a></li> <li><a href="agenda.php">Agenda</a></li> <li><a href="departamento.php">Departamento</a></li> <li><a href="https://www.flickr.com/photos/142117425@N02/" target="blanck">Fotos</a></li> <li><a href="#localizacao">Localização</a></li> <li><a href="https://www.facebook.com/deives.duarte.9" target="blanck" class="fa fa-facebook"></a></li> <li><a href="#" target="blanck" class="fa fa-twitter"></a> <li><a href="#" class="fa fa-youtube"></a> </ul> </nav> </div> CSS .container { position: absolute; margin: 20px; width: auto; } .menu{ width:100%; height:54px; background-color: #333; font-family:'Arial'; } .menu ul{ list-style:none; position:relative; background-color: #333; /*css custom*/ display: flex; flex-wrap: wrap; padding-left: 0px; } .menu ul li{ width:50px auto; float:left; } .menu a{ padding:15px; display:block; text-decoration:none; text-align:center; color:#fff; } .menu ul ul{ position:absolute; visibility:hidden; } .menu ul li:hover ul{ visibility:visible; } .menu a:hover{ background-color:#f4f4f4; color:#555; } .menu ul ul li{ float:none; border-bottom:1px solid #ccc; } .menu ul ul li a{ background-color:#069; } @media screen and (max-width: 640px){ .menu ul li{ width: 100%; text-align:center; } .menu a{ text-align:center; } }
  6. Muito obrigado jovem pela sua ajuda
  7. Só preciso arrumar pra modo texto?
  8. Gostaria q pudessem me ajudar HTML <div class="container"> <nav class="menu"> <ul> <li><a href="index.php">Home</a></li> <li><a href="agenda.php">Agenda</a></li> <li><a href="departamento.php">Departamento</a></li> <li><a href="https://www.flickr.com/photos/142117425@N02/" target="blanck">Fotos</a></li> <li><a href="#localizacao">Localização</a></li> <li><a href="https://www.facebook.com/deives.duarte.9" target="blanck" class="fa fa-facebook"></a></li> <li><a href="#" target="blanck" class="fa fa-twitter"></a> <li><a href="#" class="fa fa-youtube"></a> </ul> </nav> </div> CSS .container { position: absolute; margin: 20px; width: auto; } .menu{ width:100%; height:auto; background-color: #333; font-family:'Arial'; } .menu ul{ list-style:none; position:relative; background-color: #333; } .menu ul li{ width: auto; height:auto; float:left; } .menu a{ padding:15px; text-decoration:none; text-align:center; color:#fff; } .menu a:hover{ background-color:#f4f4f4; color:#555; }
×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.