E:
/
home
/
kbcomunicacao1
/
Web
/
sysmex-news
/
adm
/
controlers
/
Upload File
HOME
<?php $query = "SELECT * FROM cw_newsletter ORDER BY data_newsletter DESC"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); $rows = mysqli_num_rows($result); ?> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-lg-10"><!--topo cliente --> <h2>Trabalhe Conosco</h2> </div> <div class="col-lg-2"> </div> </div><!-- topo clientes --> <div class="wrapper wrapper-content animated fadeInRight"><!-- clientes--> <div class="row"> <div class="col-sm-12"> <div class="ibox"> <div class="ibox-content"> <div class="clients-list"> <ul class="nav nav-tabs"> <li class="active"><a data-toggle="tab" href="#tab-1"><i class="fa fa-laptop"></i> Trabalhe Conosco (<?php echo $rows; ?>)</a></li> </ul> <div class="tab-content"> <div id="tab-1" class="tab-pane active"> <div class="full-height-scroll"> <div class="table-responsive"> <table class="footable table table-stripped" data-page-size="1000" data-filter=#filter> <tbody> <?php while($res = mysqli_fetch_assoc($result)){ ?> <tr> <td><?php echo dbDateToDate2($res['data_newsletter']); ?></td> <td><?php echo $res['nome_newsletter']; ?></td> <td><?php echo $res['email_newsletter']; ?></td> <td><?php echo $res['telefone_newsletter']; ?></td> <td><?php echo $res['mensagem_newsletter']; ?></td> <td> <?php $querya = "SELECT * FROM cw_anexo WHERE chave_anexo = '$res[anexo_newsletter]' "; $linka = DBConnect(); $resulta = @mysqli_query($linka, $querya) or die(mysqli_error($linka)); while($resa = mysqli_fetch_assoc($resulta)){ ?> <a target="_blank" href="upload/uploads/<?php echo $resa['caminho_anexo']; ?>"><small><?php echo $resa['nomearquivo_anexo']; ?></small></a><br /> <?php } ?> </td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> <div class="col-sm-5"> <div class="ibox "> </div> </div> </div> </div><!-- clientes-->