Jump to content
Fórum Script Brasil

edyr0x

Membros
  • Content Count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutro

About edyr0x

  1. migrei meu sistema de server, eu utilizava php 5 e agora o novo server é php 7 como faço pra substiuir esta função no php 7, essa função seria para pegar somente o texto da variavel e ignorar os numeros. <?php echo eregi_replace("([^a-z ])","",$aPaga[0]["resumo"]); ?>
  2. ok, te mandei msg no privado
  3. Boa tarde Leonardo! poderia me ajudar em mais uma questão? quero gerar, uma tabela que pegue tipo de camisa, quantidade e data... na verdade quero que some a quantidade de camisa P, M, e G produzidas no determinado mês... como esta da imagem em anexo. segue meu banco: roupas id quantidade data camisas usuario local segue meu código: $link = $conexao; mysqli_query($conexao,"SET lc_time_names = 'pt_BR'"); $consultar = "SELECT SUM(`quantidade`) AS qtd, MONTHNAME(data) AS mes, camisas AS cam FROM roupas GROUP BY MONTH(`data`), camisas"; $resulta = mysqli_query($link, $consultar); <table> <tr> <th class="tg-sg5v">MES</th> <th class="tg-sg5v">CAMISA</th> <th class="tg-sg5v">QUANT</th> </tr> <?php foreach ($resulta as $row) { ?> <tr> <td class="tg-0w8i"><?php echo $row['mes']; ?></td> <td class="tg-0w8i"><?php echo $row['cam']; ?></td> <td class="tg-0w8i"><?php echo $row['qtd']; ?></td> </tr> <?php } ?> </table
  4. ALGUÉM PODERIA ME AJUDAR NESTE RELATÓRIO? quero gerar, uma tabela que pegue tipo de camisa, quantidade e data... na verdade quero que some a quantidade de camisa P, M, e G produzidas no determinado mês... como esta da imagem em anexo. segue meu banco: roupas id quantidade data camisas usuario local segue meu código: $link = $conexao; mysqli_query($conexao,"SET lc_time_names = 'pt_BR'"); $consultar = "SELECT SUM(`quantidade`) AS qtd, MONTHNAME(data) AS mes, camisas AS cam FROM roupas GROUP BY MONTH(`data`), camisas"; $resulta = mysqli_query($link, $consultar); <table> <tr> <th class="tg-sg5v">MES</th> <th class="tg-sg5v">CAMISA</th> <th class="tg-sg5v">QUANT</th> </tr> <?php foreach ($resulta as $row) { ?> <tr> <td class="tg-0w8i"><?php echo $row['mes']; ?></td> <td class="tg-0w8i"><?php echo $row['cam']; ?></td> <td class="tg-0w8i"><?php echo $row['qtd']; ?></td> </tr> <?php } ?> </table OBS: LEMBRANDO QUE ESSES DADOS CAMISA P, CAMISA M, CAMISA G, VEM DE UMA COLUNA DO BANCO DE DADOS (camisas) PODERÁ SER ACRESCENTADO CAMISA GG, CAMISA XG, ETC...
  5. VALEU LEONARDO! AGORA FICOU 100% 👏
  6. Leonardo, Desculpa, acho que não expliquei direito... tenta preencher os dados do COMPRADOR e em seguida vai em baixo e clica pra preencher os dados do VENDEDOR que verá que tudo que foi preenchido COMPRADOR se apagará... link: https://jsfiddle.net/745yr0vm/ desculpa mais uma vez o meu código gigante... é que ainda to no feijão com arroz !!! rsrssr se puder me mandar um exemplo do que citou serei grato!!
  7. BOA NOITE, FIZ CADASTRO COM BUTTON COLAPSE, QUE POSSO SETAR A QUANTIDADE DE PESSOAS QUE QUERO CADASTRAR, TANTO VENDEDOR QUANTO COMPRADOR E QUE CALCULA IDADE AUTOMATICAMENTE. PORÉM QUANDO ACABO DE PREENCHER O COMPRADOR E VOU PREENCHER O VENDEDOR ELE ZERA O COMPRADOR. NÃO SEI SE ME EXPRESSEI LEGAL. MAS VOU MANDAR O CÓDIGO PRA SE ALGUÉM PUDER ME AJUDAR. AGRADEÇO!! <button type="button" class="btn btn-secondary btn-sm btn-block" data-toggle="collapse" data-target="#COMPRADORs"><i class="fa fa-sign-out"></i> COMPRADOR(ES) </button> <div class="form-group"> <div id="COMPRADORs" class="collapse"> <div class="form-group"> <div class="form-group"> <label class="col-md-2 control-label" for="textinput">QUANTIDADE</label> <div class="col-md-1"> <input id="envolvidoCOMPRADOR" name="envolvidoCOMPRADOR" type="text" value="" placeholder="" class="form-control" maxlength = "1"> </div> </div> <script> $(document).ready(function() { $('#form input').keyup(function() { if($('#envolvidoCOMPRADOR').val() == "2") { document.getElementById("demoenvolCOMPRADOR").innerHTML = ' <div class="form-group"><input type="hidden" id="envolvido1tipo" name="envolvido1tipo" value="COMPRADOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido1nome" name="envolvido1nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido1sexo" name="envolvido1sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido1idt" name="envolvido1idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido1nasc" name="envolvido1nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido1idade" name="envolvido1idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido1situa" name="envolvido1situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div> </div> </div> <hr> \ <div class="form-group"><input type="hidden" id="envolvido2tipo" name="envolvido2tipo" value="COMPRADOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido2nome" name="envolvido2nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido2sexo" name="envolvido2sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for \ ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido2idt" name="envolvido2idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido2nasc" name="envolvido2nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido2idade" name="envolvido2idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido2situa" name="envolvido2situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div></div> <hr> \ '; document.getElementById("envolvido2nasc").addEventListener('change', function() { var dataA = new Date(this.value); if(isDate_A(this.value) && dataA.getFullYear() > 1900) document.getElementById("envolvido2idade").value = calculateAge2(this.value); }); document.getElementById("envolvido1nasc").addEventListener('change', function() { var dataA = new Date(this.value); if(isDate_A(this.value) && dataA.getFullYear() > 1900) document.getElementById("envolvido1idade").value = calculateAge(this.value); }); function calculateAge2(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calculateAge(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calcular2(dataA) { var dataA = document.form.envolvido2nasc.value; alert(dataA); var partes = dataA.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.idade.value = (calculateAge(junta)); } function calcular(dataA) { var dataA = document.form.envolvido1nasc.value; alert(dataA); var partes = dataA.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.idade.value = (calculateAge(junta)); } var isDate_ = function(input) { var status = false; if (!input || input.length <= 0) { status = false; } else { var result = new Date(input); if (result == 'Invalid Date') { status = false; } else { status = true; } } return status; } } else if($('#envolvidoCOMPRADOR').val() == "1") { document.getElementById("demoenvolCOMPRADOR").innerHTML = ' <div class="form-group"><input type="hidden" id="envolvido1tipo" name="envolvido1tipo" value="COMPRADOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido1nome" name="envolvido1nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido1sexo" name="envolvido1sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido1idt" name="envolvido1idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido1nasc" name="envolvido1nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido1idade" name="envolvido1idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido1situa" name="envolvido1situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div></div> <hr> \ '; document.getElementById("envolvido1nasc").addEventListener('change', function() { var data = new Date(this.value); if(isDate_(this.value) && data.getFullYear() > 1900) document.getElementById("envolvido1idade").value = calculateAge(this.value); }); function calculateAge(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calcular(data) { var data = document.form.envolvido1nasc.value; alert(data); var partes = data.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.envolvido1idade.value = (calculateAge(junta)); } var isDate_ = function(input) { var status = false; if (!input || input.length <= 0) { status = false; } else { var result = new Date(input); if (result == 'Invalid Date') { status = false; } else { status = true; } } return status; } } else { document.getElementById("demoenvolCOMPRADOR").innerHTML = ' <div class="form-group"> \ </div> </div> \ '; } }); }); </script> <p id="demoenvolCOMPRADOR"></p> </div> </div> </div> <button type="button" class="btn btn-secondary btn-sm btn-block" data-toggle="collapse" data-target="#VENDEDORs"><i class="fa fa-sign-out"></i> VENDEDOR(ES) </button> <div class="form-group"> <div id="VENDEDORs" class="collapse"> <div class="form-group"> <div class="form-group"> <label class="col-md-2 control-label" for="textinput">QUANTIDADE</label> <div class="col-md-1"> <input id="envolvidoVENDEDOR" name="envolvidoVENDEDOR" type="text" value="" placeholder="" class="form-control" maxlength = "1"> </div> </div> <script> $(document).ready(function() { $('#form input').keyup(function() { if($('#envolvidoVENDEDOR').val() == "2") { document.getElementById("demoenvolVENDEDOR").innerHTML = ' <div class="form-group"><input type="hidden" id="envolvido6tipo" name="envolvido6tipo" value="VENDEDOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido6nome" name="envolvido6nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido6sexo" name="envolvido6sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido6idt" name="envolvido6idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido6nasc" name="envolvido6nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido6idade" name="envolvido6idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido6situa" name="envolvido6situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div> </div> </div> <hr> \ <div class="form-group"><input type="hidden" id="envolvido7tipo" name="envolvido7tipo" value="VENDEDOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido7nome" name="envolvido7nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido7sexo" name="envolvido7sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for \ ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido7idt" name="envolvido7idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido7nasc" name="envolvido7nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido7idade" name="envolvido7idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido7situa" name="envolvido7situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div></div> <hr> \ '; document.getElementById("envolvido7nasc").addEventListener('change', function() { var data = new Date(this.value); if(isDate_(this.value) && data.getFullYear() > 1900) document.getElementById("envolvido7idade").value = calculateAge7(this.value); }); document.getElementById("envolvido6nasc").addEventListener('change', function() { var data = new Date(this.value); if(isDate_(this.value) && data.getFullYear() > 1900) document.getElementById("envolvido6idade").value = calculateAge(this.value); }); function calculateAge7(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calculateAge(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calcular7(data) { var data = document.form.envolvido7nasc.value; alert(data); var partes = data.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.idade.value = (calculateAge(junta)); } function calcular(data) { var data = document.form.envolvido6nasc.value; alert(data); var partes = data.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.idade.value = (calculateAge(junta)); } var isDate_ = function(input) { var status = false; if (!input || input.length <= 0) { status = false; } else { var result = new Date(input); if (result == 'Invalid Date') { status = false; } else { status = true; } } return status; } } else if($('#envolvidoVENDEDOR').val() == "1") { document.getElementById("demoenvolVENDEDOR").innerHTML = ' <div class="form-group"><input type="hidden" id="envolvido6tipo" name="envolvido6tipo" value="VENDEDOR"> \ <label class="col-md-2 control-label" for="textinput">NOME COMPLETO</label> \ <div class="col-md-4"> \ <input id="envolvido6nome" name="envolvido6nome" type="text" value="" placeholder="" class="form-control" maxlength = "100"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">SEXO</label> \ <div class="col-md-1"> \ <input id="envolvido6sexo" name="envolvido6sexo" type="text" value="" placeholder="" class="form-control" maxlength = "1"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDENTIDADE</label> \ <div class="col-md-2"> \ <input id="envolvido6idt" name="envolvido6idt" type="text" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> </div> \ <div class="form-group"> \ <label class="col-md-2 control-label" for="textinput">NASCIMENTO</label> \ <div class="col-md-3"> \ <input id="envolvido6nasc" name="envolvido6nasc" type="date" value="" placeholder="" class="form-control" maxlength = "30"> \ </div> \ <label class="col-md-1 control-label" for ="textinput">IDADE</label> \ <div class="col-md-1"> \ <input id="envolvido6idade" name="envolvido6idade" type="num" value="" placeholder="" class="form-control" maxlength = "3" readonly=""> \ </div> \ <label class="col-md-2 control-label" for="textinput">SITUAÇÃO</label> \ <div class="col-md-2"> \ <select id="envolvido6situa" name="envolvido6situa" class="form-control" maxlength = "50" style="width:150px"> \ <option value=" "> </option> \ <option value="A">A</option> \ <option value="B">B</option> \ <option value="C">C</option> \ </select> </div></div> <hr> \ '; document.getElementById("envolvido6nasc").addEventListener('change', function() { var data = new Date(this.value); if(isDate_(this.value) && data.getFullYear() > 1900) document.getElementById("envolvido6idade").value = calculateAge(this.value); }); function calculateAge(dobString) { var dob = new Date(dobString); var currentDate = new Date(); var currentYear = currentDate.getFullYear(); var birthdayThisYear = new Date(currentYear, dob.getMonth(), dob.getDate()); var age = currentYear - dob.getFullYear(); if(birthdayThisYear > currentDate) { age--; } return age; } function calcular(data) { var data = document.form.envolvido6nasc.value; alert(data); var partes = data.split("/"); var junta = partes[2]+"-"+partes[1]+"-"+partes[0]; document.form.envolvido6idade.value = (calculateAge(junta)); } var isDate_ = function(input) { var status = false; if (!input || input.length <= 0) { status = false; } else { var result = new Date(input); if (result == 'Invalid Date') { status = false; } else { status = true; } } return status; } } else { document.getElementById("demoenvolVENDEDOR").innerHTML = ' <div class="form-group"> \ </div> </div> \ '; } }); }); </script> <p id="demoenvolVENDEDOR"></p> </div> </div> </div> SÓ LEMBRANDO QUE o valor do <input id="envolvidoCOMPRADOR"> seta q quantidade de pessoa pra eu cadastrar no DB, pois a ideia é colocar opção até umas 10 pessoas. vendedor e comprador
  8. Muito Obrigado Leonardo! Deu certo! 🙏 Agora vou partir pro próximo passo que é não aparecer os resultados que todos os meses sejam "0"
  9. array(5) { ["nome"]=> string(8) "Bolsa 12" ["total"]=> int(2) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "0" ["março"]=> string(1) "2" } array(5) { ["nome"]=> string(8) "Bolsa 20" ["total"]=> int(0) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "0" ["março"]=> string(1) "0" } array(5) { ["nome"]=> string(8) "Bolsa 38" ["total"]=> int(2) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "2" ["março"]=> string(1) "0" } array(5) { ["nome"]=> string(8) "Bolsa 40" ["total"]=> int(3) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "0" ["março"]=> string(1) "3" } array(5) { ["nome"]=> string(8) "Bolsa 80" ["total"]=> int(7) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "5" ["março"]=> string(1) "2" } array(5) { ["nome"]=> string(8) "Bolsa 90" ["total"]=> int(2) ["janeiro"]=> string(1) "0" ["fevereiro"]=> string(1) "2" ["março"]=> string(1) "0" }
  10. Obrigado pela dica Leonardo. Estou quase lá... mas acho que estou errando em algum lugar... minha tabela só saiu a soma total, os meses ficaram em branco... a tabela ficou assim agora..
  11. Alguém poderia me ajudar a gerar uma relátório em php? preciso gerar uma tabela com total de bolsas vendidas por mês. com total de cada modelo de bolsa fabricada por mês e total geral até consegui, porém gostaria de gerar com os meses nas colunas e só consegui gerar com os meses nas linhas... tentei da seguinte forma: $link = $conexao; $consultar = "SELECT SUM(`resumo_bolsas_80`) AS m80, SUM(`resumo_bolsa_12`) AS m12, SUM(`resumo_bolsa_20`) AS m20, SUM(`resumo_bolsa_40`) AS m40, SUM(`resumo_bolsa_90`) AS m90, SUM(`resumo_bolsa_38`) AS m38, MONTHNAME(resumo_data) AS `mes` FROM resocor GROUP BY YEAR(`resumo_data`), MONTH(`resumo_data`)"; $resulta = mysqli_query($link, $consultar); ################## codigo php ####################### <table> <tr> <th class="tg-sg5v">MES</th> <th class="tg-sg5v">80</th> <th class="tg-sg5v">12</th> <th class="tg-sg5v">20</th> <th class="tg-sg5v">40</th> <th class="tg-sg5v">90</th> <th class="tg-sg5v">38</th> </tr> <?php foreach ($resulta as $row) { ?> <tr> <td class="tg-0w8i"><?php echo $row['mes']; ?></td> <td class="tg-0w8i"><?php echo $row['m80']; ?></td> <td class="tg-0w8i"><?php echo $row['m12']; ?></td> <td class="tg-0w8i"><?php echo $row['m20']; ?></td> <td class="tg-0w8i"><?php echo $row['m40']; ?></td> <td class="tg-0w8i"><?php echo $row['m90']; ?></td> <td class="tg-0w8i"><?php echo $row['m38']; ?></td> </tr> <?php } ?> </table SEGUE TABELA ANEXADA DE COMO GOSTARIA QUE APARECESSE NO RELATORIO
  12. Alguém consegue Desincriptografar isso? PARECE QUE TEM MAIS DE UMA CRIPTOGRAFIA... EU SÓ CONSEGUI A PRIMEIRA PARTE... unescape("") O restante não consegui... Alguém aí consegue? <html><head><script>eval(unescape('%66%75%6E%63%74%69%6F%6E%20%6D%28%73%29%7B%76%61%72%20%63%2C%6E%2C%7A%2C%69%3B%7A%3D%27%27%3B%69%3D%30%3B%77%68%69%6C%65%28%69%3C%73%2E%6C%65%6E%67%74%68%29%7B%63%3D%73%2E%63%68%61%72%41%74%28%69%29%3B%20%69%66%28%27%75%27%3D%3D%63%29%7B%63%3D%27%25%27%2B%63%3B%63%2B%3D%73%2E%63%68%61%72%41%74%28%69%2B%31%29%3B%63%2B%3D%73%2E%63%68%61%72%41%74%28%69%2B%32%29%3B%63%2B%3D%73%2E%63%68%61%72%41%74%28%69%2B%33%29%3B%63%2B%3D%73%2E%63%68%61%72%41%74%28%69%2B%34%29%3B%6E%3D%35%3B%7D%20%65%6C%73%65%7B%63%3D%27%25%27%2B%63%3B%63%2B%3D%73%2E%63%68%61%72%41%74%28%69%2B%31%29%3B%6E%3D%32%3B%7D%7A%2B%3D%63%3B%69%3D%69%2B%6E%3B%7D%72%65%74%75%72%6E%20%7A%3B%7D%20%66%75%6E%63%74%69%6F%6E%20%65%28%73%29%7B%72%65%74%75%72%6E%20%75%6E%65%73%63%61%70%65%28%6D%28%73%29%29%3B%7D'));eval(e('66756E6374696F6E2064286F73297B766172206B65793D2261766364766466726565223B7661722064733B64733D27273B766172206B702C73702C732C6B632C73633B206B703D303B73703D303B7768696C652873703C6F732E6C656E677468297B73633D206F732E63686172436F64654174287370293B6B633D6B65792E63686172436F64654174286B70293B20696628282873635E6B63293D3D3339297C7C282873635E6B63293D3D3932297C7C282873635E6B63293C3332297C7C282873635E6B63293E3132362929207B733D537472696E672E66726F6D43686172436F6465287363293B7D656C73657B733D537472696E672E66726F6D43686172436F6465282873635E6B6329293B7D2064732B3D733B6B702B2B3B73702B2B3B6966286B703E3D6B65792E6C656E677468296B703D303B7D72657475726E2064733B7D2066756E6374696F6E2064692873297B733D642873293B646F63756D656E742E777269746528756E657363617065286D28732929293B7D'));/*EncryptHTML*/</script><script Language='JavaScript'>di('R5U8APP6S&R3QTECPJSPWGUPE!TBV&VBU][email protected]@USAPU0WSWATPE&[email protected]@WPKRWWEP&@ PGRWWGTWDTTDS&VBP&[email protected]"APPKRQW5UQE!TBV&W2UQAPPCWUWNTPAPQBW!WCTUAQPKRSR2QVBWP4S [email protected]!QFW!TBT][email protected]"P7RQWCU!APU6WWVBUQA8QFW#[email protected] [email protected]"D UJV]RCP]D [email protected]@QU6WWVBUQA8QFW#[email protected] SFPCDUT6W!Q2S%@VP4SQVOQTA&[email protected]@"QGS WBQ @WP4S&W0TVE%TBWVRGWQEWUEVQUEP&F [email protected]"AQP7SQS2U]@ PCSRWCP%[email protected] WBU"[email protected]]E&V6U$QOU @[email protected]!D [email protected]%TBVUVFT8E&V6U$QOU @[email protected]!D QFS#VFP%DTUBRUVNP&F V3U9W2UUAVPES9W3Q AVPKSRWNTPE%TBVUVFT8E&V6U$QOU @[email protected]!D [email protected]#[email protected]"P6V$SFPTATQJVBQ2S%A V6U$S2Q E!TBV&S0TWAPQKS&WCP!ECT4S][email protected]@"[email protected][email protected]@"[email protected] [email protected]@WPGS&[email protected][email protected]]@[email protected]]@[email protected]&[email protected]@"[email protected] [email protected]@WPGS&[email protected]]@[email protected]"@VP3SPWETPDTPKSQR2QVCRRAQ TBQVDTPAS#WBUQBVPCRVWCP DVPJRQVBTTE%T4W#VATSAST7S][email protected]@ QAW WEU"@ T4PSUEW!CPUAW UEWUBVTAPSWCTVAWPKS#W3P [email protected] [email protected][email protected]]@[email protected]!RGPQBQUDW!RGPUBPUFW!ROPVEURAW!RFPTETUBQVRFWQERUJQTUCWVDVTBSTW5U]@[email protected][email protected] RGV!SDV"@WQJWWSFVRBUR1PPUCP [email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]#WET][email protected][email protected] [email protected]@RSWCTVDVTBPSUGWCCQRGV!SDPVETUBW [email protected] [email protected][email protected]@STW2QTB!RCQ!UCP [email protected]]QFR9SDQTCRRCQ&TCWQE [email protected]@[email protected]!RCQ!UCP [email protected]@ TBQ UGW BQU6WWU4UQA][email protected]!SDP]E][email protected] RGV!SDW]@[email protected] [email protected] [email protected] PGWWSFVRBUR1PPUCP [email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]#[email protected]!TBV&VFUUAVPCS!SFW!BUR6QPR2QVBQQDSPW3TPCWPJS#VAQVDTSDQTU5VQBQU6WWRFQVE!TBV&[email protected] WAQVDTSDQTU5VQBQU6WWRFQVE!TBV&[email protected]@UQDVTBPSUGWCCQRGV!SDP]E][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@VP1SPTFVPC%[email protected]@[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@QPAWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]]@PPGS#U5U"[email protected]@[email protected]@WUBCSGQPR2QVEWUBWWR3QTECT4S#WDU%@[email protected]@][email protected]]PFRQWNP [email protected] [email protected]!ECT4RQWBP!DTU1RQWBP!DTU1S#WDU%@QPARQSFU]@[email protected][email protected]"PFSPUDUUAWPGV!SDU8APQFRUR7Q"D"[email protected]@UP7SQVET]AWQFSPW2TWD!PAS#W2Q"CRRAQ TBPWD!RAQTUDQWCRPGRWVEU]@"P7V!REQCEWT1VUS5PTDVTBS]WCU]@SPJRQR2QVEVUFVUSDQTASPKSQVBU8E [email protected] DVPAS&VEU]@PU3VQRFPRERUDVWRDWQD UCVPUCPRD UCVTUBPPD UKVWRGWWD [email protected]@UP1S9WAU!E [email protected]&[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]#WET8DVTBPSUGWCCQRGV!SDPUETUCVSRFQVE!TBV&VFUUAVPCS!SFW!BUR6QPR2QVC"PAR9SDQTCRRCQ&TCWQE [email protected]@[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]&TCWQE [email protected][email protected][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected] @[email protected]&TCWQE [email protected][email protected] RGV!SDVUAQPCS&WOTPA][email protected]@[email protected] [email protected] [email protected]@STW2QTB!RCQ!UCP [email protected]&TCWQE [email protected]]E][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@[email protected][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected][email protected]!TBV&[email protected]"[email protected]&TCWQE [email protected]@ TBQ UGW [email protected]@"QEWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]]@!PEWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]]QDSPSDQTCRRCQ&TCWQE [email protected]!TBV&[email protected]E!TBV&V[email protected][email protected]!RCQ!UCP [email protected]"R1S#VETPB]P7RQWCTVAVQGRUVBQVDTSDQTU5VQBQU6WWREPTDVU7WUR5Q"@"[email protected]$WCUWAPU7WUR5Q"APPFV SFPCD"[email protected]]P6SRSFTWAVPAV!SDPUA8UCW WAU]@[email protected]]@PQFS][email protected]@]PES]VBP DVUGWWR3PCD"QFSQR3QTECQFSQR3PCD"QFSQR3QTECQFSQR3PCD"QFSQR3QTECT4RQVDP!DTU1RQVDP!DTU1RQWBP!DTU1S#WDU%@QPARQSFU]@[email protected][email protected]"PFSPUDUUAWPGV!SDU8APQFRUR7Q"D"[email protected]@UP7SQVET]AWQFSPW2TWD!PAS#W2Q"CRRAQ TBPWD!RAQTUDQWCRPGRWVEU]@"P7V!REQCEWT1VUS5PTDVTBS]WCU]@SPJRQR2QVEVUFVUSDQTASPKSQVBU8E [email protected] DVPAS&VEU]@PU3VQRFPRERUDVWRDWQD UCVPUCPRD UCVTUBPPD UKVWRGWWD [email protected]@UP1S9WAU!E [email protected]&[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]#WET8DVTBPSUGWCCQRGV!SDPUETUCVSRFQVE!TBV&VFUUAVPCS!SFW!BUR6QPR2QVC"PAR9SDQTCRRCQ&TCWQE [email protected]@[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]&TCWQE [email protected][email protected][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected] @[email protected]&TCWQE [email protected][email protected] RGV!SDVUAQPCS&WOTPA][email protected]@[email protected] [email protected] [email protected]@STW2QTB!RCQ!UCP [email protected]&TCWQE [email protected]]E][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@[email protected][email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected][email protected]!TBV&[email protected]"[email protected]&TCWQE [email protected]@ TBQ UGW [email protected]@"QEWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]]@!PEWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]]QDSPSDQTCRRCQ&TCWQE [email protected]!TBV&[email protected]E!TBV&V[email protected][email protected]!RCQ!UCP [email protected]"R1S#VETPB]P7RQWCTVAVQGRUVBQVDTSDQTU5VQBQU6WWREPTDVU7WUR5Q"@"[email protected]$WCUWAPU7WUR5Q"APPFV SFPCAPPFV [email protected][email protected]"[email protected] [email protected][email protected]"@[email protected]$S0Q"[email protected]]PES][email protected][email protected][email protected]@RVWOU"@!U6VVS5PWDCUBW&[email protected][email protected]]PFRQWNP DVUAVWRFQVDTPAS&[email protected]%[email protected]@VWUCQ [email protected] EUUCQQRBQ E][email protected] [email protected]@CPKSRW3P [email protected]@[email protected]!RCQ!UCP [email protected] RGV!SDV"@WQKWWSFVRBUR1PPUCP [email protected]@STW2QTB!RCQ!UCP [email protected]@WWSFVRBUR1PPUCP [email protected]!EVUAVVS3PUEUUDW [email protected]@STW2QTB!RCQ!UCP DVRASTW2UQAVPCWWSFVRBUR1PPUCP [email protected] TBQ UGW [email protected]][email protected] TBQ UGW [email protected]@[email protected]!TBV&VFUUAVPCS!SFW!BUR6QPR2QVB&PGR9TDUUAPPGWWSFVRBUR1PPUCP DVUKV9ROP][email protected]@STW2QTB!RCQ!UCP DVRKS [email protected]@STW2QTB!RCQ!UCP [email protected]WUU3WUB [email protected]"AVPFWWSFVRBUR1PPUCP [email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@[email protected]!QFPVWNU"[email protected]@[email protected] SFPCATPCRWWGU DTR7QTU2WQE [email protected]@"[email protected][email protected]@[email protected]@V SFPCATPCRWWGU DTR7QTU2WQE [email protected]]ARPGWWSFVRBUR1PPUCP [email protected] [email protected]!PCSWW5UQCTSFP$SDQTCRRCQ&TCWQE [email protected][email protected] [email protected]"PFSPWEQVDTSDQTU5VQBQU6WWRGQVE!TBV&VFUUAVPCS!SFW!BUR6QPR2QVCRPKSQWCU"BCP4RVVBW]@!QFSPVDTVAQQBRQSDQTCRRCQ&TCWQE [email protected]!TBV&S0U"@VP3SPWETPE!TBV&[email protected]"[email protected] SFPCD"[email protected]&[email protected]"[email protected] SFPCD"[email protected]@[email protected] B%[email protected]@S9VFTPE!PDRPW3UWAPPKS#[email protected]]SOT&[email protected]!TBSSWGUCAWPGV[email protected] [email protected]]P4S SFUPATTJSPSOT&@]PDW]WCQ!ASPJS9WEU8E U6VTSOT&[email protected][email protected]@[email protected]!R6Q#TCVWBQR6Q#[email protected]]U0RRS3U"@!P6S#[email protected]#[email protected] P7RPW5UCE&Q6R!SFURAQP7SVVBU]@"[email protected]&S3WP4WUWCTWAP#[email protected]][email protected]@[email protected][email protected] [email protected]]P4S [email protected]&@]PDW]WCQ!ASPJS9WEU8E U6VVSOT&[email protected]!TBSQWGQ8D][email protected] [email protected]]P4S [email protected] [email protected]@[email protected]!QFW WDTQAPQFS#W3P&@]PDW]WNUSE [email protected]!R2PWD]PFSTSNQ]E&Q6WUWBP @PP4SVVCU @QP7RQR4TSE [email protected]"[email protected] PFW [email protected] @[email protected]!QFQWVOW]@PU0WUWOURD8QDSVSOT&@]PDW]VGUVD]Q0SQS3U"@!PAS#[email protected]@!QGV!WBUUE&PFW W0U!AWPGS&WCUWAPQARQWGTVAPU6SQW2T @QP1RVWCT&@PT7S#W3U @"[email protected]"QES [email protected] [email protected]]PDW][email protected]]Q0SQS3U"@!P6S#[email protected]#VAU!E PFS!R4UPD!P4S W2U"AQQASPVCTTE PFSQR4UPD!P4S WEU"@[email protected] PGS VCP @[email protected]]PDW][email protected] ASPKS WBU"[email protected]@QRGRSWCU!APQAW][email protected] B"[email protected]@!QFW U2W"CQSAQPUBW"CSR7W9R4TSD!P4S W2U"AQQASPWBU"ASP7V!WBUPE&QEW [email protected] P4RPVEUQAQQBV!WBTTE&Q6V&[email protected]@S9VFTPE!TBV&[email protected] [email protected]%@[email protected] [email protected]]P4S [email protected] [email protected][email protected]!SFURAQP7SVVBU]@"P7WUWBTTD8PGW9V4U]@[email protected] E UCW9V4TSE [email protected]"QEVBVAQ!AVPGS&[email protected]@!QFRVSNWQARPGS VBQ!B R4PPTEWQB R4PSUCQ]E&QEW [email protected] [email protected] P4RSWCP @!QGS&W5P&A [email protected]@!PARQWOU"@!TBSQWGQ8D][email protected]@[email protected] $A&[email protected]"[email protected]@S9W5U][email protected]&VEUQE&Q6R!SFURAQP7SVVBU]@"P7WUWBUPD8PGW9V4U]@[email protected] E [email protected]!DTPFSTSNQ]E&Q6R!SFURAQP7SVVBU]@"P7WUWEU D8TKRBWNUSE PGRSWCU!APT7SWVCTPAPP4S R4U]@RTJS]WAP E [email protected]&[email protected]!REQ]@PPCW]SOP&A [email protected]"[email protected]!QFVBVAP ASPKS WBU"ASU0RSWEP @PT7STW5UCE&[email protected][email protected]&[email protected]]@RTJRTWDQ]A&PFW [email protected] VBUQA8QFS!WCU!AQU6SQWGP&@PT7S#[email protected] [email protected]!P4S W2U"AQQASPWBU"ASP7V!WEU E&Q6R!SFU]@RTJRTWDQRDRTCRSWEQ]A&PFW [email protected] [email protected] @[email protected]"P7S!W0TQAWPGRPVFP @[email protected]"P7SVW0U!APPGR]VBU @[email protected] U0R!SFU]@[email protected]][email protected]]P7SQW0TSE&QEW [email protected]@!QFW U2W"[email protected]"[email protected]!U6SQWBP&AST7S#W3U @"QGRVWCTQATU6SQVFP&A U1W#[email protected]][email protected]@[email protected]]QBRQR3URAQP7SVVBU]@"P7WUWBU [email protected]&VEUQE&[email protected]@!PARQWOU"@[email protected] [email protected]]PAS]R2P EUTKRBVAP ASPKS WBU"[email protected]@QRGRSWCU!APQAW][email protected] B"SGPVUCW B"SDQPSOP&AST7S#W3U @"QGRVWCU @"QDSPR2U!AQP1S&R4T A [email protected]!DTPFSTSNQ]A&Q0STW5UQAVQFW]SDWQAWQASTSFURAQP7 R$EU"DTPGRVVB&[email protected]&[email protected]][email protected] [email protected]&A [email protected]@!PARQWOU"@[email protected] [email protected]]PAS]R2P [email protected]]SOP&A [email protected]@!PARQWOU"@!TBSVW2Q8D]Q0S]WAP @[email protected]@"P7VBWOURD8PJSRR2P EVQ1R&WNUSE [email protected] DTPFV!WBU"@[email protected]]P7SQW0TSE&QDSVR2UPD!PCS&W5P&[email protected][email protected]@QP6SPW3TPBVQKQ9WBP&[email protected]&@PT7S#[email protected]"P7RQWCT8APP6SPW3TQE PFSTR4UPD!P4S [email protected] @[email protected]"[email protected]!U6SVW2P&A [email protected]&@PT7S#W3U @"[email protected]"QES [email protected] U0SQS3U"@!P6S#[email protected]@PU0SQS3U"@!PAS#[email protected]@!QGV!WBU E&Q6WUWOURD8PFW W5UUA]PGRWVEQ]A&QEV!VAU]@!PFS#VAP&AST7SVWGTTAPQGRWWCWQARPGS [email protected]!R6Q#TCVWBQRFQ#tal!D]U0RRS3U"@!P6S#[email protected]#VAU!E PFSQR4TSD!P4S W2U"AQQASPVCTTE PFRUR4T [email protected]]QBRQR3QTECQASVVDU][email protected][email protected][email protected]]ATQFV [email protected]@!PARQWOU"@!TBSQW2Q8D][email protected] [email protected]&A [email protected]!DTPFRUSNUQD][email protected]@QT7RRWNU]@WPJV!R2PUD][email protected]]P7SQW0TSE&QEW [email protected]@[email protected]!QFW U2W"CQSAQPU2W"CRRGW9R4TSD!P4S W2U"AQQASPW2U"[email protected] DTPDRPW3UWAPPKS#[email protected]]SOT&A&PCS&[email protected]@!#E [email protected][email protected]@][email protected]]E&[email protected]@[email protected] A [email protected]!DTPFSQSNUQD][email protected]@QT7RRWNU]@WPJV!R2PWD][email protected] [email protected] A [email protected]@!PARQWOU"@!TBSVW2Q8D]Q0S]WAP @[email protected]@"P7VBWOURD8PJSRR2P EVQ1R&WNUSE [email protected] [email protected]"[email protected]!QFVBVAP ASPKS WBU"ASU0RSWEP @PT7STW5UCE&[email protected][email protected]&TBWUWOURD8QDSVSOT&@]PDW]VGUVD]Q0SQS3U"@!PAS#[email protected]@!QGV!WBUUE&PFW W0U!AWPGS&WCUWAPQARQWGTVAPU6SQW2T @QP1RVWCT&@PT7S#W3U @"[email protected]"QES [email protected] [email protected]@[email protected]"[email protected]!U6SQW2P&@PT7S#W3U @"QGRVWCTQATU6SQWBP&@PT7S#[email protected]"P7RQWCT8APP6SPW3TQE PFS!R4T [email protected]@PT7S&WGT]@[email protected]&[email protected][email protected]@[email protected]!R6Q#TCVWBQSGPUV5UQARPGS VBQ!B R4PPTEWQBPR4PRU3Q]E&QEW [email protected] [email protected] @[email protected]"P7S!W0TQAWPGRPVFP @PQBVBV2PCD"QASVVDU]ATQFV SFPCD"[email protected]#WBT]E!TBV&S0U8APP6S&R3QTDTTB');</script></head></html>
×
×
  • Create New...